HOTELS BULK DATA RECORD DESCRIPTIONS
9 December, 2003
ROOMMASTER BULK DATA PRODUCT IS DESIGNED TO ALLOW SPECIFIC DATA FIELDS TO BE ADDED, CHANGED, OR DELETED. THE BULK DATA USER SHOULD USE THE ADD, CHANGE, AND DELETE FUNCTION VS SENDING A COMPLETE REPLACEMENT SET OF DATA. THIS RULE SHOULD BE USED ESPECIALLY WHEN UPDATING RULES AND RATES.
TO MAINTAIN AN EFFIENCENT DATABASE, TO MAXIMUMIZE PERFORMANCE, AND TO REDUCE UNNECCESSARY DATA, RULES SHOULD BE LOADED AT THE HIGHEST LEVEL POSSIBLE. IF A RULE APPLIES TO THE ENTIRE OR THE MARJORITY OF THE PROPERTIES IN A CHAIN THE RULE SHOULD BE ENTERED AT THE CHAIN LEVEL AND NOT AT THE PROPERTY LEVEL. IF RULES APPLY TO MULTIPLE PROPERTIES THE SAME RULE NUMBER SHOULD BE USED FOR ALL THE PROPERTIES IT APPLIES, VS THE SAME RULE BEING LOADED FOR EACH PROPERTY.
GALILEO INTERNATIONAL RESERVES THE RIGHT TO IMPOSE SYSTEM LIMITS AND/OR THROTTLE DATA COMING INTO THE SYSTEM THAT WE DETERMINE IS NEGATIVELY
IMPACTING SYSTEM PERFORMANCE. THE PRACTICE OF DELETES FOLLOWED BY ENTIRE REPLACES SHOULD NOT BE DONE. UPDATES OF THE NECESSARY INFORMATION IN EACH RECORD TYPE IS THE CORRECT PROCEDURE.
GENERAL INFORMATION
The following codes will be used in this document:
C = Character
N = Numeric
CONTENTS
CONTENTS......
SUBSCRIPTION HEADER RECORD......
CHAIN POLICY RECORD - (GENL)......
CHAIN POLICY RECORD - (RULE)......
CHAIN POLICY RECORD - (FREE FORM TEXT)......
PRIMARY HOTEL RECORD......
SECONDARY HOTEL RECORD......
INDEX RECORD......
DEPOSIT/GUARANTEE RECORD......
RESERVATION RULE RECORD......
EXTRA OPTIONS RULE RECORD......
CANCELLATION PENALTY RULE RECORD......
METHOD OF PAYMENT RULE RECORD......
LENGTH OF STAY RULE RECORD......
ROOM DESCRIPTION RULE RECORD......
CHECK-IN/OUT TIMES RECORD......
POINT OF SALE RULE RECORD......
RULE CONNECTION RECORD......
RATE CODE RECORD......
RATE AMOUNT RECORD......
APPENDIX A......
STATE AND PROVINCE CODES......
APPENDIX B......
COUNTRY CODES......
APPENDIX C......
CREDIT CARD CODES......
APPENDIX D......
PHONE & ADDRESS RULES......
HOTELS BULK DATA RECORD DESCRIPTIONS
SUBSCRIPTION HEADER RECORD
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
The Subscription Header record is a mandatory record for all transmissions and must be the first record on the file.
If this record does not exist, or if any fields do not validate correctly, the entire file will be discarded.
(This is the only mandatory record in the file.)
SYSTEM
IDENTIFIER Identifies which subsystem is C 1 2 HT = Galileo Hotels
being transmitted.
VENDOR CODE The industry vendor code. C 3 3 Example: AS = Apollo Suites
The third position is reserved for
future expansion.
DATE File creation date. N 6 6 YYMMDD format
TIME File creation time. N 12 4 HHMM format
RECORD COUNT The total number of records in N 16 6 000000 - 999999
the file, excluding the header
record.
RECORD LENGTH 21 BYTES
HOTELS BULK DATA RECORD DESCRIPTIONS
CHAIN POLICY RECORD - (GENL)
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
Chain Policy 'GENL' records will be processed according to the date logic as defined in the APOLLO Hotels Vendor
Functional Specification document.
RECORD TYPE Indicates record type. C 1 1 A = Chain Policy Record
ACTION CODE The type of processing to C 2 1 U = Update, creates new record or
be applied to this record. modifies an existing record.
D = Delete, removes specific
record when EFFECTIVE and
DISCONTINUE dates match.
Removes all records when dates
are zero.
VENDOR CODE The industry vendor code. C 3 3 Example: AS = Apollo Suites
The third position is reserved for
future expansion.
EFFECTIVE DATE The date the record becomes N 6 8 YYYYMMDD format
effective
DISCONTINUE DATE The last date the record is N 14 8 YYYYMMDD format
effective 99999999 = No discontinue date.
KEYWORD IDENTIFIER A four position code which C 22 4 GENL
identifies this Chain Policy
Record
CORPORATE NAME The corporate name associated C 26 40 Free form text.
with the vendor.
FILLER C 66 6 blanks
BROCHURE TEXT Free form text for marketing C 72 64 Free form text.
display purposes.
HOTELS BULK DATA RECORD DESCRIPTIONS
CHAIN POLICY RECORD - (GENL)
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
RESERVATION RULE A pointer to a Reservation Rule N 136 5 00000-65535 Rule must exist.
POINTER Record. Can be overridden by
Reservation Rule pointers in the
Primary Property Record.
EXTRA OPTIONS A pointer to an Extra Options N 141 5 00000-65535 Rule must exist.
RULE POINTER Record. Can be overridden by
Extra Options pointers in the
Rule Connection Records.
CANCELLATION PENALTY A pointer to a Cancellation N 146 5 00000-65535 Rule must exist
RULE POINTER Penalty Record. Can be
overridden by Cancellation
Penalty pointers in the
Rule Connection Records.
METHOD OF PAYMENT A pointer to a Method of Payment N 151 5 00000-65535 Rule must exist.
RULE POINTER Record. Can be overridden by
Method of Payment pointers in the
Primary Property Record.
DEPOSIT/GUARANTEE RULE A pointer to a Deposit/Guarantee N 156 5 00000-65535 Rule must exist
POINTER Record. Can be overriden by
Deposit/Guarantee Pointer in the
Rule Connection Record.
Record Length = 160 bytes
HOTELS BULK DATA RECORD DESCRIPTIONS
CHAIN POLICY RECORD - (RULE)
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
Chain Policy 'RULE' records will be processed according to the date logic as defined in the APOLLO Hotels Vendor
Functional Specification document.
RECORD TYPE Indicates record type. C 1 1 A = Chain Policy Record
ACTION CODE The type of processing to be C 2 1 U = Update, creates new record
applied to this record. or modifies an existing record.
D = Delete, removes specific record
when EFFECTIVE and DISCONTINUE
dates match. Removes all records
when dates are zero.
VENDOR CODE The industry vendor code. C 3 3 Example: AS = Apollo Suites
The third position is reserved
for future expansion.
EFFECTIVE DATE The date the record becomes N 6 8 YYYYMMDD format
effective.
DISCONTINUE DATE The last date the record is N 14 8 YYYYMMDD format
effective. 99999999 = No discontinue date.
KEYWORD IDENTIFIER A four byte code which identifies C 22 4 RULE
this Chain Policy Record.
RULE TAGS Tags which indicate how the vendor
will handle a reservation.
1. Written Confirmation Provided C 26 1 X = Yes blank = No R = Upon
2. Cancellation Number Provided C 27 1 X = Yes blank = No Request
3. Corporate Identification C 28 1 X = Yes blank = No
Required
Filler C 29 5 blanks
ROOM STATUS AT Indicator which defines how a new C 34 1 O = Open
LOAD room type should be handled when C = Closed
loaded into Apollo Hotels until its N = Upon Request
status is designated.
MAXIMUM NUMBER OF Indicates the maximum number of N 35 3 001-999
ROOMS PER SEGMENT rooms an agent can sell in one Apollo max is 9
booking segment.
NUMBER OF The number of consecutive days N 38 3 001-999
CONSECUTIVE DAYS for which a reservation can be Apollo max is 99
PER RESERVATION booked for a room.
CHECK-IN TIME Earliest time allowed to check C 41 4 Military Time
in to hotel.
HOTELS BULK DATA RECORD DESCRIPTIONS
CHAIN POLICY RECORD - (RULE)
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
CHECK-OUT TIME Latest time the customer may C 45 4 Military time
check out of the hotel
Record Length = 48 bytes
HOTELS BULK DATA RECORD DESCRIPTIONS
CHAIN POLICY RECORD - (FREE FORM TEXT)
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
Chain Policy text records will be processed in a 'replace all' mode. For each date range / keyword transmitted, any
existing text will first be deleted, then the new text will be sequentially loaded. The text for release dated keywords
can be updated or deleted separately from the original text.
RECORD TYPE Indicates record type. C 1 1 A = Chain Policy Record
ACTION CODE The type of processing to be C 2 1 U = Update, creates new keyword group
applied to this record. or replaces an existing group of
text records.
D = Deletes selected records. *
* Removes specific keyword group date range when EFFECTIVE and DISCONTINUE dates
match. Zeros in both EFFECTIVE and DISCONTINUE dates will remove ALL date
ranges for keyword group. If a release dated record exists, a match on the
RELEASE date will delete only the release dated record, while zeros in the
RELEASE date will delete both the original and release dated records.
VENDOR CODE The industry vendor code. C 3 3 Example: AS = Apollo Suites
The third position is reserved for
future expansion.
EFFECTIVE DATE The date the record becomes effective N 6 8 YYYYMMDD format
DISCONTINUE DATE The last date the record is N 14 8 YYYYMMDD format
effective. 99999999 = No discontinue date.
KEYWORD IDENTIFIER A four byte code which is an C 22 4 ADDR = Corporate Address
abbreviated keyword. The specified CLUB = Club
codes are standard keywords. CANC = Cancellation Data
Additional vendor defined keywords COMM = Commission
may be transmitted after Galileo approves CONT = Contacts
and sets them up in the database. CONV = Convention Facilities
. . CORP = Corporate Rates
All keyword identifier records are free CRED = Credit Policies
form text records, with the exception of DPST = Deposit Policy
'GENL' and 'RULE' records, which are FAMI = Family Plan
formatted records. FREQ = Frequent Traveler Participation
GENL = Corporate Name, Corporate Phone,
Only the first 5 'ADDR' records will be and Pointers to Rules records.
loaded to the database. . GRPS = Group-Special Information
GUAR = Guarantee Policy
Other keywords may be used if they are HELP = Customer Service; Problem Solving
defined in the online system HOUR = Hours of Operation
INDX = Index
INTL = International Travel
HOTELS BULK DATA RECORD DESCRIPTIONS
CHAIN POLICY RECORD - (FREE FORM TEXT)
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
LINK = Inside Link
NEWS = News
( con't) PLCY = Policies of Hotel Chain
PREP = Prepayment Policy
PROM = Promotional Information
PYMT = Form of Payment
ROOM = Room / Unit Types
RULE = Rule
TRVL = Travel Industry Information
WKND = Weekend Rates
RELEASE DATE The date the record is released N 26 8 YYYYMMDD format
to APOLLO. Zeros if not applicableIt takes two records to CHANGE the release
date. Enter ALL ZEROS,(0) in the first record to identify the keyword that you wish. to update. The second release date record should contain the new release date.
SYSTEM GENERATED An indicator which requires the C 34 1 X = Yes blank = No
TEXT * system to programmatically Applicable keywords are: generate text from data contained in rules and other records CNCL GUAR PLCY
LINE NUMBER Sequential number to N 35 3 001-999
organize the free form text.
TEXT Free form text related to C 38 64 Free form text.
the keyword identifier.
* If this field is a valid keyword, all date-effective text for that keyword
will be deleted, and only one date range will be created, that being the effective
and discontinue dates supplied on the current Chain Policy Record.
Release Date and System Generated Text will be loaded from the line 001 record only.
Record Length = 101 bytes
HOTELS BULK DATA RECORD DESCRIPTIONS
PRIMARY HOTEL RECORD
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
Primary Hotel records will no longer be date effective. Date effective connections to rules will be handled by record type
R. Unless otherwise noted, all data must be included. Updates will not be allowed for a property that is marked for deletion.
RECORD TYPE Indicates record type. C 1 1 B = Primary Hotel Record
ACTION CODE The type of processing to be C 2 1 U = Update, creates new record or
applied to this record. modifies an existing record.
D = Deletes property. No updates will be
at the same time.
VENDOR The industry vendor code. C 3 3 Example: AS = Apollo Suites
The third position is reserved
for future expansion.
EFF DATE Not Used N 6 8 Zeros
DISCONTINUE DATE Not Used N 14 8 Zeros
PROPERTY IDENTIFIER A five position field that C 22 5 Example: WASJW,WAS01,01040
uniquely identifies a property.
FILLER Not used C 27 1 blank
PROPERTY NAME The name of the property. C 28 35 Example: PARADISE RESORT & SPA
SHORT NAME An abbreviated version of the C 63 19 Example: PARADISE RESORT & SPA
property name that will be
displayed in APOLLO. Will be programmatically generated
if this field contains blanks.
COUNTYNAME The county name associated to C 82 40 Free form text.
the city.
HOTELS BULK DATA RECORD DESCRIPTIONS
PRIMARY HOTEL RECORD
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
LOCAL PROPERTY The telephone number of the C 122 17 Example: 703 123-4567REQUIRED FIELD FOR UPDATE
PHONE NUMBER property.
TELEX NUMBER The number to be used for C 139 17 Any valid telex number.
telexing messages to the property. Spaces if not applicable.
TELETYPE NUMBER The teletype number of the C 156 17 Any valid teletype number.
property. Spaces if not applicable.
ANSWER BACK NUMBER The answer back number of the C 173 17 Any valid answer back number.
property. Spaces if not applicable.
FAX NUMBER The FAX number of the property. C 190 17 Any valid FAX number.
Spaces if not applicable.
TIME ZONE INDICATOR Three position time zone C 207 3 Examples: EST Eastern Standard Time
indicator code. EDT Eastern Daylight Time
GMT Greenwich Mean Time
ZIP CODE Postal ZIP code of the property. C 210 10 Any valid ZIP code.
Spaces if not applicable.
LATEST CHECK IN TIME The latest time to check into the N 220 4 Time of day in hours and minutes
room without a guarantee. (HHMM) 0001-2400 Zeros if not used.
Dpst/Guar required must be blank if used
Blank = No change (default to zero on add)
NUMBER OF ROOMS Indicates the number of rooms at N 224 5 00000-99999
the property. Blank = No change (default to zero on add)
NUMBER OF SUITES Indicates the number of suites at N 229 5 00000-99999
the property. Blank = No change (default to zero on add)
NUMBER OF UNITS Indicates the number of units at N 234 5 00000-99999
the property. Blank = No change (default to zero on add)
NUMBER OF FLOORS Indicates the number of floors at N 239 3 000-999
the property. Blank = No change (default to zero on add)
HOTELS BULK DATA RECORD DESCRIPTIONS
PRIMARY HOTEL RECORD
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
CONFERENCE ROOM The maximum number of people the N 242 5 00000-99999
CAPACITY conference facilities will Blank = No change (default to zero on add)
accommodate.
YEAR BUILT Indicates the year the property N 247 4 YYYY = 1980
was built. Blank = No change (default to zero on add)
YEAR REMODELED Indicates the year the property N 251 4 YYYY = 1986
was remodeled, if applicable. Blank = No change (default to zero on add)
DPST/GUAR REQUIRED A tag indicating if a reservation C 255 1 'G' = Yes, the property requires a
requires a guarantee or a deposit. guarantee at time of booking.
'D' = Yes, the property requires a
deposit at the time of booking.
' ' = No, property does not require
a guarantee or a deposit.
RESERVATION LEAD The number of days in advance N 256 2 00-99
TIME a booking is needed (the Blank = No change (default to 99 on add)
required lead time.) An agency
cannot book a reservation if the
number of days from booking is
less than the advance reservation
time.
FIXED COMMISSION RATE The fixed rate paid by a Vendor N 258 9 0-999999999
as a commission to the reservation The decimal position is defined
agent/agency. by the Currency Code in the
Apollo Directory. If the fixed
commission is not applicable, zeroes
should be in this field.
PERCENTAGE COMMISSION The percentage rate paid by a N 267 9 Format is xxx.xxxxxx
RATE vendor as a commision to the (e.g. 009.500000 = 9 1/2% with
reservation agent/agency. the decimal position being an implied
value of '6'.
DEFAULT CURRENCY CODE A three position code which C 276 3 See Appendix B for typical values.REQUIRED FIELD FOR UPDATE
reflects the principal currency The online RoomMaster Directory will
unit of the Rate Record(s) for contain all valid codes.
this property. Blank = No change (error on add).
HOTELS BULK DATA RECORD DESCRIPTIONS
PRIMARY HOTEL RECORD
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
TAXES INCLUDED A switch to indicate how the city, C 279 1 X = Yes
state, and country tax fields are space if not applicable
applied to the Rate record.
FILLER C 280 1 blanks
ALTERNATE RATE The Rate Category to be used during C 281 1 For valid values see Rate Code Record
CATEGORY Day of Week Variations. This on page 48 under the Primary Rate Cat.
field is on this record because all 'N' - Negotiated is not allowed in the
rates must have the same alternate field.
rate category. Blank - No alternate rate category.
FILLER C 282 1 blank
RULE TAGS Tags which indicate how a property
will handle a reservation. Over-
rides corresponding tags on the
Chain Policy (RULE) Record.
1. Written Confirmation Provided C 283 1 X = Yes blank = No R = Upon Request
HOTELS BULK DATA RECORD DESCRIPTIONS
PRIMARY HOTEL RECORD
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
AMENITIES TAGS Positional fields which indicate C X = Yes
if a service is available. A = Available, not onsite
S = Available, in some rooms
$ = Available, for a fee
blank = Not Available
1. Air Conditioning C 284 1
2. Airline Desk C 285 1
3. Child Care C 286 1
4. Balcony C 287 1
5. Childrens Programs C 288 1
6. Hair Salon C 289 1
7. High Speed Internet C 290 1
8. Breakfast C 291 1
9. Car Rental Desk C 292 1
10. Casino C 293 1
11. Coffee Shop C 294 1
12. Children Stay Free C 295 1
13. Computer/Bus Ctr. C 296 1
14. Concierge Desk C 297 1
15. Concierge Level C 298 1
16. Connecting Rooms C 299 1
17. Continental Breakfast C 300 1
18. Dinner C 301 1
19. Efficiencies C 302 1
20. Elevators C 303 1
21. Entertainment C 304 1
22. Family Plan C 305 1
23. Fireplace C 306 1
24. Free Transportation C 307 1
25. Game Room C 308 1
26. Gift Shop C 309 1
27. Golf C 310 1
28. Handicap Facilities C 311 1
29. Health Club C 312 1
30. Microwave Oven C 313 1
31. Kitchen C 314 1
32. Laundry/Valet C 315 1
33. Lounge C 316 1
34. Lunch C 317 1
35. Meal Plan C 318 1
36. Meeting Facilities C 319 1
37. Mini Bar C 320 1
38 Movies In Room C 321 1
39. Multilingual C 322 1
40. Non-Smoking Room C 323 1
41. Parking C 324 1
42. Free Parking C 325 1
43. Small Pets Allowed C 326 1