Created by Corina C Larsen, last modified by Miki Yanagi on Sep 08, 2021

Report Purpose

This report returns headcount, age and GPA for a chosen term and can be run by Academic Career, Academic Program, Gender and/or Ethnic Group for any or all institutions depending on the users access level. This is one of the Enrollment Reports run at each census for all Academic Careers, Academic Programs, Genders, Ethnic Groups and Institutions for the current term. The data is as of census date for the term.

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

Report Type

Power BI

Historically in SQR (UMSTUPRO.SQR)

Slicers

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

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 reportTable (view) usedField used from table or Calculation (alias A= UM_CNS_RPT_VW)Important Remarks
LEVELUM_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-timeUM_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_VWHEADCOUNT
RESIDENCYUM_CNS_RPT_VW

UM_RESIDENCY_DESCR

The Alias B is UM_STUD_EXTRACT. (B.Residency is tuition residency from RESIDENCY_OFF table.)

DECODE(B.Residency,
              'IS', 'In-State',
              'OS', 'Out-of-State',
             'CAN', 'Canadian',
           'NEBHE', 'NEBHE',
           'INTNL', 'International',
           'ONLIN', 'Online',
           'MEONL', 'Academic Partnerships'
                    'Out-of-State'  )

FTEUM_CNS_RPT_VWFTE
IN_OUTUM_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 
ETHNICITYUM_CNS_RPT_VW

UM_ETHNIC_GRP_DESC

Followed IPEDS definition
SexUM_CNS_RPT_VW
Case
when A.SEX ='M' then 'Male'
when A.SEX ='F' then 'Female'
else 'Unknown' 
end



CREDITSUM_CNS_RPT_VWUNT_PRGRSS
AGEUM_CNS_RPT_VW

UM_CENSUS_AGE_PREC

Average age, max age, and min age excluded age <14 and birthday <= 1/1/1901
AGE_RANGEUM_CNS_RPT_VW
case 
when A.BIRTHDATE <= TO_DATE('19010101', 'yyyymmdd') then 'Unknown'
when A.um_census_age_prec < 18 then 'Under 18'
when A.um_census_age_prec >= 18 and A.um_census_age_prec < 20 then '18 to 19'
when A.um_census_age_prec >= 20 and A.um_census_age_prec < 22 then '20 to 21'  
when A.um_census_age_prec >= 22 and A.um_census_age_prec < 25 then '22 to 24'
when A.um_census_age_prec >= 25 and A.um_census_age_prec < 30 then '25 to 29'  
when A.um_census_age_prec >= 30 and A.um_census_age_prec < 35 then '30 to 34'
when A.um_census_age_prec >= 35 and A.um_census_age_prec < 40 then '35 to 39'
when A.um_census_age_prec >= 40 and A.um_census_age_prec < 50 then '40 to 49'
when A.um_census_age_prec >= 50 and A.um_census_age_prec < 65 then '50 to 64'
when A.um_census_age_prec >= 65 then '65 and over'
else 'Unknown'
end

GPAUM_CNS_RPT_VWCUM_GPAExcluded GPA = 0

Attachments:

image2019-3-7_11-31-24.png (image/png)
Student Profile Rpt Run Control.JPG (image/jpeg)
Student Profile Rpt Run Control.png (image/png)
image2019-9-27_15-8-8.png (image/png)
image2021-9-8_15-21-44.png (image/png)