!!!Alias: EID
Unique Keys: \\
Child Table: \\
Parent Table: \\
\\ 
This table provides non-date sensitive demographic (i.e. name, gender, etc.) for an employee.
 
!!Table Columns
||Column name||Data Type / Size||Domain||Mand.||Notes
|[ID]|Number(10)|[ID]|Y| 
|[PERSON_CODE]|Varchar2(16)|[CODE]|Y|
|[MUS_ID]|Number(10)|[ID]| |Link to [P2K_AM_USERS]
|[GOVERNMENT_CODE]|Varchar2(16)|[GOVERNMENT CODE]|Y|
|[FIRST_NAME]|Varchar2(50)|[VARCHAR50|VARCHARnn]|Y|
|[LAST_NAME]|Varchar2(50)|[VARCHAR50|VARCHARnn]|Y|
|[BIRTH_DATE]|Date()|[DATE]|Y|
|[GENDER]|Varchar2(2)|[X_GENDER]|Y|
|[LANGUAGE_CODE]|Varchar2(3)|[X_LANGUAGE]|Y|
|[ETHNIC]|Varchar2(4)|[X_ETHNIC]|Y|
|[CREATE_DATE]|Date()|[DATE]|Y|
|[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[CHANGE_DATE]|Date()|[DATE]|Y|
|[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[MIDDLE_NAME]|Varchar2(50)|[VARCHAR50|VARCHARnn]| |
|[SALUTATION]|Varchar2(4)|[X_SALUTATION]| |
|[RANK]|Varchar2(4)|[X_RANK]| |
|[GOVT_CODE_VERIFIED]|Varchar2(1)|[TOGGLE]| |
|[BIRTHPLACE]|Varchar2(50)|[VARCHAR50|VARCHARnn]| |
|[CHALLENGED]|Varchar2(4)|[X_CHALLENGED]| |
|[VETERAN_STATUS]|Varchar2(4)|[X_VETERAN_STATUS]| |
|[PHOTO_LOCATION]|Varchar2(50)|[VARCHAR50|VARCHARnn]| |
|[PIN_NUMBER]|Varchar2(16)|[ENCRYPTED]| |
|[PIN_NUMBER_CHANGED_DATE]|Date()|[DATE]| |
|[PIN_NUMBER_CHANGED_BY]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[DRIVERS_LICENSE]|Varchar2(30)|[LICENSE]| |
|[ALT_LANGUAGE_CODE]|Varchar2(3)|[X_LANGUAGE]| |
|[GOVT_CODE_ORIGIN]|Varchar2(2)|[X_GOVT_CODE_ORIGIN]| |


User Fields: Allowed\\
Audit Logging: Allowed\\