First Time Student Report

This report returns headcount, credit hours, and FTE by student's residency status, admit type, 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

First Time Student Report

Report Type

Power BI

(Historically in SQR)

Slicers

These fields are available for slicers. The slicers are located on the top of the report.

  • Term
  • Campus (institution)
  • In/ out (in-state/ out-of-state)
  • Career
  • Acad Program
  • Sex
  • Ethnicity

Data Sources

Field on report Table (view) used Field used from table or Calculation (alias A= UM_CNS_RPT_VW) Important Remarks
Identify first-time students (condition on the entire report)   
(CASE WHEN( A.ADMIT_TERM = A.STRM or ( to_number(A.STRM) - to_NUMBER(A.ADMIT_TERM)) = 80 )
AND ((A.ADMIT_TYPE in ('FYR', 'EFY') and (A.ACAD_LEVEL_BOT in ('10','01') 
or UM_LAST_SCH_TYPE in ('SCD','SHS')))
      or A.ADMIT_TYPE in ('GRD', 'GR6', 'GR2', 'PBA', 'REA')                                        
      or (A.ADMIT_TYPE = 'DAT' and A.ACAD_CAREER = 'GRAD')
      or (A.ADMIT_TYPE = 'TRF' and (DECODE(A.INSTITUTION, 'UMS01','0136246' ,'UMS02', 
'0136247' ,'UMS03', '0136248' ,'UMS04', '0136249','UMS05', 
'0136250','UMS06', '0136392','UMS07', '0136252','Other') <> A.Ext_Org_ID) )           
      or (A.ADMIT_TYPE = 'LAW' and A.ACAD_LEVEL_BOT = 'L1')
      or (A.INSTITUTION = 'UMS05' and A.PROG_REASON = 'RADM' )
     )
AND A.um_degree_nondeg ='Degree' THEN 'Y' else 'N' end )

= 'Y'

 Capture first-time students
Full-time / Part-time   
case
when A.UM_ACAD_LOAD_RC = 'F' then 'Full-time' 
else 'Part-time' end
  
CATEGORY   
case
when A.ADMIT_TYPE = 'REA' or (A.institution = 'UMS05' and A.PROG_REASON = 'RADM' 
and A.STRM >= '1410') then 'Readmissions'
when A.ADMIT_TYPE in ('FYR', 'EFY') then 'Freshman'
when A.ADMIT_TYPE in ('GRD', 'GR6', 'GR2', 'PBA') then 'Graduate'
when A.ADMIT_TYPE = 'DAT' and A.ACAD_CAREER = 'GRAD' then 'Graduate'
when A.ADMIT_TYPE in ('LAW') then 'Law'
when A.ADMIT_TYPE = 'TRF' and A.EXT_ORG_ID not in 
('0136246', '0136247', '0136248', '0136249', '0136250','0136392', '0136252')
then 'External'
when A.ADMIT_TYPE = 'TRF' and A.EXT_ORG_ID in 
('0136246', '0136247', '0136248', '0136249', '0136250','0136392', '0136252')
then 'From UM System'  
else 'Other'
end
  
COUNT UM_CNS_RPT_VW HEADCOUNT  
CREDITS UM_CNS_RPT_VW

UNT_PRGRSS

  
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

  
Sex   Case
when A.SEX ='M' then 'Male'
when A.SEX ='F' then 'Female'
else 'Unknown'
end		  

Environment

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