|
|
TREXCEPT FILE
This file contains exception pay codes and offsetting pay codes for deviating
employee attendances, such as absences. It is also used by web self service to
create column definitions.
REFERENCED BY
HR55.1 HR55.2 HR55.3 HS21.1 HS36.1 PR128
HS22.1
UPDATED BY
HS05.1 PR28.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TRX-COMPANY Numeric 4 HS05.1 PR28.1
Element: Company Hr
TRX-GROUP-NAME Alpha 10 HS05.1 PR28.1
Element: Group Name Contains an employee group name.
TRX-COLUMN-NUMBER Numeric 2 HS05.1 PR28.1
Element: Column Number Contains the column number value.
TRX-COLUMN-LABEL Alpha 15 (Lower Case) HS05.1 PR28.1
Element: Column Label Contains the column label to be used
for Web Exception Time Entry.
TRX-PAY-CODE Alpha 4 HS05.1 PR28.1
Element: Pay Code Contains the pay code. A pay code is a
user-defined code that identifies a kind
of pay.
TRX-OFFSET-PAY Alpha 4 HS05.1 PR28.1
Element: Offset Pay Contains a pay code that is to be used
as the offset pay code.
TRX-TIMECARD-TYPE Numeric 1 HS22.1 HS36.1
Element: Timecard Type Contains a value that determines the PR28.1
type of time record. Valid values are:
0 = Normal.
1 = Exception.
2
TRX-FORM-TYPE Alpha 1
Element: Form Type " " = Employee
E = Employee
M = Manager
TREXCEPT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TRXSET1 COMPANY HR55.1 HR55.2
GROUP-NAME HR55.3 HS05.1
COLUMN-NUMBER HS21.1 HS36.1
PR128 PR28.1
TRXSET2 COMPANY KeyChange HS22.1 HS36.1
GROUP-NAME PR128 PR28.1
PAY-CODE
COLUMN-NUMBER
TREXCEPT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Persgroup PERSGROUP Required
TRX-COMPANY -> PRG-COMPANY
TRX-GROUP-NAME -> PRG-GROUP-NAME
Prsystem PRSYSTEM Required
TRX-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
TREXCEPT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Offset Paycode PRPAYCODE
TRX-COMPANY -> PCD-COMPANY
TRX-OFFSET-PAY -> PCD-PAY-CODE
PCD-PROCESS-LEVEL
PCD-JOB-CODE
Paycode PRPAYCODE
TRX-COMPANY -> PCD-COMPANY
TRX-PAY-CODE -> PCD-PAY-CODE
PCD-PROCESS-LEVEL
PCD-JOB-CODE
|
