|
|
PRTRDADJ FILE
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PTA-COMPANY Numeric 4
Element: Company Hr Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
PTA-EMPLOYEE Numeric 9
Element: Employee Contains the employee number. Each
person employed by the company is
assigned a unique number. The system
uses the employee number to correlate
all of the information related to that
person.
PTA-ORIG-CHECK-ID Numeric 12
Element: Orig Check Id
PTA-ADJ-CHECK-ID Numeric 12
Element: Adj Check Id
PTA-TIME-SEQ Numeric 12
Element: Sequence Number
PRTRDADJ FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PTASET1 COMPANY
EMPLOYEE
ORIG-CHECK-ID
TIME-SEQ
PTASET2 COMPANY
EMPLOYEE
TIME-SEQ
PRTRDADJ FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Adjustment PAYMASTR Required
PTA-COMPANY -> PYM-COMPANY (PYMSET1)
PTA-EMPLOYEE -> PYM-EMPLOYEE
PTA-ADJ-CHECK-ID -> PYM-CHECK-ID
Cur Timerecord TIMERECORD Not Required
PTA-COMPANY -> TRD-COMPANY
PTA-EMPLOYEE -> TRD-EMPLOYEE
PTA-TIME-SEQ -> TRD-TIME-SEQ
Employee EMPLOYEE Required
PTA-COMPANY -> EMP-COMPANY
PTA-EMPLOYEE -> EMP-EMPLOYEE
Original PAYMASTR Required
PTA-COMPANY -> PYM-COMPANY
PTA-EMPLOYEE -> PYM-EMPLOYEE
PTA-ORIG-CHECK-ID -> PYM-CHECK-ID
Time Record PRTIME Not Required
PTA-COMPANY -> PRT-COMPANY
PTA-EMPLOYEE -> PRT-EMPLOYEE
PYM-PER-END-DATE -> PRT-PER-END-DATE
PTA-ADJ-CHECK-ID -> PRT-CHECK-ID
PTA-TIME-SEQ -> PRT-TIME-SEQ
PRTRDADJ FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Adjustments PRTRDADJ
PTA-COMPANY -> PTA-COMPANY
PTA-EMPLOYEE -> PTA-EMPLOYEE
PTA-ADJ-CHECK-ID -> PTA-ORIG-CHECK-ID
PTA-TIME-SEQ
|
