GRADUATE APPOINTMENT TYPE Table
This dimension table contains the definitions for the various types of graduate student appointment (e.g. Fellowship, Reseach Assistant, Teaching Assistant) and the associated fund type (Tuition, Stipend, Insurance) and fund/award status (Actual, Cancelled, etc.)
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
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 |
APPOINTMENT_TYPE_DESC |
Descriptive text for graduate student appointment type; eg. Fellowship for FE, Teaching Assistant for TA, Research Assistant for RA, etc. |
VARCHAR2 |
40 |
APPOINTMENT_TYPE_KEY |
The key identifying a unique entry in the GRADUATE APPOINTMENT TYPE table. Use this field to join to the GRADUATE AWARD TERM DETAIL table for graduate awards data. This field is NOT used for reporting. |
VARCHAR2 |
10 |
FUND_TYPE |
Types of financial aid fund: Grant, Loan, Outside Scholarship, Parent Loan, Work; and applicable for Graduate Awards only: Stipend (STIP), Medical Insurance (INS), Tuition (TUIT), and Subsidy (SUBS). INS=Medical Insurance portion |
VARCHAR2 |
4 |
FUND_TYPE_DESC |
Descriptive text for Fund Type; eg. Tuition for TUIT, Stipend for STIP, Insurance for INS. |
VARCHAR2 |
12 |
STATUS |
In the GRADUATE APPOINTMENT TYPE table, this field indicates the status of the appointment: whether Cancelled or Actual. In the ALUMNI BY COURSE table, this field carries one of these statuses: "Active", "Lost", "Purgable" regarding the MIT alumnus/alumnae. |
VARCHAR2 |
40 |