Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ATTENDHIST


                            ATTENDHIST FILE

                      Employee Attendance History

The Attendance History file contains employee attendance history information.
TM70 (Attendance History) and PR199 (Payroll Close) are the primary programs
that update this file.  More than one attendance record can exist for an
employee for the same day. For this reason a sequence number is needed to
maintain record uniqueness.

REFERENCED BY

TM240     TM245     TM52.1    HR170     HR70.1    TM470
TM50.1    TM50.2    TM60.1    TM61.1    TM01.1    TM250
TM255     TM260     TM265

UPDATED BY

AC542     PR195     PR197     PR82.1    PR85.1    TM300
TM570     TM70.1    TM71.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ATH-COMPANY            Numeric 4                                 AC542   PR195
Element: Company       Contains the company number. Validated    PR197   PR82.1
                       in the HR Company and Process Levels      PR85.1  TM570
                       file.                                     TM70.1  TM71.1

ATH-DATE               Numeric 8  (yyyymmdd)                     AC542   PR195
Element: Date          Contains the system date this record      PR197   PR82.1
                       was created.                              PR85.1  TM570
                                                                 TM70.1  TM71.1

ATH-ATTEND-CODE        Alpha 2                                   AC542   PR195
Element: Attendance CodContains the user-defined alphanumeric    PR197   PR82.1
                       code that represents a reason for an      PR85.1  TM570
                       employee's absence or hours worked.       TM70.1  TM71.1
                       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.

ATH-EMPLOYEE           Numeric 9                                 AC542   PR195
Element: Employee      Contains the employee number associated   PR197   PR82.1
                       with this attendance record. Validated    PR85.1  TM570
                       in the Employee file.                     TM70.1  TM71.1

ATH-TIME-SEQ           Numeric 12                                AC542   PR195
Element: Sequence NumbeContains the system-assigned number       PR197   PR82.1
                       that makes the record unique.             PR85.1  TM570
                                                                 TM70.1  TM71.1

ATH-PROCESS-LEVEL      Alpha 5                                   AC542   PR195
Element: Process Level Contains the process level with which     PR197   PR82.1
                       this attendance record is associated.     PR85.1  TM570
                       Validated in the HR Company and Process   TM70.1  TM71.1
                       Levels file.

ATH-DEPARTMENT         Alpha 5                                   AC542   PR195
Element: Department    Contains the department with which this   PR197   PR82.1
                       attendance record is associated.          PR85.1  TM570
                       Validated in the Department file.         TM70.1  TM71.1

ATH-HOURS              Signed 7.2                                AC542   PR195
Element: Hours         Contains the hours associated with this   PR197   PR82.1
                       attendance code. PR199 (Payroll Close)    PR85.1  TM570
                       creates attendance history for time       TM70.1  TM71.1
                       records with an attendance code
                       attached. Hours is an optional entry for
                       manual type records.

ATH-POINTS             Signed 7.2                                AC542   PR195
Element: Points        Contains the points associated with the   PR197   PR82.1
                       attendance code. The value in this field  PR85.1  TM570
                       defaults from the Points field in the     TM70.1  TM71.1
                       Attendance Code file. You can override
                       Points in TM70 (Attendance History) if
                       appropriate.

ATH-OCCURRENCE         Alpha 1                                   AC542   PR195
Element: Occurrence    Contains the value that indicates         PR197   PR82.1
                       whether this record is a unique           PR85.1  TM570
                       attendance occurrence or a continuation   TM70.1  TM71.1
                       of a previous occurrence. For example,
                       if an employee is sick on Monday and
                       Thursday, this is considered two
                       occurrences. If an employee is sick on
                       Monday and Tuesday, Monday is considered
                       an occurrence and Tuesday is not since
                       it is a continuation of Mondays
                       occurrence.
                       N = No
                       Y = Yes

ATH-RECORD-TYPE        Alpha 1                                   AC542   PR195
Element: Record Type   Contains the value that identifies the    PR197   PR82.1
                       record type. Attendance history records   PR85.1  TM570
                       created by PR199 (Payroll Close) are      TM70.1  TM71.1
                       system records. Records added or changed
                       through TM70 (Attendance History) are
                       manual records.
                       M = Manual
                       S = System

ATH-DAYS-IND           Numeric 1                                 AC542   PR195
Element: Days IndicatorContains the numeric value that           PR197   PR82.1
                       represents the day of the week on which   PR85.1  TM570
                       the occurrence took place.                TM70.1  TM71.1
                       1 = Sun
                       2 = Mon
                       3 = Tue
                       4 = Wed
                       5 = Thu
                       6 = Fri
                       7 = Sat

ATH-DATE-STAMP         Numeric 8  (yyyymmdd)                     AC542   PR195
Element: Date Stamp    This field contains the server date       PR197   PR82.1
                       (month, date, and year) of the last       PR85.1  TM570
                       change to this record.                    TM70.1  TM71.1

ATH-TIME-STAMP         Numeric 6  (hhmmss)                       AC542   PR195
Element: Time Stamp    Contains the server time (hour, minute,   PR197   PR82.1
                       and second) when the record was last      PR85.1  TM570
                       changed.                                  TM70.1  TM71.1

ATH-USER-ID            Alpha 10  (Lower Case)                    AC542   PR195
Element: User                                                    PR197   PR82.1
                                                                 PR85.1  TM570
                                                                 TM70.1  TM71.1

                         ATTENDHIST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ATHSET1   COMPANY       This path is used to access history      TM240   TM245
          DATE          records by date.                         TM300   TM52.1
          ATTEND-CODE                                            TM570   TM70.1
          EMPLOYEE                                               TM71.1
          TIME-SEQ

ATHSET2   COMPANY       This path is used to access history      HR170   HR70.1
          EMPLOYEE      records for a particular employee in     TM300   TM470
          DATE*         date sequence.                           TM50.1  TM50.2
          ATTEND-CODE                                            TM52.1  TM60.1
          TIME-SEQ*                                              TM61.1  TM70.1
                                                                 TM71.1

ATHSET3   COMPANY       This path is used to access history      TM01.1  TM240
          ATTEND-CODE   records by a particular attendance code. TM245   TM250
          DATE*                                                  TM255   TM260
          EMPLOYEE                                               TM265   TM300
          TIME-SEQ*                                              TM52.1

ATHSET4   COMPANY       This path is used to access history      TM240   TM245
          EMPLOYEE      records for a particular employee and    TM250   TM255
          ATTEND-CODE   attendance code.                         TM260   TM265
          DATE*                                                  TM470   TM50.1
          TIME-SEQ*                                              TM52.1

                         ATTENDHIST FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Attend Code    ATTENDCODE   Required

                            ATH-COMPANY          -> ATC-COMPANY
                            ATH-ATTEND-CODE      -> ATC-ATTEND-CODE

Company        PRSYSTEM     Required

                            ATH-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Department     DEPTCODE     Required
                            When ATH-DEPARTMENT != Spaces

                            ATH-COMPANY          -> DPT-COMPANY
                            ATH-PROCESS-LEVEL    -> DPT-PROCESS-LEVEL
                            ATH-DEPARTMENT       -> DPT-DEPARTMENT

Employee       EMPLOYEE     Required

                            ATH-COMPANY          -> EMP-COMPANY
                            ATH-EMPLOYEE         -> EMP-EMPLOYEE

Paemployee     PAEMPLOYEE   Required

                            ATH-COMPANY          -> PEM-COMPANY
                            ATH-EMPLOYEE         -> PEM-EMPLOYEE

Process Level  PRSYSTEM     Required
                            When ATH-PROCESS-LEVEL != Spaces

                            ATH-COMPANY          -> PRS-COMPANY
                            ATH-PROCESS-LEVEL    -> PRS-PROCESS-LEVEL

                         ATTENDHIST FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Prtime         PRTIME
                            Valid When (ATH-RECORD-TYPE = "S" )

                            ATH-COMPANY          -> PRT-COMPANY
                            ATH-EMPLOYEE         -> PRT-EMPLOYEE
                            ATH-DATE             -> PRT-TR-DATE
                            ATH-TIME-SEQ         -> PRT-TIME-SEQ
                                                    PRT-CHECK-ID