3 ADPI Configuration

This section describes the steps to use for defining the parameters in the ADPI interface according to the ship’s operation. You can specify the number of days to retain the data before purging it.

Note:

Some functions correlate with other fields. Be sure to select the correct checkbox before applying changes.

Figure 3-1 ADPI Daily Data Purge Settings

The Interface has two type of purges:

Daily Data Purge: This purge executes daily when the ADPI interface receives the ‘EndOfDay’ command from the Management application after the system date change. ADPI only purges previous day(s) data from the days you specify.

Cruise End Data Purge: This purge executes during End of Cruise when the ADPI Interface receives the ‘EndofCruise’ command from the Management application.

Refer to the following available options and descriptions:

Table 3-1 Daily Data Purge Function

Function	Description
Guest Accounts	Purges the postings and user-defined fields for all guests that checked-out, and reservation cancellation.
Guest Account Details	Purges the excursion and excursion waitlist, pre-postings and billing info, amenities and special requests, visa and flights, reservation history, guest history, travel agent info, allergies info, promotion history, credit card info, authorization, settlement info and guest comment for guests that checked out. The number of days cannot be greater than the number of days set for Guest Accounts.
Guest Bill/Item Details	Purges the bill view, point-of-sale (POS) detail item, XML guest history and Dining Reservation System (DRS) item for all guest accounts, and bill view details. The number of days cannot be greater than the number of days set for Guest Accounts.
Group Accounts	Purges the regular postings and user-defined fields for all groups that checked out and reservation cancellation.
Group Account Details	Purges the billing info, travel agent info, credit card info, authorization and settlement info for groups that checked-out The number of days cannot be greater than the number of days set for Group Accounts.
Group Bill View Details	Purges the bill view, POS detail items for all group accounts, and bill view details. The number of days cannot be greater than the number of days set set for Group Accounts.
Crew Accounts	Purges the regular postings, user defined fields, crew history info, and hotel and bar service charge info on checked-out reservations and cancellations.
Crew Account Details	Purges information about the following: pre-postings, visa, uniform, training and courses, shore side deny, crew history and promotion history, cabin change log, warning, allergies, credit card, authorization, settlement, time and attendance, scheduled crew drill training and crew comments for crew that checked-out. The number of days cannot be greater than the number of days set for Crew Accounts.
Crew Bill/Item Details	Purges the bill view and POS detail item for all crew accounts and bill view details. The number of days cannot be greater than the number of days set for Crew Accounts.
Log Information	Purges Log entries log.
Guest Pictures	Purges all checked-out and cancelled guest accounts picture details.
Gangway Log	Purges Gangway log entries.
Crew Incentive Details	Purges Crew incentive entries.
Crew Pictures	Purges all checked-out and cancelled crew accounts picture details.
Guest Document Images	Purges all checked-out and cancelled guest document image.
Queue Information	Purges guests queue details that were entered a specified number of days ago.
Signature Image	Purges all guest/crew checked-out and cancelled accounts signature image.
Completed Work Order	Purges the completed maintenance work order and the associated image file.
Gift Card Accounts	Purges the regular postings for all gift card accounts that checked-out and reservation cancellation.
Gift Card Acc Details	Purges the excursion and excursion waitlist, pre-postings and billing info, amenities and special requests, visa and flights, reservation history and guest history, travel agent info, allergies info, promotion history, credit card info and authorization and settlement info for all gift card accounts. The number of days cannot be greater than the number of days set for Gift Card Accounts.
Gift Card Bill/Item Dtls	Purges the bill view and POS detail items for all gift card accounts and bill view details. The number of days cannot be greater than the number of days set for Gift Card Accounts.
DRS Details	Purges the DRS posting details.
Payroll Information	Purges the contract, pay details, contract details and pay sheet information for all crew accounts payroll details.
Change Log	Purges change, deletion and insertion of audit trail log. Purges the errors or warnings that return from Seaware.
Seaware Error Logs	Purges the errors or warnings that return from Seaware.
Credit Card Data	Purges the orphaned credit card data, authorization and settlement.
Sync Details	Purges the completed sync data to Seaware.
Event Details	Purges event booking, item booking and group booking details.
Crew Document Images	Purges all checked-out and cancelled crew document image.
Housekeeping Details	Purges housekeeping task assignment.
GL Files Details	Purges all generated General Ledger (GL) files.
Abandon Ship Tracking	Purges all records in Abandon Ship Tracking.
General Assembly Tracking	Purges all records in General Assembly Tracking.
Passenger History	Purges all Passenger History records.

Table 3-2 Daily Data Purge Function (Special Section)

Special Edition	Description
Residents purge delay	Include all in one resident accounts and details purging that have the same purging accounts and details as Guest Accounts, Guest Account Details and Guest Bill/Item Details.

Table 3-3 Daily Data Purge Function (Comment Card Data Selection)

Comment Card Data Selection	Description
Use Number of days specified in comment card module.	Defines whether to use the Purges parameter defined in Comment Card module.
Comment Cards	Purges the comment card scanned forms and scanned results for comment card details that were entered specified number of days ago.
Purge blob data only	Purges the comment card scanned forms and scanned results blob files for comment card blob files that were entered a specified number of days ago. There is an option to purges blob data for scanned forms only or both.
Mark form as removed	Marks comment card scanned forms as removed for forms that were entered a specified number of days ago.

Table 3-4 Daily Data Purge Function (Performance)

Performance	Description
Batch Size	Purges the number of entries to delete per batch. The default number of record is 100.
Batch Purge Delay (sec)	Defines the execution time to delay between each batch. The default delay time is 0.2 seconds.

Table 3-5 Daily Data Purge Function (Others)

Others	Description
Purge orphaned records for account details	Allows all orphaned entries to be purged for guest, crew, group, resident and gift card account details.
Purge sync transactions	Purges synchronize transaction records that were entered a specified number of days ago, which have status as successful or failed.
Purge Offboard Generic visitor pictures	Allow generic visitor pictures and document images to be purged when visitor status = shore side.
Log SQL Statement	Enables log of data purges when check System stores files name ‘ADPILog_ddmmyyyy.txt’is in Oracle Hospitality Cruise folder.

Setting Up Daily Data Purge

1. From the Interface PC, launch ADPI if the program is not running in the background.

2. Navigate to the Settings tab, and select Daily Data Purge.

3. Under the Data Selection section, select the checkbox of the desired option and modify the days accordingly. The default number of days to keep the data is zero.

4. Click Apply and log in when prompted.

The system prompts a Login screen as a confirmation before the changes takes place. Log in with a user account that has permission to change the selection.

Setting Up Cruise End Data Purge

The Data purge processes during the End of Cruise when ADPI interface receives an ‘EndOfCruise’ command from the Management application. The Cruise End Data purge options are in the table below.

Figure 3-2 Cruise End Data Purge

Table 3-6 ADPI Cruise End Data Purge Setting

Function Name	Description
Routing Instructions	Purges all checked-out guests, crew and groups routing instructions details.
Discounts	Purges all checked-out guests, crew and groups discounts details.
Package Plans	Purges package plan details of the cruise.
Sys Acc Bill/Item Details	Purges system account sales check and posting details item.
Residents purge delay	Purge consist of three types and they are pictures for checked out and reservation cancellation residents, routing instructions for checked-out residents and discounts for checked-out residents.

1. From the Interface PC, launch ADPI if the program is not running in the background.

2. Navigate to the Settings tab, and select Cruise End Data Purge.

3. Under the Data Selection section, select the checkbox of the desired option and modify the days accordingly. The default number of days to keep the data is zero.

4. Click Apply and log in when prompted.

The system prompts a Login screen as a confirmation before any changes takes place. Log in with a user account that has permission to change the selection.