COURSEPrompt Table: COURSE_SRCH_VW
SESSION_NBRPrompt Table: TRN_T_ACTION_VW
F=5 - Finished and Reported
I=2 - Initiated No Reported
N=1 - Defined / Approved
R=3 - Initiated and Reported
Y=4 - Finished No Reported
Default Value: N
TRN_T_SESN_SRCH(SQL View) |
Index Back |
|---|
| SELECT A.COURSE ,B.SESSION_NBR ,A.DESCR ,C.TRN_T_ACTION_ESP ,C.TRN_T_GROUP_ESP ,B.COURSE_START_DT ,B.COURSE_END_DT ,C.TRN_T_CHK_FNSH_ESP FROM %Table(COURSE_TBL) A , %Table(CRSE_SESSN_TBL) B LEFT OUTER JOIN %Table(TRN_T_SESSN_ESP) C ON C.COURSE = B.COURSE AND C.SESSION_NBR = B.SESSION_NBR 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 | TRN_T_ACTION_ESP | Character(5) | VARCHAR2(5) NOT NULL |
Training Action
Prompt Table: TRN_T_ACTION_VW |
| 5 | TRN_T_GROUP_ESP | Character(5) | VARCHAR2(5) NOT NULL | Training Group |
| 6 | COURSE_START_DT | Date(10) | DATE | Course Start Date |
| 7 | COURSE_END_DT | Date(10) | DATE | Course End Date |
| 8 | TRN_T_CHK_FNSH_ESP | Character(1) | VARCHAR2(1) NOT NULL |
FT Status
F=5 - Finished and Reported I=2 - Initiated No Reported N=1 - Defined / Approved R=3 - Initiated and Reported Y=4 - Finished No Reported Default Value: N |