Report Purpose

This report is about distance learning. It returns credit hours, course enrollment, and FTE. It can be run by term, institution, and other characteristics, such as region, location, class delivery mode, student level and residency. The data is as of census date for the term.

As of October 15, 2019 (fall 2019 Census) the credit hour calculation is being updated to reflect the changes required by the intra-institutional cross-listed course proposal. Please click here for the Cross-listed Course proposal, and click here for the most recent definition and reporting information.

In Summer 2021, instruction mode for courses was reviewed for accuracy and modified. All distance education related field is documented on "Distance Education Course Coding - Current" page.

Report Location

Power BI App (Census-DSIT-Reports). Please contact us at DARTS@maine.edu for requesting new access.

Report Name

Distance Education Report

Report Type

Power BI

Historically in SQR (UMDSTEDC.SQR)

Slicers

These fields are available for slicers.

Term
Institution
Semester (Fall/ Spring / Summer)

This report also has a choice of data category. When you choose the field on the slicer, the category will change on the visual.

HELP IS AT HAND!

Link to compose email for help with website.

Question, comment, critique? We are here to help and we strive to make our site a comprehensive, user friendly experience. Contact us at DARTS@maine.edu.

Sample Report

Data Source

The Credit hours are calculated based on the host institution of the course, and FTE, course enrollment, and students' demographic are based on students' home institution.

Code for the table on dataset

select 
x.strm,
x.institution,
x.um_dist_class,
x.um_class_dlv_mode,
x.um_in_out,
x.um_region,
x.um_site_category,
x.um_location_descr,
x.um_student_level,
x.um_stud_level_sort,
SUM(x.headcount),
SUM(x.FTE) as FTE,
SUM(x.Credits) 
from
(select
b.strm,
b.institution,
b.um_dist_class,
b.um_class_dlv_mode,
a.um_in_out,
b.um_region,
b.um_site_category,
b.um_location_descr,
a.um_student_level,
a.um_stud_level_sort,
COUNT(Distinct A.EMPLID) as headcount,
sum(B.UNT_PRGRSS / A.UM_FTE_DIVISOR) as FTE,
0  as Credits
FROM sysadm.PS_UM_STD_ENR_C_VW B
join sysadm.PS_UM_STUD_CENS_VW A on A.EMPLID = B.EMPLID AND A.INSTITUTION = B.INSTITUTION AND A.STRM = B.STRM
WHERE B.STRM >= 1910
GROUP BY b.strm, b.institution, b.um_dist_class, b.um_class_dlv_mode, a.um_in_out, b.um_region, b.um_site_category, b.um_location_descr, a.um_student_level, a.um_stud_level_sort

union

select 
b1.strm,     
b1.um_inst_host,
b1.um_dist_class,
b1.um_class_dlv_mode,
a1.um_in_out,
b1.um_region,
b1.um_site_category,
b1.um_location_descr,
a1.um_student_level,
a1.um_stud_level_sort,
0,
0,
sum(B1.UNT_PRGRSS) as Credits
FROM sysadm.PS_UM_STD_ENR_C_VW B1
join sysadm.PS_UM_STUD_CENS_VW A1 on A1.EMPLID = B1.EMPLID AND A1.INSTITUTION = B1.INSTITUTION AND A1.STRM = B1.STRM
WHERE B1.STRM >= 1910
GROUP BY b1.strm, b1.um_inst_host, b1.um_dist_class, b1.um_class_dlv_mode, a1.um_in_out, b1.um_region,
 b1.um_site_category, b1.um_location_descr, a1.um_student_level, a1.um_stud_level_sort) x
 
GROUP BY 
x.strm,
x.institution,
x.um_dist_class,
x.um_class_dlv_mode,
x.um_in_out,
x.um_region,
x.um_site_category,
x.um_location_descr,
x.um_student_level,
x.um_stud_level_sort

Field on report	Table (view) used	Field used from table or Calculation (alias A= UM_STUD_CENS_VW and B = UM_STD_ENR_C_VW)	Important Remarks
Term	UM_STD_ENR_C_VW	B.STRM
Institution	UM_STD_ENR_C_VW	B.institution
Region	UM_STD_ENR_C_VW	B.um_region	Please see "Distance Education Course Coding - Current" page for the code.
Location	UM_STD_ENR_C_VW	B.um_location_descr	Please see "Distance Education Course Coding - Current" page for the code.
Delivery Mode	UM_STD_ENR_C_VW	B.um_class_dlv_mode	It is based on instruction mode. Please see "Distance Education Course Coding - Current" page for the code.
Student Level	UM_STUD_CENS_VW	A.um_student_level	Please go to Degree/Non-Degree Coding - Current page for the code.
In State/ Out of State	UM_STUD_CENS_VW	A.um_in_out	`(Alias A = UM_STUD_CENSUS and alias QB= RESIDENCY_OFF)` `CASE` `WHEN` `A.RESIDENCY =` `'MEONL'` `AND` `QB.RESIDENCY =` `'IS'` `THEN` `'In-State'` `WHEN` `A.Residency =` `'IS'` `THEN` `'In-State'` `ELSE` `'Out-of-State'` `END`
Credit Hours	UM_STD_ENR_C_VW	SUM(B.UNT_PRGRSS)	Based on UM_INST_HOST
Course Enrollment Count	UM_STD_ENR_C_VW	COUNT(Distinct A.EMPLID)
FTE	UM_STD_ENR_C_VW	sum(B.UNT_PRGRSS / A.UM_FTE_DIVISOR)
Distance Ed	UM_STD_ENR_C_VW	B.um_dist_class	Since Summer 2021, it is based on instruction mode. Please see "Distance Education Course Coding - Current" page for the code.

DARTS : Distance Education Report (Census)