INSTITUTIONCRSE_IDEFFDTSSR_CRSECAT_BND(SQL View) |
Index Back |
|---|---|
Course Pop Select bind rec |
| SELECT b.institution , a.crse_id , a.effdt , a.descr , a.course_title_long , b.subject , b.catalog_nbr , b.acad_org , b.acad_group , b.campus FROM ps_crse_catalog a , PS_CRSE_OFFER b WHERE a.crse_id = b.crse_id AND a.effdt = b.effdt AND b.course_approved = 'A' AND (a.effdt = ( SELECT MAX(a1.effdt) FROM ps_crse_catalog a1 WHERE a.crse_id = a1.crse_id AND a1.effdt <= %CurrentDateIn) OR (a.effdt > %CurrentDateIn AND NOT EXISTS ( SELECT 'X' FROM PS_CRSE_CATALOG a2 WHERE a.crse_id = a2.crse_id AND a2.effdt <= %CurrentDateIn)) AND a.effdt = ( SELECT MIN(a3.effdt) FROM ps_crse_catalog a3 WHERE a.crse_id = a3.crse_id AND a3.effdt > %CurrentDateIn)) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | CRSE_ID |
Character(6) | VARCHAR2(6) NOT NULL | Course ID |
| 3 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | COURSE_TITLE_LONG | Character(100) | VARCHAR2(100) NOT NULL | Long Course Title |
| 6 | SUBJECT | Character(8) | VARCHAR2(8) NOT NULL | Subject Area |
| 7 | CATALOG_NBR | Character(10) | VARCHAR2(10) NOT NULL | Catalog Nbr |
| 8 | ACAD_ORG | Character(10) | VARCHAR2(10) NOT NULL | Academic Organization |
| 9 | ACAD_GROUP | Character(5) | VARCHAR2(5) NOT NULL | Academic Group |
| 10 | CAMPUS | Character(5) | VARCHAR2(5) NOT NULL | Campus |