INSTITUTIONPrompt Table: INSTITUTION_TBL
STRMPrompt Table: TERM_TBL
CLASS_NBRCLASS_TBL_VW3(SQL View) |
Index Back |
|---|---|
Class Table View3This Class Table View is a view of the Class Table for getting course id in enrollment request panel. |
| select a.institution ,a.strm ,a.class_nbr ,a.crse_id from PS_CLASS_TBL a |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 2 | STRM |
Character(4) | VARCHAR2(4) NOT NULL |
Term
Prompt Table: TERM_TBL |
| 3 | CLASS_NBR |
Number(5,0) | INTEGER NOT NULL | Class Nbr |
| 4 | CRSE_ID | Character(6) | VARCHAR2(6) NOT NULL | Course ID |