UM_D_CRSE_OFF_V - Course Catalog and Course Offering Details

This View was built for the Discoverer Tool which has been retired,  The view remains valid and is available for use. 
It includes Academic Course Catalog and Course Offering Value Details from the Source Tables listed.

Detailed Information

Databases

PeopleSoft Campus Solutions CSPRD 
PeopleSoft Campus Solutions Reporting CSRPT

Source Tables

ACAD_GROUP_TBL - Academic Group Table
ACAD_ORG_TBL - Academic Organization Table
CAMPUS_TBL - Campus Table
CRSE_CATALOG - Course Catalog Data
CRSE_OFFER - Course Catalog Offerings

View SQL Code
Download SQL Code

Key Record.Fieldname Format XLAT Heading Text Source Tables
  ACAD_CAREER - Academic Career Char4 N Career CRSE_OFFER
  ACAD_GROUP - Academic Group Char5   Acad Group CRSE_OFFER
  ACAD_ORG - Academic Organization Char10   Acad Org CRSE_OFFER
  ALLOW_MULT_ENROLL - Allow Multiple Enroll in Term Char1   Allow Mult CRSE_CATALOG
  CAMPUS - Campus Char5   Campus CRSE_OFFER
  CATALOG_NBR - Catalog Nbr Char10   Catalog CRSE_OFFER
  CATALOG_PRINT - Catalog Print Char1   Cat Print CRSE_OFFER
  CIP_CODE - CIP Code Char13   CIP Code CRSE_OFFER
  COMPONENT_PRIMARY - Primary Component Char3   Component CRSE_CATALOG
  CONSENT - Type of Consent Required Char1 N Consent CRSE_CATALOG
  COURSE_APPROVED - Course Approved Char1 N Approved CRSE_OFFER
  COURSE_TITLE_LONG - Long Course Title Char100   Long Title CRSE_CATALOG
  CRSE_CONTACT_HRS - Course Contact Hours Num3.2   Crs Cntct CRSE_CATALOG
  CRSE_COUNT - Course Count Num2.2   Crse Count CRSE_CATALOG
Key CRSE_ID - Course ID Char6   Course ID CRSE_CATALOG
Key CRSE_OFFER_NBR - Course Offering Nbr Num2.0   Offer Nbr CRSE_OFFER
  CRSE_REPEAT_LIMIT - Total Completions Allowed Num2.0   Allow Comp CRSE_CATALOG
  CRSE_REPEATABLE - Repeat for Credit Char1   Repeatable CRSE_CATALOG
  DESCR - Description  - Course Description Char30   Descr CRSE_CATALOG
  DESCRLONG - Description - Course Description Long Text   Descr CRSE_CATALOG
  DYN_CLASS_DATA - Dynamic Class Data Rule Char10   Dynamic Data CRSE_OFFER
  ENRL_UN_LD_CLC_TYP - Enrollment Unit Load Calc Type Char1 N Enrl Unt Calc CRSE_CATALOG
  EQUIV_CRSE_ID - Equivalent Course Group Char5   Equiv Crs CRSE_CATALOG
  FEES_EXIST - Fees Exist Flag Char1   Fees Exist CRSE_CATALOG
  GRADE_ROSTER_PRINT - Grade Roster Print Char1 N Roster CRSE_CATALOG
  GRADING_BASIS - Grading Basis Char3 N Grading CRSE_CATALOG
  HEGIS_CODE - HEGIS Code Char8   HEGIS Code CRSE_OFFER
  INSTITUTION - Academic Institution Char5   Institution CRSE_OFFER
  INSTRUCTOR_EDIT - Instructor Edit Char2 N Instr Edit CRSE_CATALOG
  LST_MULT_TRM_CRS - Last Course of Mult Term Seq Char1   Last Crse CRSE_CATALOG
  OEE_IND - Allow OEE Enrollment Char1   Allow OEE Enrl CRSE_OFFER
  RQMNT_DESIGNTN - Requirement Designation Char4   Designation CRSE_CATALOG
  RQRMNT_GROUP - Requirement Group Char6   Rq Group CRSE_OFFER
  SCHED_PRINT_INSTR - Print Instructor in Schedule Char1 N Print CRSE_OFFER
  SCHED_TERM_ROLL - Schedule Term Roll Char1   Term Roll CRSE_OFFER
  SCHEDULE_COURSE - Allow Course to be Scheduled Char1   Schedule Course CRSE_OFFER
  SCHEDULE_PRINT - Schedule Print Char1 N Sch Print CRSE_OFFER
  SEL_GROUP - Tuition Group Char10   Group CRSE_OFFER
  SPLIT_OWNER - Split Ownership Char1   Split Ownr CRSE_OFFER
  SSR_COMPONENT - Course Component Char3 N Component CRSE_CATALOG
  SUBJECT - Subject Area Char8   Subject CRSE_OFFER
  UM_ACAD_GRP_DESCR - Academic Group Descr Char30   Academic Group ACAD_GROUP_TBL
  UM_ACAD_ORG_DESCR - Academic Organization Descript Char30   Acad Org Dsecr ACAD_ORG_TBL
  UM_CAMPUS_DESCR - Campus Description Char30   Campus Descr CAMPUS_TBL
  UNITS_ACAD_PROG - Academic Progress Units Num3.2   Prgrss Unt CRSE_CATALOG
  UNITS_FINAID_PROG - Financial Aid Progress Units Num3.2   FA Units CRSE_CATALOG
  UNITS_MAXIMUM - Maximum Units Num3.2   Max Units CRSE_CATALOG
  UNITS_MINIMUM - Minimum Units Num3.2   Min Units CRSE_CATALOG
  UNITS_REPEAT_LIMIT - Total Units Allowed Num3.2   Allowd Unt CRSE_CATALOG
  USE_BLIND_GRADING - Use Blind Grading Char1   Blind Grd CRSE_OFFER

 

Print Article

Details

Article ID: 172880
Created
Wed 9/11/24 2:04 PM
Modified
Tue 9/17/24 9:31 AM
Applies To
Faculty
Staff
Community