Database Synchronization Jobs

Schedule database synchronization jobs to transfer information from the Enterprise Back Office database to the Gift and Loyalty database. These jobs can be required to let certain configurations or functionality, such as round-robin loyalty programs, to act upon the most up-to-date information in the system.

Standard or Required Sync Jobs

  • Sync iCare Programs with Customer Activity: Run once to synchronize Gift and Loyalty programs with the customer activity database.

  • Initialize YTD Total: Run once to initialize the calculation of Year-to-Date totals.

  • Sync iCare Transactions with LocAct: Run once daily after Point-of-Sale End of Day operations.

  • Sync iCare Customers with LocAct: Run once daily after Point-of-Sale End of Day operations.

  • Sync New iCare Customers with Customer Activity: Run once daily after Point-of-Sale End of Day operations.

  • Sync LocAct CustAct: Run once daily after Point-of-Sale End of Day operations.

  • Sync AGGREGATE_TRANSACTIONS: Run once daily after Point-of-Sale End of Day operations.

  • Sync Organizations: Run once when the organization is created.

  • Sync Org Levels: Run once when the organization is created, and run every time an organization level is added.

  • Sync RTA Org Levels: Run once when the organization is created, and run every time an organization level is added in the DOWNLOAD organization.

  • Sync Locations and Org Levels: Run once when the organization is created, and run every time an organization level or location is added.

  • Sync Locations: Run once when the organization is created, and run every time a location is added.

  • Sync Revenue Centers: Run once daily after Point-of-Sale End of Day operations.

  • Sync CA Locations: Run once daily after Point-of-Sale End of Day operations.

Sync Jobs for Program or Rule Configurations

  • Expire Points: For any site using expiring loyalty points, schedule based on the loyalty program.

  • Reset MTD Total: For any site using Month-to-Date totals, schedule on the first or last day of each month.

  • Reset YTD Total: For any site using Year-to-Date totals, schedule on the first day of the year if the organization is using calendar years to calculate balances, or schedule daily if the organization is set to a year based on the initial transaction.

  • Expire Gift or Debit Accounts: For any site using expiring gift or debit accounts, schedule based on the applicable program.

  • Expire Loyalty Accounts: For any site using expiring loyalty accounts, schedule based on the loyalty program.

  • Reset Credit Accounts: For each credit card program that must be reset, schedule based on site requirements to reset accounts to a 0-dollar balance.

  • Limit and Reload Debit Accounts: For programs that reload with a stored value, schedule based on site requirements for reloading cards or accounts.

  • Expire Partner Links: Schedule as needed to expire partner links.

  • Unique Items Sync: Schedule as needed to synchronize unique items.

  • Sync All Configuration: Schedule as needed to troubleshoot synchronization issues. Do not use this sync job when you are not troubleshooting.

  • Sync Major Group Masters: Run daily for programs that use major groups to identify item eligibility.

  • Sync Major Groups: Run daily for programs that use major groups to identify item eligibility.

  • Sync Family Group Masters: Run daily for programs that use family groups to identify item eligibility.

  • Sync Family Groups: Run daily for programs that use family groups to identify item eligibility.

  • Sync Menu Item Masters: Run daily for programs that use menu items to identify item eligibility.

  • Sync Menu Items: Run daily for programs that use menu items to identify item eligibility.