UM_D_CLSS_ATT_V - Course Attributes

Body

 

WARNING: Field Name Definitions are Linked to the UMS Data Cookbook - this requires a University of Maine System ID and password

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 Attribute Value Details from the Source Tables listed.

Detailed Information

Databases

PeopleSoft Campus Solutions CSPRD 
PeopleSoft Campus Solutions Reporting CSRPT

Source Tables

CLASS_ATTRIBUTE - Class Attribute Table
CRSE_ATTR_TBL - Course Print Attribute Table
CRSE_ATTR_VALUE - Course Attribute Value Table

View SQL Code
Download SQL Code

Key Record.Fieldname Format XLAT Heading Text Source Tables
Key CLASS_SECTION - Class Section Char4   Section CLASS_ATTRIBUTE
Key CRSE_ATTR - Course Attribute Char4   Crse Attr CLASS_ATTRIBUTE
Key CRSE_ATTR_VALUE - Course Attribute Value Char10   CrsAtr Val CLASS_ATTRIBUTE
Key CRSE_ID - Course ID Char6   Course ID CLASS_ATTRIBUTE
Key CRSE_OFFER_NBR - Course Offering Nbr Num2.0   Offer Nbr CLASS_ATTRIBUTE
Key SESSION_CODE - Session Char3 N Session CLASS_ATTRIBUTE
Key STRM - Term Char4   Term CLASS_ATTRIBUTE
  UM_CRSE_ATTR_DESCR - Course Attribute Description Char30   Crse Attr Descr CRSE_ATTR_TBL
  UM_CRSE_ATTR_VDESC - Course Attribute Value Descrip Char30   Crse AVal Desc CRSE_ATTR_VALUE


 

Details

Details

Article ID: 172870
Created
Mon 9/9/24 9:21 AM
Modified
Tue 9/17/24 9:14 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_ATT_V.TXT Computer

Mon 9/9/24 10:34 AM
View
;