UM_D_UNITS_VW - Total Student Credit Hours by Institution

Body

This View was built for the Discoverer Tool which has been retired,  The view remains valid and is available for use. 
It includes Total "for credit" Credit Hours from each Institution for each student​​ using the Source Table listed.

Detailed Information

Databases

PeopleSoft Campus Solutions CSPRD 
PeopleSoft Campus Solutions Reporting CSRPT

Source Tables

UM_STUD_EXTRACT - Student Reporting Extract

View SQL Code
Download SQL Code

Key Record.Fieldname Source Tables
  EMPLID - Empl ID UM_STUD_EXTRACT
  STRM - Term UM_STUD_EXTRACT
  UM_UMS01_UNITS - UMS01 Units UM_STUD_EXTRACT
  UM_UMS02_UNITS - UMS02 Units UM_STUD_EXTRACT
  UM_UMS03_UNITS - UMS03 Units UM_STUD_EXTRACT
  UM_UMS04_UNITS - UMS04 Units UM_STUD_EXTRACT
  UM_UMS05_UNITS - UMS05 Units UM_STUD_EXTRACT
  UM_UMS06_UNITS - UMS06 Units UM_STUD_EXTRACT
  UM_UMS07_UNITS - UMS07 Units UM_STUD_EXTRACT

Details

Details

Article ID: 172883
Created
Thu 9/12/24 3:59 PM
Modified
Tue 9/17/24 9:48 AM
Applies To
Faculty
Staff
Community

Related Services / Offerings

Related Services / Offerings (1)

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

Attachments

Attachments (1) Sort By: Sort Attachments ByName Sort Attachments ByDate

TXT

UM_D_UNITS_VW.TXT Computer

Tue 9/17/24 9:44 AM
View
;