Absence Management – Lawson LP tables and programs

Absence Management (LP) in Lawson S3 v10 MSP6 has 31 tables, 60 online screens and 40 batch programs.

Tables (31)

Table	Prefix	Description	Primary key	Fields
BNTAEMPBAL	`BTE`	Emp Vacation Buy/Sell Balance	`COMPANY, PLAN-CODE, EMPLOYEE, TA-PLAN, EMPLOYEE-GROUP, POSITION, START-DATE`	17
BNTAGROUP	`BTG`	Vacation Buy/Sell Emp Groups	`COMPANY, PLAN-CODE, TA-PLAN, EMPLOYEE-GROUP`	8
LPEMPLEAVE	`LEL`	Employee Leave of Absence	`COMPANY, EMPLOYEE, SEQ-NBR`	64
LPLINK	`LNK`	LP Link Plan Table	`COMPANY, LINK-PLAN-TB, TABLE-TYPE`	37
LPPENDREQ	`LPQ`	No description in the Lawson data dictionary	`COMPANY, EMPLOYEE, SEQ-NUMBER`	21
TAACCRUAL	`TAR`	Absence Plan Accrual Rule	`COMPANY, ACCRUAL-RULE`	47
TACALC	`TCA`	Absence Plan Rule Calculations	`COMPANY, CALCULATION`	30
TAEEGROUP	`TGR`	Absence Plan Employee Group	`COMPANY, EMPLOYEE, EMPLOYEE-GROUP, EFFECTIVE-DATE, QUALIFY-FLAG`	12
TAEEMASTER	`TEM`	Employee Absence Plan	`COMPANY, EMPLOYEE, PLAN, EMPLOYEE-GROUP, POSITION`	121
TAELIGIBLE	`TEG`	Absence Plan Eligibility Rule	`COMPANY, ELIGIBLE-RULE`	18
TAEMPSERV	`TES`	Employee LP Service Record	`COMPANY, EMPLOYEE, TES-OBJ-ID`	38
TAEMPTRANS	`TTR`	This file contains the accrual plan transactions for each plan structure for an employee.	`COMPANY, EMPLOYEE, PLAN, EMPLOYEE-GROUP, POSITION, DATE, SEQ-NBR`	36
TAENROLL	`TEN`	No description in the Lawson data dictionary	`COMPANY, EMPLOYEE, PLAN, EMPLOYEE-GROUP, POSITION, JOB-CODE, PROCESS-LEVEL, DEPARTMENT`	18
TAFORMULAS	`TFO`	No description in the Lawson data dictionary	`COMPANY, FORMULA`	9
TAFORMULAX	`TFX`	No description in the Lawson data dictionary	`COMPANY, FORMULA, FROM-HOURS, RATIO-SRV-CLS, FORMULA-DATE`	12
TAGENLEDGR	`TGE`	LP General Ledger Rule	`COMPANY, GL-RULE`	35
TALIMIT	`TLM`	Absence Plan Limit Rule	`COMPANY, LIMIT-RULE`	29
TALOSHRS	`TLH`	No description in the Lawson data dictionary	`COMPANY, EMPLOYEE, PLAN, EMPLOYEE-GROUP, POSITION, PLAN-RULE, ACCRUAL-TYPE, YEAR`	13
TAPAYROLL	`TPR`	Absence Plan Payroll Rule	`COMPANY, PAYROLL-RULE`	39
TAPLAN	`TAP`	Absence Plan	`COMPANY, PLAN`	14
TAREASCLSS	`TRL`	Absence Plan Reason Class	`COMPANY, REASON-CLASS`	3
TAREASCODE	`TRE`	Absence Plan Reason Code	`COMPANY, REASON-CODE`	8
TAREASONS	`TRO`	Reason Class & Code Relations	`COMPANY, REASON-CLASS, REASON-CODE`	3
TASERVCLSS	`TSL`	Absence Plan Service Class	`COMPANY, SERVICE-CLASS`	3
TASERVCODE	`TSC`	Absence Plan Service Code	`COMPANY, SERVICE-CODE`	8
TASERVICE	`TSV`	Service Class & Code Relations	`COMPANY, SERVICE-CLASS, SERVICE-CODE`	5
TASERVRULE	`TSR`	Absence Plan Service Rule	`COMPANY, SERVICE-RULE`	18
TASTRUCTUR	`TST`	Absence Plan Structure	`COMPANY, PLAN, EMPLOYEE-GROUP, BEGIN-DATE`	21
TATABLE	`TBL`	No description in the Lawson data dictionary	`COMPANY, TABLE, EFFECTIVE-DATE`	14
TATABLEX	`TBX`	No description in the Lawson data dictionary	`COMPANY, TABLE, EFFECTIVE-DATE, FROM`	12
TATRANSUM	`TTS`	No description in the Lawson data dictionary	`COMPANY, EMPLOYEE, PLAN, EMPLOYEE-GROUP, POSITION, TA-TYPE, RESET-DATE`	45

Online screens (60)

Screen	Description	Updates	References
LP00.1	Absence Management Cycle Status	1	2
LP01.1	Absence Plan	3	6
LP02.1	Plan Structure	5	16
LP02.2	Plan Structure Auto Balance Transfer	1	0
LP03.1	Service Rule	2	13
LP03.2	Accrual Rule	2	13
LP03.3	Eligibility Rule	2	13
LP03.4	Limit Rule	2	13
LP03.5	Payroll Rule	2	13
LP03.6	General Ledger Rule	2	12
LP04.2	Cycle Based Accrual Table	5	7
LP04.3	Cycle Based Allotment Table	5	7
LP04.4	Cycle Based Limit Table	5	7
LP04.5	Cycle Based GL Liability Table	5	7
LP04.6	Hours Based Accrual Table	5	8
LP04.7	Hours Based Allotment Table	5	8
LP04.8	Hours Based Limit Table	5	8
LP04.9	Hours Based GL Liability Table	5	8
LP06.2	Cycle Amount Formula	3	4
LP06.3	Hours Amount Formula	3	4
LP06.4	Ratio Formula	3	4
LP06.5	Date Formula	3	4
LP07.1	Calculation	3	6
LP08.1	Service Class	10	10
LP08.2	Service Code	8	9
LP08.3	Service Class and Code Relationships	1	3
LP08.4	Service Code and Class Relationships	1	3
LP09.1	Reason Class	3	3
LP09.2	Reason Code	5	5
LP09.3	Reason Class and Code Relationships	1	3
LP09.4	Reason Code and Class Relationships	1	3
LP10.1	Link Plan Table	4	10
LP15.1	Absence Plan Benefit Groups	1	4
LP31.1	Employee Absence Plan Master	5	24
LP32.1	Employee Absence Enrollment	1	7
LP32.2	Employee Absence Enrollment	1	7
LP32.3	Employee Absence Enrollment	1	7
LP34.1	Absence Plan Hours Allocation	2	8
LP35.1	Employee Absence Group Audit	1	4
LP51.1	Employee Leave of Absence	2	13
LP53.1	Employee Service Entry	2	9
LP54.1	Employee Event History Update	3	5
LP60.1	Employee Service Inquiry	0	7
LP60.2	Employee Event Inquiry	0	7
LP60.3	Employee Service Totals	1	4
LP60.4	Employee Event Totals	1	4
LP61.1	Company Event Inquiry	0	7
LP62.1	Employee Date Calendar	1	7
LP62.2	Employee Days Calendar	1	7
LP63.1	Absence Plan Hours Balances	0	7
LP63.2	Absence Plan Earnings Balances	0	7
LP64.1	Employee Transaction Detail Inquiry	0	9
LP64.2	Employee Transaction Summary Inquiry	0	9
LP64.3	Employee Transaction Detail Balance Inquiry	0	9
LP65.1	Employee Plan Balance Inquiry	0	4
LP70.1	Manual Transactions by Employee	3	8
LP70.2	Manual Transactions by Plan Structure	3	8
LP80.1	Employee Absence Plan Transfer	6	25
LP88.1	Length of Service Hours	1	8
LP88.2	Totals	0	1

Batch programs (40)

Program	Description	Updates	References
HS706	HRM Time Off Planner Interface	2	10
LP100	Employee Absence Plan Update	15	48
LP101	Mass Absence Plan Add	14	46
LP102	Employee Master Update	10	32
LP103	Mass Absence Plan Termination	7	24
LP130	Absence Plan Payout	44	80
LP131	Zero Balance Update	8	24
LP138	Absence Plan Hours Update	5	11
LP140	Employee Absence Plan Calculation	11	31
LP145	Allotment Adjustment Calculation	9	23
LP151	FMLA Rolling 12 Month Update	9	28
LP180	Mass Absence Plan Transfer	8	28
LP188	Length of Service Hours Update	5	18
LP197	Absence Plan Close	11	24
LP198	General Ledger Liability Update	16	33
LP199	Close Unprocessed Service Records	2	11
LP201	Absence Plan Listing	1	23
LP203	Absence Plan Rules Listing	1	16
LP204	Rules Tables Listing	1	4
LP206	Formula Listing	1	5
LP207	Calculation Listing	1	4
LP208	Service Code Listing	2	3
LP209	Reason Code Listing	2	3
LP210	Service Class Listing	1	4
LP211	Reason Class Listing	1	4
LP220	Employee Absence Plan or Leave History Report	3	10
LP231	Employee Plan Master Listing	1	14
LP240	Employee Plan Transaction Report	1	9
LP251	Employee Leave of Absence Report	5	20
LP260	Employee Service and Event Report	1	19
LP262	Employee Event Audit Report	1	17
LP264	Employee Transaction History Report	2	14
LP270	Open Manual Transactions	2	10
LP331	Employee Absence Plan Purge	7	7
LP353	Employee Service History Purge	4	5
LP370	Employee Absence Transaction Consolidation	3	4
LP553	Employee Service and Event Conversion	3	8
LP554	Employee Service and Event History Conversion	3	8
LP570	Manual Transaction Conversion	3	8
LP900	LP Enable	3	3

Other tables used by Absence Management programs (123)

ACACCTCAT, ACACTGRP, ACACTIVITY, ACCAL, ACCALX, ACCATSUMX, ACCOMMIT, ACCOMMITX, ADDRDATA, ATTENDCODE, BENEFIT, BNCHANGE, BNCOMPANY, BNGRPCHG, C6EMDDMSTR, C6EMPADDRT, C6PRDDEF, C6PRDDTL, CMASSIGN, CMCONTRACT, CMCONTRULE, CMPAYCYC, CUCODES, CUCONV, CURELAT, CWASSIGN, CWCONTRACT, CWCONTRULE, DEDCODE, DEDFREQTBL, DEPTCODE, DEPTSEGBLK, EMDEDMASTR, EMDISTMAST, EMPCODES, EMPLOYEE, EMSTATUS, EMTATRANS, FBDETAIL, FBFUNDAMT, FBFUNDDTL, FBTRANS, FBYETR, FLEXDOLLAR, FLEXPLAN, GLADDRESS, GLCHART, GLCHARTDTL, GLCODES, GLCOMMIT, GLCOMMITX, GLHISCOMBL, GLHISCOMX, GLINTCO, GLNAMES, GLSYSTEM, HRCTRYCODE, HREMPRCVR, HREMPUSF, HRHISTORY, HRLTMRULE, HRSECLEV, HRSUPER, HRUSERFLDS, HRWRKSCHD, INSTCTRYCD, JOBCODE, OBJID, ONETMDED, PADICT, PADICT2, PAEMPAPP, PAEMPLOYEE, PAEMPPOS, PAPOSITION, PAPOSRULE, PASCRTY, PATHFIND, PAYDEDUCTN, PAYMASTR, PAYSUMGRP, PCODES, PCODESDTL, PERSACTION, PERSACTYPE, PERSGROUP, PGEMPLOYEE, PGSELECT, PLAN, PRBATCH, PRBUSGRP, PRCHECK, PREMDEDHST, PRMONITOR, PROVERTIME, PRPAYCODE, PRPENPAY, PRPROCGRP, PRPROVINCE, PRQCENTGRP, PRRATEHIST, PRRATES, PRREGPARM, PRSAGDTL, PRSAGHEAD, PRSHIFTHDR, PRSHIFTTBL, PRSTATE, PRSYSTEM, PRTAXAUTH, PRTAXLEVY, PRTAXLOC, PRTIME, PSGRELATE, STANDTIME, SUBCKPOINT, SYSTEMCODE, TAXGROUP, TIMERECORD, TIPPAY, TRSGBLCK, WCCLASSOVR, WFSETUP