HR CIP Table
Master data table containing the CIP(Classification of Instructional Programs) records, 2000 Edition, as published by the National Center for Education Statistics in April 2002.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
HR_CIP_FOUR_DIGIT_CODE |
Code that defines the field of study. |
VARCHAR2 |
4 |
HR_CIP_FOUR_DIGIT_CODE_DESC |
A generic description of the field of study. Example: Engineering. |
VARCHAR2 |
50 |
HR_CIP_KEY |
This field should be used to join HR_CIP table with HR_EMPLOYMENT_CIP_DETAIL table. This field should only be used for linking tables together, NOT for reporting |
VARCHAR2 |
6 |
HR_CIP_PROGRAM_CODE |
Code that defines the field of study in detail. |
VARCHAR2 |
6 |
HR_CIP_PROGRAM_DESC |
A detailed description of the field of study. Example: Chemical Engineering. |
VARCHAR2 |
50 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |