ORMS Audit Reports

Note: This topic applies to ADF 11.

The following Audit reports are available in the Revenue Management (ORMS) report group:

ORMS Audits the Indicator Forecasted ADR (orms_audit_adr_fore)
ORMS Audits the Indicator Forecasted Occupancy (orms_audit_occupancy_fore)
ORMS Audits the Indicator Occupancy OTB (orms_audit_occupancy_otb)
ORMS Audits the Indicator Forecasted RevPar (orms_audit_revpar_fore)
ORMS Audits the Indicator RevPar OTB (ORMS Audits the Indicator RevPar OTB (orms_audit_revpar_otb)

The ORMS audit reports provide auditing for ORMS Indicators for the ORMS Home Page Topic. For a specific date range of forecast, these reports display the dates ORMS picked for the forecast. Based on this data, you can troubleshoot if the forecast is too high or low.

The ORMS Home Page has six Topics: Occupancy, ADR, RevPAR, Inventory, Blocks, and Transient. Each Topic has the following Indicators:

Auditing Topic	Indicators
Occupancy	Occupancy on the Books, Forecast Occupancy
ADR, RevPAR	ADR on the Books, ADR Forecast, RevPAR on the Books, RevPAR Forecast
Inventory	Physical Rooms, Out Of Order, Available Physical Rooms, Overbooking, Total Deduct/Picked Up Rooms
Blocks	Total Block Rooms, Deductible Block Rooms, Non Deductible Block Rooms, Block Rooms P/U, Forecasted Block Rooms
Transient	Transient OTB, Transient Forecasted Stay , Transient Forecasted Arrivals, Transient Forecasted Departures
History dates for Forecast	Audit the current ORMS report: orms_history_forecast

Note: When previewing a report for a specific period, the numbers match with the numbers on the ORMS Home Page.

Report Output

Field	Column	Formula
OCC(%) OTB	otb_occupancy_pct	(definite_room + def_blocks)/ (inv_physical - inv_ooo)
OCC(%) Fore	for_occupancy_pct	least(round(definite_room + stay_con_forecast + group_mtrl + group_tobe - definite_block_room - tentative_block_room) , greatest( (definite_room + def_blocks), (inv_physical + (inv_sell_limits - inv_physical) - inv_ooo)) ) / (inv_physical - inv_ooo)
ADR OTB	otb_adr	roomrev_onthebooks/(definite_room + def_blocks)
ADR Fore	for_adr	(roomrev_trnfore+roomrev_grpfore+net_room_revenue) /(definite_room + stay_con_forecast + group_mtrl + group_tobe - definite_block_room - tentative_block_room)
RevPar OTB	otb_revpar	((definite_room + def_blocks)/(inv_physical - inv_ooo)) * (roomrev_onthebooks/(definite_room + def_blocks))
RevPar Fore	for_revpar	(roomrev_trnfore+roomrev_grpfore+net_room_revenue)/(definite_room + stay_con_forecast + group_mtrl + group_tobe - definite_block_room - tentative_block_room) * (definite_room + stay_con_forecast + group_mtrl + group_tobe - definite_block_room - tentative_block_room)/(inv_physical - inv_ooo)
Rate Low Open	Lowest Open Rate Code and Amount	orms_ref.get_lowest_available(resort, record_date,:p_roomcat)
Rate High Close	Highest close rate code and amount	orms_ref.get_highest_closed(resort, record_date,:p_roomcat)
Physical Rooms	inv_physical	inv_physical
Out Of Order	inv_ooo	inv_ooo
Overbooking	inv_oversell	inv_sell_limits - inv_physical
Rooms Reserved	inv_onthebooks	definite_room + def_blocks
Avl. Physical Rooms	inv_available	inv_physical - inv_ooo - (definite_room + def_blocks)
Total Block Rooms	grp_totblocks	def_blocks+definite_block_room+tent_blocks+tentative_block_room
Deductable Block Rooms	grp_defblocks	def_blocks+definite_block_room
Non-Ded. Block Rooms	grp_tentblocks	tent_blocks + tentative_block_room
Block Rooms P/U	grp_pickedup	definite_block_room+tentative_block_room
Forecasted Block Rooms	grp_forecasted	group_mtrl + group_tobe
Fore. Reserved Rooms	trn_stay_fore	definite_room + stay_con_forecast - definite_block_room - tentative_block_room
Fore. Arrival Rooms	trn_arrival_fore	resv_forecast - cncl_forecast
Fore. Reservations	trn_resv_fore	resv_forecast
Fore. Cancellations	trn_cncl_fore	cncl_forecast
Fore. Overbooking	oversell_forecast	(orms_opt.get_oversell(resort,record_date))

Field	Description
definite_room	Total number of deducted rooms including block rooms. From reservation_summary table.
def_blocks	Number of rooms deducted by the blocks but NOT yet picked. pms_grgrid. Allotment_definite_rooms(record_date)
inv_physical	Total number of physical rooms at the hotel. inventory_statistics.get_physical_rooms(pms_p.resort, null)
inv_ooo	Total number of Out Of Order rooms. inventory_statistics.get_daily_oo_os_rooms(pms_p.resort,record_date)
stay_con_forecast	Total remaining demand including non-yieldable demand. orms_fore.get_cons_forecast_rem(qry.resort,qry.record_date)
group_mtrl	Forecasted block materialization expected for the stay date. orms_group.get_group_forecast(qry.resort,qry.record_date)
group_tobe	Hard coded to 0.
definite_block_room	Definite rooms picked by blocks. From reservation_summary table
tentative_block_room	Tentative rooms picked by blocks. From reservation_summary table.
inv_sell_limits	Inventory with sell limits. inventory_statistics.get_house_sell_limits(pms_p.resort, record_date)
roomrev_onthebooks	net_room_revenue+ block_revenue
net_room_revenue	Net room revenue from reservation summary table for all booked reservations including block pickups.
block_revenue	Total block revenue for the non-picked up block rooms. orms_ref.block_revenue(resort,record_date)
roomrev_trnfore	Forecasted transient room revenue orms_ref.RoomRevenue_TranFore(qry.resort, qry.record_date)
roomrev_grpfore	Total expected Room Revenue for the Group remaining forecast. orms_ref.RoomRevenue_GroupFore(qry.resort, qry.record_date)
resv_forecast	Forecasted transient arrivals. orms_fore.get_forecast(qry.resort,qry.record_date,'R','A',null,'A','T')
cncl_forecast	Forecasted transient cancellations arriving on the given date. orms_fore.get_forecast(qry.resort,qry.record_date,'C','A',null,'A','T')