SAA_CLST_CRS_VL(SQL View) |
Index Back |
---|---|
Static Course ListUse 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' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(9) | VARCHAR2(9) NOT NULL | Course List | |
2 | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
|
3 | Number(7,0) | INTEGER NOT NULL | Course Sequence | |
4 | Character(3) | VARCHAR2(3) NOT NULL | Language Code | |
5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |