TREXCEPT

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


UPDATED BY
HR55.1 HR55.2 HR55.3 HS05.1 HS22.1 HS36.1
PR128 PR28.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TRX-COMPANY
Element: Company Hr
Numeric 4
HS05.1 PR28.1
TRX-GROUP-NAME
Element: Group Name
Alpha 10
Contains an employee group name.
HS05.1 PR28.1
TRX-COLUMN-NUMBER
Element: Column Number
Numeric 2
Contains the column number value.
HS05.1 PR28.1
TRX-COLUMN-LABEL
Element: Column Label
Alpha 15 (Lower Case)
Contains the column label to be used for Web Exception Time Entry.
HS05.1 PR28.1
TRX-PAY-CODE
Element: Pay Code
Alpha 4
Contains the pay code. A pay code is a user-defined code that identifies a kind of pay.
HS05.1 PR28.1
TRX-OFFSET-PAY
Element: Offset Pay
Alpha 4
Contains a pay code that is to be used as the offset pay code.
HS05.1 PR28.1
TRX-TIMECARD-TYPE
Element: Timecard Type
Numeric 1
Contains a value that determines the type of time record. Valid values are: 0 = Normal. 1 = Exception.
2
HS22.1 HS36.1
PR28.1
TRX-FORM-TYPE
Element: Form Type
Alpha 1

" " = Employee
E = Employee
M = Manager


TREXCEPT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TRXSET1 COMPANY
GROUP-NAME
COLUMN-NUMBER
HR55.1 HR55.2
HR55.3 HS05.1
HS21.1 HS36.1
PR128 PR28.1
TRXSET2 COMPANY
GROUP-NAME
PAY-CODE
COLUMN-NUMBER
KeyChange
HS22.1 HS36.1
PR128 PR28.1


TREXCEPT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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


File created: Thu Jun 09 11:27:34 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.