Lawson Insight Technical Documentation

                              ATCLASS FILE

                            Attendance Class

The Attendance Class file contains user-defined attendance classes.
Attendance classes provide a way to group attendance codes for reporting and
inquiry purposes.

REFERENCED BY

TM202     TM245     TM255     TM260     TM265     TM470
TM50.1    TM50.2    TM52.1    TM60.1    TM61.1    BN150
ET530     ETI2.1    LP130     PR128     PR130     PR131
PR132     PR134     PR136     PR189     PR29.1    PR32.2
PR33.2    PR33.3    PR35.1    PR35.2    PR35.3    PR35.4
PR35.5    PR35.6    PR35.8    PR35.9    PR36.1    PR45.1
PR529     PR530     PR560     PR80.1    PR82.1    UK102
UK560     TA147     TM01.1

UPDATED BY

TM02.1    HR00.1    HR01.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ACL-COMPANY            Numeric 4                                 TM02.1
Element: Company Hr    Contains the company number. The
                       company number represents an established
                       company and is entered on all functions.
                       The company number must be valid in the
                       HR Company and Process Levels file.

ACL-ATTEND-CLASS       Alpha 10                                  TM02.1
Element: Attend Class  Contains the user-defined alphanumeric
                       code that represents a group of
                       attendance codes used for reporting and
                       inquiring. Validated in the Attendance
                       Class file.

ACL-ATTEND-CODE        Alpha 2                                   TM02.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.

                         ATCLASS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ACLSET1   COMPANY                                                HR00.1  HR01.1
          ATTEND-CLASS                                           TM02.1  TM202
          ATTEND-CODE                                            TM245   TM255
                                                                 TM260   TM265
                                                                 TM470   TM50.1
                                                                 TM50.2  TM52.1
                                                                 TM60.1  TM61.1

ACLSET2   COMPANY                                                BN150   ET530
          ATTEND-CODE                                            ETI2.1  LP130
          ATTEND-CLASS                                           PR128   PR130
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR189   PR29.1
                                                                 PR32.2  PR33.2
                                                                 PR33.3  PR35.1
                                                                 PR35.2  PR35.3
                                                                 PR35.4  PR35.5
                                                                 PR35.6  PR35.8
                                                                 PR35.9  PR36.1
                                                                 PR45.1  PR529
                                                                 PR530   PR560
                                                                 PR80.1  PR82.1
                                                                 ...

                         ATCLASS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Attend Class   ATCLASSHDR   Required

                            ACL-COMPANY         -> ASH-COMPANY
                            ACL-ATTEND-CLASS    -> ASH-ATTEND-CLASS

Attend Code    ATTENDCODE   Required

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

Company        PRSYSTEM     Required

                            ACL-COMPANY         -> PRS-COMPANY
                            Spaces              -> PRS-PROCESS-LEVEL

                         ATCLASS FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Class History  ATTENDHIST

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