Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

TMEMPLEAVE


                            TMEMPLEAVE FILE

REFERENCED BY

UK220     UK20.1    UK20.2    UK260

UPDATED BY

UK34.1    UK120     UK60.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

TEL-EMPLOYEE           Numeric 9                                 UK120   UK60.1
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.

TEL-PLAN-NAME          Alpha 10                                  UK120   UK60.1
Element: From Plan NameThis field contains the plan name.

TEL-PL-ENTRY-DATE      Numeric 8  (yyyymmdd)                     UK120   UK60.1
Element: Plan Entry Date

TEL-PL-END-DATE        Numeric 8  (yyyymmdd)                     UK120   UK60.1
Element: Plan End Date

TEL-PREV-ABS-DATE      Numeric 8  (yyyymmdd)
Element: Prev Abs Date

TEL-PREV-ABS-TIME      Signed 7.2
Element: Prev Abs Time

TEL-PREV-ABS-UNITS     Alpha 1
Element: Prev Abs Units

TEL-AVGE-EARNS         Signed 7.2
Element: Avge Earns

TEL-NEXT-CALC-DATE     Numeric 8  (yyyymmdd)                     UK34.1
Element: Next Calc Date

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

                         TMEMPLEAVE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TELSET1   COMPANY                                                UK34.1  UK120
          EMPLOYEE                                               UK220   UK60.1
          PLAN-NAME
          PL-ENTRY-DATE

TELSET2   COMPANY                                                UK20.1  UK20.2
          PLAN-NAME                                              UK260
          EMPLOYEE
          PL-ENTRY-DATE

TELSET3   COMPANY
          EMPLOYEE
          ATTEND-CLASS
          PLAN-NAME
          PL-ENTRY-DATE

TELSET4   COMPANY       KeyChange, Subset
          EMPLOYEE      Where NEXT-CALC-DATE != Zeroes
          NEXT-CALC-DATE
          ATTEND-CLASS
          PLAN-NAME
          PL-ENTRY-DATE

                         TMEMPLEAVE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            TEL-COMPANY          -> PRS-COMPANY  (PRSSET1)
                            Spaces               -> PRS-PROCESS-LEVEL

Employee       EMPLOYEE     Required

                            TEL-COMPANY          -> EMP-COMPANY
                            TEL-EMPLOYEE         -> EMP-EMPLOYEE

Tmleave        TMLEAVE      Required

                            TEL-COMPANY          -> TLV-COMPANY
                            TEL-PLAN-NAME        -> TLV-PLAN-NAME
                            TEL-PL-ENTRY-DATE    -> TLV-EFFECT-DATE

                         TMEMPLEAVE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Tmemplvdtl     TMEMPLVDTL   Delete Cascades

                            TEL-COMPANY          -> TED-COMPANY
                            TEL-EMPLOYEE         -> TED-EMPLOYEE
                            TEL-PLAN-NAME        -> TED-PLAN-NAME
                                                    TED-TR-DATE
                                                    TED-ATTEND-CODE