Student Tuition Report

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

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.

Report Location

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

Report Name

Student Tuition Report (Census)

Report Type

Power BI

Historically in SQR (UMSTUTUI.SQR)

Slicers 

These are the slicers available on the report. The slicers are located on the left-hand side of the report. The title of the table changes with the selection of the slicer values. (It works when only one term is selected.)

  • Term
  • institution
  • In-State/ Out of State
  • Career
  • Acad Program
  • Ethnicity

Data Source

All of the fields are from the 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

Environment

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