Term Comparison Report

This report returns individual term student counts and credits by institution per term for three terms as of census day. It is further divided into full and part-time and residency.

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

Term Comparison Report

Report Type

Power BI

Historically in SQR (UMTRMCMP.SQR), -Term Count Comparison Report

Slicers

These fields are available for slicers. The slicers are located at the top right corner of the report.

  • Term
  • Career
  • Acad 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

# (COUNT)

 UM_CNS_RPT_VW HEADCOUNT  
CREDITS UM_CNS_RPT_VW UNT_PRGRSS  
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
Sex UM_CNS_RPT_VW 
Case
when A.SEX ='M' then 'Male'
when A.SEX ='F' then 'Female'
else 'Unknown'  
end
  
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'  )
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

Environment

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