|
|
|
GRADSTIP BENEFITS DETAIL
This is a benefits fact table for Graduate Assistant Stipends where you can retrieve data for health insurance benefits (including the total annual premium and the university contribution to premium in percentage) provided for graduate assistants and their spouses, partners, and dependents. Data are grouped by academic year for each participating institution and the type of graduate assistant (Teaching Assistant, Reseach Assistant, and Other Graduate Assistant). ** This table contains Graduate Assistant Benefits records prior to academic year 2005. **
| Field Name | Description | Data Type | Length |
|---|---|---|---|
| ASSISTANT_DENTAL | Is dental coverage provided for graduate assistant? (yes/no) | VARCHAR2 | 3 |
| ASSISTANT_DENTAL_PREMIUM | Total annual premium of dental coverage for graduate assistant | NUMBER | 9.2 |
| ASSISTANT_DENTAL_U_CONTRIB | University contribution to premium of dental coverage for graduate assistant in percentage | NUMBER | 6.4 |
| ASSISTANT_INSURANCE | Is health insurance provided for graduate assistant? (yes/no) | VARCHAR2 | 3 |
| ASSISTANT_INSURANCE_PREMIUM | Total annual premium of health insurance for graduate assistant | NUMBER | 9.2 |
| ASSISTANT_INSURANCE_U_CONTRIB | University contribution to premium of health insurance for graduate assistant in percentage | NUMBER | 6.4 |
| ASSISTANT_VISION | Is vision coverage provided for graduate assistant? (yes/no) | VARCHAR2 | 3 |
| ASSISTANT_VISION_PREMIUM | Total annual premium of vision coverage for graduate assistant | NUMBER | 9.2 |
| ASSISTANT_VISION_U_CONTRIB | University contribution to premium of vision coverage for graduate assistant in percentage | NUMBER | 6.4 |
| DEPENDENT_INSURANCE | Is health insurance provided for one dependent of graduate assistant? (yes/no) | VARCHAR2 | 3 |
| DEPENDENT_INSURANCE_PREMIUM | Total annual premium of health insurance for one dependent of graduate assistant | NUMBER | 9.2 |
| DEPENDENT_INSURANCE_U_CONTRIB | University contribution to premium of health insurance for one dependent of graduate assistant in percentage | NUMBER | 6.4 |
| 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 |
| PRESCRIPTION_DRUGS_INCLUDED | Does the health insurance include prescription drugs? (yes/no) | VARCHAR2 | 3 |
| SPOUSE_DEP_INSURANCE | Is health insurance provided for spouse and a dependent of graduate assistant? (yes/no) | VARCHAR2 | 3 |
| SPOUSE_DEP_INSURANCE_PREMIUM | Total annual premium of health insurance for spouse and a dependent of graduate assistant | NUMBER | 9.2 |
| SPOUSE_DEP_INSURANCE_U_CONTRIB | University contribution to premium of health insurance for spouse and a dependent of graduate assistant in percentage | NUMBER | 6.4 |
| SPOUSE_INCLUDE_PARTNER | Does "spouse" include "domestic partner"? (yes/no) | VARCHAR2 | 3 |
| SPOUSE_INSURANCE | Is health insurance provided for spouse of graduate assistant? (yes/no) | VARCHAR2 | 3 |
| SPOUSE_INSURANCE_PREMIUM | Total annual premium of health insurance for spous of graduate assistant | NUMBER | 9.2 |
| SPOUSE_INSURANCE_U_CONTRIB | University contribution to premium of health insurance for spouse of graduate assistant in percentage | NUMBER | 6.4 |
| STUDENTS_UNIONIZED | Are students unionized? (yes/no) | VARCHAR2 | 3 |
| 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