|
|
TAPAYROLL FILE
Payroll Rules define service codes for use or payout of hours balances,
service codes for payout of earnings balances, whether payout is automatic as
earnings are accrued, and which balances are printed on payments.
REFERENCED BY
BN150 ET530 ETI2.1 LP02.1 LP08.1 LP08.2
LP130 LP140 LP201 LP203 PR128 PR130
PR131 PR132 PR134 PR135 PR136 PR137
PR160 PR180 PR189 PR29.1 PR32.1 PR32.2
PR33.1 PR33.2 PR33.3 PR35.1 PR35.2 PR35.3
PR35.4 PR35.5 PR35.6 PR35.8 PR35.9 PR36.1
PR37.1 PR45.1 PR529 PR530 PR560 PR80.1
PR80.2 PR82.1 UK102 UK560 TA147
UPDATED BY
LP03.5 HR00.1 HR01.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TPR-COMPANY Numeric 4 LP03.5
Element: Company Hr
TPR-PAYROLL-RULE Alpha 10 LP03.5
Element: Ta Rule
TPR-DESCRIPTION Alpha 30 (Lower Case) LP03.5
Element: Ta Description
TPR-HRS-SRV-CLS Alpha 3 LP03.5
Element: Ta Service Cls
TPR-HRS-PYO-SRV-CD Alpha 4 LP03.5
Element: Ta Service Cd
TPR-HRS-NEGATV-BAL Numeric 1 LP03.5
Element: Ta Negativ Bal1 = Warning
2 = Error
3 = Do not check balance
4 = Reclassify as unpaid time
TPR-HRS-AVAIL-DESC Alpha 30 (Lower Case) LP03.5
Element: Ta Description
TPR-HRS-AVAIL-PRNT Numeric 1 LP03.5
Element: Ta Print 0 = No
1 = Yes
TPR-HRS-ACCR-DESC Alpha 30 (Lower Case) LP03.5
Element: Ta Description
TPR-HRS-ACCR-PRNT Numeric 1 LP03.5
Element: Ta Print 0 = No
1 = Yes
TPR-HRS-RESRV-DESC Alpha 30 (Lower Case) LP03.5
Element: Ta Description
TPR-HRS-RESRV-PRNT Numeric 1 LP03.5
Element: Ta Print 0 = No
1 = Yes
TPR-HRS-CARRY-DESC Alpha 30 (Lower Case) LP03.5
Element: Ta Description
TPR-HRS-CARRY-PRNT Numeric 1 LP03.5
Element: Ta Print 0 = No
1 = Yes
TPR-ERN-SRV-CLS Alpha 3 LP03.5
Element: Ta Service Cls
TPR-ERN-PYO-SRV-CD Alpha 4 LP03.5
Element: Ta Service Cd
TPR-ERN-NEGATV-BAL Numeric 1 LP03.5
Element: Ta Negativ Bal1 = Warning
2 = Error
3 = Do not check balance
4 = Reduce to plan balance
TPR-ERN-AVAIL-DESC Alpha 30 (Lower Case) LP03.5
Element: Ta Description
TPR-ERN-AVAIL-PRNT Numeric 1 LP03.5
Element: Ta Print 0 = No
1 = Yes
TPR-ERN-ACCR-DESC Alpha 30 (Lower Case) LP03.5
Element: Ta Description
TPR-ERN-ACCR-PRNT Numeric 1 LP03.5
Element: Ta Print 0 = No
1 = Yes
TPR-ERN-RESRV-DESC Alpha 30 (Lower Case) LP03.5
Element: Ta Description
TPR-ERN-RESRV-PRNT Numeric 1 LP03.5
Element: Ta Print 0 = No
1 = Yes
TPR-ERN-CARRY-DESC Alpha 30 (Lower Case) LP03.5
Element: Ta Description
TPR-ERN-CARRY-PRNT Numeric 1 LP03.5
Element: Ta Print 0 = No
1 = Yes
TPR-DATE-STAMP Numeric 8 (yyyymmdd) LP03.5
Element: Date Stamp This field contains the server date
(month, date, and year) of the last
change to this record.
TPR-TIME-STAMP Numeric 6 (hhmmss) LP03.5
Element: Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
TPR-USER-ID Alpha 10 (Lower Case) LP03.5
Element: User
TPR-HRS-WEB-EDIT Numeric 1
Element: Ta Negativ Bal1 = Warning
2 = Error
3 = Do not check balance
4 = Reclassify as unpaid time
TPR-ERN-WEB-EDIT Numeric 1
Element: Ta Negativ Bal1 = Warning
2 = Error
3 = Do not check balance
4 = Reduce to plan balance
TPR-HRS-NEG-LIMIT Signed 18.6
Element: Ta Amount
TPR-HRS-LINK-TABLE Alpha 10
Element: Ta Table
TPR-HRS-FINAL-OPT Numeric 1
Element: Ta Negativ Bal1 = Original plan negative bal opt
2 = Link plan negative bal opt
TPR-HRS-PROC-ORDER Numeric 1
Element: Ta Proc Order 1 = Link plans
2 = Orig neg bal limit
3 = Link plans; orig neg bal limit
4 = Link plans; link neg bal limit
5 = Orig neg bal limit; link plans
6 = Org ng bal lmt; link; link lmt
TPR-HRS-UNPAID-CD Alpha 4
Element: Ta Service Cd
TPR-ERN-NEG-LIMIT Signed 18.6
Element: Ta Amount
TPR-ERN-LINK-TABLE Alpha 10
Element: Ta Table
TPR-ERN-FINAL-OPT Numeric 1
Element: Ta Negativ Bal1 = Original plan negative bal opt
2 = Link plan negative bal opt
TPR-ERN-PROC-ORDER Numeric 1
Element: Ta Proc Order 1 = Link plans
2 = Orig neg bal limit
3 = Link plans; Orig neg bal limit
4 = Link plans; link neg bal limit
5 = Orig neg bal limit; link plans
6 = Org ng bal lmt; link; link lmt
TAPAYROLL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TPRSET1 COMPANY BN150 ET530
PAYROLL-RULE ETI2.1 HR00.1
HR01.1 LP02.1
LP03.5 LP08.1
LP08.2 LP130
LP140 LP201
LP203 PR128
PR130 PR131
PR132 PR134
PR135 PR136
PR137 PR160
PR180 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
...
TAPAYROLL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
TPR-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Ern Pyo Srv Cd TASERVCODE Required
When TPR-ERN-PYO-SRV-CD != Spaces
TPR-COMPANY -> TSC-COMPANY
TPR-ERN-PYO-SRV-CD -> TSC-SERVICE-CODE
Ern Srv Cls TASERVCLSS Required
When TPR-ERN-SRV-CLS != Spaces
TPR-COMPANY -> TSL-COMPANY
TPR-ERN-SRV-CLS -> TSL-SERVICE-CLASS
Hrs Pyo Srv Cd TASERVCODE Required
When TPR-HRS-PYO-SRV-CD != Spaces
TPR-COMPANY -> TSC-COMPANY
TPR-HRS-PYO-SRV-CD -> TSC-SERVICE-CODE
Hrs Srv Cls TASERVCLSS Required
When TPR-HRS-SRV-CLS != Spaces
TPR-COMPANY -> TSL-COMPANY
TPR-HRS-SRV-CLS -> TSL-SERVICE-CLASS
|
