Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            EMPCOMMENT FILE

REFERENCED BY

HS20.1    HS22.1    HS36.1

UPDATED BY

ES01.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

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

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

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

ECM-SEQ-NBR          Numeric 4                                   ES01.1
Sequence Number      An automatically assigned sequence
                     number.

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


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

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

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

                         EMPCOMMENT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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