MIT CARD HR EMPLOYEE FEED Table
View exposing employee identity and employment feed records used for MIT card provisioning including names, organizational attributes, titles, contact information, appointment status, preferred names, legal names, and deceased indicators.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADMIN_ORG_UNIT_TITLE |
Administrative organizational unit title associated with the employee. |
VARCHAR2 |
75 |
APPOINTMENT_END_DATE |
Appointment end date associated with the employee. |
DATE |
|
CURRENT_EMPLOYMENT_DATE |
Current employment start date associated with the employee. |
DATE |
|
DLC_SPONSOR |
Indicator or value associated with DLC sponsorship in card provisioning. |
CHAR |
|
EMAIL_ADDRESS |
Email address associated with the employee. |
VARCHAR2 |
100 |
FIRST_NAME |
First name associated with the person. |
VARCHAR2 |
40 |
IS_CURRENT_APPOINTMENT |
Indicator identifying whether the employee has a current appointment (Y/N). |
VARCHAR2 |
3 |
IS_DECEASED |
Indicator identifying whether the employee is deceased (Y/N). |
VARCHAR2 |
3 |
IS_PAID_APPOINTMENT |
Indicator identifying whether the employee appointment is paid (Y/N). |
VARCHAR2 |
3 |
JOB_TITLE |
Job title associated with the employee. |
VARCHAR2 |
40 |
KRB_NAME_UPPERCASE |
Uppercase Kerberos username associated with the employee used for matching and integration. |
VARCHAR2 |
8 |
LAST_NAME |
Last name associated with the person. |
VARCHAR2 |
40 |
LAST_TERM_DATE |
Last termination date associated with the employee record. |
DATE |
|
LEGAL_FIRST_NAME |
Legal first name associated with the employee. |
VARCHAR2 |
40 |
LEGAL_LAST_NAME |
Legal last name associated with the employee. |
VARCHAR2 |
40 |
LEGAL_MIDDLE_NAME |
Legal middle name associated with the employee. |
VARCHAR2 |
40 |
MIDDLE_NAME |
Middle name associated with the person. |
VARCHAR2 |
40 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
OFFICE_ADDRESS |
Office address associated with the employee. |
VARCHAR2 |
40 |
OFFICE_PHONE |
Office phone number associated with the employee. |
VARCHAR2 |
15 |
POSITION_TITLE |
Position title associated with the employee. |
VARCHAR2 |
50 |
PREFERRED_NAME |
Preferred given name associated with the employee. |
VARCHAR2 |
40 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |