EMPCOMMENT – No description in the Lawson data dictionary

System
Payroll (PR)
Prefix
ECM
Primary key
COMPANY, EMPLOYEE, CMT-TYPE, DATE, LN-NBR
Fields
9
Updated by
3 programs
Referenced by
3 programs

EMPCOMMENT is a Lawson Payroll table (prefix ECM); no description in the lawson data dictionary. It is indexed by COMPANY, EMPLOYEE, CMT-TYPE, DATE, LN-NBR (ECMSET1). It is related 1:1 to EMPLOYEE. It is updated by ES01.1, HR11.1 and PA115 and referenced by HS20.1, HS22.1 and HS36.1. The table has 9 fields, 1 index and 1 documented relation.

About EMPCOMMENT

No description in the Lawson data dictionary.

Fields (9)

Column = COBOL field name without the ECM- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#ECM-COMPANY PK
COMPANY		Numeric 4—ES01.1
#ECM-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains 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.ES01.1
#ECM-CMT-TYPE PK
CMT_TYPE		Alpha 2—ES01.1
#ECM-LN-NBR PK
LN_NBR		Numeric 4—ES01.1
#ECM-SEQ-NBR
SEQ_NBR		Numeric 4An automatically assigned sequence number.ES01.1
#ECM-CMT-TEXT
CMT_TEXT		Alpha 60 (Lower Case)The text associated with the sequence number.ES01.1
#ECM-DATE PK
DATE		Numeric 8 (yyyymmdd)This field displays the system date when this was created.ES01.1
#ECM-USER-ID
USER_ID		Alpha 10 (Lower Case)—ES01.1
#ECM-PROXY-ID
PROXY_ID		Alpha 10 (Lower Case)——

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ECMSET1
  1. COMPANY
  2. EMPLOYEE
  3. CMT-TYPE
  4. DATE
  5. LN-NBR
PrimaryES01.1, HR11.1, PA115, HS20.1, HS22.1, HS36.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
EMPLOYEEEMPCOMMENT

One to one (1) — lookups and parents

RelationTableRulesConditionField map
EmployeeEMPLOYEERequired
ECM-COMPANY→EMP-COMPANY
ECM-EMPLOYEE→EMP-EMPLOYEE

Programs

Updated by (3)

Referenced by (3)