CRS_1ST_SESS_VW(SQL View) |
Index Back |
---|---|
Course Session Start InfoThis view contains the start date & time of all course sessions, and is used in other views to obtain the name of the training facility where the first session is to be held. |
SELECT A.COURSE ,A.SESSION_NBR ,A.SESSN_START_DT ,MIN(A.SESSN_START_TIME) FROM PS_CRSE_SESS_DATES A WHERE A.SESSN_START_DT = ( SELECT MIN(B.SESSN_START_DT) FROM PS_CRSE_SESS_DATES B WHERE B.COURSE=A.COURSE AND B.SESSION_NBR=A.SESSION_NBR) GROUP BY A.COURSE,A.SESSION_NBR,A.SESSN_START_DT |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | COURSE | Character(6) | VARCHAR2(6) NOT NULL | Course Code |
2 | SESSION_NBR | Character(4) | VARCHAR2(4) NOT NULL | Course Session Nbr |
3 | SESSN_START_DT | Date(10) | DATE | Session Start Date |
4 | SESSN_START_TIME | Time(15) | TIMESTAMP | Start Time |