INSTITUTIONDefault Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTION_TBL
SUBJECTDefault Value: OPR_DEF_TBL_CS.SUBJECT
Prompt Table: SUBJECT_TBL
CATALOG_NBRCAMPUSPrompt Table: CAMPUS_TBL
CRSE_IDCRSE_CATLG_SRCH(SQL View) |
Index Back |
|---|---|
Course Catalog SearchThe Course Catalog Search contains course data that is printed in the academic institution's course catalog. This information is extracted from the Course Catalog and the Course Catalog Offerings tables. |
| select b.institution ,b.subject ,b.catalog_nbr ,b.campus ,b.crse_id ,a.descr from ps_crse_catalog a, PS_CRSE_OFFER b where a.crse_id = b.crse_id and a.effdt = b.effdt |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
| 2 | SUBJECT |
Character(8) | VARCHAR2(8) NOT NULL |
Subject Area
Default Value: OPR_DEF_TBL_CS.SUBJECT Prompt Table: SUBJECT_TBL |
| 3 | CATALOG_NBR |
Character(10) | VARCHAR2(10) NOT NULL | Catalog Nbr |
| 4 | CAMPUS |
Character(5) | VARCHAR2(5) NOT NULL |
Campus
Prompt Table: CAMPUS_TBL |
| 5 | CRSE_ID |
Character(6) | VARCHAR2(6) NOT NULL | Course ID |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |