|
|
|
GRADSTIP BY CIP DETAIL
This is a salary by CIP code and CIP Type ("payroll_dept" or "program_study") fact table for Graduate Assistant Stipends
| Field Name | Description | Data Type | Length |
|---|---|---|---|
| AVERAGE_SALARY | Average salary | NUMBER | 6 |
| CIP_KEY | Use this field to join to another table with the same-name field (ie. CIP_KEY) for CIP information such as the CIP program code, category code, four-digit code, and the corresponding descriptions. | VARCHAR2 | 7 |
| FIRST_YEAR_AVERAGE_SALARY | XXX | 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_MAXIMUM_SALARY | The maximum 0.50 FTE 10 month standardized salary of first year graduate assistants. | NUMBER | 9.2 |
| FIRST_YEAR_MINIMUM_SALARY | The minimum 0.50 FTE 10 month standardized salary of first year graduate assistants. | 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_CIP_TYPE_KEY | XXX | VARCHAR2 | 100 |
| 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 |
| MAXIMUM_SALARY | XXX | NUMBER | 9.2 |
| MINIMUM_SALARY | XXX | NUMBER | 9.2 |
| MODE_SALARY | The most common 0.50 FTE 10 month standardized salary of all graduate assistants. | 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 |
e-mail aaude-warehouse@mit.edu | Warehouse home | AAUDE home