Report ID | Title | Description | Columns Included | Records Included | Developer | Requestor | Comments | Shared with | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CU_BAR_CM_00001 | Subject Table Detail | This query lists the details of the subject table. It promps on Institution. | Institution, Subject, Eff Date, Status, Description, Short Description, Academic Organization, Split Owner, External Subject, CIP Code, HEGIS Code, Formal Description, Blind Grd, Field of Study |
| Michael McGovern | Edward Adams | New Report | C Valente, A Cox, C Keck, A Kamruzzaman, P Ackerman, T. Lodhi | |||||||||||||||
CU_BAR_CM_00002_1 | Course Catalog Detail | This query lists the details of the course catalog. It promps on Institution, Academic Group (optional) and Academic Organization (optional). | Acad Group, Acad org, Career, Subject, Catalog, Course Title, Credits, Long Description, Prerequisite | - CRSE_CATALOG - Course Catalog Data Hierarchy Join - CRSE_OFFER - Course Catalog Offerings Hierarchy Join - RQ_GRP_TBL - Requirement Group Table Hierarchy Join | Michael McGovern | Patrick Ackerman | New Report | C Valente, A Cox, C Keck, A Kamruzzaman, P Ackerman, T. Lodhi | |||||||||||||||
CU_BAR_CM_00003_2 | Class Detail | This is a detail list of classes for the institution and term. Prompt on Institution, Term, Academic Group (optional), Academic Organization (optional), Session (optional) and Career (optional). | Acad Group, Acad Org, Subject, Catalog, Class Description, Session, Class#, Section, Class Stat, Instruction Mode, Start Date, End Date, Room Cap, Enroll Cap, Enrollment, Seats Left, Designation Description, Rq Group, Career, Units, Contact Hrs, FTE, Pat Nbr, Facility ID, Mtg Start, Mtg End, Class Days, Instructor Name | - CLASS_TBL - Class Table Hierarchy Join | Michael McGovern | Stephanie Govan | New Report | S Govan, A Cox, C Keck, J Albanese, E Berstein, E Figini, P Davis-Friday, A Kamruzzaman, C Valente, P Ackerman, T. Lodhi, S. Loebis | |||||||||||||||
CU_BAR_CM_ | 00004Cross-Listed/Combined Courses00003_3 | Class Detail | This is a | listing of all Cross-Listed/Combined courses in the catalogdetail list of classes for the institution and term. Prompt on Institution | ., Term, Academic Group (optional), Academic Organization (optional), Session (optional) and Career (optional). | Subject, Catalog, Description, Acad Group, Acad Org, Subject, Catalog, Class Description, Acad Group, Acad Org, Session, Class#, Section, Class Stat, Instruction Mode, Start Date, End Date, Room Cap, Enroll Cap, Enrollment, Seats Left, Designation Description, Rq Group, Career, Units, Contact Hrs, FTE, Pat Nbr, Facility ID, Mtg Start, Mtg End, Class Days, Instructor Name | - CLASS_TBL - Class Table Hierarchy Join | Tabassum Lodhi | Michael McGovern | Stephanie | Govan New report.Govan | Modified Report | S Govan | , C Keck,A Kamruzzaman, P Ackerman, T. Lodhi | |||||||||
CU_BAR_CM_0000500004 | Cross-Listed/Combined CoursesClass Detail/Academic Affairs | This is a detail list of classes for the institution and termlisting of all Cross-Listed/Combined courses in the catalog. Prompt on Institution and Term. | Acad Org, Course ID, Subject, Catalog, Class Description, CareerAcad Group, UnitsAcad Org, TermSubject, Term SessionCatalog, Class SectionDescription, Component, Class Stat, Instruction Mode, Start Date, End Date, Enrollment, Pat Nbr, Facility ID, Class Start Time, Class End Time, Class Days InstructorAcad Group, Acad Org | - CRSE_CATALOG - Course Catalog Data - CLASS_TBL - Class Table Hierarchy Join
| Michael McGovernMcGovern | Abby SantanaStephanie Govan | New Reportreport. | S Govan, C Keck, A KamruzzamanA Santana, M Burgos, A Cox, C Keck, P Ackerman, T. Lodhi | |||||||||||||||
CU_BAR_CM_0000600005 | Class Detail/Academic AffairsInstructor Term Workload | This is a detail list of instructors, their classes and their workload hoursclasses for the institution and term. Prompt on Institution and Term. | Dept Description, Acad Org, Last Name, first Name, Middle Name, Empl Rcd#, Ln#, Empl ID, Pay Satus, Job Code, Job Description, Inst/Term/Session, Workload, Class #, Course ID, Subject/Catalog/Section/Enr, Class Description, unitCourse ID, Subject, Catalog, Class Description, Career, Units, Term, Term Session, Class Section, Component, Class Stat, Instruction Mode, Start Date, End Date, Enrollment, Pat Nbr, Facility ID, Class Start Time, Class End Time, Class Days Instructor |
| Michael McGovern | Abby Santana | New Report | A Santana, M Burgos, A Cox, C Keck, P Ackerman, T. Lodhi | |||||||||||||||
CU_BAR_CM_00006 | Instructor Term Workload | This is a list of instructors, their classes and their workload hours. Prompt on Institution and Term. | Dept Description, Acad Org, Last Name, first Name, Middle Name, Empl Rcd#, Ln#, Empl ID, Pay Satus, Job Code, Job Description, Inst/Term/Session, Workload, Class #, Course ID, Subject/Catalog/Section/Enr, Class Description, unit | - -EMPLOYMENT_HOME - Vw-Home Employment/Job Hierarchy Join Sub Query for Exist: -INSTR_TERM_DTL - Instructor Term Table Detail UNION1: -EMPLOYMENT_HOME - Vw-Home Employment/Job Hierarchy Join INSTR_TERM_DTL - Instructor Term Table Detail Hierarchy Join CLASS_TBL - Class Table Hierarchy Join NAME_CURR_VW - Current Name Vw all types Hierarchy Join DEPT_TBL - Departments Hierarchy Join UNION2: -EMPLOYMENT_HOME - Vw-Home Employment/ Job Hierarchy JoinINSTR_TERM_DTL - Instructor Term Table Detail Hierarchy Join CLASS_TBL - Class Table Hierarchy Join NAME_CURR_VW - Current Name Vw all types Hierarchy Join DEPT_TBL - Departments Hierarchy Join Sub Query for Exist: -INSTR_TERM_DTL - Instructor Term Table Detail | Michael McGovern | Abby Santana | New Report | Job Hierarchy Join Sub Query for Exist: -INSTR_TERM_DTL - Instructor Term Table Detail UNION1: -EMPLOYMENT_HOME - Vw-Home Employment/Job Hierarchy Join INSTR_TERM_DTL - Instructor Term Table Detail Hierarchy Join CLASS_TBL - Class Table Hierarchy Join NAME_CURR_VW - Current Name Vw all types Hierarchy Join DEPT_TBL - Departments Hierarchy Join UNION2: -EMPLOYMENT_HOME - Vw-Home Employment/Job Hierarchy Join INSTR_TERM_DTL - Instructor Term Table Detail Hierarchy Join CLASS_TBL - Class Table Hierarchy Join NAME_CURR_VW - Current Name Vw all types Hierarchy Join DEPT_TBL - Departments Hierarchy Join Sub Query for Exist: -INSTR_TERM_DTL - Instructor Term Table Detail | Michael McGovern | Abby Santana | New Report | A Santana, M Burgos, A Cox, C Keck, A. Kamruzzaman, P Ackerman, T. Lodhi | |||||||||||
CU_BAR_CM_00006I | Invalid Instructor Departments | This is a list of instructors, who are in invalid departments. Prompt on Institution and Term. | DeptID, Last Name, First Name, Middle Name, Empl Rcd#, Ln#, Empl ID, Pay Status, Job Code, Job Description, Unit, Descr, Course ID, Offer Nbr, Pat Nbr, Session, Institution | -EMPLOYMENT_HOME - Vw-Home Employment/Job Hierarchy Join - NAME_CURR_VW - Current Name Vw all types Hierarchy Join - JOBCODE_TBL_VW - Current Job Codes View Hierarchy Join - INSTR_TERM_DTL - Instructor Term Table Detail Hierarchy Join Sub Query for Exist: -INSTR_TERM_DTL - Instructor Term Table Detail Sub Query for Does Not Exist: -DEPT_TBL - Departments | Michael McGovern | Abby Santana | New Report | A Santana, M Burgos, A Cox, C Keck, P Ackerman, T. Lodhi | |||||||||||||||
CU_BAR_CM_00007 | Class Roster Detail | This is a list of students in a class, including the class information, the students' name, emplid, program, plan(s) and contact information. Prompt on Institution, Term and Class Number. | Acad group, Acad Org, Subject, Catalog, Class Description, Section, Session, Class Nbr, Component, Line#, Tot Enrl, Emplid, Last Name, First Name, Middle Name, Campus Email |
UNION 1: -CLASS_TBL_SE_VW - Class Table Student Enrl View Hierarchy Join -CU_BIO_VW - Biographical Information View Hierarchy Join -EMAIL_FERPA_VW - EMAIL FERPA VIEW Hierarchy Join -CLASS_TBL - Class Table Hierarchy Join | Michael McGovern | Stephanie Govan | New Report | S Govan, A Kamruzzaman, C Keck, P Ackerman, T. Lodhi | |||||||||||||||
CU_BAR_CM_00008 | Class Tally for New Students | This is a list of classes for the term with the total number of new students enrolled. Prompt on Institution, Admit Term range, Enrollment Term, Career (optional) and Admit Type (optional). | Acad group, Acad Org, Career, Subject, Catalog, Class Description, Session, Section,Class Nbr, Component, Class Sat, Tot Enrl, Total New Enrl |
- CLASS_TBL_SE_VW - Class Table Student Enrl View Hierarchy Join Sub Query for Exist: -ACAD_PROG - Student Academic Program Hierarchy Join -ADM_APPL_DATA - Admission Application Data Hierarchy Join | Michael McGovern | Stephanie Govan | New Report | S Govan, C Keck, A A Santana, M Burgos, A Cox, C Keck, A. Kamruzzaman, P Ackerman, T. Lodhi | |||||||||||||||
CU_BAR_CM_00006I00008_DTL | Class Tally DetailInvalid Instructor Departments | This is a list of instructors, who are in invalid departments. class student list for the prompted class. Prompt on Institution and Term, Term, Subject, Catalog and Section. | DeptIDSubject, Last Name, First Name, Middle Name, Empl Rcd#, Ln#Catalog, Class Description, Session, Section, Tot Enrl, Empl ID, Pay Status, Job Code, Job Description, Unit, Descr, Course ID, Offer Nbr, Pat Nbr, Session, Institution -EMPLOYMENT_HOME - Vw-Home Employment/Job Hierarchy Join - NAME_CURR_VW - Current Name Vw all types Hierarchy Join - JOBCODE_TBL_VW - Current Job Codes View Hierarchy Join - INSTR_TERM_DTL - Instructor Term Table Detail Hierarchy Join Sub Query for Exist: -INSTR_TERM_DTL - Instructor Term Table Detail Sub Query for Does Not Exist: -DEPT_TBL - Departments | Michael McGovern | Abby Santana | New Report | Acad Prog, Admit Term, Appl Nbr, Admit Type, Career, Career Nbr, Appl Nbr, Institution, Status | - CLASS_TBL_SE_VW - Class Table Student Enrl View Hierarchy Join - ACAD_PROG - Student Academic Program Hierarchy Join - ADM_APPL_DATA - Admission Application Data Hierarchy Join | Michael McGovern | Stephanie Govan | New Report | S Govan, C Keck, A Kamruzzaman, A Santana, M Burgos, A Cox, C Keck, P Ackerman, T. Lodhi | |||||||||||
CU_BAR_CM_0000700009 | Class Roster Detail for SEEK | This is a list of students in a class, including the class information, the students' name, emplid, program, plan(s) and contact information. Prompt on Institution, Term and Class Number., class data, SEEK indicator and grades. Prompt on Institution, Term, Academic Org (optional), Subject (optional), Catalog Nbr (optional) and Section (optional). | Acad group, Acad Org, Subject, Catalog, Class Description, Session, Section, Session, Class Nbr, Component, Line#, Tot Enrl, Emplid, Last Name, First Name, Middle Name, Campus EmailLast Name, First Name, Middle Name, Empl ID, Grade, Seek? | - CLASS_TBL_SE_VW - Class Table Student Enrl View Hierarchy Join - CU_BIO_VW - Biographical Information View Hierarchy Join - STDNT_GRPS_HIST - Student Groups History Hierarchy Join - CLASS_ATTRIBUTE - Class Attribute Table Hierarchy Join UNION1: - CLASS_TBL - Class Table Hierarchy JoinUNION 1: -CLASS_TBL_SE_VW - Class Table Student Enrl View Hierarchy Join -CU_BIO_VW - Biographical Information View Hierarchy Join -EMAIL_FERPA_VW - EMAIL FERPA VIEW Hierarchy Join -CLASS_TBL - Class Table Hierarchy JoinCLASS_ATTRIBUTE - Class Attribute Table Hierarchy Join Sub Query for Does Not Exist: -STDNT_GRPS_HIST - Student Groups History | Michael McGovern | Stephanie GovanMarisol Morales | New Report for SEEK | M Morales, C KeckS Govan, A Kamruzzaman, C Keck, P Ackerman, T. Lodhi | |||||||||||||||
CU_BAR_CM_00010_000082 | Class Tally for New StudentsDetail w/Prerequisites | This is a detail list of classes for the term with the total number of new students enrolled. institution and term. Prompt on Institution , Admit Term range, Enrollment Term, Career (optional) and Admit Type (optional). | Acad group, Acad Org, Career, Subject, Catalog, Class Description, Session, Section,Class Nbr, Component, Class Sat, Tot Enrl, Total New Enrl | and Term. | Acad Group, Acad Org, Subject, Catalog, Class Description, Session Class#, Section, Class Stat, Instruction Mode, Start Date, End Date, Room Cap, Enroll Cap, Enrollment, Seats Left, Designation Description, Units, Cntct Hrs, Pat Nbr, Facility ID, Mtg Start, Mtg End, Class Days, Instructor Last Name, Instructor First Name, Rq Group, Long Description | - CLASS_TBL - Class Table Hierarchy Join - CLASS_ASSOC - Class Associations Hierarchy Join - RQMNT_DESIG_TBL - Requirement Designation Table Hierarchy Join - CLASS_MTG_PAT - Class Meeting Pattern - CLASS_TBL - Class Table Hierarchy Join - CLASS_TBLINSTR_SE_VW - Class Table Student Enrl View Hierarchy Join Sub Query for Exist: -ACAD_PROG - Student Academic Program Hierarchy Join -ADM_APPL_DATA - Admission Application Data Hierarchy Join | Michael McGovern | Stephanie Govan | New Report | VW5 - Distinct Instructors for Class Hierarchy Join - CRSE_OFFER - Course Catalog Offerings Hierarchy Join - CRSE_CATALOG - Course Catalog Data Hierarchy Join - RQ_GRP_TBL - Requirement Group Table Hierarchy Join | Michael McGovern | Czarina Valente | New Report | C Valente, A Cox, C Keck, J Tse, B LuS Govan, C Keck, A Kamruzzaman, P Ackerman, T. Lodhi | |||||||||
CU_BAR_CM_0000800011_DTL2 | Class Tally DetailSchedule/Book Report | This is a list of class student list for the prompted class. listing of classes and their books for the bookstore. Prompt on Institution, Term , and Session (optional). | Subject, Catalog and Section. | Subject, Catalog, Class Description, Session, Section, Tot Enrl, Empl ID, Acad Prog, Admit Term, Appl Nbr, Admit Type, Career, Career Nbr, Appl Nbr, Institution, Status | , Description, Section, Session, Career, Class Status, Enroll. Cap, Total Enroll., Class Start Date, Class End Date, Material Type, Material Status, Material Title, ISBN, Author, Publisher, Edition, Published ,Price, Facil ID, Class Start Time, Class End Time, Class Days, Instructor Last Name, Instructor First Name, Email | - CLASS_TBL - Class Table Hierarchy Join - SSR_CLS_TXB_DTL - Class Reserve Capacity Table Hierarchy Join - CLASS_MTG_PAT - Class Meeting Pattern Table Hierarchy Join - CLASS_INSTR_VW5 - Distinct Instructors for Class Hierarchy Join - EMAIL_ADDRESSES - Email Addresses - CLASS_TBL_SE_VW - Class Table Student Enrl View Hierarchy Join - ACAD_PROG - Student Academic Program Hierarchy Join - ADM_APPL_DATA - Admission Application Data Hierarchy Join | Michael McGovern | Stephanie GovanChristian Keck | New Reportreport, second revision. | S Govan, C Keck, A Downing, A KamruzzamanCox, P Ackerman, T. Lodhi | |||||||||||||
CU_BAR_CM_ | 0000900012 | Class | RosterDetail | for SEEKw/Enrollment | This is | a list of students in a class, including the class information, the students' name, emplid, class data, SEEK indicator and gradesa list of active classes and the students enrolled in them. Prompt on Institution, Term with optional prompts on Academic Group, Academic | Org (optional), Subject (optional), Catalog Nbr (optional) and Section (optional).Organization (optional) and Session (optional). | Acad Group, Acad Org, Subject, Catalog, Class Description, Session, Class#, Section, Class Stat, Instruction Mode, Start Date, End Date, Room Cap, Enroll Cap, Enrollment, Seats Left, Designation Description, Career, Units, Contact Hrs, Pat Nbr, Facility ID, Mtg Start, Mtg End, Class Days, Instructor Name, Student ID, Student Last Name, Student First Name, Student Middle Name, Student Email | - CLASS_TBL - Class Table Hierarchy Join - CLASS_ASSOC - Class Associations Hierarchy Join - RQMNT_DESIG_TBL - Requirement Designation Table Hierarchy Join - CLASS_MTG_PAT - Class Meeting Pattern Table Hierarchy Join - CLASS_INSTR_VW5 - Distinct Instructors for Class | Subject, Catalog, Class Description, Session, Section, Last Name, First Name, Middle Name, Empl ID, Grade, Seek? | - CLASS_TBL_SE_VW - Class Table Student Enrl View Hierarchy Join - CU_BIO_VW - Biographical Information View Hierarchy Join - STDNT_GRPS_HIST - Student Groups History Hierarchy Join - CLASS_ATTRIBUTE - Class Attribute Table Hierarchy Join UNION1: -CLASS_TBL _SE_VW - Class Table Student Enrl View Hierarchy Join - Class Table Hierarchy Join -STDNT_ENRL - Student Enrollment Table Hierarchy Join -CU_BIO_VW - Biographical Information View Hierarchy Join CLASS_ATTRIBUTE - Class Attribute Table Hierarchy Join Sub Query for Does Not Exist: -STDNT_GRPS_HIST - Student Groups History
| Michael McGovern | Marisol MoralesChristian Keck | New | Report for SEEKreport. | M Morales,C Keck, A Kamruzzaman, P Ackerman, T. Lodhi
| |||||||
CU_BAR_CM_ | 0001000013_ | 2Class Detail w/Prerequisites1 | Non-Posted Grade Rosters | This is a | detaillist of | classes for the institution and termall classes with non-posted grade rosters. Prompt on Institution | and Term., Term and Academic Organization (optional). | Acad Org, Subject, Catalog, Descr, Section, Class Nbr, Tot Enrl, Start Date, End Date, Role, Instructor IDAcad Group, Acad Org, Subject, Catalog, Class Description, Session Class#, Section, Class Stat, Instruction Mode, Start Date, End Date, Room Cap, Enroll Cap, Enrollment, Seats Left, Designation Description, Units, Cntct Hrs, Pat Nbr, Facility ID, Mtg Start, Mtg End, Class Days, Instructor Last Name, Instructor First Name, Rq Group, Long Description Instructor Email | - CLASS_TBL - Class Table Hierarchy Join - CLASS_ASSOC - Class Associations Hierarchy Join - RQMNT_DESIG_TBL - Requirement Designation Table Hierarchy Join - CLASS_MTG_PAT - Class Meeting Pattern Table GRADE_RSTR_TYPE - Grade Roster Type Hierarchy Join - CLASS_INSTR_VW5 - Distinct Instructors for Class Hierarchy Join - CRSEEMAIL_OFFER - Course Catalog Offerings ADDRESSES - Email Addresses Hierarchy Join - CRSE_CATALOG - Course Catalog Data Hierarchy Join - RQ_GRP_TBL - Requirement Group Table Hierarchy Join | Michael McGovern | Czarina ValenteEdward Adams | New Report | C Valente, A Cox,E Adams, C Keck, | J Tse, B Lu,A Kamruzzaman, P Ackerman, T. Lodhi | |||||||||
CU_BAR_CM_00011_200014 | Grade Roster DetailClass Schedule/Book Report | This is a listing listed of all classes and their books for the bookstorefor the term with enrollment and grades. Prompt on Institution, Term and Session , Academic Group, Academic Organization (optional) and Subject (optional). | Acad Group, Acad Org, Subject, Catalog, Description, Section, Session, Career, Class StatusDescription, Enroll. CapComponent, Enrollment Total Enroll., Class Start Date, Class End Date, Material Type, Material Status, Material Title, ISBN, Author, Publisher, Edition, Published ,Price, Facil ID, Class Start Time, Class End Time, Class Days, Instructor Session, Emplid, Last Name, Instructor First Name, EmailGrade | -CLASS_TBL - Class Table Hierarchy Join- SSR_CLS_TXB_DTL - Class Reserve Capacity Table Hierarchy Join Hierarchy Join UNION 1: -CLASS_MTG_PAT TBL - Class Meeting Pattern Table Hierarchy Hierarchy Join -CLASS_INSTR_VW5 - Distinct Instructors for Class Hierarchy Join UNION 2: -CLASS_TBL - Class Table Hierarchy Join - EMAILSTDNT_ADDRESSES - Email Addresses ENRL - Student Enrollment Table Hierarchy Join -CU_BIO_VW - Biographical Information View Hierarchy Join | Michael McGovern | Christian Keck Keck | New ReportNew report, second revision. | C Keck, A Downing, A CoxKamruzzaman, P Ackerman, T. Lodhi | |||||||||||||||
CU_BAR_CM_0001200015 | Grades Posted After DateClass Detail w/Enrollment | This is a list listing of active classes and the students enrolled in themclasses which have prompted grades posted after a prompted date. Prompt on Institution, Term with optional prompts on Academic Group, Academic Organization (optional) and Session (optional).Instititution, Term, Grade Date and Grades. | Last Name, First Name, Middle Name, Empl ID, Career, Program, Acad Group, Acad Group, Acad Org, Subject, Catalog, Class DescriptionSection, Session, Class#, Section, Class Stat, Instruction Mode, Start Date, End Date, Room Cap, Enroll Cap, Enrollment, Seats Left, Designation Description, Career, Units, Contact Hrs, Pat Nbr, Facility ID, Mtg Start, Mtg End, Class Days, Instructor Name, Student ID, Student Last Name, Student First Name, Student Middle Name, Student EmailCourse Description, Units, Grade, Grade Dt | -CLASS_TBL_SE_VW - Class Table Student Enrl View Hierarchy Join - CU_BIO_VW - Biographical Information View Hierarchy Join | Michael McGovern | Arthur Downing | New report. | A Downing, C Keck, A Kamruzzaman, G Hotko, P Ackerman, T Lodhi | |||||||||||||||
CU_BAR_CM_00015_1 | Grades Posted After Date with course information | This is a listing of classes which have prompted grades posted after a prompted date. Added course number detail. Prompt on Instititution, Term, Grade Date and Grades. | Last Name, First Name, Middle Name, Empl ID, Career, Program, Acad Group, Subject, Catalog, Section, Session, Course Description, Units, Grade, Grade Dt, Course Number | -CLASS_TBL_SE_VW - Class Table Student Enrl View - CLASS_TBL - Class Table Hierarchy Join - CLASS_ASSOC - Class Associations Hierarchy Join - RQMNT_DESIG_TBL - Requirement Designation Table Hierarchy Join - CLASS_MTG_PAT - Class Meeting Pattern Table Hierarchy Join - CLASS_INSTR_VW5 - Distinct Instructors for Class Hierarchy Join UNION1: -CLASS_TBL - Class Table Hierarchy Join -STDNT_ENRL - Student Enrollment Table Hierarchy Join - CU_BIO_VW - Biographical Information View View Hierarchy Join
| Tabassum Lodhi / Michael McGovern | Christian Keck | Gary Hotko | Modified ReportNew report. | C Keck, A KamruzzamanGary Hotko, P Ackerman, T. Lodhi, D. Ramkaran
| ||||||||||||||
CU_BAR_CM_00013_100016 | Class Detail Report Non-Posted Grade Rosters | This is a list listing of all classes with non-posted grade rostersactive classes with enrollment numbers. Prompt on Institution, Term and , Academic Organization (optional) and Subject (optional). | Acad Group, Acad Org, Subject, Catalog, DescrClass Description, Class Section, Class Nbr, Tot Enrl, Component, Room Cap, Enrl Cap, Enroll Total, Career, Units, Term, Term Session, Course ID, Instruction Mode, Start Date, End Date, Role, Instructor ID, Instructor Last , Facility ID, Class Start Time, Class End Time, Class Days, Instructor Name, Instructor First NameID, Instructor EmailRole | - CLASS_TBL - Class Table Hierarchy Join - GRADECLASS_RSTRMTG_TYPE - Grade Roster Type PAT - Class Meeting Pattern Table Hierarchy Join - CLASS_INSTR_VW5 - Distinct Instructors for Class Hierarchy Join - EMAILCRSE_ADDRESSES - Email Addresses CATALOG - Course Catalog Data Hierarchy Join | Michael McGovernMcGovern | Edward AdamsDavid Christy | New Reportreport. | E Adams, C Keck, A Kamruzzaman, D Christy, P Ackerman, T. Lodhi | |||||||||||||||
CU_BAR_CM_0001400017 | Instructor Class ScheduleGrade Roster Detail | This is a listed listing of all classes for the term with enrollment and grades. Prompt on Institution, Term, Academic Group, Academic Organization (optional) and Subject (optional).classes assigned to an instructor. Prompt on Institution and Term. | Last Name, First Name, Middle Name, Empl ID, Empl Rcd#, Job Code, Job Description, Pay Status, Paid By, Work LoadAcad Group, Acad Org, Subject, Catalog, Section, Class Description, Component, Enrollment , Session, Room Cap, Enroll Cap, Enroll Total, SessionAcad Group, EmplidAcad Org, Last Name, First Name, Grade Career, Class Status, Start Date, End Date | - INSTR_TERM_DTL - Instructor Term Table Detail Hierarchy Join - NAMES_FERPA_VW - FERPA Names View Hierarchy Join -CLASS_TBL - Class Table Hierarchy Join UNION 1: -CLASS_TBL - Class Table Hierarchy Join -CLASS_INSTR_VW5 - Distinct Instructors for Class Hierarchy Join UNION 2: - CLASS_TBL - Class Table Table Hierarchy Join - CUJOBCODE_BIOTBL_VW - Biographical Information View Hierarchy Join Current Job Codes View Hierarchy Join | Michael McGovern | Christian KeckDavid Christy | New Reportreport. | C Keck, A Kamruzzaman, D Christy, P Ackerman, T. Lodhi | |||||||||||||||
CU_BAR_CM_0001500018 | Independent Study ClassesGrades Posted After Date | This is a listing by instructor of classes which have prompted grades posted after a prompted dateindependent study classes. Prompt on Instititution, Term, Grade Date and GradesInstitution and Term. | Instructor Last Name, Instructor First Name, Middle Name, Empl ID, Career, ProgramInstructor ID, Subject, Catalog, Section, Class Description, Component, Mode, Session, Acad Group, Subject, Catalog, Section, Session, Course Description, Units, Grade, Grade DtAcad Org, Career, Room Cap, Enroll Cap, Enroll Total, Start Date, End Date, Class Days, Mtg Start, Mtg End | - CLASS_TBL _SE_VW - Class Table Student Enrl View - Class Table Hierarchy Join - CLASS_INSTR_VW5 - Distinct Instructors for Class Hierarchy Join - CUCLASS_BIOMTG_VW - Biographical Information Class Meeting Pattern View Hierarchy Join | Michael McGovern | Arthur DowningDavid Christy | New report. | A Downing, C Keck, A Kamruzzaman, G HotkoD Christy, P Ackerman, T. Lodhi | |||||||||||||||
CU_BAR_CM_00015_100019 | WebWork Student EnrollmentGrades Posted After Date with course information | This is a listing of classes which have prompted grades posted after a prompted date. Added course number detail. Prompt on Instititution, Term, Grade Date and Grades.list of enrolled students in a class. Prompt on Institution, Term and Subject (optional). | Subject, Catalog, Class Description Last Name, First Name, Middle Name, Empl ID, Career, Program, Acad Group, Subject, Catalog, Section, Session, Course Description, Units, Grade, Grade Dt, Course Number Class Nbr, Last Name, First Name, Middle Name, Empl ID | - CLASS_TBL_SE_VW - Class Table Student Enrl View Hierarchy Join - CU_BIO_VW - Biographical Information View Hierarchy Join | Tabassum Lodhi / Michael McGovern | Gary Hotko | Modified Report | Patrick Ackerman | New report. | P Ackerman, C Keck, Gary Hotko, P AckermanA Kamruzzaman, T . Lodhi, D. Ramkaran | |||||||||||||
CU_BAR_CM_0001600020 | Units Attempted & PassedClass Detail Report | This is a listing of all active classes with enrollment numbers. Prompt on Institution, Term, Academic Organization (optional) and Subject (optional). | Acad Group, Acad Org, Subject, Catalog, Class Description, Class Section, Component, Room Cap, Enrl Cap, Enroll Total, Career, Units, Term, Term Session, Course ID, Instruction Mode, Start Date, End Date, Facility ID, Class Start Time, Class End Time, Class Days, Instructor Name, Instructor ID, Instructor Role | - CLASS_TBL - Class Table Hierarchy Join - CLASS_MTG_PAT - Class Meeting Pattern Table Hierarchy Join - CLASS_INSTR_VW5 - Distinct Instructors for Class Hierarchy Join - CRSE_CATALOG - Course Catalog Data Hierarchy Join | Michael McGovern | David Christy | total of attempted and passed credits by Academic Group and Academic Department. Prompt on Institution and Term. | Acad Group, Acad Org, Subject, Catalog, Section, Student Count, Total Bill Units, Counted Units | - STDNT_ENRL - Student Enrollment Table Hierarchy Join - CLASS_TBL - Class Table Hierarchy Join | Michael McGoverm | David Christy | New report.New report. | C Keck, A Kamruzzaman, D Christy, P Ackerman, T. Lodhi | ||||||||||
CU_BAR_CM_00017 | Instructor Class Schedule | _00021 | Honors Class Detail | This is a list of all honor classes (catalog ends in H) for the prompted term. Include the Subject, Catalog Nbr, Section, Enroll Total, Room Capacity, Meet Days, Start and End Time, Instructor Name, Term, Session, Academic Group and Academic OrganizationThis is a listing of classes assigned to an instructor. Prompt on Institution and Term. | Last Name, First Name, Middle Name, Empl ID, Empl Rcd#, Job Code, Job Description, Pay Status, Paid By, Work Load, Subject, Catalog, Section, Class Description, Component, Session, Room Cap, Enroll Cap, Enroll Total, Acad Group, Acad Org, Career, Class Status, Start Date, End Date | Acad Group, Acad Org, Subject, Catalog, Class Description, Section, Term, Class Status, Instruction Mode, Room Cap, Enrollment, Facility ID, Mtg Start, Mtg End, Class Days, Instructor Last Name, Instructor First Name | - - INSTR_TERM_DTL - Instructor Term Table Detail Hierarchy Join - NAMES_FERPA_VW - FERPA Names View Hierarchy Join - CLASS_TBL - Class Table Hierarchy Join - EMPLOYMENTCLASS_MTG_HOME - Vw-Home Employment/Job PAT - Class Meeting Pattern Table Hierarchy Join - JOBCODECLASS_TBLINSTR_VW - Current Job Codes View VW5 - Distinct Instructors for Class Hierarchy Join | Michael McGovern | David ChristyJody Vaisman | New report. | C Keck, A Kamruzzaman, D Christy, J Vaisman, N Aries, P Ackerman, T. Lodhi | ||||||||||||
CU_BAR_CM_00021_00018 | Independent Study Classes | 1 | Honors Class Detail | This is a list of all honor classes (catalog ends in H) for the prompted term. Include the Subject, Catalog Nbr, Section, Enroll Total, Room Capacity, Meet Days, Start and End Time, Instructor Name, Term, Session, Academic Group and Academic Organization and Instructor email AddressThis is a listing by instructor of independent study classes. Prompt on Institution and Term. | Instructor Last Name, Instructor First Name, Instructor ID, Acad Group, Acad Org, Subject, Catalog, Section, Class Description, ComponentSection, ModeTerm, Session, Acad Group, Acad Org, CareerClass Status, Instruction Mode, Room Cap, Enroll Cap, Enroll Total, Start Date, End DateEnrollment, Facility ID, Mtg Start, Mtg End, Class Days, Mtg Start, Mtg End, Instructor Last Name, Instructor First Name, Email | - CLASS_TBL - Class Table Hierarchy Join | Michael McGovern | David Christy | New report. | Abu Kamruzzaman | Jody Vaisman | Modified Report | C C Keck, A Kamruzzaman, D ChristyJ Vaisman, N Aries, P. Ackerman, T . Lodhi | ||||||||||
00019 | Honors Class Detail w/o duplicationWebWork Student Enrollment | This is a list of enrolled students in a class. Prompt on Institution, Term and Subject (optional). | Subject, Catalog, Class Description, Section, Session, Class Nbr, Last Name, First Name, Middle Name, Empl ID | - CLASS_TBL_SE_VW - Class Table Student Enrl View Hierarchy Join - CU_BIO_VW - Biographical Information View Hierarchy Join | Michael McGovern | Patrick Ackerman | New report. | P Ackerman, C Keck, A Kamruzzaman, T Lodhi | CU_BAR_CM_00020 | Units Attempted & Passed | This is a total of attempted and passed credits by Academic Group and Academic Departmentall honor classes (catalog ends in H) for the prompted term. Include the Subject, Catalog Nbr, Section, Enroll Total, Room Capacity, Meet Days, Start and End Time, Instructor Name, Term, Session, Academic Group and Academic Organization. Prompt on Institution and Term. | Acad Group, Acad Org, Subject, Catalog, Class Description, Section , Student Count, Total Bill Units, Counted Units | - STDNT_ENRL - Student Enrollment Table Hierarchy Join - CLASS_TBL - Class Table Hierarchy Join | Michael McGoverm | David Christy | New report. | , Term, Class Status, Instruction Mode, Room Cap, Enrollment, Facility ID, Mtg Start, Mtg End, Instructor Last Name, Instructor First Name, Email, Class Day
| CLASS_TBL - Class Table Hierarchy Join CLASS_MTG_PAT - Class Meeting Pattern Table Hierarchy Join CLASS_INSTR_VW5 - Distinct Instructors for Class Hierarchy Join CU_BIO_VIEW Hierarchy Join
| Tabassum Lodhi | Jodi Vaisman | Modified Report | P. C Keck, A Kamruzzaman, D Christy, P Ackerman, T. Lodhi | |
CU_BAR_CM_0002100022 | Cross-Listed/ Combined ClassesHonors Class Detail | This is a list listing of all honor classes (catalog ends in H) for the prompted term. Include the Subject, Catalog Nbr, Section, Enroll Total, Room Capacity, Meet Days, Start and End Time, Instructor Name, Term, Session, Academic Group and Academic Organization. Prompt on Institution and Term.Cross-Listed/Combined classes in the schedule. Prompt on Institution and Term. | Acad Group, Acad Org, Subject, Catalog, Section, Class Description, Class Nbr, Cap Enrl, Tot Enrl, Acad Group, Acad Org, Subject, Catalog, Section, Class Description, Section, Term, Class StatusNbr, Instruction Mode, Room Cap , Enrollment, Facility ID, Mtg Start, Mtg End, Class Days, Instructor Last Name, Instructor First NameEnrl, Tot Enrl | - CLASS_TBL - Class Table Hierarchy Join - CLASS_MTG_PAT TBL - Class Meeting Pattern Table Hierarchy Join- CLASS_INSTR_VW5 - Distinct Instructors for Class Hierarchy Join | Michael McGovern | Jody VaismanStephanie Govan | New report. | S Govan, C Keck, A Kamruzzaman, J Vaisman, N Aries, P Ackerman, T. Lodhi | |||||||||||||||
CU_BAR_CM_00021_1 | Honors Class Detail | 00023 | Dept Workload Totals | This This is a list of all honor classes (catalog ends in H) for the prompted term. Include the Subject, Catalog Nbr, Section, Enroll Total, Room Capacity, Meet Days, Start and End Time, Instructor Name, Term, Session, Academic Group and Academic Organization and Instructor email Address. students enrolled for specified term who are not permit in with Campus email listed. Prompt on Institution and Termterm.Acad Group, Acad Org, Subject, Catalog, Class Description, Section, Term, Class Status, Instruction Mode, Room Cap, Enrollment, Facility ID, Mtg Start, Mtg End, Class Days, Instructor Last Name, Instructor First Name, Email | DeptID, Department Name, Job Code, Job Description, Last Name, First Name, Middle Name, Empl ID, Total Class Units | - INSTR_TERM_DTL - Instructor Term Table Detail Hierarchy Join - CU_BIO_VW - Biographical Information View Hierarchy Join - CLASS_TBL - Class Table Hierarchy Join - CLASSDEPT_MTG_PAT - Class Meeting Pattern Table TBL - Departments Hierarchy Join - CLASSJOBCODE_INSTR_VW5 - Distinct Instructors for Class TBL - Job Codes Hierarchy Join - CU_BIO_VIEW CRSE_CATALOG - Course Catalog Data Hierarchy Join | Abu Kamruzzaman | Jody Vaisman | Modified Report | C Keck, A Kamruzzaman, J Vaisman, N Aries, P. Ackerman, T Lodhi | CU_BAR_CM_00022 | Cross-Listed/ Combined Classes | This is a listing of all Cross-Listed/Combined classes in the schedule. Prompt on Institution and Term. | Acad Group, Acad Org, Subject, Catalog, Section, Class Description, Class Nbr, Cap Enrl, Tot Enrl, Acad Group, Acad Org, Subject, Catalog, Section, Class Description, Class Nbr, Cap Enrl, Tot Enrl | - CLASS_TBL - Class Table Hierarchy Join - CLASS_TBL - Class Table Hierarchy Join | Michael McGovern | Stephanie Govan | New report. | UNION 1: -INSTR_TERM_DTL - Instructor Term Table Detail Hierarchy Join -CU_BIO_VW - Biographical Information View Hierarchy Join -JOB - EE Job History Hierarchy Join -JOBCODE_TBL - Job Codes Hierarchy Join -DEPT_TBL - Departments Hierarchy Join
| Michael McGovern | David Christy | New report. | C Keck, A Kamruzzaman, D ChristyS Govan, C Keck, A Kamruzzaman, P Ackerman, T. Lodhi |
Dept Workload TotalsDetail | This is a list of students enrolled for specified term who are not permit in with Campus email listed. detailed view by class or other assignment of the instructors' workload by the department. Prompt on Institution and termTerm. | DeptID, Department Name, Job Code, Job Description, Last Name, First Name, Middle Name, Empl ID, Total Class Units, Subject, Catalog, Class Description, Enrollment, Units, Work Load | - INSTR_TERM_DTL - Instructor Term Table Detail Hierarchy Join - CU_BIO_VW - Biographical Information View Hierarchy Join - CLASS_TBL - Class Table Hierarchy Join - JOB - EE Job History Hierarchy Join - DEPT_TBL - Departments Hierarchy Join - JOBCODE_TBL - Job Codes Hierarchy Join - CRSE_CATALOG - Course Catalog Data Hierarchy Join UNION 1: - INSTR_TERM_DTL - Instructor Term Table Detail Detail Hierarchy Join - CU_BIO_VW - Biographical Information View View Hierarchy Join - JOB - EE Job History History Hierarchy Join - JOBCODE_TBL - Job Codes Codes Hierarchy Join - DEPT_TBL - Departments Departments Hierarchy Join
| Michael McGovern | David Christy | New reportSame extract as CU_BAR_CM_00023 but more detail. | C Keck, A Kamruzzaman, D Christy, P Ackerman, T. Lodhi | ||||||||||||||||
CU_BAR_CM_00023_DTL00024 | Dept Class Workload Detailvs Credit Hrs | This is a detailed view by class or other assignment of the instructors' workload by the departmentan aggregate of class workload vs credit hours for the Institution. Prompt on Institution and Term. | Acad Group, DeptID, Department Name, Job Code, Job Description, Last Name, First Name, Middle Name, Empl ID, Total Class Units, Subject, Catalog, Class Description, Enrollment, Units, Work Load Total Credits, Total Workload | - INSTR_TERM_DTL - Instructor Term Table Detail Hierarchy Join - CU_BIO_VW - Biographical Information View Hierarchy Join - CLASS_TBL - Class Table Hierarchy Join - JOB - EE Job History Hierarchy Join - DEPT_TBL - Departments Hierarchy Join - JOBCODE_TBL - Job Codes Hierarchy Join - CRSE_CATALOG - Course Catalog Data Hierarchy Join UNION 1: - INSTR_TERM_DTL - Instructor Term Table Detail Hierarchy Join - CU_BIO_VW - Biographical Information View Hierarchy Join - JOB - EE Job History Hierarchy Join - JOBCODE_TBL - Job Codes Hierarchy Join | Michael McGovern | David Christy | New report. | C Keck, A Kamruzzaman, D Christy, P Ackerman, T. Lodhi | |||||||||||||||
CU_BAR_CM_00025 | Class Section Credit Totals | This is an aggregate of class sections by career and faculty rank. Prompt on Institution and Term. | Career, Subject, Catalog, Section Count, Total Credits | - CLASS_TBL - Class Table Hierarchy Join - CRSE_CATALOG - Course Catalog Data - DEPT_TBL - Departments Hierarchy Join | Michael McGovern | David Christy | Same extract as CU_BAR_CM_00023 but more detailNew report. | C Keck, A Kamruzzaman, D Christy, P Ackerman, T. Lodhi | |||||||||||||||
_00024 | Class Workload vs Credit Hrs | use CU_BAR_CM_00027 | CSTM 120 Student Enrollment | This is a list (count) of enrolled students in CSTM 120 class who have taken previously. Prompt This is an aggregate of class workload vs credit hours for the Institution. Prompt on Institution and Term. | Acad Group, DeptID, Department Name, Job Code, Job Description, Total Credits, Total Workload | - INSTR_TERM_DTL - Instructor Term Table Detail Hierarchy Join - CU_BIO_VW - Biographical Information View Hierarchy Join - CLASS_TBL - Class Table Hierarchy Join - JOB - EE Job History Hierarchy Join - DEPT_TBL - Departments Hierarchy Join - JOBCODE_TBL - Job Codes Hierarchy Join - CRSE_CATALOG - Course Catalog Data Hierarchy Join | Michael McGovern | David Christy | New report. | Empl ID, First Name, Middle Name, Last Name, Subject, Catalog, Class Description, Section, Session, Class Nbr, Acad Group, Previous Attempts (R, W, WU), Grade Dt | -CLASS_TBL_SE_VW - Class Table Student Enrl View Hierarchy Join | Tabassum Lodhi / Michael McGovern | Warren Gordon | New report | C Keck, A Kamruzzaman, D Christy, P Ackerman, T. Lodhi | ||||||||
CU_BAR_CM_0002500027 | Class Section Credit TotalsCSTM 120 and FSPM 121 Student Enrollment | This is an aggregate of class sections by career and faculty rank. Prompt a list (count) of enrolled students in CSTM 120 or FSPM 121 class who have taken previously. Prompt on Institution and Term. | CareerEmpl ID, First Name, Middle Name, Last Name, Course List (term, Subject, Catalog , Section Count, Total Credits number, section, grade - where previous attempts grade was R, W, WU, WN, FIN or INC), Count | -CLASS_TBL_SE_VW - Class Table Student Enrl View Hierarchy Join - CRSE_CATALOG - Course Catalog Data Hierarchy Join | Michael McGovern | David Christy | New report. | CU_BIO_VW - Biographical Information View Hierarchy Join STDNT_CAR_TERM - enrollment for specified term | Tabassum Lodhi | Warren Gordon | New Report | C Keck, A Kamruzzaman, D Christy, P Ackerman, T . Lodhi | |||||||||||
00026 | CSTM 120 and FSPM 121 Student Enrollment | This is a list (count) of enrolled students in CSTM 120 or FSPM 121 class who have taken previously . Prompt and with current enrollment of CSTM/FSPM. Prompt on Institution and Term. | Empl ID,First Name,Middle Name,Last Name,Subject,Catalog, Class Description, Section, Session, Class Nbr, Acad Group, Previous Attempts (R, W, WU), Grade DtPrevious Attempts,Previous Attempts Details | -CLASS_TBL_SE_VW - Class Table Student Enrl View Hierarchy Join STDNT_CAR_TERM - Student Career Term Table CU_BIO_VW - Biographical Information View CLASS_TBL_SE_VW - Class Table Student Enrl View SUBQUERY for Exist: CLASS_TBL_SE_VW - Class Table Student Enrl View SUBQUERY for Does Not Exist: Hierarchy Join
| Tabassum Lodhi / Michael McGovern | Warren Gordon | New reportModified Report | P Ackerman, T . Lodhi |