Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              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     TM470     TM50.1    TM50.2
TM52.1    UK120     UK20.1    UK60.1    UK70.1    TM01.1

UPDATED BY

TM02.1    HR00.1    HR01.1    PR197

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ACL-COMPANY          Numeric 4                                   TM02.1
Company              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
Attendance 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
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.

                         ATCLASS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ACLSET1   COMPANY       This path is used to validate an         HR00.1  HR01.1
          ATTEND-CLASS  attendance class for a specific company  PR197   TM02.1
          ATTEND-CODE   or to locate all of the attendance codes TM202   TM245
                        within an attendance class.              TM255   TM470
                                                                 TM50.1  TM50.2
                                                                 TM52.1  UK120
                                                                 UK20.1  UK60.1
                                                                 UK70.1

ACLSET2   COMPANY       This path is used to determine if an     TM01.1
          ATTEND-CODE   attendance code is attached to an
          ATTEND-CLASS  attendance class and if so, you cannot
                        delete the code.

                         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