ATCLASS – Attendance Class

System
Time and Attendance (TM)
Prefix
ACL
Primary key
COMPANY, ATTEND-CLASS, ATTEND-CODE
Fields
3
Updated by
3 programs
Referenced by
12 programs

ATCLASS is the Attendance Class table in Lawson Time and Attendance (prefix ACL). It is indexed by COMPANY, ATTEND-CLASS, ATTEND-CODE (ACLSET1); alternate indexes: ACLSET2. It is related 1:1 to ATCLASSHDR, ATTENDCODE and PRSYSTEM and 1:M to ATTENDHIST. It is updated by HR00.1, HR01.1 and TM02.1 and referenced by TM01.1, TM202, TM245, TM255, TM260, TM265, TM470, TM50.1 and 4 more. The table has 3 fields, 2 indexes and 4 documented relations.

About ATCLASS

The Attendance Class file contains user-defined attendance classes. Attendance classes provide a way to group attendance codes for reporting and inquiry purposes.

Fields (3)

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

Field / columnTypeDescription & valuesUpdated by
ACL-COMPANY PK
COMPANY		Numeric 4Contains the company number. The company number represents an established company and is entered on all functions. The company number must be valid in the HR Company and Process Levels file.TM02.1
ACL-ATTEND-CLASS PK
ATTEND_CLASS		Alpha 10Contains the user-defined alphanumeric code that represents a group of attendance codes used for reporting and inquiring. Validated in the Attendance Class file.TM02.1
ACL-ATTEND-CODE PK
ATTEND_CODE		Alpha 2Contains the user-defined alphanumeric code that represents a reason for an employee's absence or hours worked. Examples of attendance codes are, sick, vacation, overtime, on the job injury, snow day, tardy, left early, and so on. Validated in the Attendance Code file.TM02.1

Indexes (2)

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

IndexKeysFlagsConditionUsed in
ACLSET1COMPANY, ATTEND-CLASS, ATTEND-CODEPrimaryHR00.1, HR01.1, TM02.1, TM202, TM245, TM255, TM260, TM265 +6 more
ACLSET2COMPANY, ATTEND-CODE, ATTEND-CLASSTM01.1, TM260

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
Attend ClassATCLASSHDRRequiredACL-COMPANY → ASH-COMPANY, ACL-ATTEND-CLASS → ASH-ATTEND-CLASS
Attend CodeATTENDCODERequiredACL-COMPANY → ATC-COMPANY, ACL-ATTEND-CODE → ATC-ATTEND-CODE
CompanyPRSYSTEMRequiredACL-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL

One to many (1) — child tables

RelationTableRulesConditionField map
Class HistoryATTENDHISTACL-COMPANY → ATH-COMPANY, ACL-ATTEND-CODE → ATH-ATTEND-CODE, → ATH-DATE, → ATH-EMPLOYEE, → ATH-TIME-SEQ

Programs

Updated by (3)

Referenced by (12)