|
|
|
TUITION FEE DETAIL
This is the fact table for "Tuition and Required Fees". There is one record for a program (Graduate, Undergraduate, Business, Law, Medicine, etc.) for a resident/non-resident student of an institution in an academic year.
| Field Name | Description | Data Type | Length |
|---|---|---|---|
| ACADEMIC_SERVICE_FEE | Includes library fees, assessment fees, educational fees, and other academic related fees. | NUMBER | 9.2 |
| ACADEMIC_YEAR_KEY | Use this field to join the ACADEMIC YEAR table to a fact table for time dimension information. | VARCHAR2 | 4 |
| ACTIVITY_FEE | Activity Fee | NUMBER | 9.2 |
| ATHLETIC_FEE | Athletic Fee | NUMBER | 9.2 |
| COMPUTING_FEE | Computing Fee | NUMBER | 9.2 |
| FACILTIY_FEE | Includes debt repayment, building repair and renovations, and general operations of facilities providing student services and support. | NUMBER | 9.2 |
| GENERAL_STUDENT_SERVICE_FEE | Includes general fees, registration fees, transportation fees, student organization and publication fees, student information systems fees, financial aid fees, etc. | NUMBER | 9.2 |
| HEALTH_SERVICE_FEE | Health Service Fee | NUMBER | 9.2 |
| INSTITUTION_KEY | Use this field to join to another table with the same-name field (ie. INSTITUTION_KEY). | VARCHAR2 | 6 |
| RECREATION_FEE | Recreation fee | NUMBER | 9.2 |
| TOTAL_REQUIRED_FEE | The total of all required fees | NUMBER | 9.2 |
| TUITION_AMOUNT | Total tuition amount for the academic year, including fees. | NUMBER | 9.2 |
| TUITION_FEE_PROGRAM_KEY | Use this field to join together the TUITION_FEE_DETAIL and the TUITION_FEE_PROGRAM table for the tuition amount in different programs (such as Undergraduate, Graduate, Dentistry, Business, Medicine, etc.). This field should only be used for joining tables, NOT for reporting. | VARCHAR2 | 15 |
| TUITION_ONLY_AMOUNT | Tuition only, not including fees. | NUMBER | 9.2 |
| TUITION_ONLY_AND_REQUIRED_FEE | The sum of TUITION_ONLY_AMOUNT and TOTAL_REQUIRED_FEE | 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