SAA_CLST_CRS_VL

(SQL View)
 Index Back

Static Course List

Use this table to specify Course and Wild Card data for single courses included in a Course List.

SELECT a.COURSE_LIST , a.EFFDT , b.R_COURSE_SEQUENCE , c.LANGUAGE_CD , c.DESCR FROM PS_CLST_MAIN_TBL a , PS_CLST_DETL_TBL b , PS_CRSE_CATLG_LNG c , PS_CRSE_OFFER d WHERE a.COURSE_LIST = b.COURSE_LIST AND a.EFFDT = b.EFFDT AND b.WILDCARD_IND = 'N' AND b.CRSE_ID = c.CRSE_ID AND c.EFFDT = ( SELECT MAX(c1.EFFDT) FROM PS_CRSE_CATALOG c1 WHERE c1.CRSE_ID = c.CRSE_ID AND c1.EFFDT <= a.EFFDT) AND c.CRSE_ID = d.CRSE_ID AND c.EFFDT = d.EFFDT AND d.COURSE_APPROVED = 'A'

  • Related Language Record for SAA_CLST_CRS_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COURSE_LIST Character(9) VARCHAR2(9) NOT NULL Course List
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 R_COURSE_SEQUENCE Number(7,0) INTEGER NOT NULL Course Sequence
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description