DARTS : Multiple Term Report

Report Purpose

In-state and out-of-state student count and credit count data, summarized by un-duplicated student IDs over three terms (as of census day). Results are further divided by academic career, and other fields. The data from the first term was chosen to un-duplicate students when students enrolled multiple terms.

The FTE is sum of all terms. The FTE is calculated based on the term FTE, and it is not annualized FTE.

The IPEDS 12-month Enrollment Report is similar to this report, however, the report is based on dates between July 1 and June 30.

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.

Report Location

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

Report Name

Student Multiple Term Report

Report Type

Power BI

Historically in SQR (UNSTUMLT.SQR)

Slicers

These fields are available for slicers. For information on field values to enter, click the name of the slicer.

Campus (institution)
In/ out (in-state/ out-of-state)
Career
Acad Program
Sex
Ethnicity

HELP IS AT HAND!

Round, red help button. Click to email DARTS.

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.

JIRA Reference: REPORT-406 - Multi term reports (SQR) Closed

Data Fields Generated

Below is a sample report. The three terms are fixed. If you would like to get other terms, please contact us at DARTS@maine.edu

SQL code

SQL for multiple term report

SELECT 
D.INSTITUTION,
D.UM_INST_HOST,
D.UM_HOST_DESCR,
D.UM_HOST_DESCRSHORT as campus,
D.EMPLID,
D.SEX as Gender,
D.UM_ETHNIC_GRP_DESC as Ethnicity,
D.UM_IN_OUT,
D.ACAD_CAREER as Career,
D.ACAD_PROG_PRIMARY as Acad_Prog,
D.TERM_DESCR30 as Term,
D.UNT_PRGRSS as Credits,
D.FTE, 
D.UM_FULL_PART as FT_PT,
D.HEADCOUNT,
D.STRM1,
D.STRM2,
D.STRM3,
(Case 
when D.ACAD_LEVEL_BOT in ('GR', 'MAS', 'PHD') and D.UM_DEGREE_NONDEG= 'Non-Degree' then 'Graduate Non-Degree'
when D.ACAD_LEVEL_BOT in ('10','01', 'L1') then '1st Year'
when D.ACAD_LEVEL_BOT in ('20','02', 'L2') then '2nd Year'
when D.ACAD_LEVEL_BOT in ('30','03', 'L3') then '3rd Year'
when D.ACAD_LEVEL_BOT in ('40','04') then '4th Year' 
when D.ACAD_LEVEL_BOT in ('50') then '5th Year' 
when D.ACAD_LEVEL_BOT in ('GR', 'MAS', 'PHD') then 'Graduate' 
when D.ACAD_LEVEL_BOT <> ' ' then '1st Year'   
else 'Error'
end) as Academic_level,
(Case 
when D.UM_DEGREE_NONDEG= 'Non-Degree' and D.ACAD_LEVEL_BOT in ('02','10','20','30','40','50')
  then 'Non-Degree Assoc+Bacc'
when D.LEVEL_LOAD_RULE in ('UG2YR', 'UGAS', 'AA', 'UGA') then 'Associate'
when D.ACAD_LEVEL_BOT in ('GR', 'MAS', 'PHD') then 'Graduate' 
when D.ACAD_LEVEL_BOT in ('L1', 'L2', 'L3') then 'Law' 
else 'Baccalaureate'
end) as Level_group, 
(Case 
when D.UM_DEGREE_NONDEG= 'Non-Degree' and D.ACAD_LEVEL_BOT in ('02','10','20','30','40','50')
  then 3
when D.LEVEL_LOAD_RULE in ('UG2YR', 'UGAS', 'AA', 'UGA') then 1
when D.ACAD_LEVEL_BOT in ('GR', 'MAS', 'PHD') then 4
when D.ACAD_LEVEL_BOT in ('L1', 'L2', 'L3') then 5 
else 2
end) as Level_group_sort, 
case when D.strm = 
         ( select min(cxb.strm) from sysadm.ps_um_stud_census cxb 
                where cxb.emplid = D.emplid and cxb.institution = D.institution  
                and cxb.strm in ('2210','2120','2130')--$input_term1,$input_term2,$input_term3) 
                and cxb.row_check = 'Y' and cxb.acad_career <> 'NCRD'
                  ) and D.INSTITUTION = D.UM_INST_HOST
            then 1 else 0 end as cmoo
             
FROM
(SELECT 
A.INSTITUTION,
A.UM_INST_HOST,
A.UM_HOST_DESCR,
A.UM_HOST_DESCRSHORT,
A.EMPLID,
A.SEX,
A.UM_ETHNIC_GRP_DESC,
A.UM_IN_OUT,
A.ACAD_CAREER,
A.ACAD_PROG_PRIMARY,
A.TERM_DESCR30,
A.UM_ACAD_PROG_P_END,
A.ACAD_LEVEL_BOT,
A.LEVEL_LOAD_RULE,
A.UNT_PRGRSS,
A.FTE, 
A.UM_FULL_PART,
A.HEADCOUNT,
A.STRM,
A.STRM AS STRM1,
'0000' AS STRM2,
'0000' AS STRM3,
A.ACAD_PLAN,
A.UM_DEGREE_NONDEG
FROM sysadm.ps_um_cns_rpt_vw A
WHERE A.strm = '2210'

UNION
SELECT
B.INSTITUTION,
B.UM_INST_HOST,
B.UM_HOST_DESCR,
B.UM_HOST_DESCRSHORT,
B.EMPLID,
B.SEX,
B.UM_ETHNIC_GRP_DESC,
B.UM_IN_OUT,
B.ACAD_CAREER,
B.ACAD_PROG_PRIMARY,
B.TERM_DESCR30,
B.UM_ACAD_PROG_P_END,
B.ACAD_LEVEL_BOT,
B.LEVEL_LOAD_RULE,
B.UNT_PRGRSS,
B.FTE, 
B.UM_FULL_PART,
B.HEADCOUNT,
B.STRM,
'0000', 
B.STRM,
'0000', 
B.ACAD_PLAN,
B.UM_DEGREE_NONDEG
FROM sysadm.ps_um_cns_rpt_vw B
WHERE B.strm = '2120'

UNION
SELECT
C.INSTITUTION,
C.UM_INST_HOST,
C.UM_HOST_DESCR,
C.UM_HOST_DESCRSHORT,
C.EMPLID,
C.SEX,
C.UM_ETHNIC_GRP_DESC,
C.UM_IN_OUT,
C.ACAD_CAREER,
C.ACAD_PROG_PRIMARY,
C.TERM_DESCR30,
C.UM_ACAD_PROG_P_END,
C.ACAD_LEVEL_BOT,
C.LEVEL_LOAD_RULE,
C.UNT_PRGRSS,
C.FTE, 
C.UM_FULL_PART,
C.HEADCOUNT,
C.STRM,
'0000', 
'0000',
C.STRM,
C.ACAD_PLAN,
C.UM_DEGREE_NONDEG
FROM sysadm.ps_um_cns_rpt_vw C
WHERE C.strm = '2130'
) D