ࡱ> U@ +bjbj 0kRRRRRRRf*7*7*78b7\7f~: <:<<<<?@|BZ$RIR;q<<;q;qRR<<;qR<R<;q(:,RRҞ<r: }!*7u% Ѩ0Ȟ  ҞffRRRR RҞ(AR 8^ gO AAAff1*7"ff*7HOTELS BULK DATA RECORD DESCRIPTIONS  TIME \@ "d MMMM, yyyy" 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  TOC \o "1-3" CONTENTS  PAGEREF _Toc6812571 \h 1 SUBSCRIPTION HEADER RECORD  PAGEREF _Toc6812572 \h 2 CHAIN POLICY RECORD - (GENL)  PAGEREF _Toc6812573 \h 3 CHAIN POLICY RECORD - (RULE)  PAGEREF _Toc6812574 \h 5 CHAIN POLICY RECORD - (FREE FORM TEXT)  PAGEREF _Toc6812575 \h 7 PRIMARY HOTEL RECORD  PAGEREF _Toc6812576 \h 9 SECONDARY HOTEL RECORD  PAGEREF _Toc6812577 \h 16 INDEX RECORD  PAGEREF _Toc6812578 \h 18 DEPOSIT/GUARANTEE RECORD  PAGEREF _Toc6812579 \h 22 RESERVATION RULE RECORD  PAGEREF _Toc6812580 \h 24 EXTRA OPTIONS RULE RECORD  PAGEREF _Toc6812581 \h 31 CANCELLATION PENALTY RULE RECORD  PAGEREF _Toc6812582 \h 34 METHOD OF PAYMENT RULE RECORD  PAGEREF _Toc6812583 \h 35 LENGTH OF STAY RULE RECORD  PAGEREF _Toc6812584 \h 37 ROOM DESCRIPTION RULE RECORD  PAGEREF _Toc6812585 \h 39 CHECK-IN/OUT TIMES RECORD  PAGEREF _Toc6812586 \h 43 POINT OF SALE RULE RECORD  PAGEREF _Toc6812587 \h 44 RULE CONNECTION RECORD  PAGEREF _Toc6812588 \h 46 RATE CODE RECORD  PAGEREF _Toc6812589 \h 48 RATE AMOUNT RECORD  PAGEREF _Toc6812590 \h 50 APPENDIX A  PAGEREF _Toc6812591 \h 53 STATE AND PROVINCE CODES  PAGEREF _Toc6812592 \h 53 APPENDIX B  PAGEREF _Toc6812593 \h 54 COUNTRY CODES  PAGEREF _Toc6812594 \h 54 APPENDIX C  PAGEREF _Toc6812595 \h 55 CREDIT CARD CODES  PAGEREF _Toc6812596 \h 55 APPENDIX D  PAGEREF _Toc6812597 \h 56 PHONE & ADDRESS RULES  PAGEREF _Toc6812598 \h 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. Non Commission Indicator is 'N' (A commission is paid to the Travel Agent). Meal Included Indicator is 'N' (No meals included with rate). Cancel Penalty Indicator is 'X' (A cancellation penalty does apply). Advance Purchase Time is zero. Point of Sale and Length of Stay Rule Numbers are zero. Amount is percent of RAC Rate is zero (not a discounted rate). 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.  FILENAME \p J:\RMS\Bulk Data Transfer\Documentation\Bulk Data Record Descriptions.doc Page:  PAGE 52 Date:  DATE \l 12/9/2003 %&'?@PQRF G    0 1 2 3 4 P Q i j k l m ŷŦŷŷŕŷŷńŷŷs jkh UUmHnHu jh UUmHnHu jyh UUmHnHu jh UUmHnHujh UUmHnHuh UmHnHu h U>*h UB*phh U5B*phhmHnHujh UUh U h UCJ-%&RSr s F G 5 n )\ 68 k*  $%&'(>?WXYZ[st'()+,GH` jAh UUmHnHu jh UUmHnHu jOh UUmHnHu jh UUmHnHu j]h UUmHnHu jh UUmHnHujh UUmHnHuh UmHnHu/-fY1cFw$a$ ! 68  68 `abde:;STUWXstضإؔ؃r jh UUmHnHu jh UUmHnHu jh UUmHnHu j%h UUmHnHu jh UUmHnHu j3h UUmHnHuh UmHnHujh UUmHnHu jh UUmHnHu,+,-/0DE]^_abno jf h UUmHnHu j h UUmHnHu jt h UUmHnHu jh UUmHnHu jh UUmHnHu j h UUmHnHujh UUmHnHuh UmHnHu/'(@ABDEXYqrsuv!&;F`cilpswضإؔ،}}}}}} h U>* h UCJh Ujh UU j h UUmHnHu jJ h UUmHnHu j h UUmHnHu jX h UUmHnHuh UmHnHujh UUmHnHu j h UUmHnHu1 !k:;'WXh$a$()#$k@  vEF!!!!"""""!"%"2"((((((((((((55555555555 6=7B7Q7\7w7z7}777777=GBGPG[GrGuGyG|GGGGGKKKRL%MMM3N4NhQmQ}QQQQQQh UB*phh U5B*ph h U5h U h U>*X + , !!b!!!!!!!!4"5"""#N#O###2$e$f$$a$f$$ %?%q%%%&P&&&&2'j''''H(I(o(p(((()q))))$a$ !))k**Q++8,,, -{---@._.`...///////0001x111111I223-3.333 4 4a4444H5i5k555555 66k666$a$666777<7=777.8888J9K990::::b;;%<<<<M==$a$=>>z>{>>E?F??@k@@)AAA[BBCCDzDDMEE*FFFGG$a$GG*h U\UIVJVVVVVWWWXsXXYYYY^Z}ZZZZZZZ,[-[[[$a$[[1\\\\e]f]]6^7^^^_p__N`O``aaaajbbb:ccc d ddddQeReefffEfFfGf\f]fff*ggg!hhhhnioiiTjj$a$j:kklullmmmm2nknnnnToo0pp q qqqqUrrr@ssttttttttt+u,u-uuu!v"vzv{v|vvkww܈+zɉgghj`M:؍'vŎcP=$a$ۑ*yȒfS@ޕ<=2Зn [$a$MƔיڙ:ڢ$'+.2?5OȴӴ $%Lg)4LOUX\_cp h U;h U>*B*phh UB*phh U5B*ph h U5 h U7 h U>*hFuh UO \Ov|oNr3ɤʤˤWX̥@gۧ<pѩ1$a$k̫ͫ,LM"}FvܰF!  pqst%&\!wٷ;u׹G $a$hD cƿ()~27vwKx l^l`x34HTU$a$<\$CqsG1CD)_  ^ ` #$5szHWsxGU+8{|..<<BBBBBBBBBBBBSTT#T9T*h U5B*phh UXBCDjklyzq W1mnE$a$iBOG p6_%Nww=cdersGn*E{.h$a$h4f2+dg{| Bz  c%&!"#\lmmnuyz;{;}~!a31 ?e~      "       M  $a$ M78#$ ./9:WXYx~lsh3lK23YS=k  ^!_!z!""#5###$c$$$$%U%V%%&{&&Q'R'''@((+))))J**2+++,,-{---..///0d0e000^1_1_11[22=3>3Y33_444#55 6 6l66I7J77 8m8n88j999:::::n;;K<L<z<<`=a==H>>>>???@@AAABfBgBBMCCCCCoDDtEuEE%FFF GqGGGnHHHHIIIhJJEKFKK-L.LfLLLMMMN|NNNOOOOrPPOQPQQ7RRRWSS]TTUrUsUUoVVVVWWWWWoXXXWYY4Z5ZZ[[[[[\j\k\\g]]]O^^^^f_f___N``+a,aabb@bb'c(ccddddd2ee7f8fiffPgQggMhMhhh5iiiiNjjj6kklllllmmm;nunnn(ofooopMpMpNpp5q6qq.rrr"scssstt u u%uu+vv/w0www0xixjxxYyYyyyDzzz{zzl{{||}} ~D~E~~   qԁ(|opw6u4b؈و  s:\]]ԊPˋ5ΌVԍ\]?y9w0fgɑǒ~"MNʔC=>3-.# }}mn {|dؤ٤Kեե֥}78)}deĬŬ9:``ڮۮ>op6y߰RSpqݱ@A12S۳X[ѵFmne_ظٸMܹF  klռּLM.pjǿȿ1q$)O89jk#`aTU GmnIJkzuv v+(fDI9L[\qponjkHIp'xfgZ<=3p_ JJ ./n4`'(WXmA|R$f;ch:`=CIOU[a  g  m  s  y   &7()IOM_`K-.)CRR]drsq  Z!!f""U#V##Q$R$$$`%%%4&f&g&&''''''B(((.)/)))******++++0,,7-8---/////0162y2p3q3r33m44O5P55576r666#7W7X7y7z77<8w88888R9S9p999::;;;;;<N<<<<=4=]=======R>R>w>>>>>?%?>?W?q??????@B@n@@@@ AMAyAAAABP^PBBMBsBtBB C CyCCNDDD E EEEeFF(G)GGH}HHIII J$a$ J}JJ0K1KKL4L5LLMMNNNOmOO;PPPQ8QdQeQQJRRASSSSSSSS|TTiUjUUUUUI_bhkorv+0EPfiorvy}k klyzjh UUh h Uh h UCJ h U5h UB*phh U5B*phhh U h U>*KZ%[&[[[[[{\\a]b]]O^^9__#``'aa bbcccccc^dddEeqeeeyfzffSgggGhh@iAiijjxjjjnkkUllFmmDnEnnn%ooooLpp.q/qq r r%rKrLr_r`rrjss{tuuvvvv9w:w$a$:www xxx4y5yyyyXzzzz3{{{||r||N}O}}E~~~:gd:% #$' hqrևGH$a$wznjȌEƍLΎ3!Vܓ=>#֕*+3ܗݗf)*Cef5T & F$a$˛ui]ןQˠE9-!  & Fwk_٩SͪG;MOPQӭ@AX&[±)^ų,aȵ/d˷2gι"W%Z(]Ŀ+, znkNPb~  FHRj !j~(*+;k()*+$a$z)*+hh0JmHnHu h U0Jjh U0JUh Ujh UUhh UhmHnHu.0 0P= /!"# $ %  yDyK  _Toc6812571yDyK  _Toc6812572yDyK  _Toc6812573yDyK  _Toc6812574yDyK  _Toc6812575yDyK  _Toc6812576yDyK  _Toc6812577yDyK  _Toc6812578yDyK  _Toc6812579yDyK  _Toc6812580yDyK  _Toc6812581yDyK  _Toc6812582yDyK  _Toc6812583yDyK  _Toc6812584yDyK  _Toc6812585yDyK  _Toc6812586yDyK  _Toc6812587yDyK  _Toc6812588yDyK  _Toc6812589yDyK  _Toc6812590yDyK  _Toc6812591yDyK  _Toc6812592yDyK  _Toc6812593yDyK  _Toc6812594yDyK  _Toc6812595yDyK  _Toc6812596yDyK  _Toc6812597yDyK  _Toc6812598D@D NormalCJOJQJ_HmH sH tH 4@4 Heading 1$@&4@4 Heading 2$@&D@D Heading 3$@&>*CJOJQJD@D Heading 4$@&5CJOJQJDA@D Default Paragraph FontVi@V  Table Normal :V 44 la (k@(No List .)@. Page Number4 @4 Footer  !4@4 Header  !JP@"J Body Text 2  ^ CJOJQJkH@>@2@ Title$a$>*CJOJQJkHTC@BT Body Text Indent  ^ 5CJOJQJ&@& TOC 1.@. TOC 2 ^.. TOC 3 @^@.. TOC 4 ^.. TOC 5 ^.. TOC 6  ^ .. TOC 7 ^.. TOC 8 `^`.. TOC 9 ^+%&RSrsFG5n)\-fY 1 c  F w    ! k  : ; 'WXh()#$k@  vEF+,b45NO2ef ?qP2jH I o p !q!!!!!k""Q##8$$$ %{%%%@&_&`&&.'/'''''((()x)))))I**+-+.+++ , ,a,,,,H-i-k------ ..k.....///>>???܀+zɁghj`M:؅'vņcP=ۉ*yȊfS@ލ<=2Џn [ \Ov|oNr3ɜʜ˜WX̝@g۟<pѡ1ḳͣ,LM"}FvܨF! pqst%&\!wٯ;uױG hD cƷ()~и27vwȺKxۻܻ޻߻Ͼо34HTU<\$CqsG1CD)_BCDjklyzq W1mnEiBOG p6_%Nw=cdersGn*E{.h4f2+dg{| Bz c%&!"#\lmmnuyz;{;}~!a31 ?e~"MM78#$ . /   9 : W X Y    x  ~  l  sh3lK23YS=k^_z5cUV{QR@  +!!!!J""2###$$%{%%%&&'''(d(e(((^)_))[**=+>+Y++_,,,#-- . .l..I/J// 0m0n00j1112222n33K4L4z44`5a55H666677788999:f:g::M;;;;o<<t=u==%>>> ?q???n@@@@AAAhBBECFCC-D.DfDDEEEF|FFFGGGGrHHOIPII7JJJWKK]LLMrMsMMoNNNWOOOOoPPPWQQ4R5RRSS[SSTjTkTTgUUUOVVVVfWWWNXX+Y,YYZZ@ZZ'[([[\\\\\2]]7^8^i^^P_Q__M```5aaaaNbbb6ccdddddeee;fufff(gfggghMhNhh5i6ii.jjj"kckkkll m m%mm+nn/o0ooo0pipjppYqqqDrzr{rrlssttuu vDvEvv w wwwxxy yqyy(zzz{|{{{o|p|||w}}}6~u~~~4b؀ـ  s:\]ԂP˃5΄Vԅ\]?y9w0fgɉNJ~"MNʌC=>3-.# }mn {|d؜ٜK՝֝}78)}deĤŤ9:`ڦۦ>op6yߨRSpqݩ@A12S۫X[ѭFmne_ذٰMܱF  klմִLM.pjǷȷ1q$)޻߻O89jk#`aTU GmnIJkzuv v+(fDI9L[\qponjkHIp'xfgZ<=3p_ J ./n4`'(WXmA|R$f;ch:`=CIOU[agmsy        &   7()IOM_`K-.)CR]drsqZfUVQR`4fgB   .!/!!!""""""####0$$7%8%%%''''()6*y*p+q+r++m,,O-P---7.r...#/W/X/y/z//<0w0000R1S1p11122333334N4444545]5555555R6w666667%7>7W7q7777778B8n8888 9M9y9999::M:s:t:: ; ;y;;N<<< = ===e>>(?)??@}@@AAA B}BB0C1CCD4D5DDEEFFFGmGG;HHHI8IdIeIIJJJAKKKKKKK|LLiMjMMMMM#֍*+3܏ݏf)*Cef5T˓ui]חQ˘E9-! wk_١S͢G;MOPQӥ@AX&[©)^ū,aȭ/d˯2gα"W%Z(]ķ+, znkNPۿb~  FHRj~(*+;k(),00000000800G0G0G0G0G0G0G0G00000000000000000000000000000000000000000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 000000000000000000000000000000000000000000000000000000000000000000000000000x0x0p x0p x0p x0p x0p x0p 0p x0p x0p x0p x0p 0p x0p x0p 0p x0p x0p x0p x0p 0p x0p 0p x0p x0p x0p x0p x0p x0p x0p x0p x0p x0p x0p x0p x0p x0p x0p x0p x0p 0p 0p 0p 80p 0p 0p 0p 0p 0p 0p 0p (0p @0p 0p 0p 0p x0p x0p x0p x0p x0p x0p x0p x0p x0p x0p x0p x0p x0p x0p x0x0/x0/x0/x0/x0/x0/x0/0/x0/x0/0/x0/x0/0/x0/x0/0/x0/x0/0/x0/x0/0/x0/x0/0/x0/x0/0/0/x0/x0/x0/ 0/ 0/0/ 0/x0/ 0/0/0/ 0/x0/ 0/0/0/ 0/x0/ 0/0/x0/x0/x0/x0/x0/x0/x0/0/x0/x0/0/x0/x0/0/x0/x0/x0/0/x0/x0/x0/x0/x0/0/x0/x0/x0/x0/x0/0/0/0/0/0/0/0/0/0/0/x0/x0x0RIx0RIx0RIx0RIx0RIx0RIx0RI0RIx0RIx0RI0RIx0RIx0RIx0RI0RI0RI0RIx0RIx0RI0RIx0RIx0RIx0RIx0RIx0RI0RIx0RI0RI0RI0RIx0RI0RIx0RIx0RI0RIx0RIx0RIx0RIx0RIx0RIx0RIx0RI0RIx0RIx0RI0RIx0RIx0RI0RIx0RIx0RI0RIx0RIx0RI0RIx0RIx0RI0RIx0RIx0RI0RIx0RIx0RI0RI0RIx0RIx0RIx0RI0RI0RIx0RI0RI0RI0RIx0RIx0RI0RI0RI0RIx0RIx0RI0RI0RIx0RIx0RIx0RIx0RIx0RIx0RI0RI0RIx0RIx0RIx0RIx0RIx0RI0RIx0RIx0RI0RIx0RI0RIx0RIx0RI0RIx0RIx0RI0RIx0RIx0RI0RIx0RIx0RI0RI0RIx0RI0RI0RIx0RI0RI0RI0RIx0RIx0RI0RI0RI0RIx0RIx0RI0RI0RI 0RIx0RIx0RIx0RIx0RIx0RIx0RIx0RIx0RIx0RIx0RI0RIx0RIx0RIx0RIx0RIx0RI0RI0RI0RI0RI0RI0RI0RI0RI0RIx0RI0RIx0RI0RIx0RIx0RIx0RIx0RIx0RIx0RIx0RI0RIx0RIx0RI0RIx0RIx0RIp0RIx0RIp0RIp0RIp0RI0RIx0RIx0RIx0RI0RIx0RIx0RIx0RIx0RIx0RI0RI0RI0RI0RI0RI0RI0RI0RI0RI0RI0RI0RI0RI0RI0RI0RI0RI0RI0RI0RI0RI0RI0RI0RI(0RI(0RI(0RI 0RIx0RIx0RIx0RIx0RIx0RIx0RI0RI0RIx0RIx0RI0RIx0RIx0RI0RIx0RIx0RI0RIx0RI0RIx0RIx0RI0RI0RIx0RIx0RIx0RIx0RIx0RI0RIx0RI0RIx0RI0RIx0RI0RIx0RI0RIx0RI0RIx0RI0RIx0RI0RIx0RI0RIx0RI0RIx0RI0RIx0RI0RIx0RI0RIx0RIx0RIx0RIx0RIx0RIx0RIx0RIx0RIx0RIx0RI0RIx0RIx0RIx0RIx0RIx0RI0RI0RI0RI0RI0RI0RI0RI0RI 0RIx0RI 0RI0RI 0RIx0RI 0RI0RI 0RI0RI 0RIx0RIx0RIx0x0˜x0˜x0˜x0˜0˜0˜0˜x0˜x0˜x0˜0˜x0˜x0˜0˜x0˜x0˜x0˜x0˜x0˜x0˜x0˜x0˜x0˜x0˜0˜0˜x0˜0˜0˜0˜0˜0˜0˜0˜ 0˜ 0˜00˜ 0˜ 0˜0˜ 0˜0˜00˜ 0˜ 0˜0˜ 0˜ 0˜(0˜ 0˜ 0˜80˜x0˜x0˜x0˜x0˜x0˜x0˜x0˜0˜x0˜x0˜0˜x0˜x0˜0˜x0˜x0˜0˜x0˜x0˜0˜x0˜x0˜0˜0˜0˜0˜0˜0˜0˜ 0˜x0˜ 0˜0˜0˜0˜0˜0˜0˜0˜0˜0˜0˜0˜0˜(0˜(0˜(0˜(0˜(0˜(0˜(0˜(0˜(0˜(0˜(0˜ 0˜x0˜x0˜x0˜x0˜x0˜x0x0x00x80x0x00x0x0x0x0x00x0x0x0x0x0x0x00H00x00x0 0x0x0x00x00x00x00x00x0(0x0(0x0(0x0(0x0(0x0(0x0x0x0x0x0x0x0x0x0x0x0x0x0x0x0x0x0x0x0x0x0x0x0x0x0x0x0H0x0x0x0x0x0x0x0x0x0x0x0x0x0x0x0x0x0x0x0x0x0x0x0x0x0x0x0x0x0x0x0x0x0x000x0x00x0x00000x00x0000000000 0x0 00 00 00 00 0000 0 00 0 0800 00 0080(0 00x0x0x0x0x0x0x0x0x0x0x0x0x0x00x0x00x0x0000000x000x00000000 0x0 000000 0000 0 00 0(0800 00 0 080(0 00 0(0x0x0x0x0x0x000x0x00x0x000000x000x0000 0x0 000 0x0 00 00 0x0x0 x0 x0 x0 x0 0 x0 0 x0 0 x0 x0 x0 0 x0 0 0 0 0 0 0 x0 0 x0 0 x0 0 0 0 0 0 0 0 0 0 0 0  0 0 00  0  0  0 x0 x0 x0 x0 x0 x0 x0 x0 0 x0 x0 x0 0 x0 x0 x0 x0 x0 0 x0 x0 x0 x0 x0 0 x0 x0 x0 x0 x0 0 0 x0 0 0 x0  0 x0 0  0  0 x0  0 x0 0  0  0  0  0  0  0  0  0  0  0  0  0 x0 x0 x0 x0 x0 x0 0 0 0 x0 0 0 x0 x0 0 x0 x0 0 x0 x0 x0 x0 0 x0 x0 0 x0 x0  0 x0  0  0 x0  0 0  0  0 x0 00  0  0  0 x0 00  0  0 0  0  0 80 0  0 0 x0 x0 x0 x0 x0 x0 x0 0 x0 x0 0 0 x0 x0 0 x0 x0 x0 0 x0 0 0 0 0 0 0 0 0 x0 0 x0 0 x0 0 x0 0 x0 0 x0 0 x0 0  0 0  0  0  0 0 x0 x0 x0 x0 x0 x0 x0 0 x0 x0 0 x0 x0 0 x0 0 x0 0 0 0 0 x0 x0 0 0 x0 0 x0 0 x0 0 x0 0 x0 0 x0 0 x0 0 x0 0 x0 0 x0 0 x0 0 0 0  0  0  0  0  0  0  0 x0 x0 x0 x0 x0 x0 0 0 x0 x0 0 0 x0 x0 x0 x0 x0 x0 x0 x0 x0 x0 x0 x0 x0 0 0 x0 0 0 x0 0 0 0 0 0  0 x0  0 0 0  0 x0  0 0 0  0 x0  0 0  0 0  0 0  0 0 0 x0 x0 x0 x0 x0 x0 x0 x0 x0 x0 x0 x0 x0 x0 x0 x0 x0 x0 x0 x0 x0x0lsx0lsx0lsx0lsx0lsx0lsx0ls0lsx0lsx0lsx0lsx0lsx0ls0lsx0lsx0ls0lsx0lsx0ls0lsx0lsx0ls0lsx0lsx0ls0lsx0lsx0ls0lsx0lsx0ls0ls0lsx0ls0ls0ls0lsx0lsx0ls0ls0ls0lsx0ls0ls 0lsx0ls 0ls0ls0ls 0lsx0ls 0ls0ls0ls 0lsx0lsx0lsx0lsx0lsx0lsx0lsx0ls0ls0lsx0lsx0ls0lsx0lsx0ls0lsx0lsx0ls0ls0ls0ls0lsx0lsx0lsx0lsx0lsx0lsx0lsx0lsx0lsx0lsx0lsx0ls0ls0ls0ls0ls0lsx0ls0ls0ls0ls0ls0ls0ls0ls0ls0ls0ls 0ls0ls 0ls0ls 0ls0ls 0ls0ls 0ls0lsx0lsx0lsx0lsx0lsx0lsx0lsx0lsx0lsx0lsx0lsx0lsx0lsx0lsx0lsx0lsx0lsx0lsx0lsx0lsx0lsx0lsx0lsx0lsx0lsx0lsx0x0֝x0֝x0֝x0֝x0֝x0֝x0֝x0֝0֝x0֝x0֝x0֝x0֝x0֝0֝x0֝x0֝x0֝x0֝x0֝0֝x0֝x0֝x0֝x0֝x0֝x0֝x0֝x0֝x0֝x0֝x0֝x0֝x0֝0֝x0֝0֝x0֝0֝x0֝0֝x0֝0֝x0֝0֝x0֝0֝x0֝0֝x0֝0֝x0֝x0x02x02x02x02x0202x0202x02x02x02x020202x02x02x02x02x02x0202x02x0202x02x0202x02x0202x02x02020202x02x02020202 0202 02x02 020202 02x02 020202 02x02x02x02x02x02x02x0202x02x02x0202x02x02x02x02x0202x02x02x02x02x02x02x02x02x02x020202x0202x02x0x0Jx0Jx0Jx0Jx0J0Jx0Jx0J0Jx0Jx0J0Jx0Jx0J0J0J0Jx0Jx0Jx0Jx0Jx0Jx0J0J0J0J0J0Jx0J0Jx0J0J0J0J0J0J0J0J0J0J0J0J0J0J0J0Jx0Jx0Jx0Jx0Jx0Jx0J0J0Jx0Jx0J0Jx0Jx0J0Jx0Jx0J0Jx0Jx0J0J0Jx0Jx0x0kx0kx0kx0kx0k0kx0kx0k0kx0kx0k0kx0kx0k0kx0kx0k0kx0kx0k0kx0kx0k0kx0kx0k0k0k0k0k0kx0kx0k0k0k0kx0k0k0k0k0k0k0kx0kx0kx0kx0kx0kx0k0k0kx0kx0k0kx0kx0k0k0kx0k0k0k0k0k0k0k0k0k0k0k0k0kx0k0k0k0k0k0k0k0k0k0k0k0k0k 0k0k00k 0k 0k 0k 0k 0kx0kx0kx0kx0kx0kx0k0k0kx0kx0k0kx0kx0kx0k0kx0kx0k0k0kx0kx0kx0kx0kx0kx0kx0kx0kx0k0k0kx0kx0k0k0k0kx0k0kx0k0kx0k0k 0k0k 0k0k 0k0k 0k0k 0k(0k 0k0kx0kx0kx0kx0kx0kx0kx0k0kx0kx0k0k0kx0kx0k0kx0k0k0k0x0)x0)x0)x0)x0)x0)x0)0)x0)x0)0)x0)x0)0)x0)x0)0)x0)x0)x0)x0)x0)x0)x0)x0)x0)x0)x0)0)0)0)x0)x0)0)0)0)x0)0) 0) 0) 0) 0) 0) 0) 0) 0) 0) 0) 0) 0) 0)x0x0#x0#x0#x0#x0#x0#0#x0#x0#0#0#x0#x0#x0#x0#x0#x0#x0#x0#x0#x0#x0#x0#x0#x0#x0#x0#x0#0#0#x0#0#0# 0#0#0# 0#x0# 0#0#0# 0#x0# 0#x0#x0#x0#x0#x0#x0#x0#0#x0#x0#0#0#x0#x0#0#x0#x0#x0#0#x0#x0#x0#x0#0#x0#x0#x0#x0#x0#0#0#0#0#0#0#0# 0#0# 0#0# 0#0# 0#0# 0# 0# 0#0# 0# 0#0# 0# 0#0#x0x0t:x0t:x0t:x0t:x0t:0t:x0t:x0t:0t:x0t:x0t:x0t:0t:x0t:x0t:x0t:x0t:x0t:x0t:x0t:x0t:x0t:x0t:x0t:x0t:x0t:x0t:0t:x0t:0t:0t:x0t:0t:0t:0t:0t:0t:0t:0t:0t:0t:0t:0t: 0t:x0t: 0t:0t: 0t: 0t:x0t:@0t: 0t: 0t:0t:x0t:x0t:x0t:x0t:x0t:x0t:0t:0t:x0t:x0t:x0x0Mx0Mx0Mx0Mx0M0Mx0M0Mx0Mx0Mx0Mx0M0M0Mx0Mx0Mx0M0M0MP0M0M0M0Mx0M0Mx0M0Mx0M0M0M0M0M0M0M0M 0M0M(0M0M 0M0M 0M 0M 0M 0M(0M80M 0Mx0Mx0Mx0Mx0Mx0Mx0M0Mx0M0M0Mx0Mx0M0M0M0M0Mx0Mx0Mx0Mx0Mx0Mx0M0M0M0M0M0M0M0M0M0M0M0M0M0M0M0M0M0Mx0x0Ljx0Ljx0Ljx0Ljx0Ljx0Lj0Ljx0Ljx0Ljx0Ljx0Lj0Lj0Lj0Ljx0Ljx0Ljx0Lj0Ljx0Ljx0Lj0Lj0Lj 0Lj0Lj0Lj 0Lj0Ljp0Lj 0Lj0Lj 0Lj 0Ljx0Lj00Lj0Lj 0Lj0Lj 0Lj0Lj00Lj 0Lj 0Lj0Lj 0Lj 0Lj80Lj0Lj 0Lj0Lj 0Lj0Ljx0Ljx0Ljx0Ljx0Ljx0Ljx0Lj00Lj0Ljx0Ljx0Lj0Ljx0Ljx0Lj0Lj0Ljx0Ljx0Ljx0Lj0Ljx0Lj0Ljx0Lj0Lj0Lj0Lj0Lj0Ljx0Lj 0Lj 0Lj0Lj 0Lj0Lj(0Lj0Lj 0Lj0Lj 0Lj 0Lj 0Lj0Lj00Lj 0Lj 0Lj 0Lj 0Lj 0Lj@0Lj 0Lj 0Lj 0Lj 0Lj 0Ljx0Ljx0Ljx0Ljx0Ljx0Ljx0Ljx0Ljx0Lj0Ljx0Ljx0Lj0Lj0Lj0Lj0Ljx0Ljx0Ljx 0Ljx 0Lj 0Ljx 0Lj 0Lj 0Lj  0Lj00x0x0x0x0x0x00x000x0x00x0x0x0x0x000 00 00 0 00 0 00 00(0 00 00(00(0 000 0x0x0x0x0x0x00x0 00x0x00x0x0x0x0x0x00000000x000000x0 00(0 0 000 00 0000 00 0 080 00 00 0 0x0x0x0x0x0x0x000x0x00x0x0x0x0x0x0x000x0x0x0x00x0x00x0000x0x0x0x0x0x0x00000000 00 00 0x@0@0 {0oܛ `QM Wz+fiklmpyf$)16=GOU[ djtytg xwh  '_1:CLVf_MhMpYy]}ե`JR'/8R>B JSZdn:w:j+gjnoqrstuvwxz{|}~*h&?P 13Pjl %'>XZs(+Gad:TWs , / D ^ a n   ' A D X r u + t 4%4%4%4%4%4%4%4%4%4%4%4%4%4%4%4%4%4%4%4%4%4%4%4%4%4%4%4%4X`gj~! _Toc6812571 _Hlt6812599 _Hlt9399434 _Toc6812572 _Toc6812573 _Toc6812574 _Toc6812575 _Toc6812576 _Toc6812577 _Toc6812578 _Toc6812579 _Toc6812580 _Toc6812581 _Toc6812582 _Toc6812583 _Toc6812584 _Toc6812585 _Toc6812586 _Toc6812587 _Toc6812588 _Toc6812589 _Toc6812590 _Toc6812591 _Toc6812592 _Toc6812593 _Toc6812594 _Toc6812595 _Toc6812596 _Toc6812597 _Toc6812598P p /RI˜ osٝ5Jn)#t:MLjݔإ2, m  ;/fI sRdB#:M^j?,6e Lke  ke je  e L e  e e e ,e le e L6e 6e 6e  7e L7e 7e 7e  8e !e !e $!e d!e !e !e $!e d!e !e !e $!e d!e !e !e $!e d!e !e !e e e <e |e e e <f |f f f <f |f f f <f | f  f  f m# f m# f  n#f Ln#f n#f n#f  o#f Lo#f o#f o#f  p#f Lp#f p#f p#f  q#f Lq#f q#f q#f  r#f Lr#f r# f r#!f  s#"f Ls##f s#$f s#%f  t#&f Lt#'f t#(f t#)f  u#*f Lu#+f u#,f u#-f  v#.f Lv#/f v#0f v#1f  w#2f Lw#3f w#4f w#5f  x#6f Lx#7f x#8f x#9f  y#:f Ly#;f y#f Lz#?f z#@f z#Af  {#Bf L{#Cf {#Df {#Ef  |#Ff L|#Gf |#Hf |#If  }#Jf L}#Kf }#Lf }#Mf  ~#Nf L~#Of ~#Pf ~#Qf  #Rf L#Sf #Tf #Uf #Vf <#Wf |#Xf #Yf #Zf <#[f |#\f #]f #^f <#_f |#`f #af #bf <#cf |#df #ef #ff <#gf |#hf #if #jf <#kf |#lf #mf #nf <#of |#pf #qf #rf <#sf |#tf #uf #vf <#wf |#xf #yf #zf <#{f |#|f #}f #~f <#f |#f #f #f <#f |#f #f #f <#f |#f #f #f <#f |#f #f #f <#f |#f #f #f <#f |#f #f #f <#f |#f #f #f <#f |#f #f #f <#f |#f #f #f <#f |#f #f #f <#f |#f #f #f <#f |#f #f #f <#f |#f #f #f <#f |#f #f #f <#f |#f #f #f <#f |#f #f #f <#f |#f #f #f <#f |#f #f #f <#f |#f #f #f <#f |#f #f #f <#f |#f #f #f <#f |#f #f f 4f tf f f 4f tf f f 4f tf f f 4f tf f f 4f tf f f 4f tf f f 4f tf f f 4f tf f f 4f tf f f 4f tf f f 4f tg g g 4g tg g g 4g tg  g \PQQRccҼii??nn3 3   ""%#%#$$$$|SjjSkSk.[[a555S\__rxx::ll22Z``''NTTHH™™  <<i*00xx$$`  ZZΞΞHHzzŸ<<nn00bbܡܡ$$VVʢТТJJģģ>>k[[§§))^^ũũAAaaȫȫ//dd˭22gίί55jjѱѱ  //h]]ĵ``ǷǷͷ..ѺѺTTwSS,      !"#%$&(')*+,-/.0124356789:;<=>?@ABCDEFHGIJKMLNOPQRTSUWVXYZ[\]^a_`bdcefgihjklmnpoqrsutvwxyz|{}~     ! "#$%&(')+*,.-/012345dPRRRssѼԼԼppEErr7 7   "")#)#$$$$S%j%jbkbk3`ff##555S\__rȕȕFFss8\\gg  -PP^^w֙Dkk,,77~  kbڞڞTT˟˟AAvv88gg++__̢̢ۢۢ!RR::KmmƤffɧɧ00qqΩΩGGhhϫϫ99iiҭ99}ԯԯ==    11vȳȳddϵjj̷շշ44ۺXyyff,  !"#%$&(')*+,-/.0124356789:;<=>?@ABCDEFHGIJKMLNOPQRTSUWVXYZ[\]^`a_bdcefgihjklmnpoqrsutvwxyz|{}~     ! "#$%&(')+*,.-/01234596*urn:schemas-microsoft-com:office:smarttagsplace=4*urn:schemas-microsoft-com:office:smarttags PlaceType=3*urn:schemas-microsoft-com:office:smarttags PlaceName;2*urn:schemas-microsoft-com:office:smarttagsaddress:1*urn:schemas-microsoft-com:office:smarttagsStreet8.*urn:schemas-microsoft-com:office:smarttagsCity9-*urn:schemas-microsoft-com:office:smarttagsStateB'*urn:schemas-microsoft-com:office:smarttagscountry-region 66432166.-6.6.6'6'6'6'6'6'6'6'6212166346346.6.6436.634666-66-6-6-6-6-6-6.-6-6.-6-6-6.-6.-6-6-6-21.-6.-6-6.-6-6-6.-6'6.-6-6-6.-6-6.-6-66-6.-6-6.-6-6-66-6-6.-6-6-6-6-6-6-6-6'66-6-6-6.-6-66-6-216.-6-6.-6.-66.6'6'6'6-6'6'66'6'6.6'6'6'6'6'6'6'6'66'6'6'66'6'6'6'6'6'66.6'6'6'66'6'6'6'66'6346'6'6346'6'6.-6.-6.-21216' TU\e!!$$'',1-1*5+5l@q@KKLMMMAZEZccfipiii!q%quv~vўҞעآLP01qr  '(^w_wzz  YZ_`VWbcd'e'++<<u?v?ODSDII-M0MgPhP,R-RSSTTTTooqqqqgukuv!vV]ŽƎŦ&-/6?G(/4:}qyk),=xi o ' , }ps 393<v}5M$.2S q!!!!""""##$$$$%%T&]&&&7'D''''(((**++++\-^---..//.0600001112222x3}333 66M6Y666N7[7778888=9@9o:s:2;;;<<==r?x?j@q@CCDDRDTD}DDDDDDuEEEEFF'G*GPGUGGGHHII8JBJJJKKKLLLM/M3N6NOOP PKPYPPQ*Q3QQQRRsRvRSSTTGTOT}TTTTUUKUdUUUUUV5VVVVVWWXXXY&Y/YYYP[S[ \#\\\]]^^^^__8`;` aaaaab6b?bbbc!cccdd:eCeeeeeffIfMfffffffkgwgggh hhhhhi'iij/j2jjjjjWk_kkk3l7lmmmmn nnnn o"ojoooooRpVpZq^qqqqqHrMrrrss uus}vUYot|h}_$*̝ϝ@H|.2%*AJʤ%27B[d[aɪ̪{д3;BYaöŶ3x{۷ݷ;DGJLPݺ`cU[оſ*0O[rz$&/7]aSV&,?Dux"&;@1&T[n[]XZ25enH_HoqOT| HKES~"'WZ$&uw"V^<A|~03jnQW25=Ehl*1hkSVch( , J M   3 7    $ o r  &v27ZcSZMS=?2H,,2,'-0-<<==KKLL}]]m^v^ffXfZfffgg3hLhhhiijjjkkkkkmmooppMpPp q qvqqq)rarcr\tbtuu vvw?w0x7xpxxx{{}}}}S~V~~~QZ JQ_gсցXZmr$'u}·ևV[шӈMR ?CY_#& [^׎ڎQVKNǐʐAF|wzlvgj '\fԕޕ^dps)0eoߙƛ͞ӞΡաNQåݥ}[^TYۨݨ2?&,^aԭحIRq¯ʯprٱ۱UX̶ֵ϶OVҸԸͼμ26<Hνҽ @G6=*1dk>D4htw~*FR CM$_a ^d C/6oww #PU BFgn*,57V[W\)$+"SU+0hk]adhs=BHMR{OY5A~] `   !!!!!!!"""""{$$%%&&'&&&'E'd(g(((U*[***,,--.!.T.Z...@/V//0Y0v02233444455>5A586A6]6f66666666666770777I7P7b7j7|77::y;;;;N<U<<<====k@q@@@AA7A:ABBCCCC"D*DDDEEFFFFFGGGUHWH"I*IRI[III)J.JJJ[K_KKKBLHL|LL M1MFMhM+N;N[s,Ge:Xs  0 D b n  ' E X v V|V|f|o|SSSSrrjk,SSk), Tim Gortner Tim Gortner Tim Gortner Tim Gortner Tim Gortner Tim Gortner Tim Gortner Tim Gortner Tim GortnerCorporate Network Services'?,  =C$hh^h`.z^`zo(.'?, =Fu4F Uk),@\\DENPTR01\HP8000_03Ne01:winspoolHP LaserJet 8000 Series PCL 6\\DENPTR01\HP8000_03tter.HP LaserJet 8000 Series PCL 622xe.Aƿo5bATXĥ96!tɢ" y ,sSY|o̙T_5= 1ʅ<\\KPSJ+2H[)Hu:jV)3 4u~|ixCjk9` 8)Q'SsOA> C; KIQF(ze%CM2vSX Zw4>X-5hTmviMiG_ucș-D9LB(6ƐuH\\DENPTR01\HP8000_03tter.HP LaserJet 8000 Series PCL 622xe.Aƿo5bATXĥ96!tɢ" y ,sSY|o̙T_5= 1ʅ<\\KPSJ+2H[)Hu:jV)3 4u~|ixCjk9` 8)Q'SsOA> C; KIQF(ze%CM2vSX Zw4>X-5hTmviMiG_ucș-D9LB(6ƐuHSSSS+@@UnknownGz Times New Roman5Symbol3& z Arial?5 z Courier New"CV ɻEVK|F4e&)oiXhoiXh!V24dVH(?Fu"new version of batch load documentJerry SpetoskeyCorporate Network Services  microsoft-com:office:office#Author System AccountSystem Accountlt|ns:ds="http://schemas.openxmlformats.org/officeDocument/2006/customXml"/>as.microsoft.com/office/2006/metadata/longProperties"/> This value indicates the number of saves or revisions. The application is responsible for updating this value after each revision. ?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~="xs:string"> t.com/sharepoint/v3/contenttype/forms">DocumentLibraryFormDocumentLibraryFormDocumentLibraryFormE3D-5AC5-472F-95FF-31E5F70E6639}" xml ds:itemID="{5259BA29-FB88-4371-A63E-6B0E2B4E285C}" xml