LM_ROOM_SRCH_VW

(SQL View)
 Index Back

Room Search View

This view is used as the search results record in the result grid for the Room Search Page.

SELECT A.LM_FCLTY_ID ,B.LM_ROOM_ID ,D.OPRID ,B.LM_ROOM_TYPE_ID ,B.LM_ROOM_NBR ,B.LM_ROOM ,B.LM_BLDG ,B.LM_ROOM_STATUS ,B.LM_MAX_OCPNCY ,A.CITY ,A.STATE ,A.COUNTRY FROM PS_LM_FCLTY_TBL A ,PS_LM_ROOM_TBL B ,PS_LM_ROOM_LE C ,PS_LM_OPRID_LE_VW D WHERE A.LM_FCLTY_ID = B.LM_FCLTY_ID AND B.LM_FCLTY_ID = C.LM_FCLTY_ID AND B.LM_ROOM_ID = C.LM_ROOM_ID AND C.LM_LE_ID = D.LM_LE_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LM_FCLTY_ID Number(10,0) DECIMAL(10) NOT NULL Facility ID
2 LM_ROOM_ID Number(10,0) DECIMAL(10) NOT NULL Room ID
3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
4 LM_ROOM_TYPE_ID Number(10,0) DECIMAL(10) NOT NULL Room Type ID

Prompt Table: LM_ROOM_TYPE_VW

5 LM_ROOM_NBR Character(24) VARCHAR2(24) NOT NULL Room Number
6 LM_ROOM Character(50) VARCHAR2(50) NOT NULL Room Name
7 LM_BLDG Character(50) VARCHAR2(50) NOT NULL Building Name
8 LM_ROOM_STATUS Character(1) VARCHAR2(1) NOT NULL Room Status
1=Active
2=Inactive

Default Value: 1

9 LM_MAX_OCPNCY Number(6,0) INTEGER NOT NULL Maximum Occupancy
10 CITY Character(30) VARCHAR2(30) NOT NULL City
11 STATE Character(6) VARCHAR2(6) NOT NULL State
12 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country