DARTS : Student Summary Report (Census)

Report Purpose

This report returns student's headcount, credit hours and FTE by student's residency, student's level, full-time/part-time status, term and institution as of census date.

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 Summary Report

Report Type

Power BI

(Historically in SQR)

Slicers

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

Term
Campus (institution)
In/ out (in-state/ out-of-state)
Career
Cross-listed course hours : Choose (Blank) value to see the cross-listed hours produced by students at other institutions. Choose '1' to see non-cross listed course hours. Select All for official campus summaries. Since the headcount and FTE from cross-listed courses are counted at student's home institution, the "count" and "FTE" will not be shown when Blank value on this slicer is selected.
Sex
Ethnicity
Acad Program

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.

Data Fields Generated

Data Source

Field on report	Table (view) used	Field used from table or Calculation (alias A= UM_CNS_RPT_VW)	Important Remarks
LEVEL_GROUP	UM_CNS_RPT_VW	Case when A.um_degree_nondeg= 'Non-Degree' and A.ACAD_LEVEL_BOT in ('02','10','20','30','40','50') then 'Non-Degree Assoc-Bacc' when A.LEVEL_LOAD_RULE in ('UG2YR', 'UGAS', 'AA', 'UGA') then 'Associate' when A.ACAD_LEVEL_BOT in ('GR', 'MAS', 'PHD') then 'Graduate' when A.ACAD_LEVEL_BOT in ('L1', 'L2', 'L3') then 'Law' else 'Baccalaureate' end
ACADEMIC_LEVEL (1st Year, 2nd Year, etc.)	UM_CNS_RPT_VW	Case when A.ACAD_LEVEL_BOT in ('GR', 'MAS', 'PHD') and A.um_degree_nondeg= 'Non-Degree' then 'Graduate Non-Degree' when A.ACAD_LEVEL_BOT in ('L1', 'L2', 'L3') and A.um_degree_nondeg= 'Non-Degree' then 'Law Non-degree' when A.ACAD_LEVEL_BOT in ('10','01', 'L1') then '1st Year' when A.ACAD_LEVEL_BOT in ('20','02', 'L2') then '2nd Year' when A.ACAD_LEVEL_BOT in ('30','03', 'L3') then '3rd Year' when A.ACAD_LEVEL_BOT in ('40','04') then '4th Year' when A.ACAD_LEVEL_BOT in ('50') then '5th Year' when A.ACAD_LEVEL_BOT in ('GR', 'MAS', 'PHD') then 'Graduate' when A.ACAD_LEVEL_BOT <> ' ' then '1st Year' else 'Error' end
Full-time / Part-time	UM_CNS_RPT_VW	UM_FULL_PART	The Alias B is UM_STUD_EXTRACT. `CASE` `WHEN` `B.Acad_Level_Bot =` `'GR'` `AND` `B.Um_Unt_Tak_Prg_Rc >= 6` `THEN` `'Full-Time'` `WHEN` `B.Acad_Level_Bot =` `'MAS'` `AND` `B.Um_Unt_Tak_Prg_Rc >= 6` `THEN` `'Full-Time'` `WHEN` `B.Acad_Level_Bot =` `'PHD'` `AND` `B.Um_Unt_Tak_Prg_Rc >= 6` `THEN` `'Full-Time'` `WHEN` `B.Um_Unt_Tak_Prg_Rc >= 12` `THEN` `'Full-Time'` `ELSE` `'Part-Time'` `END`
# (COUNT)	UM_CNS_RPT_VW	HEADCOUNT	The headcount from cross-listed courses are counted at student's home institution.
CREDITS	UM_CNS_RPT_VW	UNT_PRGRSS
FTE	UM_CNS_RPT_VW	FTE	The FTE from cross-listed courses are counted at student's home institution.
IN_OUT	UM_CNS_RPT_VW	UM_IN_OUT	The Alias B is UM_STUD_EXTRACT. (B.Residency is tuition residency from RESIDENCY_OFF table.) The alias QB is RESIDENCY_OFF table. (QB.Residency is residency.) CASE WHEN B.RESIDENCY = 'MEONL' AND QB.RESIDENCY = 'IS' THEN 'In-State' WHEN B.Residency = 'IS' THEN 'In-State' ELSE 'Out-of-State' END
ETHNICITY	UM_CNS_RPT_VW	UM_ETHNIC_GRP_DESC	Followed IPEDS definition
Sex	UM_CNS_RPT_VW	Case when A.SEX ='M' then 'Male' when A.SEX ='F' then 'Female' else 'Unknown' end