DARTS : Maine Community College System Transfers Report

Report Purpose

This query provides data for the Maine Community College System (MCCS) Transfers Report that the System IR Office creates regularly as part of the UMS Data Book.

The data includes the academic plan, incoming credits, first-term credit hours, and GPA for enrolled students who transferred from the Maine Community College System (MCCS). The query also provides data for internal UMS transfers, external non-MCCS transfers, and first-time, first-year students for the 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

UMS_DTS_MCCS_TRANSFERS_REPORT 

Report Type

Query

Prompts Required

For information on field values to enter, click the name of the prompt.

• TERM: The IR Office usually uses the fall term that students enrolled and transferred for the first time.
• AS_OF_DATE - (YYYY-MM-DD) - The IR Office usually uses January 1 of the following fall term. That will give you the data for the end of the fall term, rather than at the census date.

Data Fields Generated

Tables Used

A. UM_STUD_EXT_VW - Student Reporting Extract

B. UM_STUD_EXT_ARC - Student Reporting Extract Arch

Criteria Used

• A.UM_FIRST_TIME= 'Y'
• A.UM_ADMIT_TYPE_DESC in ('Transfer Student','First-Time First-Year Student')
• B.ACAD_CAREER <> 'NCRD'
• B.ARCHIVE_FLAG= 'Y' OR B.CHANGE_FLG= 'Y'
• Used archived date logic in subquery