AAUDE banner MIT Data Warehouse logo

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