!!!Alias: EID
(P2K_HR_IDENTITIES)

Unique Keys: \\
Child Table: \\
Parent Table: \\
ERD: [ERD-HR1]

\\ 
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_CODE]|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_CODE]| |
|[GOVT_CODE_ORIGIN]|Varchar2(2)|[X_GOVT_CODE_ORIGIN]| |
|[EXTERNAL_RETIREMENT_ID]|Varchar2(16)|[GOVERNMENT CODE]| |
|[US_ETHNICITY]|Varchar2(4)|[X_US_ETHNICITY]|Y|
|[US_RACE]|Varchar2(4)|[X_US_RACE]|Y|
|[CDN_ETHNICITY]|Varchar2(4)|[X_CDN_ETHNICITY]|Y|
|[RAW_DRIVERS_LICENSE]|RAW(50)| [RAW53]| |
|[RAW_GOVERNMENT_CODE]|RAW(50)| [RAW54]| |
|[RAW_BIRTH_DATE]|RAW(50)| [RAW50]| |



!![Derived Fields|DERIVED FIELDS]
||Column Name
|[DRV_AGE]
|[DRV_CONFIRMED_PIN]
|[DRV_EMAIL_ADDRESS]
|[DRV_FORGOT_PASSWORD_URL]
|[DRV_PERSON_CODE]
|[DRV_PHOTO]
|[DRV_SCHEDULED_DATE]


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


----
![Notes|Edit:Internal.P2K_HR_IDENTITIES] 	
[{InsertPage page='Internal.P2K_HR_IDENTITIES' default='Click to create a new notes page'}]