Lawson Insight Technical Documentation


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

BN150     HATC.1    HR170     HR70.1    HS01.1    HS34.1
HS35.1    PR128     PR131     PR132     PR134     PR136
PR137     PR140     PR150     PR195     PR199     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    PR45.1    PR530     PR80.1    PR82.1
PR85.1    UK102     UK330     TM02.1    TM201     TM202
TM240     TM245     TM250     TM255     TM300     TM470
TM50.1    TM52.1    TM570     TM60.1    TM61.1    TM70.1
TM71.1    UK120     UK60.1    UK70.1

UPDATED BY

TM01.1    HR00.1    HR01.1    PBIP.1

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 5.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          BN150   HATC.1
          ATTEND-CODE   validate an attendance code.             HR00.1  HR01.1
                                                                 HR170   HR70.1
                                                                 PBIP.1  HS01.1
                                                                 HS34.1  HS35.1
                                                                 PR128   PR131
                                                                 PR132   PR134
                                                                 PR136   PR137
                                                                 PR140   PR150
                                                                 PR195   PR199
                                                                 PR30.1  PR32.1
                                                                 PR32.2  PR33.1
                                                                 PR33.2  PR33.3
                                                                 PR35.1  PR35.2
                                                                 PR35.3  PR35.4
                                                                 ...

                         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