Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse 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