TAPAYROLL

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 HR11.1 HR511 LT101 PR521 EXI2.1
EXI4.1 LP08.1 LP08.2 LP100 LP101 LP102
LP103 LP130 LP131 LP140 LP180 LP197
LP31.1 LP80.1 PA100 PA52.4 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 PR582
PR80.1 PR80.2 PR80.4 PR82.1 UK102 UK560
ZP530 TA147 LP02.1 LP10.1 LP201 LP203


UPDATED BY
HR00.1 HR01.1 LP03.5

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TPR-COMPANY
Element: Company Hr
Numeric 4
LP03.5
TPR-PAYROLL-RULE
Element: Ta Rule
Alpha 10
LP03.5
TPR-DESCRIPTION
Element: Ta Description
Alpha 30 (Lower Case)
LP03.5
TPR-HRS-SRV-CLS
Element: Ta Service Cls
Alpha 3
LP03.5
TPR-HRS-PYO-SRV-CD
Element: Ta Service Cd
Alpha 10
LP03.5
TPR-HRS-NEGATV-BAL
Element: Ta Negativ Bal
Numeric 1

1 = Warning
2 = Error
3 = Do not check balance
4 = Reclassify as unpaid time
LP03.5
TPR-HRS-AVAIL-DESC
Element: Ta Description
Alpha 30 (Lower Case)
LP03.5
TPR-HRS-AVAIL-PRNT
Element: Ta Print
Numeric 1

0 = No
1 = Yes
LP03.5
TPR-HRS-ACCR-DESC
Element: Ta Description
Alpha 30 (Lower Case)
LP03.5
TPR-HRS-ACCR-PRNT
Element: Ta Print
Numeric 1

0 = No
1 = Yes
LP03.5
TPR-HRS-RESRV-DESC
Element: Ta Description
Alpha 30 (Lower Case)
LP03.5
TPR-HRS-RESRV-PRNT
Element: Ta Print
Numeric 1

0 = No
1 = Yes
LP03.5
TPR-HRS-CARRY-DESC
Element: Ta Description
Alpha 30 (Lower Case)
LP03.5
TPR-HRS-CARRY-PRNT
Element: Ta Print
Numeric 1

0 = No
1 = Yes
LP03.5
TPR-ERN-SRV-CLS
Element: Ta Service Cls
Alpha 3
LP03.5
TPR-ERN-PYO-SRV-CD
Element: Ta Service Cd
Alpha 10
LP03.5
TPR-ERN-NEGATV-BAL
Element: Ta Negativ Bal
Numeric 1

1 = Warning
2 = Error
3 = Do not check balance
4 = Reduce to plan balance
LP03.5
TPR-ERN-AVAIL-DESC
Element: Ta Description
Alpha 30 (Lower Case)
LP03.5
TPR-ERN-AVAIL-PRNT
Element: Ta Print
Numeric 1

0 = No
1 = Yes
LP03.5
TPR-ERN-ACCR-DESC
Element: Ta Description
Alpha 30 (Lower Case)
LP03.5
TPR-ERN-ACCR-PRNT
Element: Ta Print
Numeric 1

0 = No
1 = Yes
LP03.5
TPR-ERN-RESRV-DESC
Element: Ta Description
Alpha 30 (Lower Case)
LP03.5
TPR-ERN-RESRV-PRNT
Element: Ta Print
Numeric 1

0 = No
1 = Yes
LP03.5
TPR-ERN-CARRY-DESC
Element: Ta Description
Alpha 30 (Lower Case)
LP03.5
TPR-ERN-CARRY-PRNT
Element: Ta Print
Numeric 1

0 = No
1 = Yes
LP03.5
TPR-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) of the last change to this record.
LP03.5
TPR-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
LP03.5
TPR-USER-ID
Element: User
Alpha 10 (Lower Case)
LP03.5
TPR-HRS-WEB-EDIT
Element: Ta Negativ Bal
Numeric 1

1 = Warning
2 = Error
3 = Do not check balance
4 = Reclassify as unpaid time
LP03.5
TPR-ERN-WEB-EDIT
Element: Ta Negativ Bal
Numeric 1

1 = Warning
2 = Error
3 = Do not check balance
4 = Reduce to plan balance
LP03.5
TPR-HRS-NEG-LIMIT
Element: Ta Amount
Signed 18.6
LP03.5
TPR-HRS-LINK-TABLE
Element: Ta Table
Alpha 10
LP03.5
TPR-HRS-FINAL-OPT
Element: Ta Negativ Bal
Numeric 1

1 = Original plan negative bal opt
2 = Link plan negative bal opt
LP03.5
TPR-HRS-PROC-ORDER
Element: Ta Proc Order
Numeric 1

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
LP03.5
TPR-HRS-UNPAID-CD
Element: Ta Service Cd
Alpha 10
LP03.5
TPR-ERN-NEG-LIMIT
Element: Ta Amount
Signed 18.6
LP03.5
TPR-ERN-LINK-TABLE
Element: Ta Table
Alpha 10
LP03.5
TPR-ERN-FINAL-OPT
Element: Ta Negativ Bal
Numeric 1

1 = Original plan negative bal opt
2 = Link plan negative bal opt
LP03.5
TPR-ERN-PROC-ORDER
Element: Ta Proc Order
Numeric 1

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
LP03.5


TAPAYROLL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TPRSET1 COMPANY
PAYROLL-RULE
...
BN150 HR00.1
HR01.1 HR11.1
HR511 LT101
PR521 EXI2.1
EXI4.1 LP02.1
LP03.5 LP08.1
LP08.2 LP10.1
LP100 LP101
LP102 LP103
LP130 LP131
LP140 LP180
LP197 LP201
LP203 LP31.1
LP80.1 PA100
PA52.4 PR128


TAPAYROLL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
TPR-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Ern Link Table LPLINK Required
When TPR-ERN-LINK-TABLE !=Spaces
TPR-COMPANY->LNK-COMPANY
TPR-ERN-LINK-TABLE->LNK-LINK-PLAN-TB
2->LNK-TABLE-TYPE
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 Link Table LPLINK Required
When TPR-HRS-LINK-TABLE !=Spaces
TPR-COMPANY->LNK-COMPANY
TPR-HRS-LINK-TABLE->LNK-LINK-PLAN-TB
1->LNK-TABLE-TYPE
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
Hrs Unpaid Cd TASERVCODE Required
When TPR-HRS-UNPAID-CD !=Spaces
TPR-COMPANY->TSC-COMPANY
TPR-HRS-UNPAID-CD->TSC-SERVICE-CODE


File created: Thu Jun 09 11:19:47 2016

Home
Contact Us



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