DARTS : Class Section List - Delaware Study

Report Purpose

This report is a data dump used for the Delaware Study by University of Southern Maine and system Institutional Research. The report returns a large amount of information about all courses as well as instructor information for any given institution and term. 

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

This report does not reflect Inter-Institutional Cross-listed Courses: UMS_DTS_CLASS_SEC_LIST_DEL

This report reflects Inter-Institutional Cross-listed Courses: UMS_DTS_CLASS_SEC_LIST_DEL_XL

Report Type

Query

Prompts Required

• Term
• Institution (For UMS_DTS_CLASS_SEC_LIST_DEL_XL, use INST_HOST (host institution))

Data Fields Generated

UMS_DTS_CLASS_SEC_LIST_DEL:

UMS_DTS_CLASS_SEC_LIST_DEL_XL:

Tables Used

UMS_DTS_CLASS_SEC_LIST_DEL:

• UM_CLSS_SCH_FCL - Class Schedule and Facility Vw
• UM_STD_ENR_CENS - Student Course Census Table
• CLASS_MTG_PAT - Class Meeting Pattern Table
• TERM_VAL_TBL - Term Value Table

UMS_DTS_CLASS_SEC_LIST_DEL_XL:

• UM_CLSS_SCH_FCL - Class Schedule and Facility Vw

• UM_STD_ENR_C_VW - Student Enrollment Table

• TERM_VAL_TBL - Term Value Table

• STDNT_ENRL - Student Enrollment Table