COURSEPrompt Table: COURSE_SRCH_VW
SESSION_NBRA=Active
C=Complete
N=Cancelled
CRSE_SESSN_SRCH(SQL View) |
Index Back |
|---|---|
Course Sessn Tbl Search VwCRSE_SESSN_SRCH belongs to the Training Administration application. This record is a search view that selects only those course sessions from COURSE_TBL that are being administered by your company (rather than being administered by an outside agency). For example, you wouldn't be enrolling students in a course offered (and administered) by the local university. Conversely, you would be enrolling students in a session offered in-house, and you would need to track enrollment to ensure, for instance, that you don't enroll more students than there is room for. |
| SELECT A.COURSE ,B.SESSION_NBR ,A.DESCR ,B.COURSE_START_DT ,B.COURSE_END_DT ,B.SESSION_STATUS FROM PS_COURSE_TBL A, PS_CRSE_SESSN_TBL B WHERE A.SESSN_ADMINISTRATN = 'Y' AND A.COURSE = B.COURSE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COURSE |
Character(6) | VARCHAR2(6) NOT NULL |
Course Code
Prompt Table: COURSE_SRCH_VW |
| 2 | SESSION_NBR |
Character(4) | VARCHAR2(4) NOT NULL | Course Session Nbr |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | COURSE_START_DT | Date(10) | DATE | Course Start Date |
| 5 | COURSE_END_DT | Date(10) | DATE | Course End Date |
| 6 | SESSION_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Session Status
A=Active C=Complete N=Cancelled |