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 |