Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

TMEMPLVDTL


                            TMEMPLVDTL FILE

UPDATED BY

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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

TED-COMPANY            Numeric 4
Element: Company Hr

TED-EMPLOYEE           Numeric 9
Element: 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
Element: Plan Name     This field contains the plan name.

TED-TR-DATE            Numeric 8  (yyyymmdd)
Element: Tr Date

TED-TIME-SEQ           Numeric 12
Element: Time Seq

TED-OS-TIME-SEQ        Numeric 12
Element: Os Time Seq

TED-ATTEND-CODE        Alpha 2
Element: Attend Code   A 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.

TED-PCD-SEQ-NBR        Numeric 4
Element: Pcd Seq Nbr

TED-HOURS              Signed 7.2
Element: Hours         Contains the hours.

TED-CALC-STATUS        Alpha 1
Element: Calc Status   1 = Ready for Calculation
                       2 = Calculation Completed
                       3 = Transferred to Time Records
                       4 = Ready for Deletion
                       5 = Deletion Completed

TED-AMOUNT             Currency 15.2
Element: Amount        This is the amounts by period for the
                       specified record.

TED-XFER-DATE          Numeric 8  (yyyymmdd)
Element: Xfer Date

TED-XFER-AMOUNT        Signed 7.2
Element: Xfer Amount

TED-OS-AMOUNT          Signed 7.2
Element: Os Amount

TED-XFER-OS-AMOUNT     Signed 7.2
Element: Xfer Os Amount

TED-HRS-TYPE           Alpha 1
Element: Hrs Type      H = Hours
                       D = Days
                       W = Weeks
                       M = Months

TED-EXCL-CODE          Alpha 2
Element: Excl Code

TED-PAY-CODE           Alpha 4
Element: Pay Code      Contains the pay code. A pay code is a
                       user-defined code that identifies a kind
                       of pay.

TED-XFER-PAY-CODE      Alpha 4
Element: Xfer Pay Code

TED-RATE-OS-RULE       Alpha 1
Element: Rate Os Rule

TED-RATE-OS-PCD        Alpha 4
Element: Rate Os Pcd

TED-XFER-RT-OS-PCD     Alpha 4
Element: Xfer Rt Os Pcd

TED-DAY-IND            Alpha 1
Element: Day Ind       1 = Wait
                       2 = Excluded
                       3 = SSP Day
                       4 = Non Qualifying Day
                       5 = Maternity Day
                       6 = Percentage
                       7 = No Pay
                       8 = Fixed
                       X = Other

TED-DELETION-DATE      Numeric 8  (yyyymmdd)
Element: Deletion Date

TED-TRD-DELETED        Numeric 1                                 BN150   ET530
Element: Trd Deleted                                             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
                                                                 TA147   UK102
                                                                 UK560

TED-ATTEND-CLASS       Alpha 10
Element: Attend Class  A user-defined alphanumeric code that
                       represents a group of attendance codes
                       used for reporting and inquiring.
                       Validated in the ATCLASS file.

                         TMEMPLVDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TEDSET1   COMPANY
          EMPLOYEE
          PLAN-NAME
          TR-DATE
          ATTEND-CODE

TEDSET2   COMPANY       KeyChange
          PLAN-NAME
          EMPLOYEE
          TR-DATE*
          ATTEND-CODE

TEDSET3   COMPANY       KeyChange                                BN150   ET530
          EMPLOYEE                                               ETI2.1  LP130
          TR-DATE                                                PR128   PR130
          ATTEND-CODE                                            PR131   PR132
          PLAN-NAME                                              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
                                                                 ...

TEDSET4   COMPANY       Subset
          EMPLOYEE      Where (CALC-STATUS = "2" )
          TR-DATE       Or    (CALC-STATUS = "4" )
          PLAN-NAME
          ATTEND-CODE

TEDSET5   COMPANY       KeyChange, Subset
          EMPLOYEE      Where TRD-DELETED != Zeroes
          ATTEND-CODE
          TR-DATE
          PLAN-NAME
          TRD-DELETED

                         TMEMPLVDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Attend Code    ATTENDCODE   Required

                            TED-COMPANY        -> ATC-COMPANY  (ATCSET1)
                            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

Tmleave        TMLEAVE      Required

                            TED-COMPANY        -> TLV-COMPANY
                            TED-PLAN-NAME      -> TLV-PLAN-NAME
                            TED-TR-DATE        -> TLV-EFFECT-DATE

Tmtime         TMTIME       Required

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

                         TMEMPLVDTL FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Tmempleave     TMEMPLEAVE   Required

                            TED-COMPANY        -> TEL-COMPANY
                            TED-EMPLOYEE       -> TEL-EMPLOYEE
                            TED-PLAN-NAME      -> TEL-PLAN-NAME
                                                  TEL-PL-ENTRY-DATE