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 PR521 EXI2.1 EXI4.1
LP02.1 LP10.1 LP100 LP101 LP102 LP103
LP130 LP131 LP140 LP180 LP197 LP201
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
TA147


UPDATED BY
LP03.5 HR00.1 HR01.1 LP203

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
TPR-ERN-WEB-EDIT
Element: Ta Negativ Bal		Numeric 1

1 = Warning
2 = Error
3 = Do not check balance
4 = Reduce to plan balance
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
TPR-HRS-USE-LIMIT
Element: Ta Use Amt		Signed 18.6
LP03.5
TPR-HRS-USE-BAL
Element: Ta Use Bal		Numeric 1
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 PR521
EXI2.1 EXI4.1
LP02.1 LP03.5
LP10.1 LP100
LP101 LP102
LP103 LP130
LP131 LP140
LP180 LP197
LP201 LP203
LP31.1 LP80.1
PA100 PA52.4
PR128 PR130
PR131 PR132


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: Wed Jun 08 20:50:02 2016

Home
Contact Us



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