EMPCOMMENT

REFERENCED BY
HS20.1


UPDATED BY
ES01.1 HR11.1 PA115 HS22.1 HS36.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ECM-COMPANY
Element: Company Hr
Numeric 4
ES01.1
ECM-EMPLOYEE
Element: Employee
Numeric 9
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.
ES01.1
ECM-CMT-TYPE
Element: Cmt Type
Alpha 2
ES01.1
ECM-LN-NBR
Element: Ln Nbr
Numeric 4
ES01.1
ECM-SEQ-NBR
Element: Seq Nbr
Numeric 4
An automatically assigned sequence number.
ES01.1
ECM-CMT-TEXT
Element: Cmt Text
Alpha 60 (Lower Case)
The text associated with the sequence number.
ES01.1
ECM-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
ES01.1
ECM-USER-ID
Element: User
Alpha 10 (Lower Case)
ES01.1
ECM-PROXY-ID
Element: Proxy Id
Alpha 10 (Lower Case)


EMPCOMMENT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ECMSET1 COMPANY
EMPLOYEE
CMT-TYPE
DATE
LN-NBR
ES01.1 HR11.1
PA115 HS20.1
HS22.1 HS36.1


EMPCOMMENT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Employee EMPLOYEE Required
ECM-COMPANY->EMP-COMPANY
ECM-EMPLOYEE->EMP-EMPLOYEE


File created: Thu Jun 09 11:27:06 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.