|
|
|
GRADSTIP INSTITUTION
This is a dimension table for the stars of Graduate Assistant Stipends. The table consists of institution characteristics by academic year. Other than the institution code and name, the table also contains information regarding graduate assistant stipend general policies such as whether all graduate assistants are subject to the same university-wide stipend scale, if stipends are determined invidually by the school or department, and if there is a university policy regarding increases in graduate assistant stipends for the 2nd year of service.
| Field Name | Description | Data Type | Length |
|---|---|---|---|
| AAUDE_INST_CODE | The unique 2-character alpha code assigned to each AAUDE member university for maintaining security with exchange of institutional data | VARCHAR2 | 2 |
| ACADEMIC_YEAR | Academic year, eg. 1999-2000, 2001-2002 | VARCHAR2 | 9 |
| ACADEMIC_YEAR_KEY | Use this field to join the ACADEMIC YEAR table to a fact table for time dimension information. | VARCHAR2 | 4 |
| ARE_RAS_UNIONIZED | Are Research Assistants (RA) unionized? yes, no | VARCHAR2 | 3 |
| ARE_TAS_UNIONIZED | Are Teaching Assistants (TA) unionized? yes, no | VARCHAR2 | 3 |
| GRADSTIP_INSTITUTION_KEY | Use this field to join the GRADSTIP INSTITUTION table to a Graduate Stipend fact table. | VARCHAR2 | 10 |
| INSTITUTION_KEY | Use this field to join to another table with the same-name field (ie. INSTITUTION_KEY). | VARCHAR2 | 6 |
| INSTITUTION_NAME | Name of an institution. | VARCHAR2 | 60 |
| POLICY_FOR_2ND_YEAR_INCREASES | Is there a university policy regarding increases in graduate assistant stipends for the 2nd (or 3rd) year of service? yes or no. | VARCHAR2 | 3 |
| SAME_UNIVERSITY_WIDE_SCALE | Are all graduate assistants subject to the same university-wide stipend scale(s)? yes or no. | VARCHAR2 | 3 |
| STIPENDS_DETERMINED_BY_SCHOOL | Are stipends determined individually by the school or department? yes or no. | VARCHAR2 | 3 |
| UNIT_ID | Unique identification number of each AAUDE institution | VARCHAR2 | 6 |
e-mail aaude-warehouse@mit.edu | Warehouse home | AAUDE home