Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

EMPCOMMENT


                            EMPCOMMENT FILE

REFERENCED BY

HS20.1    HS22.1    HS36.1

UPDATED BY

ES01.1    HR11.1    PA115

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ECM-COMPANY            Numeric 4                                 ES01.1
Element: Company Hr    Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

ECM-EMPLOYEE           Numeric 9                                 ES01.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.

ECM-CMT-TYPE           Alpha 2                                   ES01.1
Element: Comment Type

ECM-LN-NBR             Numeric 4                                 ES01.1
Element: Line Number

ECM-SEQ-NBR            Numeric 4                                 ES01.1
Element: Sequence NumbeAn automatically assigned sequence
                       number.

ECM-CMT-TEXT           Alpha 60  (Lower Case)                    ES01.1
Element: Comment Text  The text associated with the sequence
                       number.

ECM-DATE               Numeric 8  (yyyymmdd)                     ES01.1
Element: Date          This field displays the system date
                       when this was created.

ECM-USER-ID            Alpha 10  (Lower Case)                    ES01.1
Element: User          Contains the user ID of the person who
                       last changed this record.

ECM-PROXY-ID           Alpha 10  (Lower Case)
Element: Proxy Id

                         EMPCOMMENT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ECMSET1   COMPANY                                                ES01.1  HR11.1
          EMPLOYEE                                               PA115   HS20.1
          CMT-TYPE                                               HS22.1  HS36.1
          DATE
          LN-NBR

                         EMPCOMMENT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Employee       EMPLOYEE     Required

                            ECM-COMPANY     -> EMP-COMPANY
                            ECM-EMPLOYEE    -> EMP-EMPLOYEE