|
|
|
IPEDS EMPLOYEE POS DETAIL
IPEDS Employee by Assigned Position. This is a fact table which contains the number of employees by assigned position, primary function, and tenure status for each participating institution in an academic year.
| 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 |
| INSTITUTION_KEY | Use this field to join to another table with the same-name field (ie. INSTITUTION_KEY). | VARCHAR2 | 6 |
| IPEDS_EMPLOYEE_POSITION_KEY | Use this field to join together the IPEDS EMPLOYEE POSITION and the IPEDS EMPLOYEE POS DETAIL tables to get the number of employees by position, primary function and tenure status. | VARCHAR2 | 10 |
| IS_FINAL_VERSION | Y=This record is in the final version, N=This record is in the preliminary version | VARCHAR2 | 1 |
| NUMBER_OF_EMPLOYEES | Number of employees | 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