TASTRUCTUR – Absence Plan Structure
- System
- Absence Management (LP)
- Prefix
TST- Primary key
COMPANY,PLAN,EMPLOYEE-GROUP,BEGIN-DATE- Fields
- 21
- Updated by
- 63 programs
- Referenced by
- 34 programs
TASTRUCTUR is the Absence Plan Structure table in Lawson Absence Management (prefix TST). It is indexed by COMPANY, PLAN, EMPLOYEE-GROUP, BEGIN-DATE (TSTSET1); alternate indexes: TSTSET2 and TSTSET3. It is related 1:1 to TAACCRUAL, PRSYSTEM, CUCODES, TAELIGIBLE, PERSGROUP, TAGENLEDGR, TALIMIT, TAPAYROLL and 2 more and 1:M to BNTAGROUP, BNTAEMPBAL and TAEEMASTER. It is updated by BN150, EXI2.1, EXI4.1, HR00.1, HR01.1, HR11.1, HR511, LP02.1 and 55 more and referenced by BN15.1, ES02.2, HR55.1, HR55.2, HR55.3, HS19.1, HS706, LP01.1 and 26 more. The table has 21 fields, 3 indexes and 13 documented relations.
About TASTRUCTUR
Plan Structure is used to assign a specific set of rules to each Accrual Plan and Employee Group combination. This allows different rules to be applied to different employee goups within the same accrual plan. The only rule that is not required is the general ledger rule.
Fields (21)
Column = COBOL field name without the TST- 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 |
|---|---|---|---|
#TST-COMPANY PKCOMPANY | Numeric 4 | — | LP02.1 |
#TST-PLAN PKPLAN | Alpha 10 | — | LP02.1 |
#TST-EMPLOYEE-GROUP PKEMPLOYEE_GROUP | Alpha 10 | — | LP02.1 |
#TST-BEGIN-DATE PKBEGIN_DATE | Numeric 8 (yyyymmdd) | — | LP02.1 |
#TST-END-DATEEND_DATE | Numeric 8 (yyyymmdd) | — | LP02.1, LP103 |
#TST-ACCRUAL-OPTIONACCRUAL_OPTION | Numeric 1 | —
| LP02.1 |
#TST-CURRENCY-CODECURRENCY_CODE | Alpha 5 | This field contains the company base currency code established in Company (GL10.1 ). | LP02.1 |
#TST-SERVICE-RULESERVICE_RULE | Alpha 10 | — | LP02.1 |
#TST-ACCRUAL-RULEACCRUAL_RULE | Alpha 10 | — | LP02.1 |
#TST-ELIGIBLE-RULEELIGIBLE_RULE | Alpha 10 | — | LP02.1 |
#TST-LIMIT-RULELIMIT_RULE | Alpha 10 | — | LP02.1 |
#TST-PAYROLL-RULEPAYROLL_RULE | Alpha 10 | — | LP02.1 |
#TST-GL-RULEGL_RULE | Alpha 10 | — | LP02.1 |
#TST-ROUND-METH-HRSROUND_METH_HRS | Numeric 1 | —
| LP02.1 |
#TST-ROUND-TO-HRSROUND_TO_HRS | Signed 18.6 | — | LP02.1 |
#TST-ROUND-METH-ERNROUND_METH_ERN | Numeric 1 | —
| LP02.1 |
#TST-ROUND-TO-ERNROUND_TO_ERN | Signed 18.6 | — | LP02.1 |
#TST-DATE-STAMPDATE_STAMP | Numeric 8 (yyyymmdd) | This field contains the server date (month, date, and year) of the last change to this record. | LP02.1, LP103 |
#TST-TIME-STAMPTIME_STAMP | Numeric 6 (hhmmss) | Contains the server time (hour, minute, and second) when the record was last changed. | LP02.1, LP103 |
#TST-USER-IDUSER_ID | Alpha 10 (Lower Case) | — | LP02.1, LP103 |
#TST-BAL-TRANSFERBAL_TRANSFER | Numeric 1 | — | LP02.2 |
Indexes (3)
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 |
|---|---|---|---|---|
TSTSET1 |
| Primary | BN15.1, BN150, ES02.2, HR00.1, HR01.1, PR521, EXI2.1, EXI4.1 +22 more (list truncated in source) | |
TSTSET2 |
| HR11.1, HR511, HR55.1, HR55.2, HR55.3, HS19.1, LT101, LT111 +22 more (list truncated in source) | ||
TSTSET3 |
| BN150, PR521, EXI2.1, EXI4.1, LP01.1, LP10.1, LP130, LP145 +22 more (list truncated in source) |
Relations
One to one (10) — lookups and parents
| Relation | Table | Rules | Condition | Field map | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Accrual Rule | TAACCRUAL | Required |
| |||||||
| Company | PRSYSTEM | Required |
| |||||||
| Currency | CUCODES | Required | When (TST-CURRENCY-CODE != Spaces) |
| ||||||
| Eligible Rule | TAELIGIBLE | Required | When (TST-ELIGIBLE-RULE != Spaces) |
| ||||||
| Employee Group | PERSGROUP | Required |
| |||||||
| Gl Rule | TAGENLEDGR | Required | When (TST-GL-RULE != Spaces) |
| ||||||
| Limit Rule | TALIMIT | Required |
| |||||||
| Payroll Rule | TAPAYROLL | Required | When (TST-PAYROLL-RULE != Spaces) |
| ||||||
| Plan | TAPLAN | Required |
| |||||||
| Service Rule | TASERVRULE | Required |
|
One to many (3) — child tables
| Relation | Table | Rules | Condition | Field map | |||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Bn Plan Group | BNTAGROUP |
| |||||||||||||||||||||||
| Bn Ta Employee | BNTAEMPBAL |
| |||||||||||||||||||||||
| Taeemaster | TAEEMASTER | Delete Restricted |
|
Programs
Updated by (63)
- BN150 Life Insurance Reportable Income
- EXI2.1 Invoke for PRTRDPD
- EXI4.1 Invoke for PRPRBPD
- HR00.1 Company
- HR01.1 Process Level
- HR11.1 Employee
- HR511 Employee Conversion
- LP02.1 Plan Structure
- LP02.2 Plan Structure Auto Balance Transfer
- 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
- LP103 Mass Absence Plan Termination
- LP130 Absence Plan Payout
- LP145 Allotment Adjustment Calculation
- LP188 Length of Service Hours Update
- LP198 General Ledger Liability Update
- 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
- 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 (34)
- BN15.1 Benefit Plan
- ES02.2 Absence Plan Balances Rule
- HR55.1 Employee Group Definition
- HR55.2 Employee Groups By Employees
- HR55.3 Employee Groups By Criteria
- HS19.1 Employee Paid Time Off Request Balances
- HS706 HRM Time Off Planner Interface
- LP01.1 Absence Plan
- LP102 Employee Master Update
- 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
- LP220 Employee Absence Plan or Leave History Report
- LP231 Employee Plan Master Listing
- LP264 Employee Transaction History Report
- LP270 Open Manual Transactions
- LP31.1 Employee Absence Plan Master
- LP331 Employee Absence Plan Purge
- 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
- PR160 Payment Print
- PR180 Manual Payment Print