CIP Table
This table contains the CIP (Classification of Instructional Programs) records, 2010 Edition, as published by the National Center for Education Statistics.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CATEGORY_CODE |
The 2-digit series number or category of a CIP code; ie. the first 2-digit of the CIP code |
VARCHAR2 |
2 |
CATEGORY_TITLE |
The descriptive title of the 2-digit CIP category/series. |
VARCHAR2 |
200 |
FOUR_DIGIT_CODE |
The first four digit (sub-category) of a CIP code. |
VARCHAR2 |
4 |
FOUR_DIGIT_TITLE |
The descriptive title of the first 4-digit of a CIP code. |
VARCHAR2 |
200 |
NOTE |
For the LIBRARY FINANCIAL DETAIL and LIBRARY ALLOCATION DETAIL tables, the NOTE field contains detailed explanation of the budget transaction. May be system assigned e.g. INVOICE, ORDER ENCUMBRANCE (Z601-NOTE). For the CIP table, this field contains additional information regarding the CIP program. |
VARCHAR2 |
100 |
PROGRAM_CODE |
The 6-digit program code. CIP is the NCES (National Center for Education Statistics) publication that classifies instructional programs by standard terminology for curriculum and instruction in local and state school systems and postsecondary institutions. |
VARCHAR2 |
6 |
PROGRAM_TITLE |
The descriptive title of the 6-digit CIP code. |
VARCHAR2 |
200 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |