DARTS : FTE Enrollment Headcounts

Report Purpose

This FTE Enrollment Headcount report allows a comparison of actual versus budgeted credit hours. It was a Discoverer report recreated for Miriam White. The budgeted credit hours are represented by the BUDGET_CH field. This query now has required prompts in order to eliminate the need for the BUDGET_CH criteria to be updated every term with the most current budgeted credit hours.

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

  These reports does not reflect Inter-Institutional Cross-listed Courses:

1. UMS_DTS_ENROLL_CH_FTE_HEADCNT

2. UMS_DTS_ENROLL_CH_FTE_HCNT_ALL  - this version runs for any or all campuses and totals Headcount, Credit Hours, and FTE for each ( or all) campuses by Semester. There is no input for Budgeted Credit Hours in this second version. It is same as UMS_DTS_ENROLLMENT_SUMMARY on Enrollment Summaries with IS and OS Subtotals page. 
   
   This report reflects Inter-Institutional Cross-listed Courses. Due to the complexity of the logic, this query needs to be scheduled:

3. UMS_DTS_ENROLL_CH_FTE_HEAD_XL (replacement of #1 above)
   
   

Prompts Required

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

• Term
• Institution (or UM_INST_HOST for report #3)

The two below apply only to report 1 & 3.

• IN_STATE_BUDGET_CH
• OUT_OF_STATE_BUDGET_CH

Data Fields Generated

1 & 3

2.

Tables Used

• 1 & 2: UM_STUD_EXT_VW - Student Reporting Extract
• 3: UM_DLY_RPT_VW