|
|
|
GRADSTIP BENEFITS 2005 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 from academic year 2005 onwards. **
| Field Name | Description | Data Type | Length |
|---|---|---|---|
| ASSISTANT_DENTAL | Is dental coverage provided for graduate assistant? (yes/no) | VARCHAR2 | 3 |
| ASSISTANT_DENTAL_PREM | Total annual premium of dental coverage for graduate assistant | NUMBER | 9.2 |
| ASSISTANT_DENTAL_TOT_PREM | 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_DENTAL_U_PREM | Premium of dental coverage for graduate assistant that the university pays. | NUMBER | 9.2 |
| ASSISTANT_INSURANCE | Is health insurance provided for graduate assistant? (yes/no) | VARCHAR2 | 3 |
| ASSISTANT_INSUR_PREM | Total annual premium of health insurance for graduate assistant the assistant pays | NUMBER | 9.2 |
| ASSISTANT_INSUR_TOT_PREM | Total annual premium of health insurance for graduate assistant | NUMBER | 9.2 |
| ASSISTANT_INSUR_U_PRCNT | University contribution to premium of health insurance for graduate assistant in percentage | NUMBER | 6.4 |
| ASSISTANT_INSUR_U_PREM | Total annual premium of health insurance for graduate assistant the university pays | NUMBER | 9.2 |
| ASSISTANT_VISION | Is vision coverage provided for graduate assistant? (yes/no) | VARCHAR2 | 3 |
| ASSISTANT_VISION_PREM | Total annual premium of vision coverage for graduate assistant that the assistant pays | NUMBER | 9.2 |
| ASSISTANT_VISION_TOT_PREM | 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 |
| ASSISTANT_VISION_U_PREM | Total annual premium of vision coverage for graduate assistant that the university pays | 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 |
| PRESCRIPTION_DRUGS_INCLUDED | Does the health insurance include prescription drugs? (yes/no) | VARCHAR2 | 3 |
| SPOUSE_INCLUDE_PARTNER | Does "spouse" include "domestic partner"? (yes/no) | VARCHAR2 | 3 |
| 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 |
| WITH_DEP_INSURANCE | Is health insurance provided for graduate assistant and one dependent? (yes/no) | VARCHAR2 | 3 |
| WITH_DEP_INSUR_PREM | Total annual premium of health insurance for graduate assistant and one dependent that the assistant pays | NUMBER | 9.2 |
| WITH_DEP_INSUR_TOT_PREM | Total annual premium of health insurance for graduate assistant and one dependent | NUMBER | 9.2 |
| WITH_DEP_INSUR_U_PRCNT | University contribution to premium of health insurance for graduate asssitant and one dependent in percentage | NUMBER | 6.4 |
| WITH_DEP_INSUR_U_PREM | Total annual premium of health insurance for graduate assistant and one dependent that the university pays | NUMBER | 9.2 |
| WITH_SPOUSE_DEP_INSURANCE | Is health insurance provided for graduate assistant, spouse and dependents? (yes/no) | VARCHAR2 | 3 |
| WITH_SPOUSE_DEP_INSUR_PREM | Total annual premium of health insurance for graduate assistant, spouse and dependent that the assistant pays | NUMBER | 9.2 |
| WITH_SPOUSE_DEP_INSUR_TOT_PREM | Total annual premium of health insurance for graduate assistant, spouse and dependent. | NUMBER | 9.2 |
| WITH_SPOUSE_DEP_INSUR_U_PRCNT | University contribution to premium of health insurance for graduate assistant, spouse and dependent in percentage | NUMBER | 6.4 |
| WITH_SPOUSE_DEP_INSUR_U_PREM | Total annual premium of health insurance for graduate assistant, spouse and dependant that the university pays. | NUMBER | 9.2 |
| WITH_SPOUSE_INSURANCE | Is health insurance provided for graduate assistant and his/her spouse? (yes/no) | VARCHAR2 | 3 |
| WITH_SPOUSE_INSUR_PREM | Total annual premium of health insurance for graduate assistant and spouse that the assistant pays | NUMBER | 9.2 |
| WITH_SPOUSE_INSUR_TOT_PREM | Total annual premium of health insurance for graduate assisant and spouse | NUMBER | 9.2 |
| WITH_SPOUSE_INSUR_U_PRCNT | University contribution to premium of health insurance for graduate assistant and spouse in percentage | NUMBER | 6.4 |
| WITH_SPOUSE_INSUR_U_PREM | Total annual premium of health insurance for graduate assistant and spouse that the university pays | NUMBER | 9.2 |
e-mail aaude-warehouse@mit.edu | Warehouse home | AAUDE home