|
|
|
GRADSTIP CASH SALARY DETAIL
This is a cash salary fact table for Graduate Assistant Stipends. In this table, you can find the minimum, maximum, average, and mode cash salary of specific academic year for each participating institution, grouped by the different types of graduate assistants (ie. Teaching Assistant, Research Assistant, and Other Graduate Assistant). Also included in this table are the graduate appointment information such as the number of FTE and Headcount for each type of graduate assistant; as well as the minimum and maximum course load in academic credits permitted per term for a graduate assistant.
| Field Name | Description | Data Type | Length |
|---|---|---|---|
| AVERAGE_CASH_SALARY | Average cash salary | NUMBER | 9.2 |
| AVERAGE_CASH_SALARY_SUMMER | Average cash salary for summer | NUMBER | 9.2 |
| FIRST_YEAR_AVG_CASH_SALARY | Average cash salary - for first year students | NUMBER | 9.2 |
| FIRST_YEAR_FTE | Number of FTE (Full-Time-Equivalent) in first year students | NUMBER | 11.4 |
| FIRST_YEAR_HEAD_COUNT | Headcount - in first year students | NUMBER | 6 |
| FIRST_YEAR_MAX_CASH_SALARY | Maximum or highest cash salary - for first year students | NUMBER | 9.2 |
| FIRST_YEAR_MIN_CASH_SALARY | Minimum or lowest cash salary - for first year students | NUMBER | 9.2 |
| FIRST_YEAR_MODE_SALARY | The most common 0.50 FTE 10 month standardized salary of first year graduate assistants. | 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_TYPE_KEY | Use this field to join the GRADSTIP_CASH_SALARY_DETAIL or GRADSTIP_BENEFITS_DETAIL fact tables to the GRADSTIP_STUDENT_TYPE table for information about the type of graduate student. | VARCHAR2 | 8 |
| HEAD_COUNT | Headcount | NUMBER | 6 |
| HOURS_PER_WEEK_EXPECTED | Number of work hours per week expected from a half-time | NUMBER | 9.2 |
| MAX_CASH_SALARY | Maximum or highest cash salary | NUMBER | 9.2 |
| MAX_CREDITS_PER_TERM | Maximum course load in academic credits permitted per term for a half-time Graduate Assistant | NUMBER | 6 |
| MIN_CASH_SALARY | Minimum or lowest cash salary | NUMBER | 9.2 |
| MIN_CREDITS_PER_TERM | Minimum course load in academic credits permitted per term for a half-time Graduate Assistant | NUMBER | 6 |
| MODE_CASH_SALARY | Mode Cash Salary | NUMBER | 9.2 |
| NUMBER_OF_FTE | Number of FTE (Full-Time-Equivalent) | NUMBER | 11.4 |
| WAREHOUSE_LOAD_DATE | The date the records were last loaded/updated in this table in the Data Warehouse | DATE | 7 |
| WEEKS_IN_NORMAL_GRAD_APPT | Number of weeks in normal 9-10 month graduate appointment | NUMBER | 9.2 |
e-mail aaude-warehouse@mit.edu | Warehouse home | AAUDE home