LM_ROOM_VW

(SQL View)
 Index Back

Facility Room View

Facility Room View

SELECT LM_FCLTY_ID , LM_ROOM_ID , LM_ROOM_TYPE_ID , LM_ROOM_NBR , LM_ROOM , LM_BLDG , LM_FLOOR_NBR , LM_COST_TYPE , LM_COST , CURRENCY_CD , LM_ROOM_STATUS , LM_MAX_OCPNCY FROM PS_LM_ROOM_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LM_FCLTY_ID Number(10,0) DECIMAL(10) NOT NULL Facility ID

Prompt Table: LM_FCLTY_SRCH

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

Prompt Table: LM_ROOM_TYPE

4 LM_ROOM_NBR Character(24) VARCHAR2(24) NOT NULL Room Number
5 LM_ROOM Character(50) VARCHAR2(50) NOT NULL Room Name
6 LM_BLDG Character(50) VARCHAR2(50) NOT NULL Building Name
7 LM_FLOOR_NBR Character(6) VARCHAR2(6) NOT NULL Floor Number
8 LM_COST_TYPE Character(2) VARCHAR2(2) NOT NULL Cost Type Units
01=Per Hour
02=Per Day
03=Per Week
04=Fixed Cost
05=Per Student
9 LM_COST Number(19,3) DECIMAL(18,3) NOT NULL Cost
10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

11 LM_ROOM_STATUS Character(1) VARCHAR2(1) NOT NULL Room Status
1=Active
2=Inactive
12 LM_MAX_OCPNCY Number(6,0) INTEGER NOT NULL Maximum Occupancy