BROAD EMPLOYEE IN CARD OFFICE Table
View exposing broad employee directory attributes used by the card office including names, job and position titles, contact information, appointment status, and employment dates.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CURRENT_EMPLOYMENT_DATE |
Date associated with current employment. |
DATE |
|
EMAIL_ADDRESS |
Email address as provided by the source. |
VARCHAR2 |
100 |
FIRST_NAME |
First name as provided by the source. |
VARCHAR2 |
40 |
IS_CURRENT_APPOINTMENT |
Indicator identifying whether current appointment (Y/N). |
VARCHAR2 |
3 |
IS_PAID_APPOINTMENT |
Indicator identifying whether paid appointment (Y/N). |
VARCHAR2 |
3 |
JOB_TITLE |
Job title as provided by the source. |
VARCHAR2 |
40 |
LAST_NAME |
Last name as provided by the source. |
VARCHAR2 |
40 |
LAST_TERM_DATE |
Date associated with last term. |
DATE |
|
MIDDLE_NAME |
Middle name as provided by the source. |
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 as provided by the source. |
VARCHAR2 |
40 |
OFFICE_PHONE |
Office phone as provided by the source. |
VARCHAR2 |
15 |
POSITION_TITLE |
Position title as provided by the source. |
VARCHAR2 |
50 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |