COURSEFACILITYROOM_CDLANGUAGE_CDTRN_CRSROOM_LNG(SQL View) |
Index Back |
|---|---|
Training Rooms for CoursesRelated language view for TRN_CRS_ROOM_VW |
| SELECT B.COURSE , A.FACILITY , A.ROOM_CD , C.LANGUAGE_CD , C.ROOM_NBR FROM PS_TRN_ROOM_TBL A , PS_COURSE_TBL B , PS_TRN_ROOM_LANG C WHERE (A.MAX_STUDENTS >=B.MAX_STUDENTS OR A.MAX_STUDENTS = 0) AND A.FACILITY = C.FACILITY AND A.ROOM_CD = C.ROOM_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COURSE |
Character(6) | VARCHAR2(6) NOT NULL | Course Code |
| 2 | FACILITY |
Character(6) | VARCHAR2(6) NOT NULL | Facility |
| 3 | ROOM_CD |
Character(6) | VARCHAR2(6) NOT NULL | Room Code |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | ROOM_NBR | Character(30) | VARCHAR2(30) NOT NULL | Room Number |