IDeaS V5i Group Block API

IDeaS, a third-party external interface used for Yield or Revenue Management, is connected to OPERA PMS and OPERA S&C through direct calls to OPERA's IDeaS API. When IDeaS makes the V5i Group Block API call, OPERA creates 2 session specific temporary tables containing the data needed for IDeaS Group Wash by Group functionality. OPERA then returns a SUCCESS message to the IDeaS interface indicating that the tables have been created and populated. IDeaS can then fetch the required data.

Procedure

This API will populate two global temporary tables (session specific) which must then be queried to fetch the required data.

v5i_blocks.get_block_data

(in_resort VARCHAR,
in_from_date DATE,
in_number_of_days NUMBER,
out_msg VARCHAR)

Example 1:

Fetch future data for property ODH from current business date for 365 days.

declare

vResult VARCHAR2(200);

begin

v5i_block.get_block_date( 'ODH', pms_p.business_date(), 365, vResult );

If vResult = 'SUCCESS' then

--- query the temp_v5i_blockinfo and temp_v5i_blockdata tables.

end if;

end;

Example 2:

Fetch data for property ODH from current business date for the past 100 days.

declare

vResult VARCHAR2(200);

begin

v5i_block.get_block_date( 'ODH', pms_p.business_date()-100, 100, vResult );

If vResult = 'SUCCESS' then

--- query the temp_v5i_blockinfo and temp_v5i_blockdata tables.

end if;

end;

Note: Past data might be affected by purge routines and depends on individual property settings.

Table Structures

temp_v5i_blockinfo

Field	Data Type	Notes
HOTELCODE	VARCHAR2(20)	Property code
GROUPID	NUMBER	Unique group ID
BLOCKCODE	VARCHAR2(20)	Group code
GROUPNAME	VARCHAR2(20)	Group description
MASTERGROUPID	NUMBER	Master group ID
STATUS	VARCHAR2(20)	PMS booking status
MKTSEG	VARCHAR2(20)	Market segment
ARRDATE	DATE	Arrival date
DEPDATE	DATE	Departure date
INSERT DATE	DATE	Booking creation date
GROUPTYPE	VARCHAR2(1)	T=Transient, G=Group

Note: Only blocks designated as Deduct-from-inventory are included in the export. The STATUS field will contain OPERA ALLOTMENT$HEADER field BOOKING_STATUS (e.g., OPT, DEF, ACT, etc.).

temp_v5i_blockdata

Field	Data Type	Notes
HOTELCODE	VARCHAR2(20)	Property code
GROUPID	NUMBER	Unique group ID
BLOCKDATE	DATE	Occupancy date
FORECAST	NUMBER	Forecast/original number of rooms
RMTYPECODE	VARCHAR2(20)	Room type code
BLOCK	NUMBER	Blocked number of rooms
PICKUP	NUMBER	Picked up number of rooms
SGLOCC	NUMBER	Blocked rooms single occupancy
DBLOCC	NUMBER	Blocked rooms double occupancy
TPLOCC	NUMBER	Blocked rooms triple occupancy
QUADOCC	NUMBER	Blocked rooms quadruple occupancy
EXTRAOCC	NUMBER	Blocked rooms additional occupancy
SGLRTE	NUMBER	Single occupancy rate
DBLRTE	NUMBER	Double occupancy rate
TPLRTE	NUMBER	Triple occupancy rate
QUADRTE	NUMBER	Quadruple occupancy rate
EXTRARTE	NUMBER	Additional occupancy rate