GRADUATE AWARD APPOINTMENT Table
View exposing graduate award appointment detail including appointment dates, appointment type, sponsor attributes, processing user, outside-funding indicators, and adjustment amounts.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
APPOINTMENT_END_DATE |
Date associated with appointment end. |
DATE |
|
APPOINTMENT_NUMBER |
Appointment number associated with the record. |
NUMBER |
10 |
APPOINTMENT_START_DATE |
Date associated with appointment start. |
DATE |
|
APPOINTMENT_TYPE |
Appointment type associated with the record. |
VARCHAR2 |
8 |
COMMENTS |
Comments associated with the record. |
VARCHAR2 |
2000 |
EXTERNAL_APPOINTMENT_TYPE |
External appointment type associated with the record. |
VARCHAR2 |
40 |
FINANCIAL_AID_YEAR |
Financial aid year associated with the record. |
VARCHAR2 |
16 |
GRADUATE_AWARD_APPOINTMENT_KEY |
Surrogate key identifying the graduate award appointment. |
NUMBER |
10 |
LAST_ACTIVITY_DATE |
Date associated with last activity. |
DATE |
|
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
36 |
NSF_TYPE |
Nsf type associated with the record. |
VARCHAR2 |
3 |
OUTSIDE_FUNDING |
Outside funding associated with the record. |
VARCHAR2 |
25 |
RESCOMP_SALARY_ADJ |
Rescomp salary adj associated with the record. |
NUMBER |
|
RESCOMP_TUITION_ADJ |
Rescomp tuition adj associated with the record. |
NUMBER |
|
SELF_SUPPORTED_TYPE |
Self supported type associated with the record. |
VARCHAR2 |
100 |
SPONSOR_NAME |
Sponsor name associated with the person. |
VARCHAR2 |
32 |
SPONSOR_TYPE |
Sponsor type associated with the record. |
VARCHAR2 |
40 |
STUDENT_PAYBACK_AMOUNT |
Student payback amount associated with the record. |
NUMBER |
|
USER_ID_PROCESSED |
User id processed associated with the record. |
VARCHAR2 |
48 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |