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
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
Company The company number represents an
established company and is entered on
all function codes.
TRX-GROUP-NAME Alpha 10 HS05.1 HS36.1
Group Name Contains an employee group name. PR28.1
TRX-COLUMN-NUMBER Numeric 2 HS05.1 PR28.1
Column Number Contains the column number value.
TRX-COLUMN-LABEL Alpha 15 (Lower Case) HS05.1 PR28.1
Column Label Contains the column label to be used
for Web Exception Time Entry.
TRX-PAY-CODE Alpha 4 HS05.1 PR28.1
Payment 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
Offset Pay Contains a pay code that is to be used
as the offset pay code.
TRX-TIMECARD-TYPE Numeric 1 PR28.1
Timecard Type Contains a value that determines the
type of time record. Valid values are:
0 = Normal.
1 = Exception.
2
TREXCEPT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TRXSET1 COMPANY HS05.1 HS21.1
GROUP-NAME HS36.1 PR128
COLUMN-NUMBER PR28.1
TRXSET2 COMPANY KeyChange HS22.1 PR128
GROUP-NAME PR28.1
PAY-CODE
COLUMN-NUMBER
TRXSET3 COMPANY KeyChange
PAY-CODE
GROUP-NAME
COLUMN-NUMBER
TREXCEPT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Persgroup PERSGROUP Required
TRX-COMPANY -> PRG-COMPANY (PRGSET1)
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
|
