RoomMaster Inside Availability Data Formats
Galileo International
Leisure Rates
Phase I
Data Formats
For Inside Availability and Rules
March 16, 2005
Version 4.2
Ellen Brayford
DRAFT COPY
Galileo International Confidential
CONTENTSPAGE
DOCUMENT REVISION HISTORY2
PURPOSE3
GENERAL NOTES3
INSIDE AVAILABILITY AND RULES HEADER INFORMATION 4
HOC - HOTEL COMPLETE AVAILABILITY REQUEST (GDS TO HRS)5
HOC - HOTEL COMPLETE AVAILABILITY RESPONSE (HRS TO GDS)6
HOC - HOTEL COMPLETE AVAILABILITY ERROR RESPONSE (HRS TO GDS)7
HOV - HOTEL VIEW RULES REQUEST (GDS TO HRS)8
HOV - HOTEL VIEW RULES RESPONSE (HRS TO GDS) 9
HOV - HOTEL VIEW RULES ERROR RESPONSE (HRS TO GDS)11
APPENDIX I – HOC RESPONSE EXAMPLES (HRS TO GDS)12
APPENDIX II – HOV RESPONSE EXAMPLES (HRS TO GDS)13
DOCUMENT REVISION HISTORY
Date / Page(s) / Updates09/13/04 / 6 / Correct BI indicators
03/16/05 / 6, 9 / Corrected references to RE that should be TR. Added headings, footers and page numbers. Corrected the table of contents.
PURPOSE
This document details the changes to the data records passed between Galileo International Global Distribution System (GDS) and a Hotel Reservation System (HRS). These formats presume that the HRS has already implemented the Inside Availability product.
These changes are to upgrade the Galileo hotel requests and the HRS responses to verify that accommodations exist and quoted rates are for more than 2 people in a room.
GENERAL NOTES
Unless otherwise indicated, EBCDIC Hex values are listed for text characters. In some instances a different special character may be sent due to Communications software translation issues. The end-item character (Cross-of-Lorraine or vertical bar) has EBCIDIC value hex 4F. It translates to ASCII value 5C or the backslash (\).
Use 3 character currency codes when displaying values in text (e.g. 30.00 USD). Avoid imbedded $'s.
Header Information has fixed length data fields. Specific Information has variable length data fields. Maximum length of variable length fields is provided. Variable length fields may have less information than the guideline.
On subsequent pages, the field types are:
Field Type / Definition GDS to HRS / Definition HRS to GDSM - Mandatory / Field sent in every request. / Field must be returned or processing will error.
R - Required / N/A / Field contains required data, however processing will complete if not supplied.
A - Applicable / Field sent when information is available or if it applies to the request. / Field returned when information is available or if it applies to the request.
INSIDE AVAILABILITY AND RULES MESSAGE APPLICATION HEADER INFORMATION
The Application Header Information section of HOC and HOV transmissions is separate from the Communications Header. The Application Header from/to the GDS has a fixed length of 46 bytes and always precedes the "MS" field of the Specific Data section. The format for all transmissions is the same. All fields are Mandatory. The contents of the Specific Data Count field will vary according to the length of the message.
Header Information (Fixed):
LengthData
26Galileo International ADE Header (See below.)
5Spares
3HRS (2 char Hotel Chain Code, blank 3rd character)
2Source System
1V - Apollo GDS
1G - Galileo GDS
6LNIATA
4Specific Data Count
Includes the number of characters from the start of the Specific Data Count field through the end of the last variable length field in the Specific Data section. Does not include End-of-Message or End-of-Transmission.
Galileo International Application Data Exchange (ADE) Header Format:
The contents of the ADE header are for the GDS's use. The HRS should return the ADE header intact.
LengthDataSetting
2Length of ADE header26
2Key38
2IdentifierVR
2Unique Key01
1Request Type (Requester/Server)R
2Request Version Number00
1Response Type (Requester/Server.)R
2Response Version Number00
4Length of Data, not including ADE header0000
8Data Exchange NameHOCbbbbb or HOVbbbbb, "b"= blank.
HOC - HOTEL COMPLETE AVAILABILITY REQUEST (GDS TO HRS)
There are no changes to the HOC request format. It is reiterated below for reference purposes.
MaxField
LengthTypeIDData
5MMSAction Code
"HOC" - Hotel Complete Availability Request
3MBDDestination System (Same as HRS in Header)
5MPNProperty Number
3ACTAgent's City Code
2ACOAgent's ISO Country Code
19ABSBooking Source (ARC/IATA Number)
5MINIn-Date
5MOTOut-Date
1MNONumber of Adults
25ACDCorporate Discount Number (Max 3)
7ARRRate Requested/Booking Code (Max 8)
30AMIMore Information Storage
3MCCCurrency Code Requested
23ASQSearch Qualifiers (Max 15)
HOC - HOTEL COMPLETE AVAILABILITY RESPONSE (HRS TO GDS)
Internal RoomMaster Dsect: HOAHO
Specific Data (Variable):
The format for each field is Length (2 bytes), ID (2 bytes), and Data (variable length). "MS" must appear after the Specific Data Count in the fixed header section. Other fields are expected in the following order.
MaxField
LengthTypeIDData
5MMSAction Code
"HOCER" - HOC Availability Returned
2MVRVersion number for the HOC response(must be version ‘01’)
30N/AMIMore Information Storag[VS1]e
3MCCCurrency Code for Rates
1MDPDecimal Places for Rates (Values are 0-3.)
1MNONumber of Adults Allowed for Quoted Rates
36AMMMarketing Message
Rate item fields may occur multiple times and must appear in this order:
7MRRRate Requested Code (Must be an alphanumeric Booking Code.)
2APTThis field identifies the following RE. Options are as follows:
PN = Nightly Rate
9MRERate Amount (Does not include decimal, i.e. "05RE19500".)
8ABIBooking Code Indicators:
Char 1 - Rate Changes during Stay (Y/N)
Char 2 - Rate Available via I.A. Only (Y/N)
Char 3 - Invalid CD # Stored in RoomMaster (Y/N)
Char 4-6 Spares
Char 7 - Room Type on Request
Char 8 Spare
2RPTIf this field is present, it identifies the following TR. Total
options are as follows:
AP = Approximate Total Plus (Fully Loaded)
AT = Approximate Total
9RTRRate Amount (Does not include decimal, i.e. "05TR20823".)
25ACDCorporate ID number (Max 1, See Note 1.)
47MRDRate Description (Max 3)
HOC - HOTEL COMPLETE AVAILABILITY ERROR RESPONSE (HRS TO GDS)
There are no changes to the HOC error response format. It is reiterated below for reference purposes.
MaxField
LengthTypeIDData
5MMSAction Code:
"ERN" - Error
9MERError Number must be one of the following:
"532" - No response from HRS; default to RoomMaster MVS info.
"600" - General HOC Error; default to RoomMaster MVS info.
"601" - Hotel Requested Not Available
"602" - Past Hold Time (Failed HRS's booking rule.)
"603" - Closed to Arrival
"604" - Minimum Length of Stay Restriction (Failed HRS's rule.)
"605" - Maximum Length of Stay Restriction (Failed HRS's rule.)
“606” – Property Does Not Support Requests for this Number of Adults.
HOV - HOTEL VIEW RULES REQUEST (GDS TO HRS)
There are no changes to the HOV request format. It is reiterated below for reference purposes.
MaxField
LengthTypeIDData
5MMSAction Code
"HOV" - Hotel View Rules Request
3MBDDestination System (Same as HRS in Header)
5MPNProperty Number
3ACTAgent's City Code
2ACOAgent's ISO Country Code
19ABSBooking Source (ARC/IATA Number)
5MINIn-Date
5MOTOut-Date
1MNONumber of Adults
25ACDCorporate ID number (Max 1, See Note 1.)
7MRRBooking Code
30N/AMIMore Information Storage
3MCCCurrency Code Requested
23ASQSearch Qualifiers (Max 15)
30ACFConfirmation Number for HOV from Sold Segment
HOV - HOTEL VIEW RULES RESPONSE (HRS TO GDS)
Internal RoomMaster Dsect: HOCHO
Specific Data (Variable):
The format for each field is Length (2 bytes), ID (2 bytes), and Data (variable length).
"MS" must appear after the Specific Data Count in the fixed header section. Other fields are expected in the following order.
Unlimited lines of "Text" information are allowed, except as indicated.
MaxField
LenTypeIDData
5MMSAction Code must be one of the following:
"HOVER" - HOV Rules Information Returned
2MVRVersion number for the HOV response(must be version ‘01’)
30N/AMIMore Information Storage (See Note 8.)
25RADProperty Address (Max 2)
21RPHPhone number
21RFXFax number (State "No Fax" if number not available.)
Promotional Information
64AG3Promotional Text
Rate Information
64MRDRate Description Text
3MCCCurrency Code for Rates
1MDPDecimal Places for Rates (Values are 0-3)
1MNONumber of Adults Allowed for Quoted Rates
Pricing Type through Rate Comment fields may occur multiple times (max 99) and must appear in the following order before the total.
2APTThis field identifies the following RE. Options are as follows:
PN = Nightly Rate
9MRERate Amount (Does not include decimal, i.e. "05RE11500".)
40RF0Rate Comment
Only one total is required. If there is no approximate total, a sub total should be returned. If an approximate total is returned, a sub total is not necessary.
2RPTIf this field is present, it identifies what the rate in the following TR
represents. Options are as follows:
AP = Approximate Total Plus
AT = Approximate Total
ST = Sub Total (total for stay without taxes, fees or extra charges)
9RTRRate Amount (Does not include decimal, i.e. "05TR12349".)
40RF0Rate Comment for the total
64MRIRoom Rate Indicator Text
64AF1Inclusions Text (List items included in the rate, i.e. breakfast)
Rule Information
64RF2Guarantee Text
64RF4Deposit Text
64RF3Cancellation Text
64RF5Other Rules Text
Room Information
64AF6More Detailed Room Description Text
Extra Charges
64RF7Extra Charges Text
Package Options
64AF8Package Options Text
Property Information
64RF9Property Description Text
Property Location
64RG0Property Location Text
Miscellaneous Information
64AG1Miscellaneous Text
HOV - HOTEL VIEW RULES ERROR RESPONSE (HRS TO GDS)
There are no changes to the HOV error response format. It is reiterated below for reference purposes.
MaxField
LengthTypeIDData
5MMSAction Code:
"ERN" - Error
9MERError Number may be one of the following:
"532" - No Response from Vendor
"620" - Vendor Response Error
"621" - No Rules Information for Booking Code/Date Requested
APPENDIX I - HOC Examples:
Old format for reply to HOC12APR-2NT36324 - RD vendor in LAX.
2638VR01R00R000000HOC...... RD.1V04062B184505MSHOCER03CCUSD01DP201NO1
35MMSEE..HOV..FOR.FULL.RATE.INFORMATION07RRIA0005505RE1290007BINNNNNNN
45RDBUSINESS.CLASS.ROOM-BRKFST-COFFEE-MOVIEPAPER07RRIA0011304RE9900
07BINNNNNNN14RDCORPORATE.RATE07RRIA0011404RE790007BINYNNNNN24RDDESTINATION.RADISSON.LAX13RDSPECIAL.RATE07RRIA0005604RE820007BINNNNNNN16RDSUPER.SAVER.RATE07RRIA0004405RE1890007BINNNNNNN26RD1D-NSK-STANDARD.GUEST.ROOM
07RRIA0005105RE2090007BINNNNNNN21RD1K-NSK-EXECUTIVE.ROOM
Proposed response with added data formats for Phase I
2638VR01R00R000000HOC...... RD.1V04062B184505MSHOCER02VR0103CCUSD01DP201NO135MMSEE..HOV..FOR.FULL.RATE.INFORMATION07RRIA0005502PTPN05RE12900
07BINNNNNNN02PTAT05TR2783945RDBUSINESS.CLASS.ROOM-BRKFST-COFFEE-MOVIE-PAPER07RRIA0011302PTPN04RE990007BINNNNNNN02PTAT05TR2081414RDCORPORATE.RATE07RRIA0011402PTPN04RE790007BINYNNNNN02PTAT05TR1723824RDDESTINATION.RADISSON.LAX13RDSPECIAL.RATE07RRIA0005602PTPN04RE820007BINNNNNNN02PTAT05TR1804516RDSUPER.SAVER.RATE07RRIA0004402PTPN05RE1890007BINNNNNNN02PTAT05TR3814526RD1D-NSKSTANDARD.GUEST.ROOM07RRIA0005102PTPN05RE2090007BINNNNNNN
02PTAT05TR4308521RD1K-NSKEXECUTIVE.ROOM
APPENDIX II - HOV Examples:
Current reply sent today from the hotel to GDS for one night:
2638VR01R00R000000HOV...... RD.1V040627185605MSHOVER22AD6225.
WEST.CENTURY.BLVD14ADLOS.ANGELES.CA12PH310.670.900012FX310.670.7
85236G3YOU.COULD.EARN.1290.POINTS.WITH.THIS11G3RESERVATION58RD..
IA00055....BUSINESS.CLASS.ROOM-BRKFST-COFFEE-MOVIE-PAPER03CCUSD0
1DP201NO105RE1290037F0PER.NIGHT.STARTING.12.APR.FOR.1.NIGHT05RE1
290037F0TOTAL.STAY.-.AVERAGE.129.00.PER.NIGHT54RI.EXCLUDES.TAX..
EXCLUDES.GRATUITY..10.PCT.COMM..1.ADULT10F1.INCLUDES-37F1.-COMPL
IMENTARY.FULL.BREAKFAST.BUFFET42F1.-COMPLIMENTARY.HIGH
SPEED.INTERNET.ACCESS47F1.-COMPLIMENTARY.LOCAL.TELEPHONE.
CALLS.AND.FAXES36F1.-ONE.COMPLIMENTARY.MOVIE.EACH.NIGHT
56F1.EXECUTIVE.ROOM.-COMPLETELY.RENOVATED ROOM.-WITH.ALL.
NEW57F1.FURNISHINGS.-PILLOW.TOP.MATTRESSES.AND.MARBLE-GRANITE.IN59F1.BATHROOM.-OVERSIZED.DESK.WITH.ERGONOMIC.CHAIR.-TWO.-2.LINE59F1.PHONES.WITH.DATAPORT.AND.SPEAKERPHONE.-HIGH.
SPEED.INTERNET28F1.ACCESS.-AVAILABLE.FOR.A.FEE39
F2.GUARANTEE...MUST.GTD.TO.AX.DC.DS.MC.VI45F3.CANCEL..CXL.BY..4P
M.DAY.OF.ARRIVAL.NO.CHARGE36F3.LATE.CXL.OR.NO.SHOW.1.NITE.PLUS.TAX41F5.CHECK-IN-15-00.CHECK-OUT-12-00.EXPRESS-Y5
Proposed response with added data formats for Phase I:
2638VR01R00R000000HOV...... RD.1V040627185605MSHOVER02VR0122AD6225.WEST.CENTURY.BLVD14ADLOS.ANGELES.CA12PH310.670.900012FX310.670.7852
36G3YOU.COULD.EARN.1290.POINTS.WITH.THIS11G3RESERVATION58RD..IA00055....BUSINESS.CLASS.ROOM-BRKFST-COFFEE-MOVIE-PAPER03CCUSD01DP201NO102PTPN
05RE1290037F0PER.NIGHT.STARTING.12.APR.FOR.2.NIGHT02PTAT05TR27839
49F0APPROXIMATE.TOTAL.FOR.STAY.WITH.TAX.AND.GRATUITY.54RI.10.PCT.COMM..1.ADULT10F1.INCLUDES-37F1.-COMPL
IMENTARY.FULL.BREAKFAST.BUFFET42F1.-COMPLIMENTARY.HIGH
SPEED.INTERNET.ACCESS47F1.-COMPLIMENTARY.LOCAL.TELEPHONE.
CALLS.AND.FAXES36F1.-ONE.COMPLIMENTARY.MOVIE.EACH.NIGHT
56F1.EXECUTIVE.ROOM.-COMPLETELY.RENOVATED ROOM.-WITH.ALL.
NEW57F1.FURNISHINGS.-PILLOW.TOP.MATTRESSES.AND.MARBLE-GRANITE.IN59F1.BATHROOM.-OVERSIZED.DESK.WITH.ERGONOMIC.CHAIR.-TWO.-2.LINE59F1.PHONES.WITH.DATAPORT.AND.SPEAKERPHONE.-HIGH.
SPEED.INTERNET28F1.ACCESS.-AVAILABLE.FOR.A.FEE39
F2.GUARANTEE...MUST.GTD.TO.AX.DC.DS.MC.VI45F3.CANCEL..CXL.BY..4P
M.DAY.OF.ARRIVAL.NO.CHARGE36F3.LATE.CXL.OR.NO.SHOW.1.NITE.PLUS.TAX41F5.CHECK-IN-15-00.CHECK-OUT-12-00.EXPRESS-Y
Proposed response with added data formats for Phase I –
5 nights rate change during stayand no approximate total
2638VR01R00R000000HOV...... RD.1V040627190705MSHOVER02VR0122AD6225.WEST.CENTURY.BLVD14ADLOS.ANGELES.CA12PH310.670.900012FX310.670.7852
36G3YOU.COULD.EARN.6650.POINTS.WITH.THIS11G3RESERVATION58RD..
IA00055....BUSINESS.CLASS.ROOM-BRKFST-COFFEE-MOVIE-PAPER03CCUSD01DP2
01NO102PTPN05RE1290038F0PER.NIGHT.STARTING.12.APR.FOR.4.NIGHTS02PTPN
05RE1490037F0PER.NIGHT.STARTING.16.APR.FOR.1.NIGHT02PTST05TR66500
37F0TOTAL.STAY.-.AVERAGE.133.00.PER.NIGHT
54RI.EXCLUDES.TAX..EXCLUDES.GRATUITY..10.PCT.COMM..1.ADULT10F1.INCLUDES-36F1.COMPLIMENTARY.FULL.BREAKFAST.BUFFET42F1.COMPLIMENTARY.HIGHSPEED.INTERNET.ACCESS47F1.-COMPLIMENTARY.LOCAL.TELEPHONE.
CALLS.AND.FAXES36F1.-ONE.COMPLIMENTARY.MOVIE.EACH.NIGHT
56F1.EXECUTIVE.ROOM.-COMPLETELY.RENOVATED.ROOM.-WITH.ALL.NEW57F1.FURNISHINGS.PILLOW.TOP.MATTRESSES.AND.MARBLE-GRANITE.IN59F1.BATHROOM.OVERSIZED.DESK.WITH.ERGONOMIC.CHAIR.-TWO.-2.LINE59F1.PHONES.WITH.DATAPORT.AND. SPEAKERPHONE.-HIGH.SPEED.INTERNE T28F1.ACCESS.-AV AILABLE.FOR.A.FE E39F2.GUARANTEE. ..MUST.GTD.TO.AX .DC.DS.MC.VI45F3 .CANCEL..CXL.BY. .4PM.DAY.OF.ARRIVAL.NO.CHARGE36F3.LATE.CXL.OR.NO.
SHOW.1.NITE.PLUS.TAX41F5.CHECK-IN-15-00.CHECK-OUT-12-00.EXPRESS-Y
1
Galileo International Confidential
[VS1]1