UM_D_CLSS_ASC_V - Associated Classes with Student Requirement Status Detail

Body

This View was built for the Discoverer Tool which has been retired,  The view remains valid and is available for use. 
It includes Academic Class Associations and Student Requirement Status Details from the Source Tables listed.

Detailed Information

Databases

PeopleSoft Campus Solutions CSPRD 
PeopleSoft Campus Solutions Reporting CSRPT

Source Tables

CLASS_ASSOC - Class Associations
RQMNT_DESIG_TBL - Requirement Designation Table
RQ_GRP_TBL - Requirement Group Table

View SQL Code
Download SQL Code

Key Record.Fieldname Source Tables
Key ASSOCIATED_CLASS - Associated Class CLASS_ASSOC
  BILLING_FACTOR - Billing Factor CLASS_ASSOC
  COMPONENT_PRIMARY - Primary Component CLASS_ASSOC
  CRSE_CONTACT_HRS - Course Contact Hours CLASS_ASSOC
  CRSE_COUNT - Course Count CLASS_ASSOC
Key CRSE_ID - Course ID CLASS_ASSOC
Key CRSE_OFFER_NBR - Course Offering Nbr CLASS_ASSOC
  GRADE_ROSTER_PRINT - Grade Roster Print CLASS_ASSOC
  GRADING_BASIS - Grading Basis CLASS_ASSOC
  INSTRUCTOR_EDIT - Instructor Edit CLASS_ASSOC
  RQMNT_DESIGNTN - Requirement Designation CLASS_ASSOC
  RQRMNT_GROUP - Requirement Group CLASS_ASSOC
  SEL_GROUP - Tuition Group CLASS_ASSOC
Key SESSION_CODE - Session CLASS_ASSOC
  SSR_COMPONENT - Course Component CLASS_ASSOC
Key STRM - Term CLASS_ASSOC
  UM_RQMNT_DSG_DESCR - Requirement Description Descr RQ_GRP_TBL
  UM_RQRMNT_GRP_DESC - Requirement Group Description RQMNT_DESIG_TBL
  UNITS_ACAD_PROG - Academic Progress Units CLASS_ASSOC
  UNITS_FINAID_PROG - Financial Aid Progress Units CLASS_ASSOC
  UNITS_MAXIMUM - Maximum Units CLASS_ASSOC
  UNITS_MINIMUM - Minimum Units CLASS_ASSOC
  USE_CATLG_RQS - Also Use Catalog Requisite CLASS_ASSOC

Details

Details

Article ID: 172869
Created
Fri 9/6/24 4:20 PM
Modified
Tue 9/17/24 9:11 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_CLSS_ASC_V.TXT Computer

Fri 9/6/24 4:27 PM
View
;