1 System Parameter

This section describes the parameters required to run the DGS ResOnline module and these parameters are setup in Administration, System Setup, Database Parameter.

Table 1-1 PAR Group General

PAR NAME	PAR VALUE	Description
Allow overwrite posted pre posting	0 – Disable 1 – Enable	0 - Do not allow update PPS when PPS_POS_ID > 0 1 - Allow Update PPS when PPS_POS_ID > 0 and POS_CLOSED=0
Number of day(s) before embarkation alert	Number of day(s)	The system sends an alert e-mail for change less than x days before embarkation

Interface Parameters

Apart from enabling the above System Parameters, the program also requires an Interface Parameter Settings to further define and manage the information to be transferred to SPMS. The Interface Parameter are categorized into three (3) sub-tabs in DGS ResOnline, Settings tab.

• Parameters: All Setting for data Transfer from FMS. See Table 1-2 for detailed description of the parameters.

• Parameters 1: All setting for data Transfer from FMS (Continuous).

• Alert E-Mail List: An alert email list use inform user of the transferred reservation status.

The information transferred from FMS to SPMS depends on these settings.

Figure 1-1 DGS ResOnline Parameters

Table 1-2 DGS ResOnline Parameters

Parameter	Description
Refresh interval by seconds	The intervals time to obtain new data to transfer if any. Default minimum interval is 15 Seconds.
Delete reservation Data Older than x days	Minimum setting is 7 days and below are the process. The system removes messages from Reservation that has status = 3 and Reservation modification date < system date – x days. Remove Reservation Response data (RSP) based on RSP_MODDATE compared against x days. Remove Reservation Details Log (RSD) based on RSD_RSL_ID IN (SELECT RSL_ID FROM RSL WHERE (RSL_EMB_E IS NOT NULL AND RSL_EMB_E < DATE (SYSTEM DATE – X DAYS) OR (RSL_EMB_E IS NULL AND RSL_MODDATE < DATE (SYSTEM DATE – X DAYS) Remove Reservation Update Log (RSL) - WHERE (RSL_EMB_E IS NOT NULL AND RSL_EMB_E < TO_DATE('2016-07-12','YYYY-MM-DD')) OR (RSL_EMB_E IS NULL AND RSL_MODDATE < TO_DATE('2016-07-12','YYYY-MM-DD'))
Stop Bookable Update x days(s) before next cruise start	This stops any shore excursion and bookable ticket update x days before the start of next cruise. This change only affects shore excursion bookable and template for future cruise.
Interval to send alert email (in minutes, 0=disable)	Define the interval to send an alert email, based on email list define in ‘Alert e-mail List’ tab. 0 = disable send alert email.
Stop Update on Embarkation Day (Ctrl+Del to clear and disable)	Define the time to stop an update on embarkation day. Press Ctrl+Del to clear the time value.
Do not update package after guest check-in (B2B)	This stops the update of package for checked-in guest, and is only applicable to back to back guest.
Enable Update of Shorex/Ticket Bookable and Template	This allow update of shore excursion/bookable ticket tour and template. This rule depend on the “Stop Bookable update x day(s) before next Cruise start”.
Multiply Pre-posting Quantity to Unit Price	This multiplies the pre-posting quantity by unit price for input to PPS_TOTAL field. Requires additional configuration in Administration module, Database Parameter.
Stop Process When QCI Offline Sync is enable	This function pauses the ResOnline updates when the QCI Offline Sync process is enabled and resume when QCI Offline Sync stop running.
Do not import cruise (SCR), only import cruise details (SCD)	This flag is to only import System Cruise Days Information, excluding Cruise Itineraries.
Only process UCIData with account_checkin_status = 0	This flag only process UCIData with status Registration that is not complete. ACCOUNT_CHECKIN_STATUS=RES_RGN_COMPLETE
Number of hours to retry process credit card info	Define number of hours to retry processing of credit info in DGS.
Stop Reservation update x days before embarkation	Stops reservation update x days before of embarkation date.
Log Changes into chglog	Log changes made into change log table.
Enable Shore Excursion Language import	This enables the import of language from Shore Excursion.
Enable Over Weight Bookings Price Increase	This enables price increase by % set in Parameter for Overweight booking.
Allow Update Flights for Check-In Guest	This enables the flight info update for Check-In Guest.
Do not allow import zero price shorex/ticket prepaid/prebook transactions	This disables the import of prepaid/pre-book transactions Shore Excursion with zero pricing.
Only update cruise id, department, net price and sales price for excursion/ticket	This only allow update of cruise id, department, net price and sales price for excursion only.
Allow Change Excursion/Ticket Date for the same tour	This enables changes made to tour/ticket of the same record even though the booking date is different.
Validate ENOAD Data	When enabled, the system validates the Electronic Notice of Arrival/Departure (ENOAD) data during import, and insert as Import Warning if any of the ENOAD data is missing. The ENOAD data validation warning is viewable from ResOnlineViewer application, Import warnings.
Allow Update Value to NULL	This allow the change of Excursion or Ticket Date for the same tour.
Prevent process duplicate UCIData	This enables the update of value to NULL when this flag is checked.
Allow Field Update for B2B Guest : Disembarkation Date	This enables the additional fields to be updated for back to back guest, even after guest has checked in.

The system is capable of transferring eight (8) different types of messages (MSSG_NOTES) using ResOnline and they are:

1. UCIData - Reservation record

2. ReservationsData - Reservation record

3. DataDefinition - All field settings in Shore Excursion and Ticket description.

4. ItinData - Cruise Itinerary

5. CAMVisitor - Visitor Info

6. SPMSConfig - SPMS Configuration setup

7. Transferstatuslog - Summary of Transaction status

8. OHCEVENT - Field setting used in Event module

The reservation messages in(RESERVATION_MSGS)Table is updated with one of this status after a successful import. Below are some of the statuses.

1. MSSG_STATUS = 2 (New record that ResOnline processes)

2. MSSG_STATUS = 3 (Successfully processed)

3. MSSG_STATUS = 5 (RESERVATION_RES_ID in XML <> RESERVATION_RES_ID in RESERVATION_MSGS table)

4. MSSG_STATUS = 6 (Current reservation is older than previous, request for resend)

5. MSSG_STATUS = 7 (No Future cruise created in system)

6. MSSG_STATUS = 8 (Failure)