TAPAYROLL – Absence Plan Payroll Rule

System: Absence Management (LP)
Prefix: TPR
Primary key: COMPANY, PAYROLL-RULE
Fields: 39
Updated by: 46 programs
Referenced by: 23 programs

TAPAYROLL is the Absence Plan Payroll Rule table in Lawson Absence Management (prefix TPR). It is indexed by COMPANY, PAYROLL-RULE (TPRSET1). It is related 1:1 to PRSYSTEM, LPLINK, TASERVCODE and TASERVCLSS. It is updated by BN150, EXI2.1, EXI4.1, HR00.1, HR01.1, LP03.5, LP08.1, LP08.2 and 38 more and referenced by HR11.1, HR511, HS19.1, LP02.1, LP100, LP101, LP102, LP103 and 15 more. The table has 39 fields, 1 index and 8 documented relations.

About 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.

Fields (39)

Column = COBOL field name without the TPR- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`TPR-COMPANY` PK COMPANY	Numeric 4	—	LP03.5
`TPR-PAYROLL-RULE` PK PAYROLL_RULE	Alpha 10	—	LP03.5
`TPR-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	—	LP03.5
`TPR-HRS-SRV-CLS` HRS_SRV_CLS	Alpha 3	—	LP03.5
`TPR-HRS-PYO-SRV-CD` HRS_PYO_SRV_CD	Alpha 10	—	LP03.5
`TPR-HRS-NEGATV-BAL` HRS_NEGATV_BAL	Numeric 1	— `1` Warning `2` Error `3` Do not check balance `4` Reclassify as unpaid time	LP03.5
`TPR-HRS-AVAIL-DESC` HRS_AVAIL_DESC	Alpha 30 (Lower Case)	—	LP03.5
`TPR-HRS-AVAIL-PRNT` HRS_AVAIL_PRNT	Numeric 1	— `0` No `1` Yes	LP03.5
`TPR-HRS-ACCR-DESC` HRS_ACCR_DESC	Alpha 30 (Lower Case)	—	LP03.5
`TPR-HRS-ACCR-PRNT` HRS_ACCR_PRNT	Numeric 1	— `0` No `1` Yes	LP03.5
`TPR-HRS-RESRV-DESC` HRS_RESRV_DESC	Alpha 30 (Lower Case)	—	LP03.5
`TPR-HRS-RESRV-PRNT` HRS_RESRV_PRNT	Numeric 1	— `0` No `1` Yes	LP03.5
`TPR-HRS-CARRY-DESC` HRS_CARRY_DESC	Alpha 30 (Lower Case)	—	LP03.5
`TPR-HRS-CARRY-PRNT` HRS_CARRY_PRNT	Numeric 1	— `0` No `1` Yes	LP03.5
`TPR-ERN-SRV-CLS` ERN_SRV_CLS	Alpha 3	—	LP03.5
`TPR-ERN-PYO-SRV-CD` ERN_PYO_SRV_CD	Alpha 10	—	LP03.5
`TPR-ERN-NEGATV-BAL` ERN_NEGATV_BAL	Numeric 1	— `1` Warning `2` Error `3` Do not check balance `4` Reduce to plan balance	LP03.5
`TPR-ERN-AVAIL-DESC` ERN_AVAIL_DESC	Alpha 30 (Lower Case)	—	LP03.5
`TPR-ERN-AVAIL-PRNT` ERN_AVAIL_PRNT	Numeric 1	— `0` No `1` Yes	LP03.5
`TPR-ERN-ACCR-DESC` ERN_ACCR_DESC	Alpha 30 (Lower Case)	—	LP03.5
`TPR-ERN-ACCR-PRNT` ERN_ACCR_PRNT	Numeric 1	— `0` No `1` Yes	LP03.5
`TPR-ERN-RESRV-DESC` ERN_RESRV_DESC	Alpha 30 (Lower Case)	—	LP03.5
`TPR-ERN-RESRV-PRNT` ERN_RESRV_PRNT	Numeric 1	— `0` No `1` Yes	LP03.5
`TPR-ERN-CARRY-DESC` ERN_CARRY_DESC	Alpha 30 (Lower Case)	—	LP03.5
`TPR-ERN-CARRY-PRNT` ERN_CARRY_PRNT	Numeric 1	— `0` No `1` Yes	LP03.5
`TPR-DATE-STAMP` 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` TIME_STAMP	Numeric 6 (hhmmss)	Contains the server time (hour, minute, and second) when the record was last changed.	LP03.5
`TPR-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	LP03.5
`TPR-HRS-WEB-EDIT` HRS_WEB_EDIT	Numeric 1	— `1` Warning `2` Error `3` Do not check balance `4` Reclassify as unpaid time	LP03.5
`TPR-ERN-WEB-EDIT` ERN_WEB_EDIT	Numeric 1	— `1` Warning `2` Error `3` Do not check balance `4` Reduce to plan balance	LP03.5
`TPR-HRS-NEG-LIMIT` HRS_NEG_LIMIT	Signed 18.6	—	LP03.5
`TPR-HRS-LINK-TABLE` HRS_LINK_TABLE	Alpha 10	—	LP03.5
`TPR-HRS-FINAL-OPT` HRS_FINAL_OPT	Numeric 1	— `1` Original plan negative bal opt `2` Link plan negative bal opt	LP03.5
`TPR-HRS-PROC-ORDER` HRS_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` HRS_UNPAID_CD	Alpha 10	—	LP03.5
`TPR-ERN-NEG-LIMIT` ERN_NEG_LIMIT	Signed 18.6	—	LP03.5
`TPR-ERN-LINK-TABLE` ERN_LINK_TABLE	Alpha 10	—	LP03.5
`TPR-ERN-FINAL-OPT` ERN_FINAL_OPT	Numeric 1	— `1` Original plan negative bal opt `2` Link plan negative bal opt	LP03.5
`TPR-ERN-PROC-ORDER` ERN_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

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`TPRSET1`	`COMPANY`, `PAYROLL-RULE`	Primary		BN150, HR00.1, HR01.1, HR11.1, HR511, HS19.1, LT101, LT111 +22 more (list truncated in source)

Relations

One to one (8) — lookups and parents

Relation	Table	Rules	Condition	Field map
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`

Programs

Updated by (46)

BN150 Life Insurance Reportable Income
EXI2.1 Invoke for PRTRDPD
EXI4.1 Invoke for PRPRBPD
HR00.1 Company
HR01.1 Process Level
LP03.5 Payroll Rule
LP08.1 Service Class
LP08.2 Service Code
LP10.1 Link Plan Table
LP130 Absence Plan Payout
PR128 Offset Time Record Creation
PR131 Retroactive Pay Calculation
PR132 FLSA Overtime Calculation
PR134 Automatic Time Records
PR135 Time Record Edit
PR136 Missing Time Records
PR137 Batch Time Record Update
PR189 Gross Up Calculation
PR29.1 Pension Payment Maintenance
PR32.1 Employee Daily Time Entry
PR32.2 Employee Daily Time Entry
PR33.1 Speed Entry Setup
PR33.2 Speed Entry by Number
PR33.3 Speed Entry by Name
PR35.1 Time Entry
PR35.2 Detail Time Entry
PR35.3 Speed Time Entry
PR35.4 Step and Grade, Grade Range Time Entry
PR35.5 Attendance Time Entry
PR35.6 Activity Time Entry
PR35.8 Position Time Entry
PR35.9 Reason Code Time Entry
PR36.1 Time Record Entry
PR36.4 Manual Time Record Maintenance
PR37.1 Batch Time Control
PR45.1 Error Processing
PR521 Nonstandard Pay and Work Period CSV Load
PR529 Pension Payroll Conversion
PR530 Time Record Interface CSV
PR560 Payroll History Load CSV
PR582 Mass Adjustment Load
PR80.1 Manual Check
PR80.4 Manual Payment
PR82.1 Adjustment
TA147 Canada Vacation Audit
UK102 Bonus Pay Update

Referenced by (23)

HR11.1 Employee
HR511 Employee Conversion
HS19.1 Employee Paid Time Off Request Balances
LP02.1 Plan Structure
LP100 Employee Absence Plan Update
LP101 Mass Absence Plan Add
LP102 Employee Master Update
LP103 Mass Absence Plan Termination
LP131 Zero Balance Update
LP140 Employee Absence Plan Calculation
LP151 FMLA Rolling 12 Month Update
LP180 Mass Absence Plan Transfer
LP197 Absence Plan Close
LP201 Absence Plan Listing
LP203 Absence Plan Rules Listing
LP31.1 Employee Absence Plan Master
LP80.1 Employee Absence Plan Transfer
LT101 HRM Receiver Update
LT111 HRM Receiver Update
PA100 Action Update
PA52.4 Hire an Applicant
PR160 Payment Print
PR180 Manual Payment Print