GRADUATE AWARD TERM DETAIL Table
View exposing graduate award detail by term including student, appointment, fund, cost collector, and general ledger references together with stipend, tuition, insurance, paid amounts, and effort measures.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AMOUNT |
Amount associated with the record. |
NUMBER |
11,2 |
APPOINTMENT_NUMBER |
Appointment number associated with the record. |
NUMBER |
10 |
APPOINTMENT_TYPE_KEY |
Surrogate key identifying the appointment type. |
VARCHAR2 |
10 |
AWARDING_DEPARTMENT_KEY |
Surrogate key identifying the awarding department. |
VARCHAR2 |
6 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
12 |
END_DATE |
Date associated with end. |
DATE |
|
ENROLLMENT_KEY |
Surrogate key identifying the enrollment. |
VARCHAR2 |
15 |
FINAID_FUND_MANAGEMENT_KEY |
Surrogate key identifying the finaid fund management. |
VARCHAR2 |
12 |
FUND_CODE |
Code identifying fund. |
VARCHAR2 |
6 |
GL_ACCOUNT_KEY |
Surrogate key identifying the gl account. |
VARCHAR2 |
10 |
GRADUATE_AWARD_APPOINTMENT_KEY |
Surrogate key identifying the graduate award appointment. |
NUMBER |
10 |
GRADUATE_AWARD_WORK_AREA_KEY |
Surrogate key identifying the graduate award work area. |
NUMBER |
10 |
INSURANCE_AMOUNT |
Insurance amount associated with the record. |
NUMBER |
11,2 |
LEVEL_OF_EFFORT |
Level of effort associated with the record. |
NUMBER |
7,2 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
MONTHLY_AMOUNT |
Monthly amount associated with the record. |
NUMBER |
11,2 |
OFF_CAMPUS_FLAG |
Indicator identifying whether off campus (Y/N). |
VARCHAR2 |
1 |
PAID_AMOUNT |
Paid amount associated with the record. |
NUMBER |
11,2 |
PAID_THRU_DATE |
Date associated with paid thru. |
DATE |
|
PAYMENT_TYPE |
Payment type associated with the record. |
VARCHAR2 |
4 |
PRIMARY_APPOINTMENT_FLAG |
Indicator identifying whether primary appointment (Y/N). |
VARCHAR2 |
1 |
START_DATE |
Date associated with start. |
DATE |
|
STATUS |
Status associated with the record. |
VARCHAR2 |
4 |
STIPEND_AMOUNT |
Stipend amount associated with the record. |
NUMBER |
11,2 |
STIPEND_PAID_AMOUNT |
Stipend paid amount associated with the record. |
NUMBER |
11,2 |
STUDENT_TERM_ENROLLMENT_KEY |
Surrogate key identifying the student term enrollment. |
VARCHAR2 |
15 |
TERM_CODE |
Code identifying term. |
VARCHAR2 |
6 |
TUITION_AMOUNT |
Tuition amount associated with the record. |
NUMBER |
11,2 |
TUITION_PAID_AMOUNT |
Tuition paid amount associated with the record. |
NUMBER |
11,2 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |