Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            ATTENDCODE FILE

                            Attendance Code

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).

REFERENCED BY

AC541     AC542     BN150     HATC.1    HR170     HR70.1
HS01.1    HS34.1    HS35.1    HS36.1    PR128     PR131
PR132     PR134     PR136     PR195     PR30.1    PR32.1
PR32.2    PR33.1    PR33.2    PR33.3    PR35.1    PR35.2
PR35.3    PR35.4    PR35.5    PR35.6    PR35.8    PR36.1
PR37.1    PR530     PR82.1    PR85.1    UK102     TM02.1
TM201     TM202     TM240     TM245     TM250     TM255
TM300     TM470     TM50.1    TM52.1    TM70.1    TM71.1
UK120     UK60.1    UK70.1

UPDATED BY

TM01.1    HR00.1    HR01.1    PR197

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ATC-COMPANY          Numeric 4                                   TM01.1
Company              Contains the company number. The
                     company number must be valid in the HR
                     Company and Process Levels file and is
                     entered on all functions.

ATC-ATTEND-CODE      Alpha 2                                     TM01.1
Attendance Code      Contains 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.

ATC-DESCRIPTION      Alpha 30  (Lower Case)                      TM01.1
Description          Contains the attendance code
                     description.

ATC-POINTS           Signed 7.2                                  TM01.1
Points               Contains 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.

ATC-PAY-CODE         Alpha 4                                     TM01.1
Payment Code         Contains 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.

                         ATTENDCODE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ATCSET1   COMPANY       This path is used to access and          AC541   AC542
          ATTEND-CODE   validate an attendance code.             BN150   HATC.1
                                                                 HR00.1  HR01.1
                                                                 HR170   HR70.1
                                                                 HS01.1  HS34.1
                                                                 HS35.1  HS36.1
                                                                 PR128   PR131
                                                                 PR132   PR134
                                                                 PR136   PR195
                                                                 PR197   PR30.1
                                                                 PR32.1  PR32.2
                                                                 PR33.1  PR33.2
                                                                 PR33.3  PR35.1
                                                                 PR35.2  PR35.3
                                                                 PR35.4  PR35.5
                                                                 ...

                         ATTENDCODE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            ATC-COMPANY        -> PRS-COMPANY
                            Spaces             -> PRS-PROCESS-LEVEL

                         ATTENDCODE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Atclass        ATCLASS      Delete Restricted

                            ATC-COMPANY        -> ACL-COMPANY
                            ATC-ATTEND-CODE    -> ACL-ATTEND-CODE
                                                  ACL-ATTEND-CLASS

Code History   ATTENDHIST   Delete Restricted

                            ATC-COMPANY        -> ATH-COMPANY
                            ATC-ATTEND-CODE    -> ATH-ATTEND-CODE
                                                  ATH-DATE
                                                  ATH-EMPLOYEE
                                                  ATH-TIME-SEQ

Prpaycode      PRPAYCODE    Required
                            When ATC-PAY-CODE != Spaces

                            ATC-COMPANY        -> PCD-COMPANY
                            ATC-PAY-CODE       -> PCD-PAY-CODE
                                                  PCD-PROCESS-LEVEL
                                                  PCD-JOB-CODE