Bulk Data Record Descriptions.doc
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 1
SUBSCRIPTION HEADER RECORD 2
CHAIN POLICY RECORD - (GENL) 3
CHAIN POLICY RECORD - (RULE) 5
CHAIN POLICY RECORD - (FREE FORM TEXT) 7
PRIMARY HOTEL RECORD 9
SECONDARY HOTEL RECORD 16
INDEX RECORD 18
DEPOSIT/GUARANTEE RECORD 22
RESERVATION RULE RECORD 24
EXTRA OPTIONS RULE RECORD 31
CANCELLATION PENALTY RULE RECORD 34
METHOD OF PAYMENT RULE RECORD 35
LENGTH OF STAY RULE RECORD 37
ROOM DESCRIPTION RULE RECORD 39
CHECK-IN/OUT TIMES RECORD 43
POINT OF SALE RULE RECORD 44
RULE CONNECTION RECORD 46
RATE CODE RECORD 48
RATE AMOUNT RECORD 50
APPENDIX A 53
STATE AND PROVINCE CODES 53
APPENDIX B 54
COUNTRY CODES 54
APPENDIX C 55
CREDIT CARD CODES 55
APPENDIX D 56
PHONE & ADDRESS RULES 56
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 applicable It 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.
COUNTY NAME 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-4567 REQUIRED 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
HOTELS BULK DATA RECORD DESCRIPTIONS
PRIMARY HOTEL RECORD
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
44. Phone Service C 327 1
45 Indoor Pool C 328 1
46. Outdoor Pool C 329 1
47. Porters C 330 1
48. Refrigerator C 331 1
49. Restaurant C 332 1
50. Room Service C 333 1
51. Rm. Style, Orient C 334 1
52. Rm. Style, Western C 335 1
53. In-Room Safe C 336 1
54. Safe Deposit Box C 337 1
55. Sauna C 338 1
56. Secretarial Service C 339 1
57. Shower C 340 1
58. Snow Skiing C 341 1
59. Water Skiing C 342 1
60. Spa C 343 1
61. Tennis Court C 344 1
62. Tour Desk C 345 1
63. Television C 346 1
64. Cable TV C 347 1
65. VCR C 348 1
66. Waterbed C 349 1
67. Private Bath C 350 1
68. Wet Bar C 351 1
69. 120AC C 352 1
70. 120DC C 353 1
71. 220AC C 354 1
72. 220DC C 355 1
73. FAX Service C 356 1
74. Jogging Track C 357 1
75. Sofa Bed C 358 1
76. Photo Copy Service C 359 1
77. Bath Tub C 360 1
78 Fire Safety C 361 1
Filler C 362 4 blanks
PROPERTY TYPE Positional fields which indicate C 366 12 X = Yes
the style of the property. blank = No
(Multiple types may be selected)
1. Hotel C 366 1
2. Motel C 367 1
3. Inn C 368 1
4. All Suites C 369 1
5. Condo C 370 1
6. Villa C 371 1
7. Castle C 372 1
HOTELS BULK DATA RECORD DESCRIPTIONS
PRIMARY HOTEL RECORD
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
8. Pension C 373 1
9. Resort C 374 1
10. Convention C 375 1
11. Bed/Breakfast C 376 1
12. Other C 377 1
Filler C 378 4 blanks
RESERVATION RULE A pointer to a Reservation Rule N 382 5 00000-65535. Rule must exist.
POINTER record. Overrides Reservation Blank = No change (defaults to zero on Add)
Rule pointers in the Chain Policy 00000 = DELETES default reservation rule and
(GENL) record. Can be overridden all reservation rule - point of sale
by Reservation Rule pointers in rule connections.
the Rate record. 00001-65535 REPLACES existing default reservation
rule with new default i.e. 00001-65535, unless
new default duplicates an existing connection
(error). All reservation - point of sale rule
connections remain unchanged.
METHOD OF PAYMENT A pointer to a Method of Payment N 387 5 00000-65535. Rule must exist.
POINTER Rule record. Overrides Method of Blank = No change (defaults to zero on Add)
Payment Rule pointers in the Chain
Policy (GENL) record. Can be
overridden by Method of Payment
Rule pointers in the Rate record.
LENGTH OF STAY POINTER A pointer to a Length of Stay Rule N 392 5 00000-65535. Rule must exist.
record. Can be overridden by Length Blank = No change (defaults to zero on Add)
of Stay pointers in the rate record.
Record length = 396 bytes
HOTELS BULK DATA RECORD DESCRIPTIONS
SECONDARY HOTEL RECORD
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
Secondary Hotel 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 C = Secondary Hotel 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 N 6 8 YYYYMMDD format
effective.
DISCONTINUE DATE The last date the record is N 14 8 YYYYMMDD format
effective. 99999999 = No discontinue date.
PROPERTY IDENTIFIER A five position field that C 22 5 Example: WASJW,WAS10,01040
uniquely identifies a property.
KEYWORD IDENTIFIER A four byte code which is an C 27 4 ADDR = Street Address
abbreviated keyword which CLUB = Club
identifies the type of CANC = Cancellation Data
Secondary Hotel record being COMM = Commission
processed. The text field in CONT = Contacts
the record is free form. CONV = Convention Facilities
CORP = Corporate Rate
Only the first 5 records for CRED = Credit Policies
'ADDR' and 'MAIL' will be DIRS = Directions to Hotel
loaded to the database. DPST = Deposit Policy
EVEN = Special Events
Other keywords, which are not on this list, FACI = Facilities (i.e., restaurant, gift shop, etc)
may be used if they are defined in RoomMaster. FAMI = Family Plans Available
FREQ = Frequent Traveler Participation
GRPS = Group - Special Information
GUAR = Guarantee Policy
HOTELS BULK DATA RECORD DESCRIPTIONS
SECONDARY HOTEL RECORD
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
HELP = Customer Service; problem
solving
LOCA = General Location of Hotel
MAIL = Mailing Address
MEAL = Meal Plans Available
OTHR = Other
PLCY = Policies of Hotel
PREP = Prepayment Policy
PROM = Promotional Information
RECR = Recreation (i.e., Fishing, Golf)
REFR = Referral Program
ROOM = Room / Unit Types
SERV = Services available (i.e., baby-
sitting, valet cleaning, etc.)
TAXS = Tax Information
TRAN = Area Transportation
TRVL = Travel Industry Information
RELEASE DATE The date the record will be N 31 8 YYYYMMDD format Rlse date > today date and < discontinue date. Must match Zeros if not applicable existing range. Next, must be diff from original. Creates a record keyword. **See comments release date A=chain policy keyword
released to APOLLO.
SYSTEM GENERATED An indicator which requires the C 39 1 X = Yes blank = No
TEXT * system to programmatically Applicable keywords are:
generate text from data contained CANC CRED FACI GUAR LOCA
in rules and other records. PLCY RECR ROOM
CHAIN DEFAULT * A Chain Keyword. The text for C 40 4 blanks = No
the Chain Keyword will be used or valid Chain Keyword
at the Property level. (reference Chain Record)
* System Generated Text and Chain Default are mutually exclusive.
No text will be loaded if either field is other than blanks.
If either is used, 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 Secondary Hotel Record.
Release Date, System Generated Text, and Chain Default fields
will be loaded from line 001 record only.
LINE NUMBER Sequential number to organize N 44 3 001-999
the free form text.
TEXT Free form text related to C 47 64 Free form text.
the keyword identifier.
Record length = 110 bytes
HOTELS BULK DATA RECORD DESCRIPTIONS
INDEX RECORD
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
THIS RECORD IS INTENDED TO BE USED TO UPDATE REFERENCE POINT INFORMATION AS IT RELATES TO A PROPERTY. IT MUST BE SENT AFTER A PROPERTY HAS BEEN ADDED TO THE RoomMaster SYSTEM AND THE Galileo AUTO-CONNECT APPLICATION HAS CONNECTED THE PROPERTY TO THE APPROPRIATE REFERNCE POINT. Optional text records can be included, updated, or deleted separately from "header" information as long as the Line 001 data exists. When text is updated, all text lines must be transmitted. This is not a date effective record. A primary index record (Index Type = P) is required for each property.
RECORD TYPE Indicates record type. C 1 1 D = Index 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 selected records. *
* 'U' on Line 1 updates only line 1 and does not affect any existing text.
'U' on Line 2 will create new or replace all existing text records.
'D' on Line 1 will delete all lines (1 through 999).
'D' on Line 2 will delete only text lines (2 through 999).
VENDOR CODE The industry vendor code. C 3 3 Example: AS = Apollo Suites
The third position is reserved for
future expansion.
EFFECTIVE 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,WAS10,01040
uniquely identifies a property.
REFERENCE POINT CODE A reference point name assigned C 27 30 Example: CHI, SFO, ‘John Hancock Tower’, ‘STATUE OF LIBERTY'
to the property. ***NOTE*****
This field must contain an existing reference point added to this
property via the Galileo Auto-Connect application. If additional
reference points are required call the Galileo Vendor Support
Desk located in Atlanta.
AIRPORT OR An alphanumeric code which C 57 5 Example:
CITY CODE * indicates the city/airport S01 (Sonoma)
code located near the SFO (San Francisco Int'l. Airport)
reference point or if the Fourth and fifth positions are
Loc Code is 'X' for City reserved for future expansion.
or Airport, this will be the Spaces if not applicable.
actual city or airport code.
LINE NUMBER A sequential number used to N 62 3 001 - Line number 001 record will
determine the format of the record contain formatted text fields.
being processed and to organize
any free form text records. There 002-999 - Line numbers 002-999
must be a line #001 record. will consist of free form text.
HOTELS BULK DATA RECORD DESCRIPTIONS
INDEX RECORD
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
Line number 001, formatted fields follow:
INDEX TYPE The classification of this Index C 65 1 P = Primary
record type. C = City
A = Airport
R = Reference Point
HIDDEN STATUS CODE Display status of the record C 66 1 H = Hidden from agency displays
blank = displayed normally.
Note: a Hidden value is valid only
on the Primary Index record.
STATE CODE * Two position state or province C 67 2 See Appendix A for codes. The
postal code in which the online Apollo Directory will
reference point is located. contain all valid codes.
COUNTRY CODE * Two position IATA country code C 69 2 See Appendix B for codes. The
in which the reference point Apollo Directory will contain
is located. all valid codes.
* Additional editing will take place on these three fields as follows.
If the Location Code Tag is 1-City or 2-Airport the Airport/City Code field will be
validated against GALILEO's City Code Table, and the State and Country Codes will be
programmatically generated. For all other Location Code Tags, the City Code Table will
be scanned, and if the City exists in the Table, then the State and Country Codes
will be programmatically generated.
LOCATION CODE TAGS A series of tags describing what
the location is or where the
reference point is located.
1. City C 71 1 X = Yes blank = No
ONLY ONE WITHIN 2. Airport C 72 1 X = Yes blank = No
THE FIRST EIGHT 3. Resort C 73 1 X = Yes blank = No
IS ALLOWED 4. Any Suburb C 74 1 X = Yes blank = No
5. North Suburb C 75 1 X = Yes blank = No
6. South Suburb C 76 1 X = Yes blank = No
7. East Suburb C 77 1 X = Yes blank = No
8. West Suburb C 78 1 X = Yes blank = No
ANY MORE IN 9. Downtown C 79 1 X = Yes blank = No
ADDITION OK 10. Theater District C 80 1 X = Yes blank = No
11. Entertainment District C 81 1 X = Yes blank = No
12. Shopping District C 82 1 X = Yes blank = No
13. Business District C 83 1 X = Yes blank = No
14. Financial District C 84 1 X = Yes blank = No
15. Highway C 85 1 X = Yes blank = No
16. On Beach C 86 1 X = Yes blank = No
17. By Lake C 87 1 X = Yes blank = No
18. In Mountains C 88 1 X = Yes blank = No
19. In Country C 89 1 X = Yes blank = No
20. Filler C 90 5 blanks
HOTELS BULK DATA RECORD DESCRIPTIONS
INDEX RECORD
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
DIRECTIONS Compass direction from the C 95 2 Example: N = North
CANNOT CHANGE reference point to the property. SE = Southeast
THIS FIELD A one position direction will
be in the first byte, followed
by a space. This field may be
blank even if the distance is
not zero.
DISTANCE INDICATOR TAG A tag that indicates if the miles C 97 1 K = Kilometers
CANNOT CHANGE field represents miles or M = Miles
kilometers. Space if miles is 0.
NUMBER OF MILES/ The number of miles/kilometers N 98 3 000-999
KILOMETERS from the reference point to
CANNOT CHANGE the property.
TRANSPORTATION CODE Codes indicating the forms of ONE FIELD REQUIRED
transportation available to/from
the reference point as follows:
1. Walk C 101 1 X = Yes blank = No
2. Hotel Courtesy Bus C 102 1 X = Yes blank = No
3. Limo C 103 1 X = Yes blank = No
4. Railway/Subway C 104 1 X = Yes blank = No
5. Bus C 105 1 X = Yes blank = No
6. Taxi C 106 1 X = Yes blank = No
7. Rental Car C 107 1 X = Yes blank = No
8. Other C 108 1 X = Yes blank = No
TRANSPORTATION TEXT A required field when C 109 20 Free form text.
Other is specified for
transportation code to further
describe the form of trans-
portation available to/from the
reference point.
SHORT ADDRESS An abbreviated address of the C 129 20 Example: 40TH & PLUM
reference point.
Record length = 148 bytes
** If line number is 002-999, the text will consist of free form text information related to the reference point as follows:
LINE NUMBER A sequential number used to N 62 3 002-999
determine the format of the record
being processed and to organize
any free form text records. There
must be a line #001 record.
INDEX TYPE The classification of this Index C 65 1 P = Primary
record type. C = City
A = Airport
R = Reference Point
TEXT Free form text applicable C 66 64 Free form text.
to the reference point.
Record length = 129 bytes
PAGE LEFT BLANK
HOTELS BULK DATA RECORD DESCRIPTIONS
DEPOSIT/GUARANTEE RECORD
------------------------------------------------------------------------------------------------------------------------------------
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
------------------------------------------------------------------------------------------------------------------------------------
Deposit/Guarantee records are not date effective. Therefore only one set of Deposit/Guarantee records exist for each rule number
If multiple sets of records for one rule number are transmitted, only the last set of records will be loaded to the database.
The Deposit/Guarantee Rule is used to give information about how the booking should be guaranteed. It can be connected to chains
properties, and rates using the rule connection record (Type R). Each time this record is transmitted, all information must be sent
as it will be a total replace of the database record.
RECORD TYPE Indicates record type. C 1 1 E = Deposit/Guarantee Rule
ACTION CODE The type of processing to be applied C 2 1 U = Update, create new record, or modify an
to this record. existing record.
D = Delete selected record. Record may not be
connected to any chains, properties, or rates.
VENDOR CODE Industry Vendor code C 3 3 Example: AS = Apollo Suites.
Third position is reserved for future expansion.
EFFECTIVE DATE Not Used N 6 8 Zeros
DISCONTINUE DATE Not Used N 14 8 Zeros
RULE NUMBER The number which identifies the N 22 5 1 to 65535.
Deposit/Guarantee Rule. This number
is input on the Rule Connection, and/
or Chain Policy record. The order of
precedence is the Rate connection,
property connection, chain connection.
RULE DESCRIPTION 19 character text field used to C 27 19 Free-form text.
briefly describe the rule. Will
never be seen by agents. It is used
to help decide which rules to connect
to.
TYPE OF GUARANTEE Indicator to show what type of C 46 1 N = No Guarantee required.
Guarantee is required to book the room. H = Guarantee required for late arrival.
G = Guarantee required for all bookings.
D = Deposit required for all bookings.
Required field.
LATE ARRIVAL TIME The latest time to check into a room N 47 4 0000-2359 - Military time. Will be ignored
without a guarantee. (Hold until time) unless Type of Guarantee is 'H'.
The next three fields only apply is type of guarantee is "D' (deposit). In this case only one of the three may be non zero.
DEPOSIT AMOUNT A fixed amount required for a deposit. N 51 9 The decimal position is defined by the Currency
type in the Apollo Directory. If the amount is
not applicable, the field should be zeroes.
Field will always be set to zero unless Type of
Guarantee is 'D'.
HOTELS BULK DATA RECORD DESCRIPTIONS
DEPOSIT/GUARANTEE RECORD
------------------------------------------------------------------------------------------------------------------------------------
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
------------------------------------------------------------------------------------------------------------------------------------
DEPOSIT NUMBER OF DAYS The number of days of stay required N 60 2 00 to 99. Will be automatically set to zero
as a deposit. unless Type of Guarantee is 'D'.
HOTELS BULK DATA RECORD DESCRIPTIONS
DEPOSIT PERCENT OF STAY The percentage of the full stay N 62 3 000 to 100. Example: 025 for 25% of total stay.
required as a deposit. Will be automatically set to zero unless Type
of Guarantee is 'D'.
Note: The next four fields are only used if Type of Deposit is 'D' (deposit). In this case, only one of the four fields should
be used. The others should be blank or zero.
DEPOSIT CURRENCY CODE A code which reflects the currency C 65 3 Three character alpha code. Must be a valid
unit of the deposit amount currency code. The online Apollo Directory will
contain a list of the valid codes.
DAYS PRIOR TO ARRIVAL The number of days the deposit must N 68 2 00-99. Will be set to zero unless Type of
received prior to check-in. Guarantee is 'D'.
HOURS PRIOR TO ARRIVAL The number of hours the deposit must N 70 2 00-99. Will be set to zero unless Type of
received prior to check-in. Guarantee is 'D'.
DAYS AFTER RESERVATION The number of days the deposit must be N 72 2 00-99. Will be set to zero unless Type of
received after the booking has been Guarantee is 'D'.
made.
HOURS AFTER RESERVATION The number of hours the deposit must be N 74 2 00-99. Will be set to zero unless Type of
received after the booking has beem Guarantee is 'D'.
made.
LENGTH OF RECORD = 75 BYTES.
HOTELS BULK DATA RECORD DESCRIPTIONS
RESERVATION RULE RECORD
------------------------------------------------------------------------------------------------------------------------------------
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
------------------------------------------------------------------------------------------------------------------------------------
Reservation Rule records are not date-effective. Therefore, only one set of Reservation Rule records exists on the
GALILEO database for a specific rule number. If multiple sets of records for one rule number are transmitted, only
the last set of records will be loaded to the database.
Optional text records can be included, updated, or deleted separately from "header" information as long as the
Line 001 data exists. When text is updated, all text lines of a specified type must be transmitted.
RECORD TYPE Indicates record type. C 1 1 F = Reservation Rule 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 selected records. *
* 'U' on Line 1 updates only line 1 and does not affect any existing text.
'U' on Line 2 will create new or replace all existing text records.
'D' on Line 1 will delete all lines (1 through 999).
'D' on Line 2 will delete all text lines (2 through 999) when Text Qualifier is blank.
'D' on Line 2 with Text Qualifier identified will delete a specific text group.
To delete 2 groups use Line 2 for the first and Line 3 for the next.
VENDOR CODE The industry vendor code. C 3 3 Example: AS = Apollo Suites
The third position is reserved for
future expansion.
EFFECTIVE DATE Not used N 6 8 Zeros
DISCONTINUE DATE Not used N 14 8 Zeros
RULE NUMBER The number which identifies the N 22 5 00001-65535
Reservation Rule. This number
is input on the Rate, Primary Hotel,
and/or Chain Policy record. The
order of precedence is the Rate,
Primary Hotel and the Chain
Policy record pointers.
LINE NUMBER A sequential number used to N 27 3 001 - Line number 001 record will
determine the format of the record contain formatted text fields.
being processed and to organize
any free form text records. There 002-999 - Line numbers 002-999
must be a line number 001. will contain free form text.
HOTELS BULK DATA RECORD DESCRIPTIONS
RESERVATION RULE RECORD
------------------------------------------------------------------------------------------------------------------------------------
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
------------------------------------------------------------------------------------------------------------------------------------
Line number 001, formatted fields follow:
RULE DESCRIPTION 19 character text field used to C 30 19 Free-form text.
briefly describe the rule. Will
never be seen by agents. It is used
to help decide which rules to connect
to.
ACCEPTANCE TAGS Positional fields which represent
conditions or acceptable forms of
guarantee/deposit/form of payment.
1. Personal Name/Address
Guarantee C 49 1 X = Yes
N = Yes, if non U.S. address
U = Yes, if U.S. address
Blank = No
Deposit C 50 1 X = Yes
N = Yes, if non U.S. address
U = Yes, if U.S. address
W = Accept within waiver period
Blank = No
2. Business Name/Address
Guarantee C 51 1 X = Yes
N = Yes, if non U.S. address
U = Yes, if U.S. address
Blank = No
Deposit C 52 1 X = Yes
N = Yes, if non U.S. address
U = Yes, if U.S. address
W = Accept within waiver period
Blank = No
3. Travel Agency Name/Address
Guarantee C 53 1 X = Yes
Blank = No
Deposit C 54 1 X = Yes
W = Accept within waiver period
Blank = No
4. Travel Agency ID
Guarantee C 55 1 X = Yes
Blank = No
Deposit C 56 1 X = Yes
W = Accept within waiver period
Blank = No
HOTELS BULK DATA RECORD DESCRIPTIONS
RESERVATION RULE RECORD
------------------------------------------------------------------------------------------------------------------------------------
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
------------------------------------------------------------------------------------------------------------------------------------
ACCEPTANCE TAGS 5. Travel Agency IATA Number
(continued) Guarantee C 57 1 X = Yes
Blank = No
Deposit C 58 1 X = Yes
W = Accept within waiver period
Blank = No
6. Guarantee Override Allowed
Guarantee C 59 1 X = Yes
Blank = No
Deposit C 60 1 X = Yes
W = Accept within waiver period
Blank = No
7. Club Membership ID
Guarantee C 61 1 X = Yes
Blank = No
Deposit C 62 1 X = Yes
W = Accept within waiver period
Blank = No
8. Corporate ID
Guarantee C 63 1 X = Yes
Blank = No
Deposit C 64 1 X = Yes
Blank = No
W = Accept within waiver period
9. Deposit Requirements Met
Guarantee C 65 1 X = Yes
Blank = No
10. MCO (Misc. Charges Order)
Guarantee C 66 1 X = Yes
Blank = No
Deposit C 67 1 X = Yes
W = Accept within waiver period
Blank = No
Form of Payment C 68 1 X = Yes
Blank = No
HOTELS BULK DATA RECORD DESCRIPTIONS
RESERVATION RULE RECORD
------------------------------------------------------------------------------------------------------------------------------------
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
------------------------------------------------------------------------------------------------------------------------------------
ACCEPTANCE TAGS 11. Credit Cards
(continued) Guarantee C 69 1 X = Yes
Blank = No
Deposit C 70 1 X = Yes
Blank = No
W = Accept within waiver period
Form of Payment C 71 1 X = Yes
Blank = No
12. Vouchers
Guarantee C 72 1 X = Yes
Blank = No
Deposit C 73 1 X = Yes
W = Accept within waiver period
Blank = No
Form of Payment C 74 1 X = Yes
Blank = No
13. Prepayment Required at
Related Property
Guarantee C 75 1 X = Yes
Blank = No
Deposit C 76 1 X = Yes
W = Accept within waiver period
Blank = No
14. Cash
Guarantee C 77 1 X = Yes
Blank = No
Deposit C 78 1 X = Yes
W = Accept within waiver period
Blank = No
Form of Payment C 79 1 X = Yes
Blank = No
HOTELS BULK DATA RECORD DESCRIPTIONS
RESERVATION RULE RECORD
------------------------------------------------------------------------------------------------------------------------------------
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
------------------------------------------------------------------------------------------------------------------------------------
ACCEPTANCE TAGS 15. Money Orders
(continued) Guarantee C 80 1 X = Yes
Blank = No
Deposit C 81 1 X = Yes
W = Accept within waiver period
Blank = No
Form of Payment C 82 1 X = Yes
Blank = No
16. Personal Check
Guarantee C 83 1 X = Yes
Blank = No
Deposit C 84 1 X = Yes
W = Accept within waiver period
Blank = No
Form of Payment C 85 1 X = Yes
Blank = No
17. Wire Accepted (i.e., Western
Union)
Guarantee C 86 1 X = Yes
Blank = No
Deposit C 87 1 X = Yes
W = Accept within waiver period
Blank = No
Form of Payment C 88 1 X = Yes
Blank = No
18. Company Check
Guarantee C 89 1 X = Yes
Blank = No
Deposit C 90 1 X = Yes
W = Accept within waiver period
Blank = No
Form of Payment C 91 1 X = Yes
Blank = No
19. Tour Order
Guarantee C 92 1 X = Yes
Blank = No
Form of Payment C 93 1 X = Yes
Blank = No
HOTELS BULK DATA RECORD DESCRIPTIONS
RESERVATION RULE RECORD
------------------------------------------------------------------------------------------------------------------------------------
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
------------------------------------------------------------------------------------------------------------------------------------
ACCEPTANCE TAGS 20. Travelers Check
(continued) Guarantee C 94 1 X = Yes
Blank = No
Deposit C 95 1 X = Yes
W = Accept within waiver period
Blank = No
Form of Payment C 96 1 X = Yes
Blank = No
21. Certified Check
Guarantee C 97 1 X = Yes
Blank = No
Deposit C 98 1 X = Yes
W = Accept within waiver period
Blank = No
Form of Payment C 99 1 X = Yes
Blank = No
DEPOSIT WITHIN The number of days prior to N 100 3 000-999
COUNTRY WAIVER arrival within which the deposit
PERIOD is waived when booking is within
the same country. (Note: Subject
to exceptions by the Deposit
Acceptance Tags.)
DEPOSIT OUTSIDE The number of days prior to N 103 3 000-999
COUNTRY WAIVER arrival within which the deposit
PERIOD is waived when booking is from
outside the country. (Note:
Subject to exceptions by the
Deposit Acceptance Tags.)
DEPOSIT TAX INCLUDED Indicates if tax must be C 106 1 X = Yes
included in the deposit made. Blank = No
DEPOSIT ADDRESS TAG A tag which indicates the address C 107 1 C = Corporate Address
in which to mail the deposit. The S = Property Street Address
'ADDR' keyword on the Chain Policy M = Property Mailing Address
contains the Corporate Address,
the 'ADDR' keyword on the Secondary
Record contains the Property Street
Address, and the 'MAIL' keyword on
the Secondary Record contains the
Property Mailing Address.
Record length = 107 bytes
HOTELS BULK DATA RECORD DESCRIPTIONS
RESERVATION RULE RECORD
------------------------------------------------------------------------------------------------------------------------------------
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
------------------------------------------------------------------------------------------------------------------------------------
** If line number is 002-999, the text will consist of free form information related to the Reservation Rule as follows:
LINE NUMBER A sequential number used to N 27 3 002-999
determine the format of the record
being processed and to organize
any free form text records.
TEXT QUALIFIER An indicator which identifies C 30 1 D = Deposit
the type of rule the text is F = Form of Payment
associated with. G = Guarantee
TEXT Free form information applicable C 31 64 Free form text.
to the Reservation Rule.
Record length = 94 bytes
HOTELS BULK DATA RECORD DESCRIPTIONS
EXTRA OPTIONS RULE RECORD
------------------------------------------------------------------------------------------------------------------------------------
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
------------------------------------------------------------------------------------------------------------------------------------
Extra Options Rule records are not date-effective. Therefore, only one set of Extra Options Rule records exists on the
GALILEO database for a specific rule number. If multiple sets of records for one rule number are transmitted, only
the last set of records will be loaded to the database.
Optional text records can be included, updated, or deleted separately from "header" information as long as the
Line 001 data exists. When text is updated, all text lines must be transmitted.
RECORD TYPE Indicates record type. C 1 1 I = Extra Options Rule 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 selected records. *
* 'U' on Line 1 updates only line 1 and does not affect any existing text.
'U' on Line 2 will create new or replace all existing text records.
'D' on Line 1 will delete all lines (1 through 999).
'D' on Line 2 will delete all text lines (2 through 999)
VENDOR CODE The industry vendor code. C 3 3 Example: AS = Apollo Suites
The third position is reserved
for future expansion.
EFFECTIVE DATE Not used N 6 8 Zeros
DISCONTINUE DATE Not used N 14 8 Zeros
RULE NUMBER A number which identifies the N 22 5 00001-65535
Extra Options Rule. This number
can be referenced on the Rule,
Connection or Chain Policy records with
the respective order representing
the hierarchy for the system.
LINE NUMBER A sequential number used to N 27 3 001 - Line number 001 record will
determine the format of the record contain formatted text fields.
being processed and to organize
any free form text records. There 002-999 - Line numbers 002-999
must be a line number 001. will contain free form text.
* Line number 001, the formatted text follows:
RULE DESCRIPTION 19 character text field used to C 30 19 Free-form text.
briefly describe the rule. Will
never be seen by agents. It is used
to help decide which rules to connect
to.
CURRENCY CODE A code which reflects the C 49 3 A three character alpha code.
currency unit of the record See Appendix B for typical values.
being processed. The online Directory will contain
all valid codes.
HOTELS BULK DATA RECORD DESCRIPTIONS
EXTRA OPTIONS RULE RECORD
------------------------------------------------------------------------------------------------------------------------------------
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
------------------------------------------------------------------------------------------------------------------------------------
EXTRA PERSON MINIMUM AGE The minimum age for which the N 52 2 00 = infants
extra person child rate applies, 01-99
(i.e., rate applies to child
from this age to maximum age).
EXTRA PERSON MAXIMUM AGE The maximum age for which the N 54 2 00-99
extra person child rate applies,
(i.e., rate applies to child up
to this age). If person is older
than maximum age, they will pay
extra person adult rate.
FILLER Spare character that is not used N 56 1 Ignored
NUMBER OF SEGMENTS A number which indicates the N 57 1 1-6. Ignored only one segment allowed for this release
number of extra charges rate
segments that follow.
SEGMENT IDENTIFICATION A one position field which C 58 1 D = Daily
describes the time period to N = Not Available
which the following segment
date applies.
SERVICE CHARGE The service charge rate. N 59 9 The decimal position is defined by
the Currency type in the Apollo
Directory. If the amount is not
applicable, the field should be zeros.
ROLLAWAY BED, ADULT The rate charged for a rollaway N 68 9 The decimal position is defined by
bed and for an extra person the Currency type in the Apollo
(adult) in the room. Directory. If the amount is not
applicable, the field should be zeros.
ROLLAWAY BED, CHILD The rate charged for a rollaway N 77 9 The decimal position is defined by
bed and for an extra person the Currency type in the Apollo
(child) in the room. Directory. If the amount is not
applicable, the field should be zeros.
INFANT CRIB The rate charged for an infant N 86 9 The decimal position is defined by
crib in the room. the Currency type in the Apollo
Directory. If the amount is not
applicable, the field should be zeros.
EXTRA ADULT RATE The rate charged for an extra N 95 9 The decimal position is defined by
adult in the room using existing the Currency type in the Apollo
bedding. Directory. If the amount is not
applicable, the field should be zeros.
HOTELS BULK DATA RECORD DESCRIPTIONS
EXTRA OPTIONS RULE RECORD
------------------------------------------------------------------------------------------------------------------------------------
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
------------------------------------------------------------------------------------------------------------------------------------
EXTRA CHILD RATE The rate charged for an extra N 104 9 The decimal position is defined by
child in the room using existing the Currency type in the Apollo
bedding. Directory. If the amount is not
applicable, the field should be zeros.
Record Length = 112 bytes
** If line number is 002-999, the text will consist of free form information related to the Extra Options record
as follows:
LINE NUMBER A sequential number used to N 27 3 002-999
determine the format of the record
being processed and to organize
any free form text records.
TEXT Free form information applicable C 30 64 Free form text
to the Extra Options record.
Record length = 93 bytes
HOTELS BULK DATA RECORD DESCRIPTIONS
CANCELLATION PENALTY RULE RECORD
------------------------------------------------------------------------------------------------------------------------------------
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
------------------------------------------------------------------------------------------------------------------------------------
Cancellation Penalty records are not date-effective. Therefore, only one set of Cancellation Penalty records exists on
the GALILEO database for a specific rule number. If multiple sets of records for one rule number are transmitted, only
the last set of records will be loaded to the database.
RECORD TYPE Indicates record type. C 1 1 J = Cancellation Penalty Rule Record
ACTION CODE The type of processing to be C 2 1 U = Update, creates new rule or
applied to this record. replaces an existing group
of text records.
D = Deletes the rule.
VENDOR CODE The industry vendor code. C 3 3 Example: AS = Apollo Suites
The third position is reserved
for future expansion.
EFFECTIVE DATE Not used N 6 8 Zeros
DISCONTINUE DATE Not used N 14 8 Zeros
RULE NUMBER The number which identifies the N 22 5 00001-65535
Cancellation Penalty Rule. It
can be referenced on the Rate,
Primary or Chain Policy records with
the respective order representing
the hierarchy for the system.
LINE NUMBER Sequential number to organize N 27 3 001-999
the free form text.
LINE NUMBER 001 FIELDS BELOW:
RULE DESCRIPTION 19 character text field used to C 30 19 Free-form text.
briefly describe the rule. Will
never be seen by agents. It is used
to help decide which rules to connect
to.
Record Length = 48 bytes
Line Numbers 002 - 999 Below
TEXT Free form text information that C 30 64 Free form text.
describes the Cancellation
Penalty Rule.
Record length = 93 bytes
HOTELS BULK DATA RECORD DESCRIPTIONS
METHOD OF PAYMENT RULE RECORD
------------------------------------------------------------------------------------------------------------------------------------
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
------------------------------------------------------------------------------------------------------------------------------------
Method of Payment Rule records are not date-effective. Therefore, only one set of Method of Payment records exists on
the GALILEO database for a specific rule number. If multiple sets of records for one rule number are transmitted,
only the last set of records will be loaded to the database. Individual payment items can be transmitted without
repeating all previous information.
RECORD TYPE Indicates record type. C 1 1 K = Method of Payment Rule 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. *
R = Replace, replaces all records. *
D = Deletes selected records. *
* 'U' changes an existing record when Payment Type and Payment Code match. Otherwise,
it creates a new entry.
'R' assumes that all entries will be retransmitted..
Do not mix 'R' and 'U' records for the same object. 'R' is preferred.
'D' deletes a specific entry when the Payment Type and Payment Code match.
When these fields are blank, it removes the entire rule.
VENDOR CODE The industry vendor code. C 3 3 Example: AS = Apollo Suites
The third position is reserved
for future expansion.
EFFECTIVE DATE Not used N 6 8 Zeros
DISCONTINUE DATE Not used N 14 8 Zeros
RULE NUMBER The number which identifies the N 22 5 00001-65535
Method of Payment Rule. It
can be referenced on the Rate,
Primary or Chain Policy records with
the respective order representing
the hierarchy for the system.
LINE NUMBER Sequential number to organize N 27 3 001-999
Payment Code records.
Line number 001, formatted fields below:
RULE DESCRIPTION 19 character text field used to C 30 19 Free-form text.
briefly describe the rule. Will
never be seen by agents. It is used
to help decide which rules to connect
to.
Record Length = 48 bytes.
HOTELS BULK DATA RECORD DESCRIPTIONS
METHOD OF PAYMENT RULE RECORD
------------------------------------------------------------------------------------------------------------------------------------
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
------------------------------------------------------------------------------------------------------------------------------------
Line numbers 002-999, formatted fields below
PAYMENT TYPE A tag which indicates if the C 30 1 C = Credit Card
Payment code that follows is M = MCO
a Credit Card, MCO or Voucher V = Voucher
code.
PAYMENT CODE A code which represents a credit C 31 15 Credit Card Codes: Appendix C
card, voucher or MCO. shows examples.
MCO = 2-3 position airline code
Voucher Type
Specific Voucher Number
GUARANTEE TAG A tag which indicates if the C 46 1 X = Yes Blank = Not Acceptable
Payment Code is an acceptable
payment method for a guarantee.
DEPOSIT TAG A tag which indicates if the C 47 1 X = Yes Blank = Not Acceptable
Payment Code is an acceptable
payment method for a deposit.
FORM OF PAYMENT TAG A tag which indicates if the C 48 1 X = Yes Blank = Not Acceptable
Payment Code is an acceptable
payment method for a form of
payment.
Record length = 48 bytes
HOTELS BULK DATA RECORD DESCRIPTIONS
LENGTH OF STAY RULE RECORD
------------------------------------------------------------------------------------------------------------------------------------
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
------------------------------------------------------------------------------------------------------------------------------------
Length of Stay records are used to update minimum and maximum length of stay at the property and rate levels. These records are date
effective. Each set of dates controls length of stay for seven days of the week. This record may not be used to close out
availability for a room. Zero for minimum or maximum length of stay will indicate that there are no limits. Since this rule is
date effective, the connections are not. The connections are made on the Rate Code record and the Primary Property record.
RECORD TYPE Indicates record type. C 1 1 L = Length of Stay record.
ACTION CODE The type of processing to be applied C 2 1 U = Update, create new rule, or modify existing
to this record. D = Delete. If effective dates are entered will
modify the records to show no length of stay
restrictions. No effective dates will attempt
to delete the rule. The rule may not be
deleted if connections exist to it.
VENDOR CODE The industry vendor code C 3 3 Example: AS = Apollo Suites
The third position is reserved for future
expansion.
EFFECTIVE DATE The begin date of this length of stay N 6 8 YYYYMMDD. Use zero for a full rule delete.
modification.
DISCONTINUE DATE The end date of this length of stay N 14 8 YYYYMMDD. Use 99999999 to indicate no discontinue
modification. date.
RULE NUMBER The number which identifies the Length N 22 5 1 to 65535.
of Stay record. This number is
referenced by the Rate Code and/or
Primary Property Record.
RULE DESCRIPTION 19 character text field used to C 27 19 Free Form Text.
briefly describe the rule. Will never
be seen by agents. It is used to help
decide which rules to connect to.
SUNDAY MINIMUM NUMBER The minimum number of days required to N 46 2 0 to 35. Zero or 1 indicate that there is no
OF DAYS stay at a location in order to qualify minimum stay restriction.
for the rate based on the day of the week.
SUNDAY MAXIMUM NUMBER The maximum number of days allowed at N 48 3 0 to 255. Both zero and 255 indicate that there
OF DAYS a location for the rate or property is no maximum stay restriction.
based on the day of the week.
HOTELS BULK DATA RECORD DESCRIPTIONS
LENGTH OF STAY RULE RECORD
------------------------------------------------------------------------------------------------------------------------------------
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
------------------------------------------------------------------------------------------------------------------------------------
Monday through Saturday fields are in the same format and will be edited identically to the Sunday fields.
MON MIN DAYS N 51 2
MON MAX DAYS N 53 3
TUES MIN DAYS N 56 2
TUES MAX DAYS N 58 3
WED MIN DAYS N 61 2
WED MAX DAYS N 63 3
THURS MIN DAYS N 66 2
THURS MAX DAYS N 68 3
FRI MIN DAYS N 71 2
FRI MAX DAYS N 73 3
SAT MIN DAYS N 76 2
SAT MAX DAYS N 78 3
RECORD LENGTH = 80 BYTES
HOTELS BULK DATA RECORD DESCRIPTIONS
ROOM DESCRIPTION RULE RECORD
------------------------------------------------------------------------------------------------------------------------------------
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
------------------------------------------------------------------------------------------------------------------------------------
Room Description Rule records are not date-effective. Therefore, only one set of Room Description records exists on the
GALILEO database for a specific rule number. If multiple sets of records for one rule number are transmitted,
only the last set of records will be loaded to the database.
Optional text records can be included, updated, or deleted separately from "header" information as long as the
Line 001 data exists. When text is updated, all text lines must be transmitted.
RECORD TYPE Indicates record type. C 1 1 M = Room Description Rule 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 selected records. *
* 'U' on Line 1 updates only line 1 and does not affect any existing text.
'U' on Line 2 will create new or replace all existing text records.
'D' on Line 1 will delete all lines (1 through 999).
'D' on Line 2 will delete all text lines (2 through 999).
VENDOR CODE The industry vendor code. C 3 3 Example: AS = Apollo Suites
The third position is reserved
for future expansion.
EFFECTIVE DATE Not used N 6 8 Zeros
DISCONTINUE DATE Not used N 14 8 Zeros
RULE NUMBER The number which identifies the N 22 5 00001-65535
Room Description Rule record.
NOTE: Room Description
Rule must be the same for a
bed type within a property.
LINE NUMBER A sequential number used to N 27 3 001 - Line number 001 record will
determine the format of the record contain formatted text fields.
being processed and to organize
any free form text records. There 002-999 - Line numbers 002-999
must be a line number 001. will contain free form text.
HOTELS BULK DATA RECORD DESCRIPTIONS
ROOM DESCRIPTION RULE RECORD
------------------------------------------------------------------------------------------------------------------------------------
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
------------------------------------------------------------------------------------------------------------------------------------
* Line number 001, formatted text and a free form text field follows:
RULE DESCRIPTION 19 character text field used to C 30 19 Free-form text.
briefly describe the rule. Will
never be seen by agents. It is used
to help decide which rules to connect
to.
ROOM TYPE A one position field that C 49 1 C = Cottage
describes the room. E = Efficiency
J = Junior Suite
K = Condo
L = Lanai
P = Parlor
R = Regular
S = Suite
T = Studio
V = Villa
NUMBER OF BEDROOMS The number of bedrooms in N 50 1 0-9
the unit.
FLOOR RANGE (FROM) Indicates the beginning range N 51 3 000-999
of the floor the room is located.
FLOOR RANGE (TO) Indicates the ending range of the N 54 3 000-999
floor the room is located.
LOCATION/VIEW A two position code describing C 57 2 Blank
the view/location. BF = Beach Front
OF = Ocean Front
MV = Mountain View
SV = Sea View
PS = Pool Side
GC = Golf Course View
BV = Bay View
GV = Garden View
LV = Lake View
RV = River View
DO = Down-and-Out
(drive up room)
PV = Park View
CV = Courtyard View
HOTELS BULK DATA RECORD DESCRIPTIONS
ROOM DESCRIPTION RULE RECORD
------------------------------------------------------------------------------------------------------------------------------------
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
------------------------------------------------------------------------------------------------------------------------------------
FACILITIES TAGS Tags which indicate if options X = Yes
are included with the unit rate. $ = Available for a fee
blank = Not available
1. AIR CONDITIONING C 59 1
2. BALCONY C 60 1
3. BATH TUB IN ROOM C 61 1
4. BIDET C 62 1
5. BREAKFAST C 63 1
6. COMPUTER IN ROOM C 64 1
7. CONCIERGE LEVEL C 65 1
8. CONNECTING ROOMS C 66 1
9. CONTINENTAL BREAKFAST C 67 1
10. DINNER C 68 1
11. EFFICIENCY C 69 1
12. FAMILY PLAN C 70 1
13. FIREPLACE C 71 1
14. HANDICAP C 72 1
15. KITCHEN C 73 1
16. LUNCH C 74 1
17. MEAL PLAN C 75 1
18. MINI BAR C 76 1
19. MOVIES IN ROOM C 77 1
20. NON-SMOKING C 78 1
21. SMALL PET C 79 1
22. PHONE SERVICE C 80 1
23. REFRIGERATOR C 81 1
24. RM. STYLE, ORIENT C 82 1
25. RM. STYLE, WESTERN C 83 1
26. SAFE IN ROOM C 84 1
27. SAUNA C 85 1
28 SHOWER IN ROOM C 86 1
29. SPA C 87 1
30. TV C 88 1
31. TV, CABLE C 89 1
32. VCR C 90 1
33. WATERBED C 91 1
34. WC IN ROOM C 92 1
35. WET BAR C 93 1
36. 120AC C 94 1
37. 120DC C 95 1
38. 220AC C 96 1
39. 220DC C 97 1
40. MODEM IN ROOM C 98 1
MAX NUMBER OF ROLLAWAYS Maximum number of rollaway beds N 99 1 0-9
allowed in a room.
Record length = 99 bytes
HOTELS BULK DATA RECORD DESCRIPTIONS
ROOM DESCRIPTION RULE RECORD
------------------------------------------------------------------------------------------------------------------------------------
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
------------------------------------------------------------------------------------------------------------------------------------
** If line number is 002-999, the text will consist of free form information related to the room description rule
as follows:
LINE NUMBER A sequential number used to N 27 3 002-999
determine the format of the record
being processed and to organize
any free form text records.
TEXT Free form information applicable C 30 64 Free form text
to the Room Description Rule.
Record length = 93 bytes
HOTELS BULK DATA RECORD DESCRIPTIONS
CHECK-IN/OUT TIMES RECORD
------------------------------------------------------------------------------------------------------------------------------------
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
------------------------------------------------------------------------------------------------------------------------------------
Check-in/out times record is used to give information about check-in and check-out times for properties. This record is available
only at the property level and overrides the times reported on the Chain Policy Record. Each record is date effective. In addition,
the times can have day of week variations using the day of week pattern and variation times. This will work the same way as the
rate amounts.
RECORD TYPE Indicates record type. C 1 1 N = Check-in/out times record.
ACTION CODE The type of processing to be applied C 2 1 U = Update, create new times, modify existing
this record times.
D = Delete record. If effective dates are
entered it will default that period to the
chain level. If no effective dates are
found all times will be defaulted to the
chain level.
VENDOR CODE Industry vendor code C 3 3 Example: AS = Apollo Suites.
Third position reserved for future expansion.
EFFECTIVE DATE Effective date of times modification. N 6 8 Format = YYYYMMDD. Zero to delete all times.
DISCONTINUE DATE The last date of the times N 14 8 Format = YYYYMMDD. 99999999 = No discontinue
modification. date.
PROPERTY IDENTIFIER A five position field that uniquely C 22 5 Example: WASJW, WAS01, 01040
identifies a property.
CHECK-IN TIME Earliest time customer may check-in N 27 4 0000-2359. Military Time.
the hotel. Standard check-in time.
CHECK-OUT TIME Latest time customer may check-out N 31 4 0000-2359. Military Time.
of the hotel. Standard check-out time.
DAY OF WEEK PATTERN Pattern to which times apply on what C 35 7 X = Use variation times.
day of the week. Seven characters Blank = Use standard times.
are used with the first being Sunday
and the last being Saturday.
VARIATION CHECK-IN TIME Earliest time customer may check-in N 42 4 0000-2359. Military Time.
the hotel. Used during the variation
days of the week.
VARIATION CHECK-OUT TIME Latest time customer may check-out of N 46 4 0000-2359. Military Time
the hotel. Used during the variation
days of the week.
LENGTH OF RECORD = 49 BYTES
HOTELS BULK DATA RECORD DESCRIPTIONS
POINT OF SALE RULE RECORD
------------------------------------------------------------------------------------------------------------------------------------
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION |
------------------------------------------------------------------------------------------------------------------------------------
Point of Sale Rule records are not date-effective. Therefore, only one set of Point of Sale Rule records exists on the
GALILEO database for a specific rule number.
The batch process handles only a list of inclusions. That means, all the entities on each record are stored as a single list of inclusions for each rule. Note, the batch process does not provide the same flexibility as the Online Maintenance System to manipulate sections and their exclusions.
RECORD TYPE Indicates record type. C 1 1 P = Point of Sale Rule Record
ACTION CODE Type of processing C 2 1 U = for Record 001 -- Add new rule or update rule description. for Record 002 - 999 -- Add the new list. If
the list already exists, add the inclusions on the batch record.
R = for Record 001 - Update rule (description only) used for record 002 - 999 -- replace the list so it contains only the inclusions on the batch record.
D = for Record 001 delete the rule
for Record 002 - 999 If entities furnished, delete them only. If no entities are furnished, delete the whole list (but not e rule).
VENDOR CODE The industry vendor code. C 3 3 Example: AS = Apollo Suites
The third position is reserved
for future expansion.
FILLER Not used N 6 16 Zeros
RULE NUMBER The number which identifies N 22 5 00001-65535
the Point of Sale rule. This
number is referenced by the
online Multilevel Maintenance
and Rate Maintenance screens.
LINE NUMBER Sequential number to organize N 27 3 001-999
Point of Sale records.
LINE NUMBER 001 FIELDS BELOW:
RULE DESCRIPTION 19 character text field used to C 30 19 Free-form text
briefly describe the rule.
Will never be seen by agents.
FILLER Not used C 49 90 Spaces
LENGTH OF RECORD = 112 BYTES
HOTELS BULK DATA RECORD DESCRIPTIONS
POINT OF SALE RULE RECORD
------------------------------------------------------------------------------------------------------------------------------------
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
------------------------------------------------------------------------------------------------------------------------------------
LINE NUMBERS 002 - 999 BELOW
ENTITY GROUP The entity (pseudo-city, IATA C 30 80
number, city/state/country) included in the POS List
This is a Group field. It occurs 8 times.
ENTITY ID (1) The code for the pseudo-city, C 30 9
IATA, city/state/country
(all codes should be aligned left
e.g. IATA number - '12345678_'
City - 'DEN______'
State - 'CO_______'
Country - 'US_______'
Pseudo City - 'GK5______')
ENTITY-TYPE (1) Type Identifier C 39 1 V - Pseudo-city (Apollo)
G - Pseudo-city (Galileo)
C - Pseudo-city (Gemini)
I - IATA number
T - City code
S - State code
N - Country code
1 - Pseudo-city Group
2 - IATA Group
3 - City Group
4 - State Group
5 - Country Group
ENTITY ID (2) C 40 9
ENTITY TYPE (2) C 49 1
ENTITY ID (3) C 50 9
ENTITY TYPE (3) C 59 1
ENTITY ID (4) C 60 9
ENTITY TYPE (4) C 69 1
ENTITY ID (5) C 70 9
ENTITY TYPE (5) C 79 1
ENTITY ID (6) C 80 9
ENTITY TYPE (6) C 89 1
ENTITY ID (7) C 90 9
ENTITY TYPE (7) C 99 1
ENTITY ID (8) C 100 9
ENTITY TYPE (8) C 110 1
FILLER C 111 2
HOTELS BULK DATA RECORD DESCRIPTIONS
RULE CONNECTION RECORD
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
Date effective connections can be made for properties or rates. Deposit/Guarantee, Extra Option, Cancellation
Penalty are the rules that have date effective connections. The other rules are connected directly from
the Primary Property or Rate code records. Deposit/Guarantee rule also allows Day of Week Variations. Any
attempt to add the variations to other rule types will be reject.
RECORD TYPE Indicates record type. C 1 1 R = Rule Connection Record
ACTION CODE The type of processing to be C 2 1 U = Update, creates or changes
applied to this record. individual rate record.
D = Delete selected records. *
'D' with a valid date range will remove the connection for that range.
'D' with zero dates will remove connections to the rate or property.
VENDOR CODE The industry vendor code. C 3 3 Example: AS = Apollo Suites
The third position is reserved for
future expansion.
EFFECTIVE DATE The effective date of the N 6 8 YYYYMMDD format.
connection.
DISCONTINUE DATE The last date of the period. N 14 8 YYYYMMDD format
99999999 = No discontinue date.
Zeros for some delete functions.
PROPERTY IDENTIFIER A five position field that C 22 5 Example: WASJW,WAS01,01040
uniquely identifies a property.
PROPERTY/RATE INDICATOR An indicator to say if the C 27 1 P = Property
connection is for a rate or a R = Rate
property.
RATE CODE Code describing rate that the C 28 4 Must be blank if Property/Rate
rule connection is for. Indicator is P. Otherwise, first 3
Characters must be alphanumeric. 4th
may be blank. No special characters.
RATE CATEGORY One character code describing C 32 1 See next page for valid values.
the rate type. Only necessary when rate code is a duplicate.
Otherwise, use blank.
RULE TYPE Identifier to describe the C 33 1 E = Deposit/Guarantee
type of rule the connection I = Extra Options
is to. J = Cancellation/Penalty
STANDARD RULE NUMBER Pointer to the rule. Used N 34 5 00000-65535.
standard part of the
effective period.
DAY OF WEEK PATTERN Pattern to which connection C 39 7 X = Use Variation Rule Number
applies on what day of the week. blank = Use standard Rule Number
Seven characters are used with Only Deposit/Guarantee rule connection
the first being Sunday and the may use this field. All other rule types
last being Saturday. must use all blanks in this field.
HOTELS BULK DATA RECORD DESCRIPTIONS
RULE CONNECTION RECORD (cont)
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
VARIATION RULE NUMBER Pointer to Rule. Used during N 46 5 00000-65535. Must be zero if not a
Variation part of the effective prd. Deposit/Guarantee Rule connection.
Record length = 50 bytes.
HOTELS BULK DATA RECORD DESCRIPTIONS
RATE CODE RECORD
This record gives non date effective information about rate codes. Spaces is used in this record to show that the information
should not be changed. Zero will be used to show that the data does not exist. The only exception to this rule is in both
rate categories, which must always exist and can never be changed once created. In the rate category field, if the field is blank,
there will be no change to the record. Zeros will not be allowed in the rate category field.
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
RECORD TYPE Indicates record type C 1 1 S = Rate Code Record
ACTION CODE The type of processing to be C 2 1 U = Update, create, or change rate code record.
applied to this record D = Deletes Rate Code and all booking codes
using it.
VENDOR CODE The industry vendor code C 3 3 Example: AS - Apollo Suites
The third position is reserved for future
expansion.
PROPERTY IDENTIFIER A five position field that C 6 5 Example: WASJW, WAS01, 01040
uniquely identifies a property.
Or optionally, Apollo#.
RATE CODE Code describing the rate. It is C 11 4 First three characters must be alphanumeric.
Last four characters of booking cd. The fourth character may be blank. No
special characters allowed.
PRIMARY RATE CATEGORY One position code which indicates C 15 1 R = Regular or Rack C = Corporate
the rate type. G = Government M = Military
L = Special P = Package
S = Senior Citizens W = Weekend
F = Family Plan T = Tour
A = Association V = Convention
I = Industrial D = Multi-day Package
B = Club N = Multilevel (Negotiated)
Once created it may not be changed.
ALTERNATE RATE CATEG. Rate will use the Alternate Rate C 16 1 X = Use Alternate Rate Category during day of week
Category that was established at variations.
the property level during day of Zero = Always use Primary Rate Category
week variations. Blank = No change (defaults to zero on add)
FILLER C 17 1 Blanks
NON COMMISSION IND. Tag that identifies all booking C 18 1 X = Non Commissionable rate.
codes using the rate code will not N = Normal commission paid.
have a commission paid when they are Blank = No change (default to N on add).
booked by an agent.
HOTELS BULK DATA RECORD DESCRIPTIONS
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
MEAL INCLUDED IND. Tag that indicates that at least C 19 1 X = Meal is included with rate.
one meal is included in the rate N = No meals included.
at no extra charge. Blank = No change (default to N on add).
CANCEL PENALTY IND Tag that indicates that a penalty C 20 1 X = Penalty will be assessed for cancel
will be assessed for booking the N = No penalty applied for cancellation.
rate and later canceling it. Blank = No change (will default to N for add).
ADVANCE PURCHASE TIME Number of days before check-in N 21 3 0 to 255.
that the rate must be booked. Blank = No change (defaults to 0 on add).
POINT OF SALE RULE Pointer to Point of Sale Rule. N 24 5 00000 to 65535
Blank = No change (defaults to 0 on add).
AMT IS PCT OFF RAC RATE Indicates the amount is not a true N 29 2 0 to 99%. Zero indicates that the rate
amount but is a percentage off the amounts are true amounts.
RAC rate for the same room type. 10 would indicate that the rate is 10% off
Primary Rate Category may not be 'R'. the RAC rate or 90% of the RAC rate.
Blank = No change (defaults to 0 on add).
CAN ONLY DO THIS ON AN INITIAL ADD.
CAN ONLY UPDATE THIS FIELD IF PERCENT IS ALREADY THERE.
AVAILABILTIY IS FROM Rate does not have its own C 31 4 Must be existing rate code or
RATE CODE availability but uses the Zero = has its own availability
availability for the booking code Blank = No change (defaults to 0 on add).
that has this rate code in it.
RATE CATEGORY FOR AVAIL The rate category used to C 35 1 Same values as rate category above
IS FROM RATE CODE distinguish a duplicate rate code Required only if rate code is a duplicate.
that is for availability sharing. Otherwise, use BLANK
LENGTH OF STAY RULE Pointer to Length of Stay Rule N 36 5 00000 - 65535.
Blank = No change (defaults to 0 on add).
Record length = 40 bytes.
HOTELS BULK DATA RECORD DESCRIPTIONS
RATE AMOUNT RECORD
This record updates the non date effective data for Room Types and Booking Codes. It also updates the dated rate amount information.
If the rate code referred to does not exist it will be added with all the defaults except for rate category which may be entered on
this record. The preferred method is to add the rate code using the rate code record before using this record. If the room type does
not exist it will be added. The same is true of the booking code. The non date effective room type data may be updated without updating
any other data by leaving the rate code blank and effective dates zero. The non date effective booking code data may be updated without
updating any other data by leaving the effective date zero . Action code 'D' will be used to delete a booking code if the effective date
is zero. Otherwise, it will delete a date period. Room types may not be deleted in batch. Rate codes may only be deleted using the Rate
code record. Blank may be used to leave the data the same. This is not true of the rate amount fields. If one amount is updated they
should all be entered.
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
RECORD TYPE Indicates record type. C 1 1 T = Rate Amount Record.
ACTION CODE The type of processing to be C 2 1 U = Update, create or change rate records.
applied to these records. D = Delete selected records
D with a date range will change all rates to zero for the period.
D without a date range will delete the booking code.
VENDOR CODE The industry vendor code C 3 3 Example: AS = Apollo Suites
The third position is reserved for future expansion. Left jusfitied.
PROPERTY IDENTIFIER A five position field that C 6 5 Example: WASJW, WAS01, 01040
uniquely identifies a property
Or optionally, Apollo#.
ROOM TYPE Three character code that C 11 3 Alphanumeric. No spaces allowed.
uniquely identifies a room type. First character must be alphabetic.
First three characters of booking
code.
ROOM DESCRIPTION RULE Pointer to the Room Description N 14 5 0 to 65535.
Rule. Blank = No change (default to 0 on add).
Rule must exist.
RATE CODE Code describing the rate. It is C 19 4 First three characters must be alphanumeric.
the last four characters of the The fourth character may be blank. No
booking code. special characters allowed. Left justified.
PRIMARY RATE CATEGORY One position code which indicates C 23 1 R = Regular or Rack C = Corporate
the rate type. G = Government M = Military
L = Special P = Package
S = Senior Citizens W = Weekend
F = Family Plan T = Tour
A = Association V = Convention
I = Industrial D = Multi-day Package
B = Club N = Multilevel (Negotiated)
Once created it may not be changed.
HOTELS BULK DATA RECORD DESCRIPTIONS
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
ALTERNATE RATE CATEG. Rate will use the Alternate Rate C 24 1 X = Use Alternate Rate Category during day of week
Category that was established at variations.
the property level during day of Zero = Always use Primary rate Category.
week variations. Blank = No change (defaults to zero on add).
Once created it may not be changed.
NUMBER OF PEOPLE Maximum number of people allowed N 25 2 1 to 99.
in the room. This is a booking Blank = No change (not allowed on an add).
code level field.
EFFECTIVE DATE Effective date of the rate change. N 27 8 YYYYMMDD format.
DISCONTINUE DATE Discontinue date of the rate N 35 8 YYYYMMDD format.
amount change. 99999999 = No discontinue date.
PERIOD TYPE An indicator to show that the rate C 43 1 S = Standard date range.
period entered is a standard or an
exception rate period. Exception E = Exception date range. Must be less than 99
rate periods overide standard periods. days. No day of week variations allowed.
Blank = Allow the following algorithm to decide.
If day of week variation is used it is a standard rate period. Otherwise, if period length is less than
28 days it is an exception period. Otherwise, it is a standard rate period.
Note: Standard rates may be any length but it is recommended to use an exception period if the period
length is less than 7 days. An exception period must be less than 100 days. The total number of standard
periods plus exception Periods must be less than 65.
SINGLE RATE Amount of the one person rate. N 44 9 Numeric. Do not include decimal point, but
use the digits as if there was a decimal point.
The decimal point will be placed automatically based
on the currency type. For example: use 10000 to
show 100.00 in USD.
Zero = No single rate.
01 = Rate amount will not show to agent, but rate is
still sellable.
DOUBLE RATE Amount of the two person rate. N 53 9 Numeric. Do not include decimal point, but
use the digits as if there was a decimal point.
The decimal point will be placed automatically based
on the currency type. For example: use 10000 to
show 100.00 in USD.
Zero = No double rate.
01 = Rate amount will not show to agent, but rate is
still sellable.
DAY OF WEEK PATTERN Pattern to which rate amount C 62 7 X = Use variation rate amounts.
applies on what day of the week. Blank = Use standard rate amounts.
Seven characters are used with May be used only on standard rate periods.
the first being Sunday and the
last being Saturday.
HOTELS BULK DATA RECORD DESCRIPTIONS
FIELD | DESCRIPTION | REP | LOC | LEN | SPECIFICATION
VARIATION SINGLE RATE Rate amount to use for one C 69 9 Same rules apply as for the standard amounts. At least
person during the day of week one character in the day of week pattern must be X.
variations.
VARIATION DOUBLE RATE Rate amount to use for two C 78 9 Same rules apply as for the standard amounts. At least
people during the day of week one character in the day of week pattern must be X.
variations.
RECORD LENGTH = 86 BYTES
NOTE: The Rate Amount Record assumes the following defaults of rate level items that are specified on the Rate Code Record (Type S). These
defaults are only used when the rate code is being added for the first time. If the rate code already exists, no values are changed except
the ones specified on the record.
1. Non Commission Indicator is 'N' (A commission is paid to the Travel Agent).
2. Meal Included Indicator is 'N' (No meals included with rate).
3. Cancel Penalty Indicator is 'X' (A cancellation penalty does apply).
4. Advance Purchase Time is zero.
5. Point of Sale and Length of Stay Rule Numbers are zero.
6. Amount is percent of RAC Rate is zero (not a discounted rate).
7. Availability is from rate code is blank (rate uses its own availability).
HOTELS BULK DATA RECORD DESCRIPTIONS
APPENDIX A
STATE AND PROVINCE CODES
STATE/PROVINCE CODE STATE/PROVINCE CODE
Alberta AB Nebraska NE
Alaska AK Newfoundland NF
Alabama AL New Hampshire NH
Arkansas AR New Jersey NJ
Arizona AZ New Mexico NM
British Columbia BC Nova Scotia NS
California CA Northwest Territories NT
Colorado CO Nevada NV
Connecticut CT New York NY
District of Columbia DC Ohio OH
Delaware DE Oklahoma OK
Florida FL Ontario ON
Georgia GA Oregon OR
Hawaii HI Pennsylvania PA
Iowa IA Prince Edward Island PE
Idaho ID Quebec PQ
Illinois IL Puerto Rico PR
Indiana IN Rhode Island RI
Kansas KS South Carolina SC
Kentucky KY South Dakota SD
Labrador LB Saskatchewan SK
Louisiana LA Tennessee TN
Massachusetts MA Texas TX
Manitoba MB Utah UT
Maryland MD Virginia VA
Maine ME U.S. Virgin Islands VI
Michigan MI Vermont VT
Minnesota MN Washington WA
Mississippi MS Wisconsin WI
Missouri MO West Virginia WV
Montana MT Wyoming WY
New Brunswick NB Yukon Territory YT
North Carolina NC
North Dakota ND
- ** This appendix is for sample purposes only.
HOTELS BULK DATA RECORD DESCRIPTIONS
APPENDIX B
__________
COUNTRY CODES
ALPHA
COUNTRY COUNTRY CODE CURRENCY CODE
Abu Dhabi (see United Arab Emirates) AE ADH
Afghanistan AF AFG
Albania AL LEK
Algeria DZ ALD
Angola AO AKZ
Anguilla AI ECD
Antigua and Barbuda AG ECD
Argentina AR ARA
Ascension Island/St. Helena SH UKL
Australia AU AUD
Austria AT AUS
Bahamas BS BSD
Bahrain BH BHD
Bangladesh BD BDT
Barbados BB BDD
Belize BZ BZD
Benin BJ AFR
Bermuda BM BED
Bolivia BO BOP
Botswana BW BTP
Brazil BR BRZ
British Virgin Islands VG USD
Brunei BN BRD
Bulgaria BG LEV
Burma BU BUR
Uganda UG UGS
Union Of Soviet Socialist Republics SU ROU
United Arab Emirates (comprised of Abu
Dhabi, Ajman, Dubai, Fugairah, Ras Al
Khaimah, Sharjah, Umm Al Quaiwain) AE ADH
United Kingdom GB UKL
United States of America US USD
United States Virgin Islands VT USD
Uruguay UY NUP
U.S.S.R. SU ROU
Vanuatu VU VUV
Venezuela VE VBO
Vietnam VN VDN
Wake Island WK USD
Wallis & Futuna Islands WF USD
Yemen, Arab Republic YE YEM
Yemen, Democratic YD DYD
Yugoslavia YU YUD
Zaire Republic ZR ZAI
Zambia ZM ZMK
Zimbabwe RH ZWD
** This appendix is for sample purposes only.
HOTELS BULK DATA RECORD DESCRIPTIONS
APPENDIX C
CREDIT CARD CODES
CREDIT CARD CODE CREDIT CARD CODE
Australian BankCard AB MasterCard CA
American Express AX Shoppers Card SC
Banamex B1 United Airlines Travel Card UC
Choice CX Visa VI
EuroCard EC Hertz ZE
0 ** This appendix is for sample purposes only.
HOTELS BULK DATA RECORD DESCRIPTIONS
APPENDIX D
PHONE & ADDRESS RULES
PHONE and FAX NUMBERS
Phone and Fax numbers should include area code, space, prefix, hyphen and suffix.
Remember to include applicable dialing codes. Do not use special characters such as slashes (/), parenthesis (( )) or plus signs (+). 303 555-5686
ADDR - Street Address
To define the street address for the property.
Up to 5 lines of text will be accepted, however only the first 2 lines (25 characters per line) will print on the travel agent itinerary.
Line 1 must include physical street address of property
Line 2 must include actual city name, two letter state code, and postal code
Line 3 may include country
The state code and postal code must NOT appear on line 3, as it will never be picked-up by the travel agents customer Itinerary/Invoice.
Addresses should be input in the format illustrated below:
Example:
9700 W Higgins Road@
Rosemont@IL@60018@
US@
Example:
Park Lane@
London@WIA AAA@ UK@
The @ symbols allow the address to be printed correctly on an itinerary. No other special characters are permitted.
POSTAL/ZIP CODE
No spaces or special characters are permitted.
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- finance job descriptions and duties
- daycare job descriptions duties
- marketing job descriptions and duties
- nonprofit job descriptions templates
- descriptions of a good man
- culture descriptions for a workplace
- one word descriptions of people
- pill descriptions and pictures
- personality descriptions words
- facilities job descriptions and duties
- cfo job descriptions and responsibilities
- finance job descriptions and titles