LM_ROOM_SEARCH (SQL View)	Index Back
Facility Room Search Facility Room Search View

LM_ROOM_SEARCH

(SQL View)

Facility Room Search

Facility Room Search View

SELECT C.OPRID , A.LM_FCLTY_ID , A.LM_ROOM_ID , A.LM_ROOM_NBR , E.LM_ROOM_TYPE , A.LM_ROOM FROM PS_LM_ROOM_TBL A , PS_LM_ROOM_LE B , PS_LM_OPRID_LE_VW C , PS_LM_FCLTY_TBL D , PS_LM_ROOM_TYPE E WHERE A.LM_FCLTY_ID = B.LM_FCLTY_ID AND A.LM_ROOM_ID = B.LM_ROOM_ID AND B.LM_LE_ID = C.LM_LE_ID AND A.LM_FCLTY_ID = D.LM_FCLTY_ID AND A.LM_ROOM_TYPE_ID = E.LM_ROOM_TYPE_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 LM_FCLTY_ID Number(10,0) DECIMAL(10) NOT NULL Facility ID
Prompt Table: LM_FCLTY_TBL

3 LM_ROOM_ID Number(10,0) DECIMAL(10) NOT NULL Room ID

4 LM_ROOM_NBR Character(24) VARCHAR2(24) NOT NULL Room Number

5 LM_ROOM_TYPE Character(50) VARCHAR2(50) NOT NULL Room Type Description

6 LM_ROOM Character(50) VARCHAR2(50) NOT NULL Room Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	LM_FCLTY_ID	Number(10,0)	DECIMAL(10) NOT NULL	Facility ID Prompt Table: LM_FCLTY_TBL
3	LM_ROOM_ID	Number(10,0)	DECIMAL(10) NOT NULL	Room ID
4	LM_ROOM_NBR	Character(24)	VARCHAR2(24) NOT NULL	Room Number
5	LM_ROOM_TYPE	Character(50)	VARCHAR2(50) NOT NULL	Room Type Description
6	LM_ROOM	Character(50)	VARCHAR2(50) NOT NULL	Room Name