Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse 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, 2000, and 2010 versions are included in the table.


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

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 of CIP published by the NCES (National Center for Education Statistics). Eg. 1990, 2000, 2010

VARCHAR2

4

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8