Time and Attendance – Lawson TM tables and programs

Time and Attendance (TM) in Lawson S3 v10 MSP6 has 6 tables, 9 online screens and 11 batch programs.

Tables (6)

Table	Prefix	Description	Primary key	Fields
ATCLASS	`ACL`	Attendance Class	`COMPANY, ATTEND-CLASS, ATTEND-CODE`	3
ATCLASSHDR	`ASH`	No description in the Lawson data dictionary	`COMPANY, ATTEND-CLASS`	4
ATTENDCODE	`ATC`	Attendance Code	`COMPANY, ATTEND-CODE`	5
ATTENDHIST	`ATH`	Employee Attendance History	`COMPANY, DATE, ATTEND-CODE, EMPLOYEE, TIME-SEQ`	15
TMLEAVE	`TLV`	No description in the Lawson data dictionary	`COMPANY, PLAN-NAME, EFFECT-DATE`	37
TMLEAVEDTL	`TLD`	No description in the Lawson data dictionary	`COMPANY, PLAN-NAME, REM-UNITS`	4

Online screens (9)

Screen	Description	Updates	References
TM01.1	Attendance Code	1	4
TM02.1	Attendance Class	2	2
TM50.1	Employee Attendance Inquiry	0	7
TM50.2	Employee Attendance Totals	0	2
TM52.1	Attendance Inquiry	0	9
TM60.1	Employee Date Calendar	0	6
TM61.1	Employee Days Calendar	0	6
TM70.1	Employee Attendance History	2	5
TM71.1	Attendance History Speed Entry	2	5

Batch programs (11)

Program	Description	Updates	References
TM201	Attendance Code Listing	1	2
TM202	Attendance Class Listing	1	4
TM240	Employee Attendance Code Report	1	10
TM245	Employee Attendance Class Report	1	11
TM250	Attendance Code Distribution Report	1	8
TM255	Attendance Class Distribution Report	1	9
TM260	Absence Monitoring Report	1	11
TM265	Lost Time Report	1	12
TM300	Attendance History Purge	2	3
TM470	Attendance History Audit Report	1	13
TM570	Attendance History Conversion	3	5

Other tables used by Time and Attendance programs (16)

DEPTCODE, EMPLOYEE, EMSTATUS, HRSECLEV, HRSUPER, JOBCODE, PAPOSITION, PERSGROUP, PGEMPLOYEE, PGSELECT, PREMPWKPAT, PRPAYCODE, PRSYSTEM, PRTIME, PRWKPAT, PRWKPATDTL