FACILITYROOM_CDLANGUAGE_CDTRN_ROOMSEL_LNG(SQL View) |
Index Back |
|---|---|
Related language viewAdminister Training related language view of TRN_ROOM_SEL_VW. |
| SELECT A.FACILITY , B.ROOM_CD , B.LANGUAGE_CD , B.ROOM_NBR FROM PS_TRN_FACIL_TBL A , PS_TRN_ROOM_LANG B , PS_TRN_ROOM_TBL C WHERE B.FACILITY = A.FACILITY AND B.FACILITY = C.FACILITY AND B.ROOM_CD = C.ROOM_CD AND C.ROOM_ACTIVE='Y' |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | ROOM_NBR | Character(30) | VARCHAR2(30) NOT NULL | Room Number |