2020 CIP Codes Load Into EDW

October 2, 2020

On Tuesday, October 6, 2020, the new 2020 CIP Series will be loaded into the Enterprise Data Warehouse. This affects any table that contains CIPKeyId. The tables that contain CIP code reference data are dimCIPCurrent and CIPAcademicYear in EDWPresentation.

What is included in CIP code updates?

Part 1: CIP codes with descriptions from the National Center for Education Statistics (NCES).

Part 2: Federal STEM (Science, Technology, Engineering & Mathematics) indicator provided by Immigrations and Customs Enforcement (ICE). This indicator is updated at irregular intervals. The most current data is from 2016.

Part 3: Washington State STEM indicators provided by the Office of Financial Management (OFM) in Olympia. This data is updated yearly.

  • Currently we have CIP codes (part 1) with their descriptions from NCES.
  • Federal STEM indicator (part 2) from 2016 matches what is currently in dimCIPCurrent and CIPAcademicYear.
  • Washington State STEM indicators (part 3) will be delivered to us sometime in the near future from OFM.

What is being loaded into dimCIPCurrent and CIPAcademicYear?

The Office of Planning and Budgeting (OPB) has given us the authorization to load the new 2020 CIP codes, with mapping to the Federal STEM indicators from 2016 and Washington State STEM indicators from 2019. Once new STEM indicators from ICE and OFM become available, we will update them accordingly in dimCIPCurrent and CIPAcademicYear

How may this affect you?

  1. There are new CIP codes for 2020 that did not exist in 2010. A subset of these CIP codes has been entered into the Student Database (SDB). So you may see CIP codes that are in dimCIPCurrent or CIPAcademicYear but not in the SDB.
  2. The STEM indicators for 2020 CIP codes to be published, both from ICE and OFM, are mapped based on their relationship to 2010 CIP codes. When we receive new indicator values from ICE and OFM, the relationship may or may not be the same.
  3. The 2020 CIP codes that are not in the 2010 version will have no STEM indicators.

 

Why is dimCIPCurrent and CIPAcademicYear being loaded without all of the updated data?

There is a need throughout campus for these new CIP codes and STEM indicators. Since a subset of 2020 CIP codes has been added to SDB, and dimCIPCurrent and CIPAcademicYear are the only places storing the relationship between the CIP codes and the STEM indicators, OPB, Registrar, and the Graduate School have requested EDW to load and publish the data.

Questions or concerns?

If you have questions or concerns, please email us at help@uw.edu with “2020 CIP Codes” in the subject line.