Responsys Reservation Exports

The General export, Responsys_Resv_Day, exports reservations to the Oracle Responsys system. You can generate the export for an arrival date range and request it for a specific reservation status. Additional filter conditions are definable in the Miscellaneous menu. Select Exports, select General, select the export file type, select Edit, and then click Filter Condition. The OPERA Cloud add on OPP_EXP subscription must be activated for General Exports functionality.

There are three export file types available in the list of templates within the General exports. You can select the export(s) from the Template list and add them to your property. The Template list is available in the Miscellaneous menu. Select Exports, select General, and then select New.
The image show the Search and Select Template screen.

The image show the Search and Select Template screen.

Generating the Responsys_Resv_Day Export

The Responsys_Resv_Day export can be generated manually. When generating it manually, you must select the Arrival Date Range and the Reservation Statuses to be considered in the export. The Date range defaults to the current month, and you can modify the date selection as required. By default, reservation statuses Arrivals, Checked In, InHouse, Departure, and Checked Out are available. You can select the following additional statuses: Waitlist, Canceled, and No Show if required.

Generating the Responsys_Resv Export

You can schedule the Responsys_Resv export to generate during End Of Day (EOD). The frequency of the export is set to Daily by default. Once this export is added to the Property, the EOD automatically considers it based on the export frequency defined. If required, you can deactivate the scheduler job for the export from Miscellaneous > Exports> Schedules > and turning off the scheduler job for the export Responsys_Resv.

When the export is scheduled to run during EOD, it generates for the next 30 days of arrivals (from the current business date). Reservations with these statuses: Arrivals, Checked In, InHouse, Departure, and Checked Out are considered by the export.

Generating the Responsys_Resv_Auto Export

You can schedule the Responsys_Resv_Auto export from Export Schedules (Miscellaneous > Exports> Schedules> Create Schedules).

When the export is scheduled to run from Scheduler, it generates for the next 30 days of arrivals from the current business date. Reservations with these statuses: Arrivals, Checked In, InHouse, Departure and Checked Out are considered by the export.

Export Output

The export is generated in the .csv format by default. You can change the file format to .txt from Miscellaneous > Exports > General > Select the export file type > Edit> update the file extension formula.

The export data is ordered by reservation arrival date. Pseudo room reservations are not considered by this export.

Export file name format: propertycode_filetype_date.csv, for example: PROP1_RESPONSYS_RESV_EXPORT_202002241510.txt (Note: the DateTimestamp format for the file name is YYYYMMDDHHMI).

Table 8-6 Export Fields

Column	Type and Length	Description
RESERVATION_ID	Number	OPERA Cloud Reservation Confirmation Number.
GUEST_LAST_NAME	Text (100)	Guest Last name.
GUEST_FIRST_NAME	Text (100)	Guest First Name.
GUEST_MIDDLE_NAME	Text (100)	Guest Middle Name.
TRAVEL_AGENT_NAME	Text (100)	Name of the Travel Agent Profile. This is blank if No Travel agent is associated to the reservation.
COMPANY_NAME	Text (100)	Name of the Company Profile. This is blank if No Company is associated to the reservation.
BOOKING_SOURCE	Text (100)	Source Code of the Reservation.
PROPERTY_NAME	Text (100)	Name of the Property.
ARRIVAL_DATE	Datestamp	Arrival date of the reservation in Properties Date format.
DEPARTURE_DATE	Datestamp	Arrival date of the reservation in Properties Date format.
NUM_NIGHTS	Number	Number of Nights.
NUM_ADULTS	Number	Number of Adults in the reservation first stay night.
NUM_CHILDREN	Number	Number of Children in the reservation first Stay night.
NUM_ROOMS	Number	Number Rooms in the reservation.
ROOM_TYPE	Text (25)	Room Type in the Reservation. If the Reservation has multiple room type, this field should carry the Room Type applicable for the first Stay Night.
ROOM_TYPE_TO_CHARGE	Text (25)	Room Type to Charge (RTC) in the Reservation. If the Reservation has multiple RTC, this field should carry the RTC applicable for the first Stay Night.
ROOM_NUMBER	Text (25)	Room Number assigned to the Reservation. For multiple room reservations, display room numbers as comma separated. If different rooms are assigned to different nights, Room Number(s) assigned to the first stay night.
RATE	Number	Rate applicable for the first Stay night of the reservation.
BLOCK_CODE	Text (25)	Block Code assigned to the Reservation First Stay Night.
RESERVATION_TYPE	Text (25)	Reservation Type of the Reservation.
PAYMENT_TYPE	Text (25)	Reservation Payment method applicable for the Payment Window1 /Folio1.
NAME_ON_CARD	Text (500)	Name on the Card. Comma separate Last Name and First Name.
DISCOUNT_AMOUNT	Number	Discount amount applied to the reservation- This field will pass null value, if no discount applied.
DISCOUNT_PERCENTAGE	Number	Discount Percentage applied to the reservation- This field will pass null value, if no discount applied.
DISCOUNT_REASON	Text (25)	Discount reason specified while applying the discount. This field will pass a null value if no discount is applied.
SPECIAL_REQUESTS	Text (500)	Special Request Codes attached to the reservation. Any preferences from the SPECIALS preference group added to the reservation will appear in this column. If multiple special requests are attached, those will be displayed as comma separated.
PROMOTION	Text (25)	Promotion Codes attached to the reservation. If multiple Promotion Codes are attached, those will be displayed as comma separated.
ROOM_PREFERENCES	Text (500)	Reservation preference Codes from the preference group ROOM FEATURES, SMOKING and FLOOR, If there are multiple records, display as comma separated.
OTHER_PREFERENCES	Text (500)	Reservation Preference Codes from all other preference groups (VIDEO OPTIONS, TV OPTIONS, MINIBAR OPTIONS, PHONE OPTIONS, INTERESTS, KEY OPTIONS, EVENTS, ATTENDEES + ANY ADDITIONAL PREFERENCE GROUPS ADDED BY THE PROPERTY). If there are multiple records, display as comma separated.
SHARED_ROOM	Character ( Y / N)	Y/N Y- if the Reservation is sharing a room with another reservation. N - if the reservation doesn’t share the room.
RATE_CODE	Text (25)	Rate Code attached to the reservation. If the Reservation has multiple Rate Codes, this field should carry the Room Type applicable for the first Stay Night. For a Block Reservation, where the Block doesn’t have a Rate Code attached, the Rate Code will be passed as null.
PARENT_BLOCK	Text (25)	Leave this as blank always.
RESERVATION_STATUS	Text (25)	Status of the reservation while generating the export.

Parent topic: Exports