FACILITYROOM_CDCOURSESESSION_NBRCUT_SESSION_NBRCRS_ROOMEQUIPVW(SQL View) |
Index Back |
|---|---|
Course Session Room EquipmentThis view lists the fixed equipment/materials within a training room for all course sessions. |
| SELECT A.FACILITY, A.ROOM_CD, A.COURSE, A.SESSION_NBR, A.CUT_SESSION_NBR, B.EQUIP_CD, B.QUANTITY FROM PS_CRSE_SESS_DATES A, PS_TRN_ROOM_EQUIP B WHERE A.FACILITY=B.FACILITY AND A.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 | COURSE |
Character(6) | VARCHAR2(6) NOT NULL | Course Code |
| 4 | SESSION_NBR |
Character(4) | VARCHAR2(4) NOT NULL | Course Session Nbr |
| 5 | CUT_SESSION_NBR |
Character(4) | VARCHAR2(4) NOT NULL | Cut Session Nbr |
| 6 | EQUIP_CD | Character(4) | VARCHAR2(4) NOT NULL | Equipment/Materials Code |
| 7 | QUANTITY | Number(3,0) | SMALLINT NOT NULL | Quantity |