NEW HIRE EMPLOYEE Table
View exposing new-hire onboarding detail including employee identifiers, hire dates, organizational attributes, first and last access timestamps, completion timestamps, expiration dates, and email-sent counts.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COMPLETION_DATE |
Date associated with completion. |
DATE |
|
COMPLETION_TIME |
Time associated with completion. |
VARCHAR2 |
6 |
COMPLETION_TIMESTAMP |
Completion timestamp associated with the record. |
DATE |
|
DLC_KEY |
Surrogate key identifying the dlc. |
VARCHAR2 |
15 |
DLC_NAME |
Dlc name associated with the record. |
VARCHAR2 |
70 |
EMAIL_SENT_NUMBER |
Email sent number associated with the record. |
NUMBER |
|
FIRST_ACCESS_DATE |
Date associated with first access. |
DATE |
|
FIRST_ACCESS_TIME |
Time associated with first access. |
VARCHAR2 |
6 |
FIRST_ACCESS_TIMESTAMP |
First access timestamp associated with the record. |
DATE |
|
FULL_NAME |
Full name associated with the person. |
VARCHAR2 |
100 |
HIRE_DATE |
Date associated with hire. |
DATE |
|
HIRE_ENTRY_DATE |
Date associated with hire entry. |
DATE |
|
HR_ORG_UNIT_ID |
Business identifier for the hr org unit. |
VARCHAR2 |
8 |
HR_ORG_UNIT_TITLE |
Hr org unit title associated with the record. |
VARCHAR2 |
75 |
KRB_NAME_UPPERCASE |
Krb name uppercase associated with the record. |
VARCHAR2 |
12 |
LAST_ACCESS_DATE |
Date associated with last access. |
DATE |
|
LAST_ACCESS_TIME |
Time associated with last access. |
VARCHAR2 |
6 |
LAST_ACCESS_TIMESTAMP |
Last access timestamp associated with the record. |
DATE |
|
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
NEW_HIRE_EMPLOYEE_KEY |
Surrogate key identifying the new hire employee. |
VARCHAR2 |
20 |
NEW_HIRE_PSH_EXPIRE_DATE |
Date associated with new hire psh expire. |
DATE |
|
NEW_HIRE_REC_EXPIRE_DATE |
Date associated with new hire rec expire. |
DATE |
|
PERSONNEL_KEY |
Surrogate key identifying the personnel. |
VARCHAR2 |
8 |
STATUS |
Status associated with the record. |
VARCHAR2 |
70 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |