CIP, Subject, Catalog, Course
Report Purpose
Following a meeting with the registrars (September 12, 2017), this query was developed by System IR to compare CIP Codes in the Course Catalog and the Subject tables to highlight inconsistencies, missing CIP codes, and inactive CIP codes. Course is the unit of analysis.
Report Location
MyCampus > MaineStreet > Enterprise Applications > Campus Solutions-92-Reporting > PS Query tile > Query Manager or Query Viewer
Note - If your CSRPT Reporting Homepage dashboard does not have a PS Query tile, contact the UMS - Campus Solutions Security Liaisons for your institution.
Report Name/Type
UMS_IR_CIP_CATALOG_VS_SUBJECT
Prompts Required
For information on field values to enter, click the name of the prompt.
(None required)
Data Fields Generated
| Institution | Subject | Catalog Number | CIP Code from Course Catalog | Is CIP (Catalog) inactive? | CIP Code from Subject Table | Is CIP (Subject Tbl) inactive? | Codes missing or different? |
|---|
Tables Used
- UM_CLSS_SCH_FCL - Class Schedule and Facility Vw
- CRSE_OFFER - Course Catalog Offerings
- SUBJECT_TBL - Subject Table
Data Governance
The University of Maine System, and its respective campuses, does not have a systematic process for review and updating of CIP codes associated with courses, degrees and faculty. While some campuses may update more often, we do not, system-wide currently have a dependable way of querying data for studies like the Delaware Cost Study, which UMS is participating in this academic year (2017-2018). A proposal has been forwarded to the Data Governance Committee for review.
New to PeopleSoft Query?
Click on Getting Started and begin with the Query Basics video
Need help running a query?
Click on Running Reports with Query Viewer & Query Manager for a quick how-to guide for navigating to PS Query and running a report.
HELP IS AT HAND!
Question, comment, critique? We are here to help and we strive to make our site a comprehensive, user friendly experience. Contact us at DARTS@maine.edu.