Student Profile Report

This report is one of the Census Enrollment Reports and it is as of the census date for the term. The report returns headcount, age, and GPA for a chosen term by Academic Career, Academic Program, Gender, and/or Ethnic Group for any or all institutions. 

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

Report Type

Power BI

Historically in SQR (UMSTUPRO.SQR)

Slicers

These fields are available for slicers on the report. The slicer is located on the left-hand side of the report.

  • Term
  • Academic Career
  • Academic Program
  • Ethnicity
  • Sex

Data Source

Field on report Table (view) used Field used from table or Calculation (alias A= UM_CNS_RPT_VW) Important Remarks
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

# (COUNT)

 UM_CNS_RPT_VW HEADCOUNT  
RESIDENCY UM_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'  )
FTE UM_CNS_RPT_VW FTE  
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

 

 
CREDITS UM_CNS_RPT_VW UNT_PRGRSS  
AGE UM_CNS_RPT_VW

UM_CENSUS_AGE_PREC

 Average age, max age, and min age excluded age <14 and birthday <= 1/1/1901
AGE_RANGE UM_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

 
GPA UM_CNS_RPT_VW CUM_GPA Excluded GPA = 0

Environment

  • PeopleSoft Campus Solutions Reporting (CSRPT)
  • Power BI
Submit an Inquiry or Request to DARTS Print Article

Related Services / Offerings (1)

DARTS (UMS Data) Inquiry
Submit an inquiry about UMS Data (except Data Governance)