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.

Field / column	Type	Description & values	Updated by
`TST-COMPANY` PK COMPANY	Numeric 4	—	LP02.1
`TST-PLAN` PK PLAN	Alpha 10	—	LP02.1
`TST-EMPLOYEE-GROUP` PK EMPLOYEE_GROUP	Alpha 10	—	LP02.1
`TST-BEGIN-DATE` PK BEGIN_DATE	Numeric 8 (yyyymmdd)	—	LP02.1
`TST-END-DATE` END_DATE	Numeric 8 (yyyymmdd)	—	LP02.1, LP103
`TST-ACCRUAL-OPTION` ACCRUAL_OPTION	Numeric 1	— `1` Hours `2` Earnings `3` Hours and Earnings	LP02.1
`TST-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	This field contains the company base currency code established in Company (GL10.1 ).	LP02.1
`TST-SERVICE-RULE` SERVICE_RULE	Alpha 10	—	LP02.1
`TST-ACCRUAL-RULE` ACCRUAL_RULE	Alpha 10	—	LP02.1
`TST-ELIGIBLE-RULE` ELIGIBLE_RULE	Alpha 10	—	LP02.1
`TST-LIMIT-RULE` LIMIT_RULE	Alpha 10	—	LP02.1
`TST-PAYROLL-RULE` PAYROLL_RULE	Alpha 10	—	LP02.1
`TST-GL-RULE` GL_RULE	Alpha 10	—	LP02.1
`TST-ROUND-METH-HRS` ROUND_METH_HRS	Numeric 1	— `0` None `1` Normal `2` High `3` Low	LP02.1
`TST-ROUND-TO-HRS` ROUND_TO_HRS	Signed 18.6	—	LP02.1
`TST-ROUND-METH-ERN` ROUND_METH_ERN	Numeric 1	— `0` None `1` Normal `2` High `3` Low	LP02.1
`TST-ROUND-TO-ERN` ROUND_TO_ERN	Signed 18.6	—	LP02.1
`TST-DATE-STAMP` DATE_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-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	Contains the server time (hour, minute, and second) when the record was last changed.	LP02.1, LP103
`TST-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	LP02.1, LP103
`TST-BAL-TRANSFER` BAL_TRANSFER	Numeric 1	—	LP02.2

Indexes (3)

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

Index	Keys	Flags	Used in
`TSTSET1`	`COMPANY`, `PLAN`, `EMPLOYEE-GROUP`, `BEGIN-DATE`	Primary	BN15.1, BN150, ES02.2, HR00.1, HR01.1, PR521, EXI2.1, EXI4.1 +22 more (list truncated in source)
`TSTSET2`	`COMPANY`, `EMPLOYEE-GROUP`, `PLAN`, `BEGIN-DATE*`		HR11.1, HR511, HR55.1, HR55.2, HR55.3, HS19.1, LT101, LT111 +22 more (list truncated in source)
`TSTSET3`	`COMPANY`, `PLAN`, `EMPLOYEE-GROUP`, `BEGIN-DATE*`		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		`TST-COMPANY` → `TAR-COMPANY`, `TST-ACCRUAL-RULE` → `TAR-ACCRUAL-RULE`
Company	PRSYSTEM	Required		`TST-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`
Currency	CUCODES	Required	When (TST-CURRENCY-CODE != Spaces)	`TST-CURRENCY-CODE` → `CUC-CURRENCY-CODE`
Eligible Rule	TAELIGIBLE	Required	When (TST-ELIGIBLE-RULE != Spaces)	`TST-COMPANY` → `TEG-COMPANY`, `TST-ELIGIBLE-RULE` → `TEG-ELIGIBLE-RULE`
Employee Group	PERSGROUP	Required		`TST-COMPANY` → `PRG-COMPANY`, `TST-EMPLOYEE-GROUP` → `PRG-GROUP-NAME`
Gl Rule	TAGENLEDGR	Required	When (TST-GL-RULE != Spaces)	`TST-COMPANY` → `TGE-COMPANY`, `TST-GL-RULE` → `TGE-GL-RULE`
Limit Rule	TALIMIT	Required		`TST-COMPANY` → `TLM-COMPANY`, `TST-LIMIT-RULE` → `TLM-LIMIT-RULE`
Payroll Rule	TAPAYROLL	Required	When (TST-PAYROLL-RULE != Spaces)	`TST-COMPANY` → `TPR-COMPANY`, `TST-PAYROLL-RULE` → `TPR-PAYROLL-RULE`
Plan	TAPLAN	Required		`TST-COMPANY` → `TAP-COMPANY`, `TST-PLAN` → `TAP-PLAN`
Service Rule	TASERVRULE	Required		`TST-COMPANY` → `TSR-COMPANY`, `TST-SERVICE-RULE` → `TSR-SERVICE-RULE`

One to many (3) — child tables

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

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