Created by Miki Yanagi, last modified on Oct 19, 2022

Report Purpose

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

First Time Student Report

Report Type

Power BI

(Historically in SQR)

Slicers

These fields are available for slicers. Title of the table changes as the values selected on slicer changes. 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 Sources

Field on reportTable (view) usedField 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

COUNTUM_CNS_RPT_VWHEADCOUNT
CREDITSUM_CNS_RPT_VW

UNT_PRGRSS


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 A.RESIDENCY = 'MEONL' AND QB.RESIDENCY = 'IS' THEN 'In-State'
WHEN A.Residency = 'IS' THEN 'In-State'
ELSE 'Out-of-State'
END 

ETHNICITYUM_CNS_RPT_VW

UM_ETHNIC_GRP_DESC


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



Attachments:

image2019-9-24_9-16-25.png (image/png)
opt psoft CSRPTOUT SQR_UMTRMCMP_1904092 umtrmcmp_1904092 PDF.png (image/png)
Multi Term.JPG (image/jpeg)
image2019-9-24_9-3-57.png (image/png)
image2019-9-24_9-21-18.png (image/png)
image2019-9-26_10-47-50.png (image/png)
image2021-9-8_14-58-50.png (image/png)