Alias: EID#
(P2K_HR_IDENTITIES)Unique Keys:
Child Table:
Parent Table:
ERD: ERD-HR01
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 |
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
