FACILITYROOM_CDTRN_ROOM_VW(SQL View) |
Index Back |
|---|---|
Training Rooms ViewThis view lists the dates and times for all training rooms that are currently booked for active course sessions. |
| SELECT B.FACILITY,B.ROOM_CD,C.ROOM_NBR,B.SESSN_START_DT,B.SESSN_END_DT,B.SESSN_START_TIME,B.SESSN_END_TIME,B.COURSE,B.SESSION_NBR,B.CUT_SESSION_NBR FROM PS_CRSE_SESSN_TBL A,PS_CRSE_SESS_DATES B,PS_TRN_ROOM_TBL C WHERE B.COURSE=A.COURSE AND B.SESSION_NBR=A.SESSION_NBR AND A.SESSION_STATUS='A' AND C.FACILITY=B.FACILITY AND C.ROOM_CD=B.ROOM_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FACILITY |
Character(6) | VARCHAR2(6) NOT NULL | Facility |
| 2 | ROOM_CD |
Character(6) | VARCHAR2(6) NOT NULL | Room Code |
| 3 | ROOM_NBR | Character(30) | VARCHAR2(30) NOT NULL | Room Number |
| 4 | SESSN_START_DT | Date(10) | DATE | Session Start Date |
| 5 | SESSN_END_DT | Date(10) | DATE | Session End Date |
| 6 | SESSN_START_TIME | Time(15) | TIMESTAMP | Start Time |
| 7 | SESSN_END_TIME | Time(15) | TIMESTAMP | End Time |
| 8 | COURSE | Character(6) | VARCHAR2(6) NOT NULL | Course Code |
| 9 | SESSION_NBR | Character(4) | VARCHAR2(4) NOT NULL | Course Session Nbr |
| 10 | CUT_SESSION_NBR | Character(4) | VARCHAR2(4) NOT NULL | Cut Session Nbr |