SAA_OFFER_VW

(SQL View)
 Index Back

Advising Report Offer View

This view is used to select the course offering (subject and catalog number) for all courses that can be used in the complex set theory in the new advising reports.

SELECT A.SUBJECT ,A.CATALOG_NBR ,B.CRSE_ID ,A.ACAD_GROUP ,A.INSTITUTION ,B.DESCR ,C.CRS_TOPIC_ID ,C.DESCR FROM PS_CRSE_OFFER A , PS_CRSE_CATALOG B , PS_CRSE_TOPICS C WHERE A.CRSE_ID = B.CRSE_ID AND A.EFFDT = B.EFFDT AND B.CRSE_ID = C.CRSE_ID AND B.EFFDT = C.EFFDT UNION SELECT A.SUBJECT ,A.CATALOG_NBR ,B.CRSE_ID ,A.ACAD_GROUP ,A.INSTITUTION ,B.DESCR ,0 ,' ' FROM PS_CRSE_OFFER A , PS_CRSE_CATALOG B WHERE A.CRSE_ID = B.CRSE_ID AND A.EFFDT = B.EFFDT AND NOT EXISTS ( SELECT 'X' FROM PS_CRSE_TOPICS C WHERE B.CRSE_ID = C.CRSE_ID AND B.EFFDT = C.EFFDT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area
2 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr
3 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
4 ACAD_GROUP Character(5) VARCHAR2(5) NOT NULL Academic Group
5 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
7 CRS_TOPIC_ID Number(3,0) SMALLINT NOT NULL Course Topic ID
8 SAA_CRS_TOPIC_DESC Character(30) VARCHAR2(30) NOT NULL This field is used for the course topic title used in AA reports.