PLANMASTER – Time Accrual Plan

System: Event Management (TA)
Prefix: PLM
Primary key: COMPANY, PLAN-NAME
Fields: 54
Updated by: 6 programs
Referenced by: 51 programs

PLANMASTER is the Time Accrual Plan table in Lawson Event Management (prefix PLM). It is indexed by COMPANY, PLAN-NAME (PLMSET1); alternate indexes: PLMSET2, PLMSET3 and PLMSET4. It is related 1:1 to GLMASTER, PRSYSTEM, PERSGROUP, PAYCLASS and PLANCLASS and 1:M to ACTRLIMIT, TAFORMULA, PGEMPLOYEE, PGSELECT, EMTAMASTR, ACCRSCHED and TAEEMASTER. It is updated by TA20.1, TA20.2, TA20.3, TA20.4, TA20.5 and TA40.1 and referenced by BN15.1, HPLM.1, HR170, HR55.1, HR55.2, HR55.3, HR70.1, PR134 and 43 more. The table has 54 fields, 4 indexes and 16 documented relations.

About PLANMASTER

Contains the time accrual plan information.

Fields (54)

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

Field / column	Type	Description & values	Updated by
`PLM-COMPANY` PK COMPANY	Numeric 4	Contains the number that represents an established company.	TA20.1, TA20.2, TA20.3, TA20.4, TA20.5, TA40.1
`PLM-PLAN-NAME` PK PLAN_NAME	Alpha 10	Contains the plan name. This is verified in the Time Accrual Plan file.	TA20.1, TA20.2, TA20.3, TA20.4, TA20.5, TA40.1
`PLM-PLAN-CLASS` PLAN_CLASS	Alpha 3	Contains the plan class that groups plans for printing balance information on payments. This is verified in the Plan Class file.	TA20.1, TA40.1
`PLM-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	Contains the plan description.	TA20.1, TA40.1
`PLM-HRS-PAY-CL` HRS_PAY_CL	Alpha 3	Contains the pay class that tracks spent hours. This is verified in the Pay Class file.	TA20.1
`PLM-GROUP-NAME` GROUP_NAME	Alpha 10	Contains the employee group. Only employees in this employee group can enroll in the plan.	TA20.1, TA40.1
`PLM-BEG-EFF-DATE` BEG_EFF_DATE	Numeric 8 (yyyymmdd)	Contains the date the plan begins accruing.	TA20.1, TA40.1
`PLM-END-EFF-DATE` END_EFF_DATE	Numeric 8 (yyyymmdd)	Contains the date the plan stops accruing.	TA20.1, TA40.1
`PLM-BEG-ENR-DATE` BEG_ENR_DATE	Numeric 8 (yyyymmdd)	Contains the first date an employee can enroll in the plan.	TA20.1, TA40.1
`PLM-END-ENR-DATE` END_ENR_DATE	Numeric 8 (yyyymmdd)	Contains the last date an employee can enroll in the plan.	TA20.1, TA40.1
`PLM-ACR-ELIG-CD` ACR_ELIG_CD	Alpha 1	Contains the value that indicates whether eligible hours equal accrual hours. `N` Hours Not Immediately Eligible `Y` Hours Immediately Eligible	TA20.1
`PLM-AUTO-CREATE` AUTO_CREATE	Alpha 1	Contains the value that Indicates whether employees enroll in the plan when they are added in HR11.1 (Employee). `N` No,do not add employee to plan `Y` Yes,enter New employee in Plan	TA20.1, TA40.1
`PLM-ACR-DIST-CO` ACR_DIST_CO	Numeric 4	Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.	TA20.1, TA40.1
`PLM-ACR-ACCT-UNIT` ACR_ACCT_UNIT	Alpha 15	Contains the accrual accounting unit. This is verified in the General Ledger Account Master file.	TA20.1, TA40.1
`PLM-ACR-ACCOUNT` ACR_ACCOUNT	Numeric 6	Contains the accrual account. This is verified in the General Ledger Account Master file.	TA20.1, TA40.1
`PLM-ACR-SUB-ACCT` ACR_SUB_ACCT	Numeric 4	Contains the accrual subaccount. This is verified in the General Ledger Account Master file.	TA20.1, TA40.1
`PLM-EXP-DIST-CO` EXP_DIST_CO	Numeric 4	Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.	TA20.1, TA40.1
`PLM-EXP-ACCT-UNIT` EXP_ACCT_UNIT	Alpha 15	Contains the expense accounting unit. This is verified in the General Ledger Account Master file.	TA20.1, TA40.1
`PLM-EXP-ACCOUNT` EXP_ACCOUNT	Numeric 6	Contains the expense account. This is verified in the General Ledger Account Master file.	TA20.1, TA40.1
`PLM-EXP-SUB-ACCT` EXP_SUB_ACCT	Numeric 4	Contains the expense subaccount. This is verified in the General Ledger Account Master file.	TA20.1, TA40.1
`PLM-GL-TRANS` GL_TRANS	Alpha 1	Contains the value that indicates whether liability amounts for accrued and eligible hours are posted to the general ledger. `N` Do Not Post To General Ledger `Y` Post To General Ledger	TA20.1, TA40.1
`PLM-LIABILITY` LIABILITY	Alpha 1	Contains the value that determines the basis of the liability. `B` Accrued and Eligible hours `E` Eligible hours `N` No liability	TA20.1
`PLM-LOS-UNITS` LOS_UNITS	Numeric 5	Contains the number of units required to meet the length of service requirement for eligibility in the plan. Units are determined by the value in the Length of Service Unit of Time field.	TA20.1
`PLM-LOS-UOT` LOS_UOT	Alpha 1	Contains the unit of time in which the length of service is measured. `D` Days `H` Hours `M` Months `S` Semimonths `W` Weeks	TA20.1
`PLM-LOS-DT-CD` LOS_DT_CD	Alpha 2	Contains the value that indicates when the service requirement begins. `AJ` Adjusted hire `HI` Hire	TA20.1
`PLM-LOS-PAY-CL` LOS_PAY_CL	Alpha 3	If the length of service unit is Hours, this field contains the pay class that represents the hours that count toward the eligibility requirement. This is verified in the Pay Class file.	TA20.1
`PLM-ENTRY-CD` ENTRY_CD	Alpha 1	Contains the nearest entry point at which an employee can enroll in the plan. `A` After meeting length service `P` Prior meeting length service	TA20.1
`PLM-ENTRY-DAYS` ENTRY_DAYS	Numeric 4 (mmdd) Occurs 13 Times ×13	Contains the entry points employees can enroll in the plan.	TA20.1
`PLM-AS-CYCLE` AS_CYCLE	Alpha 2	Contains the unit of time for each accrual cycle. `AN` Annually `BW` Biweekly `MO` Monthly `QT` Quarterly `SA` Semiannually `SM` Semimonthly `WK` Weekly	TA20.2
`PLM-AS-FRM-DT-IND` AS_FRM_DT_IND	Alpha 2	Contains the date accruals begin. `AJ` Adjusted hire date `HI` Hire date `PE` Plan Entry date	TA20.2
`PLM-AS-TO-PR` AS_TO_PR	Alpha 1	Contains the value that indicates whether the accrual cycle adjusts to the payroll cycle. `N` Do not adjust to payroll cycl `Y` Adjust to payroll cycle	TA20.2
`PLM-EP-LOS-UNITS` EP_LOS_UNITS	Numeric 5	Contains the number of units required before an employee can transfer accrued hours to eligible hours. Units are determined by the value in the Entry Point Length of Service Unit of Time field.	TA20.4
`PLM-EP-LOS-UOT` EP_LOS_UOT	Alpha 1	Contains the unit of time in which the service requirement for transferring accrued hours is measured. `D` Days `H` Hours `M` Months `S` Semimonths `W` Weeks	TA20.4
`PLM-EP-LOS-DT-CD` EP_LOS_DT_CD	Alpha 2	Contains the value that indicates when the length of service begins. `AJ` Adjusted hire date `HI` Hire date	TA20.4
`PLM-EP-LOS-PAY-CL` EP_LOS_PAY_CL	Alpha 3	Contains the pay class used to track hours for the service requirement. This is verified in the Pay Class file.	TA20.4
`PLM-EP-ENTRY-CD` EP_ENTRY_CD	Alpha 1	Contains the nearest entry point at which employees can transfer accrued hours to eligible hours. `A` After meeting LOS requirement `P` Prior to meeting LOS require	—
`PLM-EP-ENTRY-DAYS` EP_ENTRY_DAYS	Numeric 4 (mmdd) Occurs 13 Times ×13	Contains the entry points at which employees can transfer accrued accrued hours to eligible hours.	TA20.4
`PLM-EP-TO-PR` EP_TO_PR	Alpha 1	Contains the value that indicates whether the transfer date matches the payroll cycle. `N` Do not adjust to Payroll cycle `Y` Adjust to Payroll cycle	TA20.4
`PLM-EP-CYCLE-IND` EP_CYCLE_IND	Alpha 2	Contains the value that indicates how often accrued hours transfer to eligible hours. `AN` Annually `BW` Biweekly `MO` Monthly `QT` Quarterly `SA` Semiannually `SM` Semimonthly `WK` Weekly	TA20.4
`PLM-COMPLETE-FLG1` COMPLETE_FLG1	Alpha 1	Contains the value that indicates if form TA20.1 (Plan) is complete. " " `*` TA20.1 (Plan) is complete	TA20.1
`PLM-COMPLETE-FLG2` COMPLETE_FLG2	Alpha 1	Contains the value that indicates if TA20.2 (Accrual Schedule) is complete. " " `*` TA20.2 is complete	TA20.2
`PLM-COMPLETE-FLG3` COMPLETE_FLG3	Alpha 1	Contains the value that indicates if the plan setup is complete. If the plan's accrual hours equal eligible hours, the plan is complete after you complete TA20.3 (Accrual Limit). If the plan's accrual hours do not equal eligible hours, the plan is complete after you complete TA20.5 (Eligibility Limit). " " `*` TA20.3 or TA20.5 is complete	TA20.1, TA20.2, TA20.4
`PLM-ALIMIT-CYCLE` ALIMIT_CYCLE	Alpha 1	Contains the value that indicates how often accrual limits are applied. `A` Annually `E` Everytime `M` Monthly `Q` Quarterly `S` Semiannually	TA20.3
`PLM-AAPPLY-LIMIT` AAPPLY_LIMIT	Alpha 1	Contains the value that indicates how often accrual limits are checked. `C` Cyclical `R` Request	TA20.3
`PLM-AONE-TIME-LIM` AONE_TIME_LIM	Alpha 1	Contains the value that indicates if the system checks Accrual limits during the next time accrual cycle. `N` No, One time limit `Y` Yes, limits are checked	TA20.3
`PLM-ELIMIT-CYCLE` ELIMIT_CYCLE	Alpha 1	Contains the value that indicates how often the system applies eligible limits. `A` Annually `E` Everytime `M` Monthly `Q` Quarterly `S` Semiannually	TA20.5
`PLM-EAPPLY-LIMIT` EAPPLY_LIMIT	Alpha 1	Contains the value that indicates how the system checks eligible limits. `C` Cyclical `R` Request	TA20.5
`PLM-EONE-TIME-LIM` EONE_TIME_LIM	Alpha 1	Contains the value that indicates if the system checks eligible limits during the next time accrual cycle. `N` No, One time limit `Y` Yes, limits are checked	TA20.5
`PLM-WEB-AVAILABLE` WEB_AVAILABLE	Alpha 1	—	—
`PLM-WEB-AVAIL-SUPV` WEB_AVAIL_SUPV	Alpha 1	—	—
`PLM-WEB-DESC` WEB_DESC	Alpha 15 (Lower Case)	—	—
`PLM-COUNTRY-CODE` COUNTRY_CODE	Alpha 2	The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).	TA40.1
`PLM-PLAN-BASIS` PLAN_BASIS	Numeric 2	— `00` n/a `01` Hours `02` Date	TA40.1
`PLM-ACCRUAL-TYPE` ACCRUAL_TYPE	Numeric 2	— `00` n/a `01` No Accrual/Vac Pay only `02` Accrual-Dollars Only `03` Accrual-Dollars and Hours `04` Accrual-User Calc	TA40.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	Used in
`PLMSET1`	`COMPANY`, `PLAN-NAME`	Primary	BN15.1, HPLM.1, HR170, HR55.1, HR55.2, HR55.3, HR70.1, ZH230 +22 more (list truncated in source)
`PLMSET2`	`COMPANY`, `PLAN-CLASS`, `PLAN-NAME`	KeyChange	—
`PLMSET3`	`COMPANY`, `COUNTRY-CODE`, `PLAN-NAME`		TA20.1, TA20.2, TA20.3, TA20.4, TA20.5, TA220, TA40.1
`PLMSET4`	`COMPANY`, `COUNTRY-CODE`, `PLAN-CLASS`, `PLAN-NAME`	KeyChange	—

Relations

One to one (8) — lookups and parents

Relation	Table	Rules	Condition	Field map
Accrual Acount	GLMASTER	Required	When PLM-GL-TRANS = "Y"	`PLM-COMPANY` → `GLM-COMPANY`, `PLM-ACR-ACCT-UNIT` → `GLM-ACCT-UNIT`, `PLM-ACR-ACCOUNT` → `GLM-ACCOUNT`, `PLM-ACR-SUB-ACCT` → `GLM-SUB-ACCOUNT`
Company	PRSYSTEM	Required		`PLM-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`
Employee Group	PERSGROUP	Required	When PLM-GROUP-NAME != Spaces	`PLM-COMPANY` → `PRG-COMPANY`, `PLM-GROUP-NAME` → `PRG-GROUP-NAME`
Ep Los Pay Cl	PAYCLASS	Required	When PLM-EP-LOS-UOT = "H"	`PLM-COMPANY` → `PCL-COMPANY`, `PLM-EP-LOS-PAY-CL` → `PCL-PAY-CLASS`
Exp Account	GLMASTER	Required	When PLM-GL-TRANS = "Y"	`PLM-COMPANY` → `GLM-COMPANY`, `PLM-EXP-ACCT-UNIT` → `GLM-ACCT-UNIT`, `PLM-EXP-ACCOUNT` → `GLM-ACCOUNT`, `PLM-EXP-SUB-ACCT` → `GLM-SUB-ACCOUNT`
Hrs Pay Class	PAYCLASS	Required		`PLM-COMPANY` → `PCL-COMPANY`, `PLM-HRS-PAY-CL` → `PCL-PAY-CLASS`
Los Pay Class	PAYCLASS	Required	When PLM-LOS-UOT = "H"	`PLM-COMPANY` → `PCL-COMPANY`, `PLM-LOS-PAY-CL` → `PCL-PAY-CLASS`
Plan Class	PLANCLASS	Required	When PLM-PLAN-CLASS != Spaces	`PLM-COMPANY` → `PLC-COMPANY`, `PLM-PLAN-CLASS` → `PLC-PLAN-CLASS`

One to many (8) — child tables

Relation	Table	Rules	Field map
Accrual Limit	ACTRLIMIT	Delete Cascades	`PLM-COMPANY` → `ATL-COMPANY`, `PLM-PLAN-NAME` → `ATL-PLAN-NAME`, `"A"` → `ATL-LIMIT-TYPE`, → `ATL-THRU-LIM-CYC`
Formula	TAFORMULA	Required	`PLM-COMPANY` → `TAF-COMPANY`, → `TAF-CALC-NAME`
Pgemployee	PGEMPLOYEE		`PLM-COMPANY` → `PGE-COMPANY`, → `PGE-GROUP-NAME`, → `PGE-EMPLOYEE`
Pgselect	PGSELECT		`PLM-COMPANY` → `PGS-COMPANY`, → `PGS-GROUP-NAME`, → `PGS-EMPLOYEE`, → `PGS-SEQ-NBR`
Plan Employees	EMTAMASTR	Delete Restricted	`PLM-COMPANY` → `ETM-COMPANY`, `PLM-PLAN-NAME` → `ETM-PLAN-NAME`, → `ETM-EMPLOYEE`
Schedule	ACCRSCHED	Delete Cascades	`PLM-COMPANY` → `ACS-COMPANY`, `PLM-PLAN-NAME` → `ACS-PLAN-NAME`, → `ACS-THRU-CYCLE`
Taeemaster	TAEEMASTER		`PLM-COMPANY` → `TEM-COMPANY`, → `TEM-EMPLOYEE`, → `TEM-PLAN`, → `TEM-EMPLOYEE-GROUP`, → `TEM-POSITION`
Transfer Limit	ACTRLIMIT	Delete Cascades	`PLM-COMPANY` → `ATL-COMPANY`, `PLM-PLAN-NAME` → `ATL-PLAN-NAME`, `"E"` → `ATL-LIMIT-TYPE`, → `ATL-THRU-LIM-CYC`

Programs

Updated by (6)

TA20.1 Plan
TA20.2 Accrual Schedule
TA20.3 Accrual Limit
TA20.4 Transfer Schedule
TA20.5 Eligibility Limit
TA40.1 Canada Vacation Plan Master

Referenced by (51)

BN15.1 Benefit Plan
HPLM.1 Plan Name Selection Invoke
HR170 Human Resource Writer Report Request
HR55.1 Employee Group Definition
HR55.2 Employee Groups By Employees
HR55.3 Employee Groups By Criteria
HR70.1 Human Resource Writer Inquiry
PR134 Automatic Time Records
PR135 Time Record Edit
PR32.2 Employee Daily Time Entry
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
PR530 Time Record Interface CSV
PR80.1 Manual Check
PR80.4 Manual Payment
TA05.1 Plan Class
TA147 Canada Vacation Audit
TA148 Canada Vacation Rollover
TA175 Time Accrual Report
TA220 Plan Listing
TA241 Canada Vacation Transaction Report
TA242 Canada Vacation Employee Plan, Balance Listing
TA260 Employee Plan Listing
TA265 History Usage Report
TA270 Open Manual Transactions
TA290 Transaction History Report
TA310 Employee Plan Purge
TA341 Canada Vacation Employee Plan Purge
TA42.1 Canada Vacation Adjustments
TA50.1 Canada Employee Vacation Plan
TA542 Canada Vacation Balance Load
TA570 CSV Load Balances
TA60.1 Employee Plan Inquiry
TA65.1 Plan Balance Inquiry
TA65.2 Yearly Activity Inquiry
TA65.3 Employee Transaction Inquiry
TA70.1 Plan Adjustments
TA70.2 Employee Plan Adjustments
TA80.1 Plan Transfer
TA81.1 Canada Vacation Plan Transfer
ZH230 PPH Big Bad Edit