UROP INSTRUCTOR Table
This is a dimension table used in the UROP Project Star. It contains the MIT ID, full name, gender, title, and home department of all faculty supervisors, instructors, mentors, and intellectual guidances who have participated in an UROP Project. There is one record per person per UROP term in this table.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADMIN_ORG_UNIT_ID |
The SAP 8-digit object id assigned to the employee's administrative org unit. |
VARCHAR2 |
8 |
ADMIN_ORG_UNIT_TITLE |
The title of employee's administrative org unit. |
VARCHAR2 |
75 |
ADMIN_POSITION_TITLE |
The title of the position of the administrative appointment |
VARCHAR2 |
50 |
EMPLOYMENT_STATUS |
Identifies the most recent status of an employee, eg, Active, Leave, Retiree, Terminated, Deceased. NOTE: In cases where an employee was terminated on their student appoinment, use IS_FORMER_EMP_CURRENT_STU and/or APPOINTMENT_END_DATE to determine if they are still active. Employees that become students are not always terminated in SAP on their Employee record. |
VARCHAR2 |
30 |
FIRST_NAME |
The person's first name. |
VARCHAR2 |
30 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
90 |
GENDER |
The person's gender. |
VARCHAR2 |
30 |
HOME_DEPARTMENT |
The home (major) department of a person. |
VARCHAR2 |
4 |
INSTRUCTOR_ID |
Faculty supervisor ID, usually an MIT ID, occasionally a non MIT ID as recorded in MITSIS. |
VARCHAR2 |
9 |
INSTRUCTOR_TITLE |
Title, as provided by MITSIS, of the UROP faculty supervisor. |
VARCHAR2 |
50 |
LAST_NAME |
The person's last name. |
VARCHAR2 |
30 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
PERSONNEL_AREA |
Definition of PERSONNEL_AREA_CODE; identifies campus groupings of employees; e.g., academic, nonacademic, external, or Lincoln Lab. |
VARCHAR2 |
30 |
PERSONNEL_SUBAREA |
Text that further identifies the personnel area into sub groupings of Positions,e.g., Admin Staff, Support Staff. Similar to the old Rank Lists values. |
VARCHAR2 |
30 |
SAP_STATUS |
Identifies the status within SAP, active for people being paid, withdrawn from ex-employees and ex-people (deceased). NOTE: In cases where an employee was terminated on their student appoinment, use IS_FORMER_EMP_CURRENT_STU and/or APPOINTMENT_END_DATE to determine if they are still active. Employees that become students are not always terminated in SAP on their Employee record. |
VARCHAR2 |
30 |
UROP_INSTRUCTOR_KEY |
Use this field to join together UROP PROJECT DETAIL and UROP INSTRUCTOR tables. |
VARCHAR2 |
9 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |