GRADUATE AWARD APPOINTMENT Table
This dimension table consists of all the graduate appointments/awards, ie. RA (Research Assistant), TA (Teaching Assistant), and FE (Fellowship) created for the graduate students. There is one record per appointment.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
APPOINTMENT_END_DATE |
This field is used in several HR tables. In HR_PERSON_EMPLOYEE and HR_PERSON_EMPLOYEE_LIMITED, it is the latest last date or expected last date of the person's appointments. If there are no appointment records for the person in SAP HR, this date is set to LAST_TERM_DATE (termination date). In HR_APPOINTMENT_DETAIL and HR_APPT_TX_DETAIL, it is the end date of an uninterrupted appointment to a specific MIT position. Changes to the appointment, such as salary increases, one-time payments, changes in effort etc. do not affect this date, but are reflected in appointment transactions: APPT_TX_BEGIN_DATE and APPT_TX_END_DATE in HR_APPT_TX_DETAIL. |
DATE |
8 |
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 |
APPOINTMENT_START_DATE |
The start date of an appointment to a specific MIT position. (See also TRANSACTION_START_DATE: Changes to a parrticular appointment, such as salary increases, leaves, change in effort, etc. are reflected by TRANSACTION_START_DATES and TRANSACTION_END_DATES). |
DATE |
8 |
APPOINTMENT_TYPE |
In the various APPOINTMENT tables (ie, MIT Employees): For Faculty, identifies whether they have a 9-, 10-, 11-, or 12-month appointment. This information is used to position faculty members with their peers in salary reviews; also determines whether they are eligible to receive summer salary (1, 2, or 3 months). For other MIT employees, specifies whether the appointment is Regular, Term (= has a specified end date), Temporary (normally of more than 2 and less than 12 months duration), or Summer only. In the GRADUATE AWARD tables, specifies the type of Graduate Student Appointment: RA, TA, etc. In the KRB_PERSON table, indicates whether the appointment is Primary or Secondary. |
VARCHAR2 |
30 |
COMMENTS |
Comments about the graduate appointment |
VARCHAR2 |
255 |
EXTERNAL_APPOINTMENT_TYPE |
XXX |
VARCHAR2 |
40 |
FINANCIAL_AID_YEAR |
The financial aid year |
VARCHAR2 |
4 |
GRADUATE_AWARD_APPOINTMENT_KEY |
Use this field to join together tables GRADUATE_AWARD_TERM_DETAIL and GRADUATE_AWARD_APPOINTMENT. |
NUMBER |
10 |
LAST_ACTIVITY_DATE |
Date when information in the record was last updated. |
DATE |
8 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
NSF_TYPE |
XXX |
VARCHAR2 |
3 |
OUTSIDE_FUNDING |
XXX |
VARCHAR2 |
25 |
RESCOMP_SALARY_ADJ |
XXX |
NUMBER |
22 |
RESCOMP_TUITION_ADJ |
XXX |
NUMBER |
22 |
SELF_SUPPORTED_TYPE |
XXX |
VARCHAR2 |
100 |
SPONSOR_NAME |
In the PROJECT and SPONSOR tables, identifies the sponsor, associated with a particular sponsor code, providing funding for a sponsored research project. In the personnel APPOINTMENT tables, identifies the sponsor providing financial support for a Fellow; this field is not currently populated by Human Resources. |
VARCHAR2 |
60 |
SPONSOR_TYPE |
The type of sponsor (Example: Federal, Private - Pofit, Private - Non-Profit, State, etc..) |
VARCHAR2 |
100 |
STUDENT_PAYBACK_AMOUNT |
XXX |
NUMBER |
22 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |