EMPALTNAME

UPDATED BY
HR11.1 HR40.1 HR40.2 LT101 LT111 PA115

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EAN-COMPANY
Element: Company Hr		Numeric 4
HR40.1 HR40.2
LT101 LT111
EAN-EMPLOYEE
Element: Employee		Numeric 9
HR40.1 HR40.2
LT101 LT111
EAN-LAST-NAME
Element: Last Name		Alpha 30 (Lower Case)
HR40.1 HR40.2
LT101 LT111
EAN-FIRST-NAME
Element: First Name		Alpha 15 (Lower Case)
HR40.1 HR40.2
LT101 LT111
EAN-MIDDLE-INIT
Element: Middle Init		Alpha 1
HR40.1 HR40.2
LT101 LT111
EAN-MIDDLE-NAME
Element: Middle Name		Alpha 15 (Lower Case)
HR40.1 HR40.2
LT101 LT111
EAN-NICK-NAME
Element: Nick Name		Alpha 30 (Lower Case)
HR40.1 HR40.2
LT101 LT111
EAN-NAME-PREFIX
Element: Name Prefix		Alpha 4 (Lower Case)
HR40.1 HR40.2
LT101 LT111
EAN-NAME-SUFFIX
Element: Name Suffix		Alpha 4 (Lower Case)
HR40.1 HR40.2
LT101 LT111
EAN-LAST-NAME-PRE
Element: Last Name Pre		Alpha 30 (Lower Case)
HR40.1 HR40.2
LT101 LT111
EAN-LAST-PRE
Element: Last Pre		Derived
EAN-LAST-SUF
Element: Last Suf		Derived
EAN-LAST-PRE-SUF
Element: Last Pre Suf		Derived
EAN-FIRST-MI
Element: First Mi		Derived
EAN-LAST-NAME-EXP
Element: Last Name Exp		Derived
EAN-FIRST-MI-EXP
Element: First Mi Exp		Derived
EAN-FULL-NAME
Element: Full Name		Derived
EAN-SHORT-NAME
Element: Short Name		Derived
EAN-LABEL-NAME-1
Element: Label Name 1		Derived
EAN-UPDATED-BY-LTM
Element: Updated By Ltm		Alpha 1
EAN-CREATE-USER-ID
Element: User		Alpha 10 (Lower Case)
HR40.1 HR40.2
LT101 LT111
EAN-CREATION-DATE
Element: Creation Date		Numeric 8 (yyyymmdd)
HR40.1 HR40.2
LT101 LT111
EAN-CREATE-TIME
Element: Creation Time		Numeric 6 (hhmmss)
HR40.1 HR40.2
LT101 LT111
EAN-USER-ID
Element: User		Alpha 10 (Lower Case)
HR40.1 HR40.2
LT101 LT111
EAN-DATE-STAMP
Element: Date Stamp		Numeric 8 (yyyymmdd)
HR40.1 HR40.2
LT101 LT111
EAN-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
HR40.1 HR40.2
LT101 LT111


EMPALTNAME FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EANSET1 COMPANY
EMPLOYEE
HR11.1 HR40.1
HR40.2 LT101
LT111 PA115


EMPALTNAME FILE RELATIONS


ONE TO ONE RELATIONS

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

File created: Thu Jun 09 02:15:56 2016

Home
Contact Us



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