|
|
|
IPEDS STAFF EMPLOYEE TYPE
This is a dimension table for IPEDS Fall Staff Survey by Employee Types. This table contains information for employee status, employee type, and contract type.
| Field Name | Description | Data Type | Length |
|---|---|---|---|
| CONTRACT_TYPE | Appointment or contract type for faculty: 9-10 month, 11-12 month | VARCHAR2 | 20 |
| EMPLOYEE_STATUS | Status of an employee: Full-Time, Part-Time | VARCHAR2 | 10 |
| EMPLOYEE_TYPE | The category of the type of work an employee performs. Possible values are: Faculty, Exec/Admin/Managerial, Other Administrative, Other Professional, Technical and Professional, Clerical and Secreterial, Skilled Crafts, Service and Maintenance, and Instruction/Research Assistant. | VARCHAR2 | 60 |
| IPEDS_STAFF_EMPTYPE_KEY | Use this field to join together the IPEDS STAFF EMPTYPE table and the IPEDS STAFF BY EMPTYPE DETAIL table. | VARCHAR2 | 8 |
| 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