CRSE_ID_EXTEFFDTSUBJECT_SRCHCATALOG_NBR_SRCHCRSE_OFFER_NBRCRSE_OFFER_EXVW(SQL View) |
Index Back |
|---|---|
Course Catalog Offerings View |
| select a.crse_id, a.effdt, a.subject, a.catalog_nbr, a.crse_offer_nbr from PS_CRSE_OFFER a |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CRSE_ID_EXT |
Character(6) | VARCHAR2(6) NOT NULL | External Course ID |
| 2 | EFFDT |
Date(10) | DATE | Effective Date |
| 3 | SUBJECT_SRCH |
Character(8) | VARCHAR2(8) NOT NULL | Subject Area |
| 4 | CATALOG_NBR_SRCH |
Character(10) | VARCHAR2(10) NOT NULL | Catalog Nbr |
| 5 | CRSE_OFFER_NBR |
Number(2,0) | SMALLINT NOT NULL | Course Offering Nbr |