EMPLIDCOURSESESSION_NBRCOURSE_START_DTCOURSE_TITLETRN_SESS_DUR_VW(SQL View) |
Index Back |
|---|---|
View for Total SessionDurationView for Display only grid |
| SELECT A.EMPLID ,A.COURSE ,A.SESSION_NBR ,A.COURSE_START_DT ,A.COURSE_TITLE ,B.TRN_HOUR_TYPE , SUM(B.TRN_SCUT_IN_HRS) , SUM(B.TRN_SCUT_OUT_HRS) FROM PS_TRAINING A , PS_TRN_SCUT_HRS B WHERE A.EMPLID=B.EMPLID AND A.COURSE=B.COURSE AND A.SESSION_NBR=B.SESSION_NBR AND A.COURSE_START_DT=B.COURSE_START_DT AND A.COURSE_TITLE=B.COURSE_TITLE GROUP BY A.EMPLID,A.COURSE,A.SESSION_NBR,A.COURSE_START_DT,A.COURSE_TITLE,B.TRN_HOUR_TYPE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | COURSE |
Character(6) | VARCHAR2(6) NOT NULL | Course Code |
| 3 | SESSION_NBR |
Character(4) | VARCHAR2(4) NOT NULL | Course Session Nbr |
| 4 | COURSE_START_DT |
Date(10) | DATE | Course Start Date |
| 5 | COURSE_TITLE |
Character(30) | VARCHAR2(30) NOT NULL | Course Title |
| 6 | TRN_HOUR_TYPE | Character(4) | VARCHAR2(4) NOT NULL | Training Hours type |
| 7 | TRN_SCUT_IN_HRS | Number(10,3) | DECIMAL(9,3) NOT NULL | Training Session Cut in hours |
| 8 | TRN_SCUT_OUT_HRS | Number(10,3) | DECIMAL(9,3) NOT NULL | Training Session cut out hours |