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 OrgSession, 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 Kamruzzaman, A 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 -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 typestypes Hierarchy Join DEPT_TBL - Departments Hierarchy Join UNION2:
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/ JobJob Hierarchy Join INSTR- NAME_ TERMCURR_ DTL - Instructor Term Table DetailVW - Current Name Vw all types Hierarchy Join CLASS_TBL - Class Table Hierarchy Join NAME_CURR- JOBCODE_TBL_VW - Current Name Vw all typesJob Codes View Hierarchy Join DEPT_TBL - Departments- 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, | A. Kamruzzaman,P Ackerman, T. Lodhi | ||||||||||||||
CU_BAR_CM_ | 00006IInvalid Instructor Departments00007 | Class Roster Detail | This is a list of | instructors, who are in invalid departmentsstudents in a class, including the class information, the students' name, emplid, program, plan(s) and contact information. Prompt on Institution, Term and | TermClass Number. | 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 | 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 | Michael McGovern | Abby Santana | New Report | A Santana, M Burgos, A Cox, C Keck, P Ackerman, T. Lodhi | |||||||
CU_BAR_CM_0000700008 | Class Roster DetailTally for New Students | This is a list of students in a class, including the class information, the students' name, emplid, program, plan(s) and contact information. classes for the term with the total number of new students enrolled. Prompt on Institution, Admit Term and Class Numberrange, Enrollment Term, Career (optional) and Admit Type (optional). | Acad group, Acad Org, Career, Subject, Catalog, Class Description, Session, Section, Session, Class Nbr, Component, Line#Class Sat, Tot Enrl, Emplid, Last Name, First Name, Middle Name, Campus EmailTotal New Enrl |
- CLASS_TBL_SE_VW - Class Table Student Enrl View View Hierarchy Join Sub Query for Exist: -CUACAD_BIO_VW - Biographical Information View Hierarchy Join PROG - Student Academic Program Hierarchy Join -EMAILADM_FERPAAPPL_VW - EMAIL FERPA VIEW Hierarchy Join -CLASS_TBL - Class Table Hierarchy DATA - Admission Application Data Hierarchy Join | Michael McGovern | Stephanie Govan | New Report | S Govan, A Kamruzzaman, C Keck, A Kamruzzaman, P Ackerman, T. Lodhi | |||||||||||||||
CU_BAR_CM_00008_DTL | Class Tally | for New StudentsDetail | This is a list of | classes for the term with the total number of new students enrolledclass student list for the prompted class. Prompt on Institution, | AdmitTerm | range, | Enrollment Term, Career (optional) and Admit Type (optional).Subject, Catalog and Section. | Acad group, Acad Org, Career, Subject, Catalog, Class Description, Session, Section,Class Nbr, Component, Class Sat, Tot Enrl, Total New Enrl- CLASS_TBL - Class Table Hierarchy Join, Tot Enrl, Empl ID, 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 JoinSub Query for Exist: - ACAD_PROG - Student Academic Program Program Hierarchy Join Join - ADM_APPL_DATA - Admission Application Data Data Hierarchy Join Join | Michael McGovern | Stephanie Govan | New Report | S Govan, C Keck, | AA Kamruzzaman, P Ackerman, T. Lodhi | |||||||||
CU_BAR_CM_ | 00008_DTL00009 | Class | TallyRoster Detail for SEEK | This is a list of | class student list for the prompted class.students in a class, including the class information, the students' name, emplid, class data, SEEK indicator and grades. Prompt on Institution, Term, Academic Org (optional), Subject (optional), Catalog Nbr (optional) and Section (optional). | Subject, Catalog, Class Description, Session, Section, Tot Enrl, Last Name, First Name, Middle Name, Empl ID, Acad Prog, Admit Term, Appl Nbr, Admit Type, Career, Career Nbr, Appl Nbr, Institution, StatusGrade, 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 View Hierarchy Join - ACAD_PROG - Student Academic Program Hierarchy Join - ADM_APPL_DATA - Admission Application Data Hierarchy Join | Michael McGovern | Stephanie Govan | New Report | 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 Morales | New Report for SEEK | M Morales, C Keck, | S Govan, C Keck,A Kamruzzaman, P Ackerman, T. Lodhi | |||||||
CU_BAR_CM_0000900010_2 | Class Roster Detail for SEEKw/Prerequisites | This is a detail list of students in a class, including the class information, the students' name, emplid, class data, SEEK indicator and gradesclasses for the institution and term. Prompt on Institution , Term, Academic Org (optional), Subject (optional), Catalog Nbr (optional) and Section (optional). | Subject, Catalog, Class Description, Session, Section, Last Name, First Name, Middle Name, Empl ID, Grade, Seek? | 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 - 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 MTG_PAT - Class Attribute Meeting Pattern Table Hierarchy Join UNION1: - CLASS_TBLINSTR_SE_VW - Class Table Student Enrl View VW5 - Distinct Instructors for Class 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 Morales | New Report for SEEK | - 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 LuM Morales, C Keck, A Kamruzzaman, P Ackerman, T. Lodhi | |||||||||
CU_BAR_CM_ | 0001000011_2 | Class | Detail wSchedule/ | PrerequisitesBook Report | This is a | detail listlisting of classes and their books for the | institution and termbookstore. Prompt on Institution | and Term, Term and Session (optional). | Acad Group, Acad Org, Subject, Catalog, Class Description, Section, Session Class#, SectionCareer, Class Stat, Instruction Mode, Status, Enroll. Cap, Total Enroll., Class Start Date, Class End Date, Room Cap, Enroll Cap, Enrollment, Seats Left, Designation Description, Units, Cntct Hrs, Pat Nbr, Facility ID, Mtg Start, Mtg EndMaterial 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, Rq Group, Long Description Email | - CLASS_TBL - Class Table Hierarchy Join - CLASS_ASSOC - Class Associations Hierarchy Join- RQMNT_DESIG_TBL - Requirement Designation 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 - CRSE_OFFER - Course Catalog Offerings Hierarchy Join - CRSE_CATALOG - Course Catalog Data Hierarchy Join - RQEMAIL_GRP_TBL - Requirement Group Table ADDRESSES - Email Addresses Hierarchy Join | Michael McGovern | Czarina ValenteChristian Keck | New | Reportreport, second revision. | C | ValenteKeck, A Downing, A Cox, | C Keck, J Tse, B Lu,P Ackerman, T. Lodhi | ||||||
CU_BAR_CM_00011_200012 | Class ScheduleDetail w/Book ReportEnrollment | This is a listing list of active classes and their books for the bookstorethe students enrolled in them. Prompt on Institution, Term and with optional prompts on Academic Group, Academic Organization (optional) and Session (optional). | Acad Group, Acad Org, Subject, Catalog, Class Description, SectionSession, SessionClass#, CareerSection, Class Status, Enroll. Cap, Total Enroll., Class Stat, Instruction Mode, Start Date, Class End Date, Material Type, Material Status, Material Title, ISBN, Author, Publisher, Edition, Published ,Price, Facil ID, Class Start Time, Class End TimeRoom 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, Instructor Student First Name, Student Middle Name, EmailStudent Email | - CLASS_TBL - Class Table Hierarchy Join - CLASS_TBL ASSOC - Class Table Associations Hierarchy Join - SSRRQMNT_CLSDESIG_TXB_DTL - Class Reserve Capacity 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 - EMAILCU_BIO_ADDRESSES - Email Addresses VW - Biographical Information View Hierarchy Join
| Michael McGovern | Christian Keck Keck | New report, second revision. | C Keck, A DowningKamruzzaman, A Cox,P Ackerman, T. Lodhi
| |||||||||||||||
CU_BAR_CM_0001200013_1 | Non-Posted Grade RostersClass Detail w/Enrollment | This is a list of active classes and the students enrolled in themall classes with non-posted grade rosters. Prompt on Institution, Term with optional prompts on Academic Group, and Academic Organization (optional) and Session (optional). | Acad Group, Acad Org, Subject, Catalog, Class Description, Session, Class#Descr, 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 Nbr, Tot Enrl, Start Date, End Date, Role, Instructor ID, Instructor Last Name, Instructor First Name, 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 UNION1: -CLASS_TBL - Class Table Hierarchy Join -STDNT_ENRL - Student Enrollment Table for Class Hierarchy Join - CUEMAIL_BIO_VW - Biographical Information View ADDRESSES - Email Addresses Hierarchy Join
| Michael McGovern | Christian KeckEdward Adams | New report.Report | E Adams, C Keck, A Kamruzzaman, P Ackerman, T. Lodhi
| |||||||||||||||
CU_BAR_CM_00013_100014 | Grade Roster DetailNon-Posted Grade Rosters | This is a list listed of all classes with non-posted grade rostersfor the term with enrollment and grades. Prompt on Institution, Term and , Academic Group, Academic Organization (optional) and Subject (optional). | Acad Group, Acad Org, Subject, Catalog, Descr, Section, Class Nbr, Tot Enrl, Start Date, End Date, Role, Instructor ID, Instructor Description, Component, Enrollment Total, Session, Emplid, Last Name, Instructor First Name, Instructor EmailGrade | -CLASS_TBL - Class Table Hierarchy Join Hierarchy Join UNION 1: - GRADECLASS_RSTR_TYPE - Grade Roster Type Hierarchy TBL - Class Table 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 | Edward AdamsChristian Keck | New Report | E Adams, C Keck, A Kamruzzaman, P Ackerman, T. Lodhi | |||||||||||||||
CU_BAR_CM_0001400015 | Grades Posted After DateGrade Roster Detail | This is a listed listing of all classes for the term with enrollment and gradesclasses which have prompted grades posted after a prompted date. Prompt on InstitutionInstititution, Term, Academic Group, Academic Organization (optional) and Subject (optional).Grade Date and Grades. | Last Name, First Name, Middle Name, Empl ID, Career, Program, Acad Group, Acad Group, Acad Org, Subject, Catalog, Section, Class Description, Component, Enrollment Total, Session, EmplidCourse Description, Last NameUnits, First NameGrade, Grade Grade Dt | -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 Hierarchy Join -STDNT_ENRL - Student Enrollment Table _SE_VW - Class Table Student Enrl View Hierarchy Join - CU_BIO_VW - Biographical Information View View Hierarchy Join Join | Michael McGovern | Christian KeckArthur Downing | New Reportreport. | A Downing, C Keck, A KamruzzamanKamruzzaman, 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. Prompt . Added course number detail. Prompt on Instititution, Term, Grade Date and Grades. | Last 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 Hierarchy Join - CU_BIO_VW - Biographical Information View Hierarchy Join | Tabassum Lodhi / Michael McGovern | Arthur Downing | New report. | Gary Hotko | Modified Report | A Downing, C Keck, A Kamruzzaman, G Gary Hotko, P Ackerman, T. Lodhi, D. Ramkaran | |||||||||||||
CU_BAR_CM_00015_100016 | Class Detail Report 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 Hierarchy Join - CU_BIO_VW - Biographical Information View Hierarchy Join | Tabassum Lodhi / Michael McGovern | Gary Hotko | Modified Report | 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 | New report. | C Keck, A Kamruzzaman, D ChristyC Keck, Gary Hotko, P Ackerman, T. Lodhi, D. Ramkaran | |||||||||
CU_BAR_CM_0001600017 | Instructor Class Detail Report Schedule | This is a listing of all active classes with enrollment numbersclasses assigned to an instructor. Prompt on Institution , Term, Academic Organization (optional) and Subject (optional). 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, Class SectionComponent, ComponentSession, Room Cap, Enrl Enroll Cap, Enroll Total, CareerAcad Group, UnitsAcad Org, 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 Career, Class Status, Start Date, End Date | - INSTR_TERM_DTL - Instructor Term Table Detail Hierarchy Join - NAMES_FERPA_VW - FERPA Names View - CLASS_TBL - Class Table Hierarchy Join - CLASS_MTG_PAT TBL - Class Meeting Pattern Table Hierarchy Join - CRSEJOBCODE_TBL_CATALOG - Course Catalog Data VW - Current Job Codes View Hierarchy Join | Michael McGovern McGovern | David Christy Christy | New report. | C Keck, A Kamruzzaman, D Christy, P Ackerman, T. Lodhi | |||||||||||||||
CU_BAR_CM_0001700018 | Independent Study ClassesInstructor Class Schedule | This is a listing by instructor of independent study classes assigned to an instructor. Prompt on Institution and Term. | Instructor Last Name, Instructor First Name, Middle Name, Empl ID, Empl Rcd#, Job Code, Job Description, Pay Status, Paid By, Work Load, Subject, Catalog, Section, Class Description, Component, SessionInstructor ID, Subject, Catalog, Section, Class Description, Component, Mode, Session, Acad Group, Acad Org, Career, Room Cap, Enroll Cap, Enroll Total, Acad Group, Acad Org, Career, Class Status, Start Date, End Date - INSTR_TERM_DTL - Instructor Term Table Detail Hierarchy Join - NAMES_FERPA_VW - FERPA Names View Hierarchy JoinStart Date, End Date, Class Days, Mtg Start, Mtg End | - CLASS_TBL - Class Table Hierarchy Join - EMPLOYMENTCLASS_INSTR_HOME - Vw-Home Employment/Job VW5 - Distinct Instructors for Class Hierarchy Join - JOBCODECLASS_TBLMTG_VW - Current Job Codes Class Meeting Pattern View Hierarchy Join | Michael McGovern | David Christy | New report. | C Keck, A Kamruzzaman, D Christy, P Ackerman, T. Lodhi | |||||||||||||||
CU_BAR_CM_0001800019 | WebWork Student EnrollmentIndependent Study Classes | This is a listing by instructor of independent study classeslist of enrolled students in a class. Prompt on Institution and Term., Term and Subject (optional). | Instructor Last Name, Instructor First Name, Instructor ID, Subject, Catalog, Section, Class Description, ComponentSection, Mode, Session, Acad Group, Acad Org, Career, Room Cap, Enroll Cap, Enroll Total, Start Date, End Date, Class Days, Mtg Start, Mtg EndClass Nbr, Last Name, First Name, Middle Name, Empl ID | - CLASS_TBL - Class Table Hierarchy Join- CLASS_INSTR_VW5 - Distinct Instructors for Class _SE_VW - Class Table Student Enrl View Hierarchy Join - CLASSCU_MTGBIO_VW - Class Meeting Pattern Biographical Information View Hierarchy Join | Michael McGovern | David ChristyPatrick Ackerman | New report. | P Ackerman, C Keck, A Kamruzzaman, D Christy, P Ackerman, T . Lodhi | |||||||||||||||
CU_BAR_CM_0001900020 | Units Attempted & PassedWebWork Student Enrollment | This is a list of enrolled students in a classtotal of attempted and passed credits by Academic Group and Academic Department. Prompt on Institution , and Term and Subject (optional). | Acad Group, Acad Org, Subject, Catalog, Class Description, Section, Session, Class Nbr, Last Name, First Name, Middle Name, Empl IDStudent Count, Total Bill Units, Counted Units | - STDNT_ENRL - Student Enrollment Table - CLASS_TBL_SE_VW - Class Table Student Enrl View Hierarchy Join - CUCLASS_BIO_VW - Biographical Information View TBL - Class Table Hierarchy Join | Michael McGovernMcGoverm | Patrick AckermanDavid Christy | New report. | P Ackerman, C Keck, A Kamruzzaman, D Christy, P Ackerman, T. Lodhi | |||||||||||||||
CU_BAR_CM_0002000021 | Honors Class DetailUnits Attempted & Passed | This is a total of attempted and passed credits by 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 DepartmentOrganization. Prompt on Institution and Term. | Acad Group, Acad Org, Subject, Catalog, Section, Student Count, Total Bill Units, Counted Units | 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 | - CLASS_TBL - Class - STDNT_ENRL - Student Enrollment Table Hierarchy Join - CLASS_TBL MTG_PAT - Class Meeting Pattern Table Hierarchy Join | Michael McGoverm | - CLASS_INSTR_VW5 - Distinct Instructors for Class Hierarchy Join | Michael McGovern | Jody VaismanDavid Christy | New report. | C Keck, A Kamruzzaman, D ChristyJ Vaisman, N Aries, P Ackerman, T. Lodhi | ||||||||||||
CU_BAR_CM_00021_1 | Honors Honors Class Detail | 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. Prompt on Institution and Term. | 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 | - CLASS_TBL - Class Table Hierarchy Join | Michael McGovern Abu Kamruzzaman | Jody Jody Vaisman | New report. | Modified Report | C C Keck, A Kamruzzaman, J Vaisman, N Aries, P. Ackerman, T . Lodhi | ||||||||||||||
1 | Honors Honors Class Detail w/o duplication | 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. Prompt on Institution and Term. | 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, Class Day
| - CLASS_TBL - Class Table Table Hierarchy Join - CLASS_MTG_PAT - Class Meeting Pattern Table Table Hierarchy Join - CLASS_INSTR_VW5 - Distinct Instructors for Class Class Hierarchy Join - CU_BIO_VIEW VIEW Hierarchy Join | Abu Kamruzzaman |
| Tabassum Lodhi | Jodi Jody Vaisman | Modified Modified Report | C Keck, A Kamruzzaman, J Vaisman, N Aries, P. Ackerman, T. Lodhi | |||||||||||||
CU_BAR_CM_00021_200022 | Cross-Listed/ Combined ClassesHonors Class Detail w/o duplication | 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. | Acad Group, Acad Org, Subject, Catalog, Class Description, Section, 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. 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. | 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. | S Govan, C Keck, A Kamruzzaman, P Ackerman, T. Lodhi |
CU_BAR_CM_00023 | Dept Workload Totals | This is a list of students enrolled for specified term who are not permit in with Campus email listed. Prompt on Institution and term. | 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 - 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 -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. | 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 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 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 _CATALOG - Course Catalog Data 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 | |||||||||||||||
CU_BAR_CM_0002400025 | Class Workload vs Section Credit HrsTotals | This is an aggregate of class workload vs credit hours for the Institutionsections by career and faculty rank. 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 JoinCareer, Subject, Catalog, Section Count, Total Credits | - 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. | C Keck, A Kamruzzaman, D Christy, P Ackerman, T. Lodhi | ||||||||||||||
use CU_BAR_CM_ 00025 | Class Section Credit Totals | 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 sections by career and faculty rank. Prompt on Institution and Term. | CareerEmpl ID, First Name, Middle Name, Last Name, Subject, Catalog, Section Count, Total Credits 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 - CRSE_CATALOG - Course Catalog Data Hierarchy Join | Michael McGovern | David Christy | New report. |
| Tabassum Lodhi / Michael McGovern | Warren Gordon | New report | C Keck, A Kamruzzaman, D Christy, P Ackerman, T. Lodhi | ||||||||||
CU_BAR_CM_00026use CU_BAR_CM_00027 | 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 on Institution and Term. | Empl ID, First Name, Middle Name, Last Name, Course List (term, Subject, Catalog number, Class Description, Section, Session, Class Nbr, Acad Group, Previous Attempts (section, grade - where previous attempts grade was R, W, WU, WN, FIN or INC), Grade DtCount | -CLASS_TBL_SE_VW - Class Table Student Enrl View Hierarchy Join -CU_BIO_VW - Biographical Information View Hierarchy Join-CLASS STDNT_TBLCAR_SE_VW - Class Table Student Enrl View Hierarchy JoinTERM - enrollment for specified term | Tabassum Lodhi / Michael McGovern | Warren Gordon | New reportReport | P Ackerman, T . Lodhi | |||||||||||||||
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, Course List (term,Subject,Catalog number, section, grade - where previous attempts grade was R, W, WU, WN, FIN or INC), CountSection,Previous 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 Hierarchy JoinSTDNT_CAR_TERM - enrollment for specified term 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: CLASS_TBL_SE_VW - Class Table Student Enrl View
| Tabassum Lodhi | Warren Gordon | New Modified Report | P Ackerman, T Lodhi |