DARTS : Tuition Report

Report Purpose

This report returns student's tuition amount, credit hours and headcount by student's tuition residency, student's level, full-time/part-time status, term and institution.

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

Report Type

Power BI

Historically in SQR (UMSTUTUI.SQR)

Slicers

Click slicer on the left column of the report. The title of table changes as slicer changes. (It works when only one term is selected.)

JIRA Reference:

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 Source

All of the fields are from Census dataset which is based on UM_CNS_RPT_VW.

Field on report	Table (view) used	Field used from table or Calculation (alias A= UM_CNS_RPT_VW)	Important Remarks
ACADEMIC_LEVEL	UM_CNS_RPT_VW	Case when A.um_degree_nondeg= 'Non-Degree' then 'Non-Degree' when A.LEVEL_LOAD_RULE in ('UG2YR', 'UGAS', 'AA', 'UGA') then 'Associate' when A.ACAD_LEVEL_BOT in ('10','01') then 'Freshman' when A.ACAD_LEVEL_BOT in ('20','02') then 'Sophomore' when A.ACAD_LEVEL_BOT in ('30','03') then 'Junior' when A.ACAD_LEVEL_BOT in ('40','04') then 'Senior' when A.ACAD_LEVEL_BOT in ('50','05') then '5th Year' when A.ACAD_LEVEL_BOT in ('GR', 'MAS', 'PHD') then 'Graduate' when A.ACAD_LEVEL_BOT in ('L1', 'L2', 'L3') then 'Law' else 'Non_Degree' 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`
REVENUE	UM_CNS_RPT_VW	SUM (UM_TUITION_PAID)	Although this field says "Tuition Paid," the values are actually charges calculated from the CHARGES tree It does not reflect any revenue for the YourPace (Academic Partnerships) programs at UMPI.
CREDITS	UM_CNS_RPT_VW	SUM (UNT_PRGRSS)
COUNT	UM_CNS_RPT_VW	SUM (HEADCOUNT)
IN_OUT STATE	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
ACAD_PROGRAM	UM_CNS_RPT_VW	ACAD_PROG_PRIMARY
ETHNICITY	UM_CNS_RPT_VW	UM_ETHNIC_GRP_DESC	Followed IPEDS definition