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
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: Cmt Type
ECM-LN-NBR Numeric 4 ES01.1
Element: Ln Nbr
ECM-SEQ-NBR Numeric 4 ES01.1
Element: Seq Nbr An automatically assigned sequence
number.
ECM-CMT-TEXT Alpha 60 (Lower Case) ES01.1
Element: Cmt 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
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
|
