CIP WITH VERSION Table

This table consists of multiple versions of the CIP (Classification of Instructional Programs) records as published by the National Center for Education Statistics. The 1990 version is loaded from the publication in July 1999. The 2000 version is loaded from the 2000 Edition published in April 2002.

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	100
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	100
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 and CIP WITH VERSION tables, this field contains additional information regarding the Program Title.	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
VERSION	The version or edition number. Currently, there are two: 1990 or 2000.	VARCHAR2	8
WAREHOUSE_LOAD_DATE	The date the record was loaded into the Data Warehouse from the source system.	DATE	8