|
|
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
|
