|
|
|
GRADSTIP TUITION FEES DETAIL
This is a tuition and fees fact table for Graduate Assistant Stipends where you can retreive data for the Average Graduate Assistant Compensation and Cost to Institution for each participating institution. Data are grouped by academic year, type of graduate assistant (Teaching Assistant, Research Assistant, and Other Graduate Assistant), as well as the resident status and the credit hours per semester of the graduate assistant.
| Field Name | Description | Data Type | Length |
|---|---|---|---|
| AVERAGE_GA_COMPENSATION | Average Graduate Assistant (GA) Compensation (Average Cash Salary Minus Net Amount GA must pay for tuition & required fees) | NUMBER | 9.2 |
| COST_TO_INSTITUTION | Cost to Institution (Average Cash Salary Plus Net Amount of Lost Tuition and Required Fees Due to Remission or Waiver) | NUMBER | 9.2 |
| GRADSTIP_INSTITUTION_KEY | Use this field to join the GRADSTIP INSTITUTION table to a Graduate Stipend fact table. | VARCHAR2 | 10 |
| GRADSTIP_STUDENT_PROFILE_KEY | Use this field to join the GRADSTIP_TUITION_FEES_DETAIL fact table to the GRADSTIP_STUDENT_PROFILE table to get student profile information such as the type of graduate assistant, resident status, and credit hours per semester. | VARCHAR2 | 8 |
| LOST_TUITION_AND_FEES | Amount of lost tuition and required fees | NUMBER | 9.2 |
| TUITION_AND_FEES_PAID | Amount pay for tuition and required fees | NUMBER | 9.2 |
| WAREHOUSE_LOAD_DATE | The date the records were last loaded/updated in this table in the Data Warehouse | DATE | 7 |
e-mail aaude-warehouse@mit.edu | Warehouse home | AAUDE home