OPERA Data Purge Routine

The OPERA Data Purge Routine gathers all existing purging routines in OPERA and executes them under one major procedure. The purge process can be scheduled from the OPERA Scheduler, and provides OPERA users with a clean and organized maintenance procedure.

The purge routine is divided to two sub-processes (in the background and not visible to the user):

GLOBAL (ORS) Purge - Where the running application will be ORS.
Property-Specific Purge - Where the running application will be PMS. After the appropriate purges are complete for all properties, the running application will change to ORS.
Note: In PMS, inactive resorts are not included in the purge routine.

Note: A detailed log showing what data was purged is available in the OPERA Scheduler.

The table below provides an overview of the purge procedures and the tables/routines involved in the process:


Procedure	Routine / Table Name	Purge Setting
Purge Activity Action	ACTIVITY_ACTION	Deletes records from the Activity Change Log based on the past number of days entered in the application setting ACTIVITY>Activity Purge Days.
Procedure	Routine / Table Name	Purge Setting
Purge Block Attendee and Event Attendee Lists	PURGE_CAT_ATTENDEE_TABLES	Deletes block attendee and event attendee lists 730 days after the block departure date.
Procedure	Routine / Table Name	Purge Setting
Purge Forecast Data	RESERVATION_SUMMARY	Daily purge; aging older than 60 days after the date entered as the considered date.
Procedure	Routine / Table Name	Purge Setting
Purge Rate Sets	RATE_SET	Daily purge; aging older than 60 days after the date entered as the end date (assuming that the end date of the RATE_SET to which it is attached).
	RATE_SET_PRODUCTS	Daily purge; aging older than 60 days after the date entered as the end date. Note: This table is a child of the RATE_SET table and is not logged separately.
	DEPOSIT_CANCEL_RULES	Daily purge; aging older than 60 days after the date entered as the end date. Note: This table is a child of the RATE_SET table and is not logged separately.
	YM_RATE_SET_ADJUSTMENTS	Daily purge; aging older than 60 days after the date entered as the end date (assuming the end date of the RATE_SET to which it is attached). Note: This table is a child of the RATE_SET table and is not logged separately.
	RATE_SET_ROOM_CATEGORIES	Daily purge; aging older than 60 days after the date entered as the end date (assuming the end date of the RATE_SET to which it is attached). Note: This table is a child of the RATE_SET table and is not logged separately.
Procedure	Routine / Table Name	Purge Setting
Purge Rate Strategy	RATE_STRATEGY	Purge rate strategies having a control end date that is at least 60 days earlier than the business date.
Procedure	Routine / Table Name	Purge Setting
Purge Business Events	DEQUEUES> BE_QUEUE_TABLE_VW	Messages that are 4 days old or older are queued.
	INVENTORY_CONTROL_ACTION	Deletes all of the rows before the time this procedure kicked off.
	HK_ACTION	Deletes all of the rows before the time this procedure kicked off.
	RATE_ACTION	Deletes all of the rows before the time this procedure kicked off.
Procedure	Routine / Table Name	Purge Setting
Purge Credit Card Auth Log	CC_AUTH_LOG	Because authorizations could be scheduled frequently, a parameter is available to allow you to automatically purge data from the credit card authorization log file after a specified number of days. Use the IFC > PURGE CC AUTH LOG DAYS application setting to specify the number of days data will be held in the credit card authorization log file before being automatically purged. If this setting is left blank, a default of 30 days is assumed.
Procedure	Routine / Table Name	Purge Setting
Purge Credit Cards	purge_credit_card_info / NAME$_CREDIT_CARD	Procedure removes credit card information based on the GENERAL > PURGE UNNECESSARY CREDIT CARDS application setting and associated eligibility criteria. Masked credit card number and expiration date are displayed in the application for purged credit cards. (See Credit Cards: Credit Card Security for details.)
Procedure	Routine / Table Name	Purge Setting
Purge Reservation/ Financials Past Data	RESERVATION_ACTION_30	Daily purge to the User Log for Reservation actions aging older than 30 days that have a Reservation Status of Checked Out, Cancelled, or No Show. Accompanying Guest Add Accompanying Guest Assign Room Authorize Direct Bill Auto Room Assignment Change In Routing Instruction Comments New Comments Changed Comments Deleted Comments Updated Credit Card Swipe Delete Routing Instruction Facility Tasks Folio Organization Join Guest Join To Party Key Create Key Duplicate Key Modify Key Moved Locator Changed Message Changed Message Deleted Message New New Locator Added New Routing Instruction Update Routing Instruction New Trace Reopen Folio Reverse Check Out Schedule Check Out Separate Guest From Share Trace Deleted Trace Resolved on Trace Updated Video Check Out Wake up Calls Delete Wake Up Calls Room Wake Up Calls Set
	RESERVATION_ACTION_180	Daily purge to the User Log for Reservation actions aging older than 180 days that have a Reservation Status of Checked Out, Cancelled, or No Show. (This routine will run as a part of the RESERVATION_ACTION_30 routine and hence no separate message log will be created.) AR Settlement Failed Batch Settlement Check In Check Out Credit Card Authorization Deposit Transfer Deposit Batch Routine Early Checking Out Night Audit Authorization No Show Override Credit Card Rule Overrides Posting Failed From Interfaces Reactivate No Show Reactivate Waitlist Record AR Approval Record AR Failure Record AR Verification Record Commission Payment Record Credit Card Approval Credit Card Batch Authorization Record Credit Card Failure Record Credit Card Reversal Failure Reset Authorize Direct Bill Reverse Check In Rollback Cancel Settle AR Approval Settle Credit Card Approval Settlement Failed Update Reservation Video Checkout Waitlist
	RESERVATION_ACTION_2_180	Daily purge to the User Log for Reservation actions aging older than 180 days that have a Reservation Status of Checked Out, Cancelled, or No Show and an Action Type of 'NEW RESERVATION'.
	RESORT_HK_DAILY_TASK	Daily purge performed to the User Log for daily task sheets older than 30 days. Note: Tables HK_DAILY_TASK and HK_DAILY_TASK_ROOM are also purged but are not logged separately.
	GUEST_RSV_MESSAGES_30	Daily purge performed to delete Guest Reservation Message data aging 30 days after the guest's checkout.
	GUEST_RSV_TRACES_30	Daily purge performed to delete Guest Reservation Trace data aging older than 30 days after the guest's checkout.
	TRX_ROUTING_INSTRUCTIONS_30	Daily purge performed to delete Transaction Routing Instruction data aging older than 30 days after the guest's checkout.
	FIN$_TRAN_ACTION_30	Daily purge performed to delete Financial Transaction Action data aging older than 30 days. Will not purge if an Open Folio (O) is attached.
	RESERVATION_CANCEL_POLICY_180	Daily purge performed to delete Reservation Cancel Policy data aging older than 180 days after the guest's cancellation.
	RESERVATION_CONF_LETTER_180	Daily purge performed to delete Reservation Confirmation Letter data aging older than 180 days after the guest's checkout.
	RESERVATION_DEPOSIT_SCHEDULE_180	Daily purge performed to delete Reservation Deposit Schedule data aging 180 older than days after the guest's checkout. If a deposit has been refunded on No Show and Cancelled reservations, this data is not deleted.
	RESERVATION_NAME_JRNL_180	Daily purge performed to delete Reservation Name Journal data aging older than 180 days after the guest's checkout.
	RESERVATION_RECEIPTS_JRNL_180	Daily purge performed to delete Reservation Receipts Journal data aging older than 180 days after the guest's checkout.
	IFC_WAKE_JRNL_365	Daily purge performed to delete Wake Up Interface Journal data aging older than 365 days.
	RESERVATION_PRINTLOG_1	Daily purge performed to delete Reservation Print Log data aging older than 30 days that have a Reservation Status of Checked Out, Cancelled, or No Show.
	CUSTOM_FACILITY_CODES_SCHEDULE	Daily purge performed to delete Custom Facility Codes Schedule data aging older than 30 days.
	CUSTOM_FACILITY_TASK_SCHEDULE	Daily purge performed to delete Custom Facility Tasks Schedule data aging older than 30 days.
	FACILITY_SCHEDULE_DATES	Daily purge performed to delete Facility Schedule Date data aging older than 30 days.
	RESV_CUSTOMIZE_CONF_LETTER	Daily purge performed to delete Reservation Customize Confirmation Letter data aging older than 30 days.
	RESERVATION_ACTION_3_180	Daily purge performed to delete Credit Card Screen Access data that is 365 days older than the system date. Procedure also purges the FOLIO EMAILED data that is 730 days older than the system date. Note: Since the Reservation that the folio was emailed for is purged from the RESERVATION_NAME_JRNL table 180 days after it has checked out, the FOLIO EMAILED entry will be available under the Changes Reservation Option up to 180 days. After 180 days, then the user log entry will only be available in the user log until it is purged after 730 days.
	RESERVATION_ACTION_4_180	Daily purge to the User Log for Reservation actions aging older than 180 days older than the system date of when the action was logged that have an Action Type of: Delete Reservation Turnaways CC Interface Error
	FINANCIAL_TRANSACTION_JRNL_730	Daily purge performed to delete Financial Transaction Journal data aging older than 730 days.
	FOLIO_TAX_JRNL_730	Daily purge performed to delete Folio Tax Journal data aging older than 730 days. Will not purge if an Open Folio (O) is attached.
	RESERVATION_RECEIPTS_730	Daily purge performed to delete Reservation Receipts data aging older than 730 days.
	GUEST_CHECK_DETAILS_730	Daily purge performed to delete Guest Check Details data aging older than 730 days.
	CR_CARD_SETTLE_730	Daily purge performed to delete Credit Card Settlement data aging older than 730 days.
Procedure	Routine / Table Name	Purge Setting
Purge Orphaned Rows	FIN$_TRAN_ACTION and RESERVATION_ACTION	Daily purge rows that do not have a matching row in either FINANCIAL_TRANSACTION or FINANCIAL_TRANSACTION_JRNL.
Procedure	Routine / Table Name	Purge Setting
Purge Old Rate Data	RESERVATION$_RESTRICTIONS	Daily aging; purges reservation restriction records when the reservation restriction begin date is 7 days in the past.
	RATE_DAILY_SOLD	Daily aging; purges records older than 30 days from the begin date.
	BEST_AVAILABLE_RATES	Daily aging; purges records older than 30 days from the rate date.
	RESERVATION_RESTRICTIONS_LOG	If OPP_IDEA, OPP_OPTM, or OPP_EZRM license codes are active, the log is purged of all records where the Reservation Restriction End Date is 7 Days less than the current business date.
	RATE_ACTION	Stores the user activity log for the Rate module. Records with insert_date of 180 days or older from the property's current business date will be purged.
Procedure	Routine / Table Name	Purge Setting
Purge Police Interface Records	POLICE_IFC	Daily purge; aging older than 30 days.
	POLICE_IFC_JRNL	Daily purge; aging older than 30 days.
Procedure	Routine / Table Name	Purge Setting
Purge Alert Records	RESERVATION_ALERTS	Alerts are purged thirty days following check out (or, for cancelled or no show reservations, 30 days following the proposed stay end date).
Procedure	Routine / Table Name	Purge Setting
Purge Export Data	EXP_DATA_HDR	The generated_date < last day of the prior month.
	EXP_DATA_DTL	The generated_date < last day of the prior month. Note: This table is a child of the EXP_DATA_HDR table and is not logged separately.
	EXP_DATA_FILE	The generated_date < last day of the prior month. Note: This table is a child of the EXP_DATA_HDR table and is not logged separately.
Procedure	Routine / Table Name	Purge Setting
Purge Business Block UserLog	ALLOTMENT_ACTION	Daily purge to the User Log for Allotment actions aging 30 days old. Move Block Wash Block Delete Block Header Cutoff Block New Block Header Tour Series Extend Block Refresh Rates Update Rates Update Block Grid Update Block Pickup Update Block Grid Summary Block Restrictions New Block Notes Delete Block Notes Update Block Notes Update Lead Header Delete Lead Header Update Lead Grid Update Lead Rates Update Busenessblock Links Daily purge to the User Log for Allotment actions aging 365 days old. Cancel Block Update Block Header
Procedure	Routine / Table Name	Purge Setting
Purge Configuration UserLog	CONFIGURATION_ACTION	Daily purge to the User Log for Housekeeping actions aging 30 days old that have a Module Type of H. For example, HK Points Inserte HK Room Status Changed HK Room Assign HK Room Repair Deleted HK Room Repair Completed HK Task Changed HK Task Created HK Task Deleted HK Task Emp Assigned HK Task Emp Deleted HK Task Rm Assigned Daily purge to the User Log for Configuration actions aging 180 days old that have a Module Type of C. There are hundreds of possible action types under this category related to different OPERA modules. For example, Addon License Change Apply Daily Rates CF Functionality Setup CF Param Changed CF Param Deleted CF Screen Painter CF User Changed CF User Created CF User Granted Delete Authorizor Limit Delete Daily Rates Delete Rate Set Delete Rate Strategy Delete Trackit Code Membership Points Changed Membership Types Changed NAReport Create New Rate Set New Rate Strategy New Membership Points New Membership Types New Rate Code New Trackit Code Procedure Change Rate Code Changed Rate Code Deleted Rate Detail Changed Start Rate Strategy Processor Stop Rate Strategy Processor Refresh Block Rate Update Rate Strategy Deletes rows in a chunk size of 10,000 rows. Note: Purge Property Log was removed from the purge process (V5.0.03.01) since all its items are included in Purge Configuration UserLog.
Procedure	Routine / Table Name	Purge Setting
Purge Commission UserLog	COMMISSION_PROCESS_ACTION	Purged daily only to the User Log. Monthly aging for the following Action Types is 180 days old. Added New Trx Code Address Changed Bank Account Creation Bank Account Deletion Cleared Check Made Outstanding Commission Code Changed Commission Code Deleted Commission Detail Change Create Commission Code Hold Agent/Source Commissions Hold Guest Commissions Manual Adjustment of Commissions Manual Adjustment of Prepaid Commissions Profile Merged Profile Name Changed Release Hold On Agent/Source Commissions Release Hold On Guest Commissions Remove Guest Commissions from A/R Set Commissions of Guests to A/R Transaction Code Deleted Daily purge for the following Action Types is 365 days old: Voided Commission Check Commissions Processed Note: These tables are not logged individually.
Procedure	Routine / Table Name	Purge Setting
Purge Interface Orphan Messages	IFC_ACT_QUEUE_TABLE	Daily purge; aging 10 days or older. Note: This table is not logged.
	IFC_BROADCAST_REQUESTS	Daily purge for all broadcast requests that are 1 day old or older. Note: This table is not logged.
Procedure	Routine / Table Name	Purge Setting
Purge HTTP Credit Card Log	HTTP_TRANSACTION_LOG	Daily purge; aging older than 180 days.
	HTTP_ERRORS	Daily purge; aging older than 180 days.
Procedure	Routine / Table Name	Purge Setting
Purge Mailing	MAIL_RESULTS	Purged daily.
	SC$ATTACHMENT	Purged daily.
	MAIL_PARAMETERS	Purged daily.
	MAIL_CONDITIONS	Purged daily.
	MAIL_QUERY	Purged daily.
Procedure	Routine / Table Name	Purge Setting
Purge Recent Modules	RECENT_MODULES	Records kept for 1 day only (sysdate 1).
Procedure	Routine / Table Name	Purge Setting
Purge Channel Rate Log	GDS_ACTION	Daily purge; aging older than 90 days.
Procedure	Routine / Table Name	Purge Setting
Purge Track It Items	TRACKIT_ITEMS	Daily purge; the status of the reservation is CLOSED, and the business date resolved is aging older than 30 days.
Procedure	Routine / Table Name	Purge Setting
Purge Log Book Items	DEPT_LOGBOOK	Daily purge; Purge if the log date is the aging older than 30 days.
Procedure	Routine / Table Name	Purge Setting
Purge Security Key Log	SECURITY_KEY_LOG	Daily purge; aging 30 minutes.
Procedure	Routine / Table Name	Purge Setting
Purge Old Property Shells	OPERA_SHELL	Purged daily.
Procedure	Routine / Table Name	Purge Setting
Purge Profiles
The PROFILES > PURGE DAYS and PROFILES > PURGE DAYS FOR INCOMPLETE PROFILES application settings determine which individual profiles are candidates for purge. OPERA makes validation checks such as whether there are current or future reservations, open AR balances, outstanding commissions, etc., before profiles may be purged. AR invoices with a zero balance are regarded as open. Profiles attached to such invoices can be purged only after the zero balance invoice has been purged based on the CASHIERING > ZERO INVOICE PURGE DAYS application setting. The PROFILES > PURGE EXCLUDE RESTRICTED AND CASH ONLY application parameter allows you to exclude restricted and cash only profiles from the Purge Profiles procedure. The PROFILES > PURGE LAST STAY DAYS application setting allows you to purge profiles based on the number of days since a guest last stayed. For example, if the setting is 100 days and the guest's last stay was 100 or more days ago, the profile will qualify for the purge. The PROFILES > PURGE MINIMUM STAYS application setting allows you to purge guest profiles that fail to satisfy the defined minimum number of stays. The Manual Profile Purge Routine utility can be used to manually sort and purge profiles based on multiple criteria. The PROFILES > PURGE ADDRESS COUNTRY application setting allows you to purge profiles based on the country code of the address.
	NAME	Purged if the validation candidate is purged.
	RESERVATION_NAME	The only thing purged is the link to the profile. Note: This table is a child of the NAME table and is not logged separately.
	FINANCIAL_TRANSACTIONS	The only thing purged is the link to the profile. Note: This table is a child of the NAME table and is not logged separately.
	FINANCIAL_TRANSACTIONS_JRNL	The only thing purged is the link to the profile. Note: This table is a child of the NAME table and is not logged separately.
	TRX_ROUTING_INSTRUCTIONS	The only thing purged is the link to the profile. Note: This table is a child of the NAME table and is not logged separately.
	FOLIO_TAX	The only thing purged is the link to the profile. Will not purge if an Open Folio (O) is attached. Note: This table is a child of the NAME table and is not logged separately.
	FOLIOS	The only thing purged is the link to the profile. Note: This table is a child of the NAME table and is not logged separately.
	RESERVATION_STAT_DAILY	The only thing purged is the link to the profile. Note: This table is a child of the NAME table and is not logged separately.
	NAME_ADDRESS	The only thing purged is the link to the profile. Note: This table is a child of the NAME table and is not logged separately.
	PAYMENT_TAX	The only thing purged is the link to the profile. Note: This table is a child of the NAME table and is not logged separately.
	PAYMENT_TAX_JRNL	The only thing purged is the link to the profile. Note: This table is a child of the NAME table and is not logged separately.
	NAME$NOTES	Purged with the main profile. Note: This table is a child of the NAME table and is not logged separately.
	NAME_COMMENT	Purged with the main profile. Note: This table is a child of the NAME table and is not logged separately.
	NAME_COMMISSION	Purged with the main profile. Note: This table is a child of the NAME table and is not logged separately.
	NAME_CREDIT_CARD	Purged and detached from the reservation. Note: This table is a child of the NAME table and is not logged separately.
	NAME_KEYWORDS	Purged with the main profile. Note: This table is a child of the NAME table and is not logged separately.
	NAME_PHONE	Purged with the main profile. Note: This table is a child of the NAME table and is not logged separately.
	NAME_POTENTIALS	Purged with the main profile. Note: This table is a child of the NAME table and is not logged separately.
	NAME_PREFERENCES	Purged with the main profile. Note: This table is a child of the NAME table and is not logged separately.
	RESERVATION_HISTORY	Purged with the main profile. Note: This table is a child of the NAME table and is not logged separately.
	RATE_HEADER_NEGOTIATED	Purged with the main profile. Note: This table is a child of the NAME table and is not logged separately.
	GDS_RATE_CODE_NEG_SECURITY	Purged with the main profile. Note: This table is a child of the NAME table and is not logged separately.
	GDS_ACCESS_CODES	Purged with the main profile. Note: This table is a child of the NAME table and is not logged separately.
	GDS_PSEUDO_CITY_CODESs	Purged with the main profile. Note: This table is a child of the NAME table and is not logged separately.
	NAME_RESORT	Purged with the main profile. Note: This table is a child of the NAME table and is not logged separately.
	NAME$OWNER	Purged with the main profile. Note: This table is a child of the NAME table and is not logged separately.
	BANE_SUBSCRIPTIONS	Purged with the main profile. Note: This table is a child of the NAME table and is not logged separately.
	NAME_VIRTUAL#	Purged with the main profile. Note: This table is a child of the NAME table and is not logged separately.
	NAME_XREF	Purged with the main profile. Note: This table is a child of the NAME table and is not logged separately.
	PROF_ROUT_TRX_TMPL	Purged with the main profile. Note: This table is a child of the NAME table and is not logged separately.
	RESV_CUSTOMIZE_CONF_LETTER	Purged with the main profile. Note: This table is a child of the NAME table and is not logged separately.
	RESERVATION_CONF_LETTER	Purged with the main profile. Note: This table is a child of the NAME table and is not logged separately.
	RESERVATION_REGRETS	Purged with the main profile. Note: This table is a child of the NAME table and is not logged separately.
	YM_NAME_ADJUSTMENTS	Purged with the main profile. Note: This table is a child of the NAME table and is not logged separately.
	PROFILE_ACTION	Purged with the main profile. Note: This table is a child of the NAME table and is not logged separately. The PROFILES > PURGE PROFILE USER LOG FOR UNMASKED VIEWING application setting determines the number of days to purge user log records for viewed unmasked Passport Number, ID Number, and Date of Birth (if the property is included in a database schema that has one or more properties in Korea [KR] country mode and you have initiated and completed the associated encryption process).
	PROFILE_STAT_DAILY	Purged with the main profile. Note: This table is a child of the NAME table and is not logged separately.
	MEMBERSHIP_CLAIMS_HISTORY	Purged with the main profile. Note: This table is a child of the NAME table and is not logged separately.
	MEMBERSHIP_CLAIMS	Purged with the main profile. Note: This table is a child of the NAME table and is not logged separately.
	MEMBERSHIP_EXTRACTS	Purged with the main profile. Note: This table is a child of the NAME table and is not logged separately.
	MEMBERSHIP_HISTORY	Purged with the main profile. Note: This table is a child of the NAME table and is not logged separately.
	MEMBERSHIP_ISSUED_AWARDS	Purged with the main profile. Note: This table is a child of the NAME table and is not logged separately.
	MEMBERSHIP_STATEMENT_DETAILS	Purged with the main profile. Note: This table is a child of the NAME table and is not logged separately.
	MEMBERSHIP_UP_DN	Purged with the main profile. Note: This table is a child of the NAME table and is not logged separately.
	MEMBERSHIP_MULTIPLE_POINTS	Purged with the main profile. Note: This table is a child of the NAME table and is not logged separately.
	MEMBERSHIP_POINTS_ACCRUED	Purged with the main profile. Note: This table is a child of the NAME table and is not logged separately.
	MEMBERSHIP_REJECT_COMMENTS	Purged with the main profile. Note: This table is a child of the NAME table and is not logged separately.
	MEMBERSHIP_TRANSACTIONS	Purged with the main profile. Note: This table is a child of the NAME table and is not logged separately.
	RESERVATION_MEMBERSHIPS	Purged with the main profile. Note: This table is a child of the NAME table and is not logged separately.
	MEMBERSHIP_PROMOTIONS	Purged with the main profile. Note: This table is a child of the NAME table and is not logged separately.
	MEMBERSHIPS	Purged with the main profile. Note: This table is a child of the NAME table and is not logged separately.
Procedure	Routine / Table Name	Purge Setting
Purge GDS Data	GDS_RESORT_REFRESH	Daily purge; aging older than 15 days.
	GDS_RATEROOM_PRICE	Daily purge; aging older than 1 day. Note: This table is a child of the GDS_RESORT_REFRESH table and is not logged separately.
	GDS_RESTATUS_QUEUE	Daily purge; aging older than 1 day. Note: This table is a child of the GDS_RESORT_REFRESH table and is not logged separately.
	GDS_REFRESH_DETAIL	Daily purge; aging older than 15 days. Note: This table is a child of the GDS_RESORT_REFRESH table and is not logged separately.
	GDS_INVENTORY_MESSAGE	Daily purge; aging older than 1 day. Note: This table is a child of the GDS_RESORT_REFRESH table and is not logged separately.
	GDS_AVAIL_UPD_MESSAGE	Daily purge; aging older than 1 day. Note: This table is a child of the GDS_RESORT_REFRESH table and is not logged separately.
	GDS_AVAIL_UPD_MESSAGE	Daily purge; aging older than 7 days. Note: This table is a child of the GDS_RESORT_REFRESH table and is not logged separately.
	GDS_PING_MESSAGE	Daily purge; aging older than 1 day. Note: This table is a child of the GDS_RESORT_REFRESH table and is not logged separately.
	GDS_RATE_UPDATE_QUEUE_EXTERNAL	Daily purge; aging older than 1 day. Note: This table is a child of the GDS_RESORT_REFRESH table and is not logged separately.
	GDS_WAITLIST_PROCESSED	Daily purge; aging older than 90 days. Note: This table is a child of the GDS_RESORT_REFRESH table and is not logged separately.
	GDS_AUDIT_DETAILS	Daily purge; aging older than 15 days. Note: This table is a child of the GDS_RESORT_REFRESH table and is not logged separately.
Procedure	Routine / Table Name	Purge Setting
Purge Batch Logs
The GENERAL > PURGE BATCH PROC LOG DAYS application setting determines how often this procedure runs.
	JOB_SCH_DETAIL_HEADER	Daily purge; this table contains the message logs.
	JOB_SCH_DETAIL_DETAIL	Daily purge; this table contains the run logs and is maintained by Oracle.
	BATCH_PROC_LOG	Daily purge.
Procedure	Routine / Table Name	Purge Setting
Purge Housekeeping Task Status Log	HSK_RS_ACTION	Only purges data when the ACCESS TSK STATUS parameter is set to Y, then purges daily for data that is aging older than 30 days.
Procedure	Routine / Table Name	Purge Setting
Purge NA Report	NA_REPORT_PARAMETERS	Daily purge; aging older than 180 days.
Procedure	Routine / Table Name	Purge Setting
Purge Zero Allotments	ALLOTMENT$DETAIL	30 days aging for allotments which have zero value. For example, there is nothing to sell or sold.
	ALLOTMENT$DETAIL	Records in ALLOTMENT$DETAIL will be purged during the Purge Procedure if the Business Block End Date is 30 days earlier or more than the Business Date and the following columns are zero: TO_SELL, SOLD, RELEASED, CONTRACT, FORECASTED_TO_SELL.
	ALLOTMENT_RESTRICTION	Delete from ALLOTMENT_RESTRICTION table where END_DATE lays in the past.
Procedure	Routine / Table Name	Purge Setting
Purge Report	REPORTS and REPORT_DESTINATIONS	Daily purge; aging older than 30 days. (Aging may be set to any interval from 3 to 90 days using GENERAL > REPORT HISTORY PURGE DAYS application setting)
	RW_SERVER_LOG	Daily purge; aging older than 30 days.
	REPORT_TABLE	Daily purge; aging older than 5 days.
Procedure	Routine / Table Name	Purge Setting
Purge AR Invoice Jrnl
The AR > ZERO INVOICE PURGE DAYS application setting allows a property to specify the number of days to purge an invoice after the amount of the invoice equals zero. Should the setting be left blank, then the invoice will not be purged.
	AR_INVOICE_HEADER_JRNL	Daily purge of the AR Invoice Header Journal to delete AR Invoice Journal entries dating older than 365 days.
Procedure	Routine / Table Name	Purge Setting
Purge Caller Profiles	NAME	Automatically purge Caller Profiles that are older than 5 days, do not have a reservation attached, and have a name_type of "PURGE".
Procedure	Routine / Table Name	Purge Setting
Purge NA Courtesy Journal	NA_COURTESY_JRNL	When the Courtesy Card Handling application parameter is set to Y, purges courtesy card data transfers that have a status of OK and are older than 30 days.
Procedure	Routine / Table Name	Purge Setting
Purge Event Change Log/Event Change Log Details	EVENT$CHANGELOG EVENT$CHANGELOG_DETAILS	All change log entries will be purged for an Event with an End Date more than 180 days earlier than the current business date.
Procedure	Routine / Table Name	Purge Setting
Purge Deleted Catering Events	DELETED_CATERING_EVENTS	Daily purge of deleted catering events in chunks of 10,000 rows, as long as the date of deletion is less than the current business date and the exported date is not blank.
Procedure	Routine / Table Name	Purge Setting
Purge Check Ledgers Log	CHECK_LEDGERS_LOG	Daily purge. Records older than 180 days (based on insert date) are purged. This table is populated by the Imbalance Fix routine run by the Imbalance Analysis Utility.
Procedure	Routine / Table Name	Purge Setting
Purge FT Zero	FINANCIAL_TRANSACTIONS FINANCIAL_TRANSACTIONS_JRNL	Daily purge that purges any records that are 10 days older than the current business date, have a Checked Out status, has a Closed Folio Status, and all amounts (Transaction, Net, Gross) for the record = 0.
Procedure	Routine / Table Name	Purge Setting
Purge Business Intelligence Records	RESERVATION_SUMMARY_LOG	Daily purge that purges any records that are 13 months old based on the current business date.
Procedure	Routine / Table Name	Purge Setting
Purge US 1099 Records	US_1099 US_1099_PERIODS	Daily purge to purge any 1099 records that are 1825 days older than the current business date.
Procedure	Routine / Table Name	Purge Setting
Purge CC Transaction Log	CC$_TRANSACTION_LOG	Daily purge to delete any credit card transactions that are 90 days older than the current business date.
Procedure	Routine / Table Name	Purge Setting
Purge Restriction Log	RESERVATION_RESTRICTIONS_LOG	Daily purge to delete reservation restrictions records when the restriction end date is 7 days in the past.
Procedure	Routine / Table Name	Purge Setting
Purge Room Maintenance	ROOM_MAINTENANCE	Purge deletes all resolved maintenance requests that are 60 days old or older, provided the ROOMMAIN parameter has a value of Y.
Procedure	Routine / Table Name	Purge Setting
Purge Item Hold Items	ITEM$HOLD	Daily purge of items on hold older than 1 day.
Procedure	Routine / Table Name	Purge Setting
Purge Deleted Allotment Details	DELETED_ALLOTMENT_DETAILS	Purge deleted records DELETED_ALLOTMENT_DETAILS when the Export Date is not null and the Insert Date is less than the business date.
Procedure	Routine / Table Name	Purge Setting
Purge Room Repairs	ROOM_REPAIRS	Purge deleted room repairs which are greater than 90 days old.
Procedure	Routine / Table Name	Purge Setting
Purge Synchronized Function Spaces	SC_SYNC	Purge the table containing details of function spaces that were synchronized between a remote property and a central system. All records where the insert date is 180 days or older and the synchronization date is not empty will be purged.
Procedure	Routine / Table Name	Purge Setting
Purge Availability Cache Instance	OWS_ERROR_LOG CACHED$_OWSAVAIL_RESULTS CACHED$_OWSCALEN_RESULTS	Purge all cached OWS error log records older than 15 days. Purge all cached OWS general availability result records on the middle day of the month. For example, if there are 30 days in the month, records will be purged on the 15th. Purge all cached OWS calendar result records on the middle day of the month. For example, if there are 30 days in the month, records will be purged on the 15th.
Procedure	Routine / Table Name	Purge Setting
Global Resv Action Purge	DELETE_RESERVATION UPDATE_INVENTORY CREDIT_CARD_SCREEN_ACCESS UPDATE_CERTIFICATES	Purges following information from RESERVATION_NAME_JRNL: Purge inventory update records older than 180 days Purge turnaway records older than 180 days. Purge credit card interface error records older than 180 days. Purge credit card screen access records older than 1 year. Purge emailed folio records older than 2 years. Note: purge_update_inv_log function included in global_resv_action_purge as of V5.0.03.01.
Procedure	Routine / Table Name	Purge Setting
Delete IFC Msgs	IFC_MESSAGES	When the Purge Job is enabled and scheduled, records from IFC_MESSAGES for all resorts and all Interfaces will be removed according to the IFC’s Configuration setting for “Message Expires After” (minutes). If this setting is not populated, the purge will use a default value of 48 hours (2880 minutes). Any record older than 48 hours will be removed.