ATTENDCODE – Attendance Code

System
Time and Attendance (TM)
Prefix
ATC
Primary key
COMPANY, ATTEND-CODE
Fields
5
Updated by
3 programs
Referenced by
70 programs

ATTENDCODE is the Attendance Code table in Lawson Time and Attendance (prefix ATC). It is indexed by COMPANY, ATTEND-CODE (ATCSET1). It is related 1:1 to PRSYSTEM and 1:M to ATCLASS, ATTENDHIST and PRPAYCODE. It is updated by HR00.1, HR01.1 and TM01.1 and referenced by BN150, EXI2.1, EXI4.1, HATC.1, HR170, HR70.1, HS01.1, HS34.1 and 62 more. The table has 5 fields, 1 index and 4 documented relations.

About ATTENDCODE

The Attendance Code file contains the user-defined attendance codes. By linking a pay code to an attendance code, you establish pay code defaults at time record entry. Attendance history is created by PR199 (Payroll Close) for time records with an attendance code. Attendance history for attendance codes not related to payroll (those without a pay code) require entry via TM70 (Attendance History).

Fields (5)

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

Field / columnTypeDescription & valuesUpdated by
ATC-COMPANY PK
COMPANY		Numeric 4Contains the company number. The company number must be valid in the HR Company and Process Levels file and is entered on all functions.TM01.1
ATC-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.TM01.1
ATC-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)Contains the attendance code description.TM01.1
ATC-POINTS
POINTS		Signed 7.2Contains the points associated with the attendance code. The value in this field defaults to the Attendance History file record when attendance history is created. Point values assigned to attendance codes display in online inquiries, and print, with totals, on reports.TM01.1
ATC-PAY-CODE
PAY_CODE		Alpha 4Contains the pay code associated with the attendance code. If you leave the Pay Code field blank on a time record, the pay code associated with the attendance code defaults when you enter the attendance code. Validated in the Pay Code file.TM01.1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
ATCSET1COMPANY, ATTEND-CODEPrimaryBN150, HATC.1, HR00.1, HR01.1, HR170, HR70.1, PR521, EXI2.1 +22 more (list truncated in source)

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredATC-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL

One to many (3) — child tables

RelationTableRulesConditionField map
AtclassATCLASSDelete RestrictedATC-COMPANY → ACL-COMPANY, ATC-ATTEND-CODE → ACL-ATTEND-CODE, → ACL-ATTEND-CLASS
Code HistoryATTENDHISTDelete RestrictedATC-COMPANY → ATH-COMPANY, ATC-ATTEND-CODE → ATH-ATTEND-CODE, → ATH-DATE, → ATH-EMPLOYEE, → ATH-TIME-SEQ
PrpaycodePRPAYCODERequiredWhen ATC-PAY-CODE != SpacesATC-COMPANY → PCD-COMPANY, ATC-PAY-CODE → PCD-PAY-CODE, → PCD-PROCESS-LEVEL, → PCD-JOB-CODE

Programs

Updated by (3)

Referenced by (70)