GRADUATE AWARD WORK AREA Table
This table contains work area information (such as the the supervisor/faculty for which the graduate student is a TA or RA) about a graudate award.
Field Name |
Description |
Data Type |
Length |
---|---|---|---|
APPOINTMENT_NUMBER |
A unique number identifying the graduate student appointment in MITSIS. A new one is assigned each time a new appointment is created in the Web Grad Aid application. |
NUMBER |
11 |
GRADUATE_AWARD_WORK_AREA_KEY |
Use this field to join together the GRADUATE AWARD TERM DETAIL table and the GRADUATE AWARD WORK AREA table. |
NUMBER |
10 |
LAST_ACTIVITY_DATE |
Date when information in the record was last updated. |
DATE |
8 |
PERCENT_EFFORT |
Percentage of work effort. Examples: For faculty, academic and administrative staff, 100% represents full time effort. For Support and Service staff, 100% represents a 35, 37.5, or 40 hour work week. |
NUMBER |
4 |
SUBJECT_CODE |
The first part of a subject ID or the course number |
VARCHAR2 |
3 |
SUBJECT_NUMBER |
Subject Number. The right half of the Subject ID, eg. 731 of Subject ID 21W.731. 'J' is never included. |
VARCHAR2 |
4 |
SUBJECT_OTHER |
XXX |
VARCHAR2 |
20 |
SUPERVISOR_FIRST_NAME |
Supervisor's firsdt name |
VARCHAR2 |
15 |
SUPERVISOR_HOME_DEPT |
Supervisor's academic home department. |
VARCHAR2 |
4 |
SUPERVISOR_LAST_NAME |
Supervisor's last name |
VARCHAR2 |
60 |
SUPERVISOR_MIT_ID |
The 9 digit MIT identification number of the person responsible for this project, cost center, internal order, or cost center. |
VARCHAR2 |
9 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |
WORK_AREA |
Work area for a TA/RA graduate award. |
VARCHAR2 |
20 |
WORK_AREA_SEQUENCE_NUMBER |
The sequence number of a work area for a TA/RA graduate award. There may be more than one work area for a TA/RA appointment/award. |
NUMBER |
2 |