Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ATTENDCODE


                            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     ET530     ETI2.1    HATC.1    HR170     HR70.1
LP130     HS01.1    HS34.1    HS35.1    HS36.1    PR128
PR130     PR131     PR132     PR134     PR136     PR189
PR195     PR197     PR20.4    PR29.1    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    PR35.9
PR36.1    PR37.1    PR45.1    PR529     PR530     PR560
PR80.1    PR82.1    PR85.1    UK102     UK560     TA147
TM02.1    TM201     TM202     TM240     TM245     TM250
TM255     TM260     TM265     TM300     TM470     TM50.1
TM52.1    TM570     TM60.1    TM61.1    TM70.1    TM71.1


UPDATED BY

TM01.1    HR00.1    HR01.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ATC-COMPANY            Numeric 4                                 TM01.1
Element: Company Hr    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
Element: Attend 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
Element: Description   Contains the attendance code
                       description.

ATC-POINTS             Signed 7.2                                TM01.1
Element: 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
Element: Pay 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                                                BN150   ET530
          ATTEND-CODE                                            ETI2.1  HATC.1
                                                                 HR00.1  HR01.1
                                                                 HR170   HR70.1
                                                                 LP130   HS01.1
                                                                 HS34.1  HS35.1
                                                                 HS36.1  PR128
                                                                 PR130   PR131
                                                                 PR132   PR134
                                                                 PR136   PR189
                                                                 PR195   PR197
                                                                 PR20.4  PR29.1
                                                                 PR30.1  PR32.1
                                                                 PR32.2  PR33.1
                                                                 PR33.2  PR33.3
                                                                 ...

                         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