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     HATC.1    HR170     HR70.1    HS01.1    HS34.1
HS35.1    HS36.1    PR128     PR130     PR131     PR132
PR134     PR136     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
PR82.1    PR85.1    UK102     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    TP135

UPDATED BY

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

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: Attendance CodContains 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: 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
                                                                 HS36.1  PR128
                                                                 PR130   PR131
                                                                 PR132   PR134
                                                                 PR136   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
                                                                 ...

                         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