This is version 1 2 3 4 5 6 7 8 9 10 11 12 13 14 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

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	Y
LAST_NAME	Varchar2(50)	VARCHAR50	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	Y
CHANGE_DATE	Date()	DATE	Y
CHANGE_USER	Varchar2(30)	VARCHAR30	Y
MIDDLE_NAME	Varchar2(50)	VARCHAR50
SALUTATION	Varchar2(4)	X_SALUTATION
RANK	Varchar2(4)	X_RANK
GOVT_CODE_VERIFIED	Varchar2(1)	TOGGLE
BIRTHPLACE	Varchar2(50)	VARCHAR50
CHALLENGED	Varchar2(4)	X_CHALLENGED
VETERAN_STATUS	Varchar2(4)	X_VETERAN_STATUS
PHOTO_LOCATION	Varchar2(50)	VARCHAR50
PIN_NUMBER	Varchar2(16)	ENCRYPTED
PIN_NUMBER_CHANGED_DATE	Date()	DATE
PIN_NUMBER_CHANGED_BY	Varchar2(30)	VARCHAR30
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#

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 #

Click to create a new notes page