|
|
|
DELW CIP 4 DIGIT
This is a dimension table for Delaware Survey. It contains all Four-Digit CIP codes and descriptions from CIP-1990 and CIP-2000.
| Field Name | Description | Data Type | Length |
|---|---|---|---|
| CIP_4_DIGIT_CODE | The first 4-digit (sub-category) of a CIP code. | VARCHAR2 | 4 |
| CIP_4_DIGIT_DESC | The descriptive title of the first 4-digit of a CIP code. | VARCHAR2 | 150 |
| DELW_CIP_4_DIGIT_KEY | This field should be used to join to another table with the same-name field. E.g. joining between the DELW_CIP_4_DIGIT table and the DELW_EXPENDITURE_DETAIL table or the DELW_TEACHING_LOAD_DETAIL table. | VARCHAR2 | 4 |
| 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