|
|
|
GRADSTIP STUDENT PROFILE
This is a dimension table for the Graduate Assistant Stipends star of Tuition and Fees Detail. The graduate student profile includes information such as the type of graduate student (Teaching Assistant, Research Assistant, etc.), the resident status (resident or non-resident) of the graduate student and the credit hours per semester the students enrol in.
| Field Name | Description | Data Type | Length |
|---|---|---|---|
| CREDIT_HOUR_PER_SEMESTER | Credit hour per semester, e.g. 6 credits, 9 credits | VARCHAR2 | 12 |
| 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 |
| GRADUATE_STUDENT_TYPE | Type of graduate student asssistant: Teaching Assistant, Research Assistant, Other Graduate Assistant | VARCHAR2 | 20 |
| GRADUATE_STUDENT_TYPE_CODE | Code indicates the type of graduate assistant: TA=Teaching Assistant, RA=Research Assistant, OTH=Other Graduate Assistant | VARCHAR2 | 3 |
| RESIDENT_STATUS | Resident Status: Resident, Non-Resident | VARCHAR2 | 20 |
| RESIDENT_STATUS_CODE | Resident Status Code: RES=Resident, NR=Non-Resident | VARCHAR2 | 3 |
e-mail aaude-warehouse@mit.edu | Warehouse home | AAUDE home