VERIFIED SOLUTION i

Availability of old and new address information in EngageOne Delivery Audit Database

The Data Manager dbo.acs_address_changes (ACS) table contains the old and new address information as well as other information such as names, etc.
Following are the list of columns that hold the new and old address in dbo.acs_address_changes table in Data Manager Database.
  1. old_address_type
  2. old_address_urbanization_name
  3. old_address_primary_number
  4. old_address_pre_directional
  5. old_address_street_name
  6. old_address_street_suffix
  7. old_address_post_directional
  8. old_address_unit_designator
  9. old_address_secondary_number
  10. old_address_city
  11. old_address_state
  12. old_address_zip5
  13. new_address_type
  14. new_address_urbanization_name
  15. new_address_primary_number
  16. new_address_pre_directional
  17. new_address_street_name
  18. new_address_street_suffix
  19. new_address_post_directional
  20. new_address_unit_designator
  21. new_address_secondary_number
  22. new_address_city
  23. new_address_state
  24. new_address_zip5
  25. new_address_zip_plus4
  26. new_address_dpbc_2
  27. new_address_dpbc_check_digit
  28. new_address_in_label_format
  29. new_foreign_address_line_1
  30. new_foreign_address_line_2
  31. new_foreign_address_line_3
  32. new_foreign_address_code
  33. new_foreign_address_subcode
UPDATED:  November 2, 2017