|
|
|
CUPA HIRING DEMOGRAPHIC
This is a dimension table for CUPA Administrative Compensation Survey. It contains all the possible values of the hiring status (e.g. "Internal Promotion", "Outside Hire", "None Entered") and demographic types (e.g. "Male", "Female" for gender; and the minority status) which describe the occupant of the position.
| Field Name | Description | Data Type | Length |
|---|---|---|---|
| CUPA_GENDER | Gender: Male, Female, None Entered, Unknown or unavailable | VARCHAR2 | 30 |
| CUPA_GENDER_CODE | Gender Code of 0,1,2,3,F,M which represents the various types of gender. See CUPA GENDER | VARCHAR2 | 1 |
| CUPA_HIRING_DEMOGRAPHIC_KEY | Use this field to join the CUPA HIRING DEMOGRAPHIC table and the CUPA ADMIN SALARY DETAIL table to retrieve hiring status and demographic information for each of the CUPA Administrative Salary records. | VARCHAR2 | 4 |
| CUPA_HIRING_STATUS | Hiring status of this position: Internal Promotion, Outside Hire, None entered, Unknown or unavailable | VARCHAR2 | 30 |
| CUPA_HIRING_STATUS_CODE | Hiring status code: 0=None entered, 1=Interenal Promotion, 2=Outside Hire, I=Internal Promotion, O=Outside Hire, 3=Unknown or unavailable | VARCHAR2 | 1 |
| CUPA_MINORITY_STATUS | Minority Status: "Yes", "No"; or "None entered", "Unknown or unavailable" | VARCHAR2 | 30 |
| CUPA_MINORITY_STATUS_CODE | Minority Status Code: 0=None entered, Y or 1=Yes, N or 2=No, 3=unknown or unavailable | VARCHAR2 | 1 |
| CUPA_VACANCY_INDICATOR | Vacancy indicator for the position: V or X = vacant | VARCHAR2 | 1 |
| IS_VACANT | A flag indicates whether the position is vacant. Y=Yes, N=No. See also CUPA VACANCY INDICATOR | VARCHAR2 | 1 |
| 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