BUDGET_PERIODCOURSEPrompt Table: CRSE_SESSN_SRCH
SESSION_NBRTRN_SESSN_COMPL(SQL View) |
Index Back |
|---|---|
Training Sessions Completed VwCRSE_SESSN_TBL contains one record for each session of an in-house administered course. Sessions are automatically assigned a sequence number within course. This record is part of the Training Administration module. |
| SELECT A.BUDGET_PERIOD, B.COURSE, B.SESSION_NBR, B.COURSE_START_DT, B.COURSE_END_DT FROM PS_BUDGET_PERIOD A, PS_CRSE_SESSN_TBL B WHERE B.SESSION_STATUS = 'C' AND A.EFFDT <= B.COURSE_START_DT AND A.EFFDT <= B.COURSE_END_DT AND A.THRU_DATE >= B.COURSE_START_DT AND A.THRU_DATE >= B.COURSE_END_DT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUDGET_PERIOD |
Character(10) | VARCHAR2(10) NOT NULL | Budget Period |
| 2 | COURSE |
Character(6) | VARCHAR2(6) NOT NULL |
Course Code
Prompt Table: CRSE_SESSN_SRCH |
| 3 | SESSION_NBR |
Character(4) | VARCHAR2(4) NOT NULL | Course Session Nbr |
| 4 | COURSE_START_DT | Date(10) | DATE NOT NULL | Course Start Date |
| 5 | COURSE_END_DT | Date(10) | DATE | Course End Date |