Arena and Multiple/Seasonal Addresses

1. Create “Future Address” luid
   
2. Create a daily job using this script: https://pastebin.com/axtaiLMG
   1. Update the following parameters in script to match your system: @AddressTypeFuture, @AddressTypeHome, @AddressTypePrevious, @HistoryType, @OrgID

This script finds all future addresses based on the future address type luid. If a future address’s “active date” is passed, the script will change the future address to be the primary home address for the corresponding person and any family members. If “previous address” is already present, it deletes the previous address and changes former primary home address to a new previous address. Update of future address and primary address changes are logged in user notes.

3. Create a new page in Arena “Update Future Address Date”. This will allow admins to update the active date on future addresses without having to use SSMS.
   1. Add “KFS Filter Builder” module to page
      1. Set Filter Directive to (https://pastebin.com/r013ZC3p)
   2. Add “Report Grid From Query” module to page
      1. Create new stored procedure cust_CCIW_get_save_future_address https://pastebin.com/Yd23qACm
         1. Make sure tp update LUID’s in sproc to match your system
      2. Update the module field called Parameters to (@ActiveDate=;@Guid=)

This page will allow for viewing and updating of future address dates. If you don’t have the KFS Filter Builder module you can pass the active date directly through a URL parameter to the procedure. When no active date is passed the address records won’t be updated. The procedure will update future addresses for all family members.

As with any custom scripts, verify functionality on a test profile before use. Use transactions with rollback when testing.

4. Optional – Create a page that allows navigation to the Update Future Address page from any Person Profile

Page should be created as a tab of profile page. This allows you to pass in a GUID to a dynamic URL

1. Create LUID for Seasonal Address
2. Create daily job (or append Future Address job) using this script: https://pastebin.com/36BHGHGV
   1. Update the parameter @AddressTypeHome in script to match your system’s
3. Create a new page in Arena “Update Seasonal To/From MMDD Values”.
   1. Add KFS Filter Builder module with following Filter Directive: https://pastebin.com/HCiW4Y5q
   2. Add Report Grid From Query module
      1. Create stored procedure cust_CCIW_get_save_seasonal_address https://pastebin.com/jZtKDM1V
      2. Set module parameters to “@Guid=;@FromMonthDay=;@ToMonthDay=;@AddressLUID=”