RQS Query Listing
In order to run any RQS query, you must have CIW Access!
CIW PASSWORDS EXPIRE EVERY 90 DAYS! Click Here to Reset Password
Available Self-Service General Query Reports
Please remember that only authorized and authenticated CIW users will have access to their respective queries
Expand the ( ) on the General Query to view fields available to you in the general
query.
RQS-GQ807-Enrolled Student Report II - Master Enrollment Report
This query produces the following fields: SELECTION CRITERIA, QUERY ID, STUDENT ID, STUDENT NAME, PRIVACY, BIRTH DATE, CLASS, PRIMARY COLLEGE, PRIMARY DEGREE, PRIMARY MAJOR 1, PRIMARY DISCIPLINE COLLEGE 1, PRIMARY DEPARTMENT 1, PRIMARY MAJOR 1 OPTION, PRIMARY MINOR, PRIMARY MAJOR 2, PRIMARY DISCIPLINE COLLEGE 2, PRIMARY DEPARTMENT 2, PRIMARY MAJOR 2 OPTION, SECONDARY COLLEGE, SECONDARY DEGREE, SECONDARY MAJOR 1, SECONDARY DISCIPLINE COLLEGE 1, SECONDARY DEPARTMENT 1, SECONDARY MAJOR 1 OPTION, SECONDARY MINOR, SECONDARY MAJOR 2, SECONDARY DISCIPLINE COLLEGE 2, SECONDARY DEPARTMENT 2, SECONDARY MAJOR 2 OPTION, CUM GPA, TERM GPA, PREDICTED CUMULATIVE EARNED HOURS, E MAIL, STREET, CITY, STATE, ZIP, ADDRESS TYPE, INST, AU, TERM, POINT IN CYCLE, WITHDRAWAL CODE, NEW STUDENT, DEGREE SEEKING, REGISTRATION TYPE, RESIDENCY CODE, EXTRACT DATE
RQS-GQ808-Enrolled Student Report III - Major and address info only
This query produces the following fields: SELECTION CRITERIA, QUERY ID, STUDENT NAME, CLASS, PRIMARY COLLEGE, PRIMARY DEGREE, PRIMARY MAJOR 1, PRIMARY DISCIPLINE COLLEGE 1, PRIMARY DEPARTMENT 1, PRIMARY MAJOR 1 OPTION, PRIMARY MINOR, PRIMARY MAJOR 2, PRIMARY DISCIPLINE COLLEGE 2, PRIMARY DEPARTMENT 2, PRIMARY MAJOR 2 OPTION, SECONDARY COLLEGE, SECONDARY DEGREE, SECONDARY MAJOR 1, SECONDARY DISCIPLINE COLLEGE 1, SECONDARY DEPARTMENT 1, SECONDARY MAJOR 1 OPTION, SECONDARY MINOR, SECONDARY MAJOR 2, SECONDARY DISCIPLINE COLLEGE 2, SECONDARY DEPARTMENT 2, SECONDARY MAJOR 2 OPTION, E MAIL, STREET, CITY, STATE, ZIP, ADDRESS TYPE, EXTRACT DATE
RQS-GQ809-Enrollment Information Without Addresses
This query produces the following fields: SELECTION CRITERIA, QUERY ID, STUDENT ID, STUDENT NAME, PRIVACY, GENDER, ETHNICITY, BIRTH DATE, CLASS, FOREIGN STUDENT, PRIMARY COLLEGE, PRIMARY DEGREE, PRIMARY MAJOR 1, PRIMARY DISCIPLINE COLLEGE 1, PRIMARY DEPARTMENT 1, PRIMARY MAJOR 1 OPTION, PRIMARY MINOR, PRIMARY MAJOR 2, PRIMARY DISCIPLINE, COLLEGE 2, PRIMARY DEPARTMENT 2, PRIMARY MAJOR 2 OPTION, SECONDARY COLLEGE, SECONDARY DEGREE, SECONDARY MAJOR 1, SECONDARY DISCIPLINE COLLEGE 1, SECONDARY DEPARTMENT 1, SECONDARY MAJOR 1 OPTION, SECONDARY MINOR, SECONDARY MAJOR 2, SECONDARY DISCIPLINE COLLEGE 2, SECONDARY DEPARTMENT 2, SECONDARY MAJOR 2 OPTION, CUM GPA, TERM GPA, PREDICTED CUMULATIVE EARNED HOURS, INST, AU, TERM, POINT IN CYCLE, WITHDRAWAL CODE, NEW STUDENT, DEGREE SEEKING, REGISTRATION TYPE, RESIDENCY CODE, EXTRACT DATE
RQS-GQ939-Degree Report - Information about graduating students
This query produces the following fields: SELECTION CRITERIA, QUERY ID, PRIVACY, STUDENT ID, STUDENT NAME, STUDENT LAST NAME, STUDENT FIRST NAME, STUDENT MIDDLE NAME, DEGREE RECEIVED TERM, DEGREE INSTITUTION, DEGREE ACADEMIC UNIT, DEGREE COLLEGE, DEGREE RECEIVED DEGREE AWARDED, DEGREE MAJOR1, DEGREE MAJOR1 OPTION, DEGREE MAJOR1 DEPARTMENT, DEGREE MAJOR1 DISC COLLEGE, DEGREE MAJOR2, DEGREE MAJOR2 OPTION, DEGREE MAJOR2 DEPARTMENT, DEGREE MAJOR2 DISC, COLLEGE DEGREE MAJOR3, DEGREE MAJOR3 OPTION, DEGREE MAJOR3 DEPARTMENT, DEGREE MAJOR3, DISC COLLEGE, DEGREE MINOR, DEGREE CERTIFICATE, DEGREE HONORS MAJOR1 HONORS, MAJOR2 HONORS, MAJOR3 HONORS, TRANSFER HOURS, DEGREE GPA, DEGREE CAREER, DEGREE RECEIVED DATE, DEGREE MAINTENANCE DATE, CHECKOUT TERM, CHECKOUT CODE, ELECTRONIC ADDRESS, MAIL TELEPHONE, MAIL STREET, MAIL CITY, MAIL STATE, MAIL ZIP, MAIL COUNTRY, PERM TELEPHONE, PERM STREET, PERM CITY, PERM STATE, PERM ZIP, PERM COUNTRY, EXTRACT DATE
RQS-GQ949-Course Information Query - Provides detailed course info
This query produces the following fields: SELECTION CRITERIA, QUERY ID, COURSE TERM, COURSE AU, COURSE COLLEGE, COURSE ID, COURSE SUBJECT, COURSE NUMBER, COURSE SECTION, REGISTRATION STATUS, DEPARTMENT COURSE LEVEL, COURSE ACTIVITY, COURSE TITLE, PRIMARY INSTRUCTOR, WAITLIST, WAITLIST SEQUENCE, MINIMUM CREDIT HOURS, MAXIMUM CREDIT HOURS, CREDIT TYPE, AWARD UNIT TYPE, CAREER, SPECIAL GRADING, SESSION CODE, MAXIMUM ENROLLMENT, MINIMUM ENROLLMENT, FORMALLY ENROLLED COUNT, WAITLIST COUNT CALL NUMBER, COMBINED SECTION STATUS, MASTER SECTION ID, CONTROLLED ENROLLMENT, SECTION LINKAGE, DISTANCE ED CODE, MEETING DAYS, MEETING BEGIN TIME, MEETING END TIME, MEETING ROOM, OTHER MEETING PATTERNS YESNO, EXTRACT DATE
RQS-GQ1260-Final Exam Course Schedules - Provides final exam course schedules
This query produces the following fields: TERM CODE, ROOM SCHEDULE CODE, COURSE AU, COURSE ID, EXAM DATE, EXAM DAYS, EXAM BEGIN TIME, EXAM END TIME, BLDG & ROOM, POINT IN TERM, EXTRACT DATE
RQS-GQ996-Major Enrollment Report - Replaces Department Paper Report
This query produces the following fields based on student major: PRIVACY, SID, LAST NAME, FIRST NAME, MIDDLE NAME, GENDER, ETHNICITY, TOTAL ACTIVE HRS, GPA, CLASS, PRIMARY COLLEGE, PRIMARY MAJOR 1, PRIMARY MAJOR 2, SECONDARY COLLEGE, SECONDARY MAJOR 1, SECONDARY MAJOR 2, PRIMARY MINOR, SECONDARY MINOR, ADVISOR 1 NAME, ADVISOR 2 NAME, POINT IN TERM, TERM CODE, AU, EMAIL, EXTRACT DATE
RQS-GQ997-Minor Enrollment Report - Replaces Department Paper Report
This query produces the following fields based on student minor: PRIVACY, SID, LAST NAME, FIRST NAME, MIDDLE NAME, GENDER, ETHNICITY, TOTAL ACTIVE HRS, GPA, CLASS, PRIMARY COLLEGE, PRIMARY MAJOR 1, PRIMARY MAJOR 2, SECONDARY COLLEGE, SECONDARY MAJOR 1, SECONDARY MAJOR 2, PRIMARY MINOR, SECONDARY MINOR, ADVISOR 1 NAME, ADVISOR 2 NAME, POINT IN TERM, TERM CODE, AU, EMAIL, EXTRACT AS OF DATE
RQS-GQ1115-Missing Grades by Course College - List of Instructors and their Students with missing grades
This query produces the following fields based on the offering Course College: CRS TERM, CRS AU, SESSION, COURSE ID, COURSE TITLE, PRIVACY, SID, STUDENT NAME, GRADE, INSTRUCTOR, INSTRUCTOR EMAIL, POINT IN TERM, EXTRACT DATE
RQS-GQ1223-Fire Capacity Overenrolled Courses - List of Courses That Are Overenrolled and Exceeding Fire Capacity
This query produces the following fields based on the offering Course College: COURSE TERM, COURSE AU, COURSE COLLEGE, DEPARTMENT, SESSION CODE, COURSE ID, COURSE ACTIVITY, COURSE TITLE, REGISTRATION STATUS, MAXIMUM ENROLLMENT, FORMALLY ENROLLED COUNT, MAXIMUM SEATING CAPACITY, MEETING DAYS, MEETING BEGIN TIME, MEETING END TIME, MEETING ROOM, PRIMARY INSTRUCTOR, INSTRUCTOR EMAIL, INSTRUCTOR PHONE, EXTRACT DATE
RQS-GQ1255-Course Enrollment/Waitlist by Date/Time All students that ever enrolled/waitlisted/dropped a course, by individual course, sorted by date order of enrollment.
This query produces the following fields:TERM CODE, PRIVACY, SID, STUDENT NAME, COURSE ID, REG AUDIT DATE, REG AUDIT TIME, NEW STATUS, PREVIOUS STATUS, EXTRACT DATE

RQS-GQ1222-Grade Liaison Report
Assists Department Grade Liaisons with Web Grading Submission Verification. - Updated Daily
Access to this query is granted only with permission. Click Here to fill out form.
RQS-GQ1222-Grade Liaison Report - Assists Department Grade Liaisons with Web Grading Submission Verification. Access to this query is granted only with permission. Click Here to fill out form.
This query produces the following fields: TERM CODE, SESSION, COURSE CODE, SUBJECT CODE, COURSE ID, COURSE SECTION, COURSE TITLE, PRIMARY COLLEGE, PRIVACY, GRADE, STUDENT NAME, SID, STUDENT EMAIL, INSTRUCTOR, INSTRUCTOR EMAIL, POINT IN TERM, EXTRACT DATE
Available Self-Service Custom Query Reports by Department
Please remember that only authorized and authenticated CIW users will have access to their respective queries.
Expand the ( ) on the Department Name to view available queries by department.
Access Services
Athletics
Arts & Sciences
Center for Multicultural Affairs
Communications
Continuing Education
CU Book Store
CU Foundation
Economics
Environmental Studies
Engineering
Graduate School
Greek Life
Honors
Housing
Integrative Physiology
International Education
Law School
Leeds School of Business
Libby Hall RAP
Music
Off Campus Student Services
Office of the Registrar
Physics
Psychology
Recreation Center
Security
Sewell Academic Program
Special Undergraduate Enrichment Programs
Student Affairs
Study Abroad Programs
Wardenburg Health Center
|