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