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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#TAP-COMPANY PKCOMPANY | Numeric 4 | — | LP01.1 |
#TAP-PLAN PKPLAN | Alpha 10 | — | LP01.1 |
#TAP-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | — | LP01.1 |
#TAP-STATUSSTATUS | Numeric 1 | —
| LP01.1 |
#TAP-AUTO-ENROLLAUTO_ENROLL | Numeric 1 | —
| LP01.1 |
#TAP-BALANCE-TYPEBALANCE_TYPE | Numeric 1 | —
| LP01.1 |
#TAP-ENROLL-TYPEENROLL_TYPE | Numeric 1 | —
| LP01.1 |
#TAP-TABLE-BASISTABLE_BASIS | Numeric 1 | —
| LP01.1 |
#TAP-CATEGORYCATEGORY | Alpha 10 | — | LP01.1, LP180 |
#TAP-WEB-AVAILABLEWEB_AVAILABLE | Alpha 1 | —
| LP01.1 |
#TAP-WEB-AVAIL-SUPVWEB_AVAIL_SUPV | Alpha 1 | —
| LP01.1 |
#TAP-DATE-STAMPDATE_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-STAMPTIME_STAMP | Numeric 6 (hhmmss) | Contains the server time (hour, minute, and second) when the record was last changed. | LP01.1 |
#TAP-USER-IDUSER_ID | Alpha 10 (Lower Case) | — | LP01.1 |
Indexes (4)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
TAPSET1 |
| Primary | BN15.1, BN215, ES02.2, HR00.1, HR01.1, HR04.2, HR04.3, HR04.7 +22 more (list truncated in source) | |
TAPSET2 |
| Subset | Where (WEB-AVAILABLE = "2") | — |
TAPSET3 |
| Subset | Where (WEB-AVAIL-SUPV = "2") | — |
TAPSET4 |
| 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) |
| ||||||
| Company | PRSYSTEM | Required |
|
One to many (4) — child tables
| Relation | Table | Rules | Condition | Field map | |||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Bn Plan Group | BNTAGROUP |
| |||||||||||||||||||||||
| Bn Ta Employee | BNTAEMPBAL | Delete Restricted |
| ||||||||||||||||||||||
| Employees | TAEEMASTER | Delete Restricted |
| ||||||||||||||||||||||
| Structure | TASTRUCTUR |
|
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