CAMPUS_EVENT_NBRSTRMSUBJECTCATALOG_NBRCLASS_SECTIONEVENT_CLASS_VW(SQL View) |
Index Back |
|---|
| SELECT CAMPUS_EVENT_NBR , STRM , SUBJECT , CATALOG_NBR , CLASS_SECTION , CLASS_NBR FROM PS_CLASS_TBL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CAMPUS_EVENT_NBR |
Character(9) | VARCHAR2(9) NOT NULL | Event ID |
| 2 | STRM |
Character(4) | VARCHAR2(4) NOT NULL | Term |
| 3 | SUBJECT |
Character(8) | VARCHAR2(8) NOT NULL | Subject Area |
| 4 | CATALOG_NBR |
Character(10) | VARCHAR2(10) NOT NULL | Catalog Nbr |
| 5 | CLASS_SECTION |
Character(4) | VARCHAR2(4) NOT NULL | Class Section |
| 6 | CLASS_NBR | Number(5,0) | INTEGER NOT NULL | Class Nbr |