Distance Education Report (Census)

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 the census date for the term.

Detailed Information

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 read the Cross-linked course definition page for more information.

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

Report Location

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

Report Name

Distance Education Report

Report Type

Power BI

Historically in SQR (UMDSTEDC.SQR)

Slicers

These fields are available for slicers. The slicers are located on the left-hand side of the report.

  • 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.

The report has 3 pages: All campus, One term, and Trend. The button function is located on the top right corner of the report to switch the page.

Data Source

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 the "Distance Education Course Coding - Current" page for the code.
Location UM_STD_ENR_C_VW

B.um_location_descr

 Please see the "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 the "Distance Education Course Coding - Current" page for the code.
Student Level UM_STUD_CENS_VW 

A.um_student_level

Please see the "Distance Education Course Coding - Current" page for the code.
In State/ Out of State UM_STUD_CENS_VW 

A.um_in_out

CASE WHEN A.RESIDENCY = 'MEONL' AND QB.RESIDENCY = 'IS' THEN 'In-State'
WHEN A.Residency = 'IS' THEN 'In-State'
ELSE 'Out-of-State'
END
(Alias A = UM_STUD_CENSUS and alias QB= RESIDENCY_OFF)
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 has been based on instruction mode. Please see the "Distance Education Course Coding - Current" page for the code.

Code Script

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. Below is the SQL code for the semantic model for Power BI.

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

Environment

  • PeopleSoft Campus Solutions Reporting (CSRPT)
  • Power BI
Print Article