|
|
|
IPEDS COMPLETION DETAIL
This is the IPEDS Completion Survey fact table. It contains the USDE National Center for Educational Statistics annual survey of recognized completions in postsecondary education programs. This table consists of the completions by award level conferred by sex and ethnicity with program (CIP).
| Field Name | Description | Data Type | Length |
|---|---|---|---|
| ACADEMIC_YEAR_KEY | Use this field to join the ACADEMIC YEAR table to a fact table for time dimension information. | VARCHAR2 | 4 |
| CIP_CROSS_IPEDSCOM_COMPARE_KEY | Use this field to join the CIP CROSS FACULTY SALARY table and the AAUDE FACULTY SALARY DETAIL table for comparing faculty salary by CIP (discipline) with other institutions. This field should only be used to join data/tables, NOT for reporting | VARCHAR2 | 11 |
| 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 |
| INSTITUTION_KEY | Use this field to join to another table with the same-name field (ie. INSTITUTION_KEY). | VARCHAR2 | 6 |
| IPEDS_AWARD_LEVEL_KEY | Use this field to join to another IPEDS table with the same-name field (ie. IPEDS_AWARD_LEVEL_KEY). It should not be used for reporting. | VARCHAR2 | 2 |
| IPEDS_DEMOGRAPHIC_KEY | Use this field to join to another IPEDS table with the same-name field. | VARCHAR2 | 12 |
| IPEDS_MAJOR_KEY | Use this field to join IPEDS_COMPLETION_DETAIL to IPEDS_MAJOR | VARCHAR2 | 1 |
| NUMBER_OF_COMPLETIONS | Number of completions | NUMBER | 6 |
| 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