LM_RSRV_CNF_VW

(SQL View)
 Index Back

Room Reservation Conflicts

Room Reservation conflicts with sessions and other room reservations. Selects the unique Catalog Item Name and Room Reservation Name.

SELECT DISTINCT SES1.LM_FCLTY_ID , SES1.LM_ROOM_ID , 0 , CIT1.LM_CI_ID , SES1.LM_SES_DT , SES1.LM_START_TM , SES1.LM_END_TM , SES1.TIMEZONE FROM PS_LM_SES SES1 , PS_LM_RSRV_RM RMR1 , PS_LM_ACT ACT1 , PS_LM_CI_TBL CIT1 WHERE CIT1.LM_CI_ID = ACT1.LM_CI_ID AND ACT1.LM_ACT_ID = SES1.LM_ACT_ID AND %Sql(LM_RSRV_CNF_SQL, SES1, RMR1) UNION SELECT DISTINCT RMR2.LM_FCLTY_ID , RMR2.LM_ROOM_ID , RMR2.LM_RSRV_RM_ID , 0 , RMR2.LM_SES_DT , RMR2.LM_START_TM , RMR2.LM_END_TM , RMR2.TIMEZONE FROM PS_LM_SES SES2 , PS_LM_RSRV_RM RMR2 WHERE %Sql(LM_RSRV_CNF_SQL, SES2, RMR2) UNION SELECT DISTINCT RMR3.LM_FCLTY_ID , RMR3.LM_ROOM_ID , RMR3.LM_RSRV_RM_ID , 0 , RMR3.LM_SES_DT , RMR3.LM_START_TM , RMR3.LM_END_TM , RMR3.TIMEZONE FROM PS_LM_RSRV_RM RMR3 , PS_LM_RSRV_RM RMR4 WHERE RMR3.LM_RSRV_RM_ID <> RMR4.LM_RSRV_RM_ID AND %Sql(LM_RSRV_CNF_SQL, RMR3, RMR4)

# 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 LM_RSRV_RM_ID Number(10,0) DECIMAL(10) NOT NULL Reserve Room ID
4 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item
5 LM_SES_DT Date(10) DATE Session Date
6 LM_START_TM Time(15) TIMESTAMP Start Time
7 LM_END_TM Time(15) TIMESTAMP End Time
8 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone