CRSE_IDPrompt Table: CRSE_CATALOG
DATE1SUBJECTPrompt Table: SUBJECT_TBL
CATALOG_NBRCRSE_OFFER_2_VW(SQL View) |
Index Back |
|---|---|
Course Catalog Offerings ViewPS Query/Schedule of Class Work View. This view switches Course Offering Number & Effective Date for the benefit of PS Query. |
| select a.crse_id, a.effdt, a.subject, a.catalog_nbr from PS_CRSE_OFFER a |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CRSE_ID |
Character(6) | VARCHAR2(6) NOT NULL |
Course ID
Prompt Table: CRSE_CATALOG |
| 2 | DATE1 |
Date(10) | DATE | Effective Date |
| 3 | SUBJECT |
Character(8) | VARCHAR2(8) NOT NULL |
Subject Area
Prompt Table: SUBJECT_TBL |
| 4 | CATALOG_NBR |
Character(10) | VARCHAR2(10) NOT NULL | Catalog Nbr |