TAPLAN – Absence Plan

System: Absence Management (LP)
Prefix: TAP
Primary key: COMPANY, PLAN
Fields: 14
Updated by: 98 programs
Referenced by: 103 programs

TAPLAN is the Absence Plan table in Lawson Absence Management (prefix TAP). It is indexed by COMPANY, PLAN (TAPSET1); alternate indexes: TAPSET2, TAPSET3 and TAPSET4. It is related 1:1 to PCODES and PRSYSTEM and 1:M to BNTAGROUP, BNTAEMPBAL, TAEEMASTER and TASTRUCTUR. It is updated by HR00.1, HR01.1, HR04.2, HR04.3, HR04.7, HR04.8, HR80.1, HR80.2 and 90 more and referenced by BN15.1, BN150, BN215, ES02.2, EXI2.1, EXI4.1, HR11.1, HR511 and 95 more. The table has 14 fields, 4 indexes and 6 documented relations.

About TAPLAN

No description in the Lawson data dictionary.

Fields (14)

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

Field / column	Type	Description & values	Updated by
`TAP-COMPANY` PK COMPANY	Numeric 4	—	LP01.1
`TAP-PLAN` PK PLAN	Alpha 10	—	LP01.1
`TAP-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	—	LP01.1
`TAP-STATUS` STATUS	Numeric 1	— `1` Active `2` Inactive	LP01.1
`TAP-AUTO-ENROLL` AUTO_ENROLL	Numeric 1	— `0` No `1` Yes	LP01.1
`TAP-BALANCE-TYPE` BALANCE_TYPE	Numeric 1	— `1` Employee group `2` Position code	LP01.1
`TAP-ENROLL-TYPE` ENROLL_TYPE	Numeric 1	— `1` Employee Group `2` Employee group; position code `3` Employee group; position level	LP01.1
`TAP-TABLE-BASIS` TABLE_BASIS	Numeric 1	— `1` Cycle based `2` Hours based	LP01.1
`TAP-CATEGORY` CATEGORY	Alpha 10	—	LP01.1, LP180
`TAP-WEB-AVAILABLE` WEB_AVAILABLE	Alpha 1	— `1` Not Available `2` Available	LP01.1
`TAP-WEB-AVAIL-SUPV` WEB_AVAIL_SUPV	Alpha 1	— `1` Not Available `2` Available	LP01.1
`TAP-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	This field contains the server date (month, date, and year) of the last change to this record.	LP01.1
`TAP-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	Contains the server time (hour, minute, and second) when the record was last changed.	LP01.1
`TAP-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	LP01.1

Indexes (4)

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
`TAPSET1`	`COMPANY`, `PLAN`	Primary		BN15.1, BN215, ES02.2, HR00.1, HR01.1, HR04.2, HR04.3, HR04.7 +22 more (list truncated in source)
`TAPSET2`	`COMPANY`, `PLAN`	Subset	Where (WEB-AVAILABLE = "2")	—
`TAPSET3`	`COMPANY`, `PLAN`	Subset	Where (WEB-AVAIL-SUPV = "2")	—
`TAPSET4`	`COMPANY`, `PLAN`	Subset	Where (STATUS = 1)	BN150, HR11.1, HR511, LT101, LT111, PR521, EXI2.1, EXI4.1 +22 more (list truncated in source)

Relations

One to one (2) — lookups and parents

Relation	Table	Rules	Condition	Field map
Category	PCODES	Required	When (TAP-CATEGORY != Spaces)	`"TC"` → `PCO-TYPE`, `TAP-CATEGORY` → `PCO-CODE`
Company	PRSYSTEM	Required		`TAP-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`

One to many (4) — child tables

Relation	Table	Rules	Field map
Bn Plan Group	BNTAGROUP		`TAP-COMPANY` → `BTG-COMPANY`, `TAP-PLAN` → `BTG-TA-PLAN`, → `BTG-EMPLOYEE-GROUP`, → `BTG-PLAN-CODE`
Bn Ta Employee	BNTAEMPBAL	Delete Restricted	`TAP-COMPANY` → `BTE-COMPANY`, `TAP-PLAN` → `BTE-TA-PLAN`, → `BTE-EMPLOYEE-GROUP`, → `BTE-EMPLOYEE`, → `BTE-POSITION`, → `BTE-PLAN-CODE`, → `BTE-START-DATE`
Employees	TAEEMASTER	Delete Restricted	`TAP-COMPANY` → `TEM-COMPANY`, `TAP-PLAN` → `TEM-PLAN`, → `TEM-EMPLOYEE-GROUP`, → `TEM-EMPLOYEE`, → `TEM-POSITION`
Structure	TASTRUCTUR		`TAP-COMPANY` → `TST-COMPANY`, `TAP-PLAN` → `TST-PLAN`, → `TST-EMPLOYEE-GROUP`, → `TST-BEGIN-DATE`

Programs

Updated by (98)

HR00.1 Company
HR01.1 Process Level
HR04.2 Human Resource Codes
HR04.3 Human Resource Codes
HR04.7 User Fields Value List
HR04.8 Human Resource Codes
HR80.1 Job Occupation Type
HR80.2 Union
HR80.3 Bargaining Unit
HR80.4 Badge Code
HR80.5 Mail Group
HR80.6 Hire Source
HR80.7 User Level
HR80.8 Relationship
HR80.9 Primary Care Physician
HR81.1 Education Degree
HR81.2 Education Subject
HR81.3 Education Institution
HR81.4 Competency
HR81.5 Competency and Certification Source
HR81.6 Certification
HR81.7 Company Property
HR81.8 Emergency Medical
HR81.9 Work Restriction
HR82.1 Working Condition
HR82.2 Work Requirement
HR82.3 Parking Lot
HR82.4 Relocation
HR82.5 Benefit
HR82.6 Qualification
HR82.7 Proficiency
HR82.8 User Field
HR82.9 Association
HR83.1 Review Type
HR83.2 Performance Rating
HR83.3 Applicant Rating
HR83.4 Interview Rating
HR83.5 Personnel Action Reason
HR83.6 Review Type
HR83.7 Benefit Reason Code
HR83.8 Requisition Status
HR83.9 Reason Code
HR84.1 Position Reason Code
HR84.2 Budget Reason Code
HR84.3 Requisition Cost
HR84.4 Supervisor User Field 1
HR84.5 Supervisor User Field 2
HR84.6 Supervisor User Field 3
HR84.7 Supervisor User Field 4
HR84.8 Supervisor User Field 5
HR84.9 Incident Status
HR85.1 Incident Outcome
HR85.2 Incident Category
HR85.3 Incident
HR85.4 Illness
HR85.5 Body Part
HR85.6 Incident Cost Category
HR85.7 Incident Cost Type
HR85.8 Accommodations
HR86.1 Incident Follow Up Category
HR86.2 Incident Follow Up Type
HR86.3 Incident Follow Up Outcome
HR86.4 Test Type
HR86.5 Test Correspondence
HR86.6 Test Source
HR86.7 Test User Field 2
HR86.8 Test User Field 3
HR86.9 Test Eligibility Override Reason
HR87.1 Test Reason
HR87.2 Test Notification Type
HR87.3 Test Refusal Reason
HR87.4 Incident Severity
HR87.5 Incident User 2
HR87.6 Incident User 3
HR87.7 Grievance and Disciplinary Action Category
HR87.8 Grievance and Disciplinary Action Status
HR87.9 Grievance and Disciplinary Action Outcome
HR88.1 Grievance and Disciplinary Action Step Category
HR88.2 Grievance and Disciplinary Action Step Type
HR88.3 Grievance and Disciplinary Action Step Outcome
HR88.4 Human Resource Codes - Disability
HR88.5 Human Resource Codes - Religion
HR88.6 Contract Type
HR88.7 Census Metropolitan Area
HR89.1 HR Codes - Work Eligibility Document Type
HR89.2 HR Codes - Work Eligibility Document Description
HR89.3 Human Resource Codes - Work Eligibility Status
HR89.4 Human Resource Codes - Travel Doc Application Status
HR89.5 Human Resource Codes - Travel Document
HR89.6 Human Resource Codes - Contact Number Type
HR89.7 HR Codes - Official Languages - Bilingual Region
HR89.8 Sharp Device
HR89.9 Brand of Device
HR91.7 Objective Status
HR92.1 Day Codes
HR92.2 Leave Status
HR92.3 Leave Reason
LP01.1 Absence Plan

Referenced by (103)

BN15.1 Benefit Plan
BN150 Life Insurance Reportable Income
BN215 Plan Parameter Listing
ES02.2 Absence Plan Balances Rule
EXI2.1 Invoke for PRTRDPD
EXI4.1 Invoke for PRPRBPD
HR11.1 Employee
HR511 Employee Conversion
HR93.8 Employee Leave Plan Audit Inquiry
HS17.1 LP Balances on Paychecks
HS19.1 Employee Paid Time Off Request Balances
HS19.2 Employee Paid Time Off Request
HS706 HRM Time Off Planner Interface
HTAP.1 Job Code Select Invoke
LP02.1 Plan Structure
LP03.1 Service Rule
LP03.2 Accrual Rule
LP03.3 Eligibility Rule
LP03.4 Limit Rule
LP03.5 Payroll Rule
LP03.6 General Ledger Rule
LP10.1 Link Plan Table
LP100 Employee Absence Plan Update
LP101 Mass Absence Plan Add
LP102 Employee Master Update
LP103 Mass Absence Plan Termination
LP130 Absence Plan Payout
LP131 Zero Balance Update
LP138 Absence Plan Hours Update
LP140 Employee Absence Plan Calculation
LP145 Allotment Adjustment Calculation
LP15.1 Absence Plan Benefit Groups
LP151 FMLA Rolling 12 Month Update
LP180 Mass Absence Plan Transfer
LP188 Length of Service Hours Update
LP197 Absence Plan Close
LP198 General Ledger Liability Update
LP201 Absence Plan Listing
LP220 Employee Absence Plan or Leave History Report
LP231 Employee Plan Master Listing
LP240 Employee Plan Transaction Report
LP264 Employee Transaction History Report
LP270 Open Manual Transactions
LP31.1 Employee Absence Plan Master
LP32.1 Employee Absence Enrollment
LP32.2 Employee Absence Enrollment
LP32.3 Employee Absence Enrollment
LP331 Employee Absence Plan Purge
LP34.1 Absence Plan Hours Allocation
LP370 Employee Absence Transaction Consolidation
LP570 Manual Transaction Conversion
LP63.1 Absence Plan Hours Balances
LP63.2 Absence Plan Earnings Balances
LP64.1 Employee Transaction Detail Inquiry
LP64.2 Employee Transaction Summary Inquiry
LP64.3 Employee Transaction Detail Balance Inquiry
LP70.1 Manual Transactions by Employee
LP70.2 Manual Transactions by Plan Structure
LP80.1 Employee Absence Plan Transfer
LP88.1 Length of Service Hours
LT101 HRM Receiver Update
LT111 HRM Receiver Update
PA100 Action Update
PA52.4 Hire an Applicant
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
PR160 Payment Print
PR180 Manual Payment Print
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.2 Manual Payment Print
PR80.4 Manual Payment
PR82.1 Adjustment
TA147 Canada Vacation Audit
UK102 Bonus Pay Update