Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse HR EMPLOYMENT CIP TYPE Table


Table containing description about the types of CIP (Classification of Instructional Programs) records for a discipline


Field Name

Description

Data Type

Length

HR_EMPLOYMENT_CIP_TYPE

This field contains the names of the CIP types for a discipline

VARCHAR2

40

HR_EMPLOYMENT_CIP_TYPE_CODE

This field contains the codes for the different CIP types for a discipline

VARCHAR2

2

HR_EMPLOYMENT_CIP_TYPE_KEY

This field should be used to join HR_EMPLOYMENT_CIP_TYPE table to HR_EMPLOYMENT_CIP_DETAIL table. This field should only be used for linking tables together, NOT for reporting

VARCHAR2

2

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8