Lawson Insight Technical Documentation

                            TMEMPLVDTL FILE

REFERENCED BY

UK260

UPDATED BY

AC541     AC542     BN150     PR128     PR131     PR132
PR134     PR136     PR32.2    PR33.2    PR33.3    PR35.1
PR35.2    PR35.3    PR35.4    PR35.5    PR35.6    PR35.8
PR36.1    PR530     PR82.1    UK102     UK120     UK60.1
UK70.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

TED-COMPANY          Numeric 4                                   UK120   UK60.1
Company              The company number represents an
                     established company and is entered on
                     all function codes.

TED-EMPLOYEE         Numeric 9                                   UK120   UK60.1
Employee             Contains the employee number. Each
                     person employed by the company is
                     assigned a unique number. The system
                     uses the employee number to correlate
                     all of the information related to that
                     person.

TED-PLAN-NAME        Alpha 10                                    UK120   UK60.1
From Plan Name       This field contains the plan name.

TED-TR-DATE          Numeric 8  (yyyymmdd)                       UK120   UK60.1
Time Record Date

TED-TIME-SEQ         Numeric 12                                  UK120   UK60.1
Sequence Number

TED-ATTEND-CODE      Alpha 2                                     UK120   UK60.1
Attendance Code      A user-defined alphanumeric code that       UK70.1
                     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.

TED-PCD-SEQ-NBR      Numeric 4                                   UK120   UK60.1
Pcd Seq Nbr                                                      UK70.1

TED-HOURS            Signed 7.2                                  UK120   UK60.1
Hours                Contains the hours.                         UK70.1

                         TMEMPLVDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TEDSET1   COMPANY                                                AC541   AC542
          EMPLOYEE                                               BN150   PR128
          TIME-SEQ                                               PR131   PR132
                                                                 PR134   PR136
                                                                 PR32.2  PR33.2
                                                                 PR33.3  PR35.1
                                                                 PR35.2  PR35.3
                                                                 PR35.4  PR35.5
                                                                 PR35.6  PR35.8
                                                                 PR36.1  PR530
                                                                 PR82.1  UK102
                                                                 UK120   UK260
                                                                 UK70.1

TEDSET2   COMPANY                                                UK120   UK260
          PLAN-NAME                                              UK60.1  UK60.2
          EMPLOYEE
          TR-DATE*
          TIME-SEQ

TEDSET3   COMPANY                                                UK120
          EMPLOYEE
          PLAN-NAME
          TR-DATE
          TIME-SEQ

                         TMEMPLVDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Attend Code    ATTENDCODE   Required

                            TED-COMPANY        -> ATC-COMPANY
                            TED-ATTEND-CODE    -> ATC-ATTEND-CODE

Company        PRSYSTEM     Required

                            TED-COMPANY        -> PRS-COMPANY
                            Spaces             -> PRS-PROCESS-LEVEL

Employee       EMPLOYEE     Required

                            TED-COMPANY        -> EMP-COMPANY
                            TED-EMPLOYEE       -> EMP-EMPLOYEE

Prpaycode      PRPAYCODE    Required

                            TED-COMPANY        -> PCD-COMPANY
                            TED-PCD-SEQ-NBR    -> PCD-SEQ-NBR

Tmempleave     TMEMPLEAVE   Required

                            TED-COMPANY        -> TEL-COMPANY
                            TED-EMPLOYEE       -> TEL-EMPLOYEE
                            TED-PLAN-NAME      -> TEL-PLAN-NAME

Tmleave        TMLEAVE      Required

                            TED-COMPANY        -> TLV-COMPANY
                            TED-PLAN-NAME      -> TLV-PLAN-NAME

Tmtime         TMTIME       Required

                            TED-COMPANY        -> TMT-COMPANY
                            TED-EMPLOYEE       -> TMT-EMPLOYEE
                            TED-TIME-SEQ       -> TMT-TIME-SEQ