---
schema_version: "1"
id: 15329ce4cb028f148a00ebf77a6163a72448cff65e23d680cad0b35ae8baf6a8
title: Data Integrity Architecture
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/sfdo/264-0-0/ip_architecture_data_integrity.md
canonical_url: https://help.salesforce.com/s/articleView?id=sfdo.ip_architecture_data_integrity.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 1d78f79bf849800286dc02d3c8c0de1b9b19ddba9f308bc83954869b48d70bb1
description: Learn about the prerequisites for Data Integrity and how it works with Nonprofit Success Pack (NPSP) fields.
products:
  - Nonprofit
release: "264"
---
# Data Integrity Architecture

Learn about the prerequisites for Data Integrity and how it works with Nonprofit Success Pack (NPSP) fields.

- **[Data Integrity Architecture](https://help.salesforce.com/s/articleView?id=sfdo.ip_architecture_data_integrity.htm&release=264.0.0&type=5)**  
    Data Integrity helps maintain the integrity of your data for Address, Contact, and Account objects.
- **[How Data Integrity Interacts with NPSP Fields](https://help.salesforce.com/s/articleView?id=sfdo.ip_architecture_data_integrity.htm&release=264.0.0&type=5)**  
    Learn how Data Integrity Address Standardization and National Change of Address (NCOA) updates interact with Nonprofit Success Pack (NPSP) objects and fields.

## Data Integrity Architecture

Data Integrity helps maintain the integrity of your data for Address, Contact, and Account objects.

The [Nonprofit Success Pack (NPSP)](https://help.salesforce.com/s/articleview?id=sfdo.nonprofit_success_pack.htm) app is a prerequisite for Data Integrity. Data Integrity works with the NPSP Address object, and consequently updated address records are only stored in NPSP. Data Integrity interacts with and modifies objects and fields in NPSP version 3.175 or later.

To start a workflow, a Salesforce administrator configures a job schedule in Data Integrity. Configuration options allow various parameters to be set, including:

- Selecting how to merge duplicate Contacts
- Updating  addresses that are to be standardized
- Setting time and frequency of updates performed by the system

Data Integrity interfaces with NPSP to process and transform the selected data. Depending on jobs that are initiated by the administrator, bulk data is deduplicated or standardized by Data Integrity. Standardized data is then pushed back to the Address object  and stored in NPSP. Related NPSP or custom triggers then initiate an update of related Account and Contact records, if required.

This diagram highlights the high-level relationship between various the components and also illustrates the general workflow:

![High-Level of Overview of Data Integrity Architecture](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sfdo-insights_platform-264-0-0-production-enus/b395891b-0de5-4183-969e-3a0bd782bfe8/insights_platform/images/npsp_dataintegrity_080422_zh_r1.png)

Data Integrity has significant data processing capabilities. The system can process millions of Address records during non-business hours. Use these out-of-the box jobs to improve the quality and integrity of your data:

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
          <colgroup>
            <col style="width:33.33333333333333%">
            <col style="width:66.66666666666666%">
          </colgroup>
          <thead class="slds-text-title_caps ">
            <tr class="">
              <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d6575e125">Job Name</th>
              <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d6575e128">Description</th>
            </tr>
          </thead>
          <tbody>
            <tr class="">
              <td data-label="Job Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d6575e125 ">Duplicate Jobs</td>

              <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d6575e128 ">
                <a href="https://help.salesforce.com/s/articleview?id=sfdo.npsp_merge_contacts.htm" target="_blank">Duplicate Jobs</a> makes
                it easy to find all of your existing duplicate records and utilize <a href="https://help.salesforce.com/s/articleview?id=sfdo.npsp_merge_contacts.htm" target="_blank">Contact Merge</a> to
                resolve these duplicates in Salesforce.
              </td>

            </tr>
            <tr class="">
              <td data-label="Job Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d6575e125 ">
                <p style="margin-bottom:0;">Address
                  Standardization</p>
              </td>

              <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d6575e128 ">
                <a href="https://help.salesforce.com/s/articleView?id=sfdo.ip_about_address_stand.htm&amp;release=264.0.0&amp;type=5" title="Incorrectly formatted addresses are costly and can lead to undeliverable mail. Address standardization in Data Integrity helps you avoid incorrectly formatted addresses by making updates based on the specific standards of your locale's postal authority. This includes city names, street abbreviations, and more.">Address Standardization</a> helps correct incorrectly formatted
                addresses by making updates based on the specific standards of your
                locale's postal authority.
              </td>

            </tr>
            <tr class="">
              <td data-label="Job Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d6575e125 ">
                <p style="margin-bottom:0;">National Change of
                  Address (NCOA) Updates</p>
              </td>

              <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d6575e128 ">
                <a href="https://help.salesforce.com/s/articleView?id=sfdo.ip_about_ncoa_data_integrity.htm&amp;release=264.0.0&amp;type=5" title="National Change of Address (NCOA) updates in Data Integrity make it easy for you to keep up with constituents when they update their address. NCOA updates may also qualify your organization for postal discounts.">NCOA Updates</a> make it easy to keep up with constituents when
                they update their address with the USPS.
              </td>

            </tr>
            <tr class="">
              <td data-label="Job Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d6575e125 ">Contact Standardization</td>

              <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d6575e128 ">Contact Standardization enables your nonprofit
                to reach out to constituents based on their latest contact information,
                deceased status, and planned giving intentions.</td>

            </tr>
          </tbody>
        </table>

## How Data Integrity Interacts with NPSP Fields

Learn how Data Integrity Address Standardization and National Change of Address (NCOA) updates interact with Nonprofit Success Pack (NPSP) objects and fields.

### Address Standardization

Address standardization updates can access these fields on npsp\_ \_Address\_ \_c:

  
| Field Label | Field API Name | Access |
| --- | --- | --- |
| Address Id | Id | Read |
| Ambiguous | npsp\_ \_Ambiguous\_ \_c | Read/Write |
| Mailing City | npsp\_ \_MailingCity\_ \_c | Read/Write |
| Mailing Country | npsp\_ \_MailingCountry\_ \_c | Read/Write |
| Mailing State/Province | npsp\_ \_MailingState\_ \_c | Read/Write |
| Mailing Street | npsp\_ \_MailingStreet\_ \_c | Read/Write |
| Mailing Street2 | npsp\_ \_MailingStreet2\_ \_c | Read/Write |
| Mailing Zip/Postal Code | npsp\_ \_MailingPostalCode\_ \_c | Read/Write |
| Verified | npsp\_ \_Verified\_ \_c | Read/Write |
| Verified Date | npsp\_ \_Verified\_Date\_ \_c | Write |

Address standardization updates use the values of these fields on npsp\_ \_Address\_ \_c to determine which records to include in updates:

  
| Field Label | Field API Name | Description |
| --- | --- | --- |
| Default Address | npsp\_ \_Default\_Address\_ \_c | When selected, indicates that the address is the default address. Allows updates to be run only on default addresses. |
| Exclude from Updates | npsp\_ \_Exclude\_from\_Updates\_ \_c | When selected, excludes the address from scheduled address standardization and NCOA updates within Data Integrity. |
| Mailing Country | npsp\_ \_MailingCountry\_ \_c | Determines the country of the address. Only US addresses are supported. |
| Verified | npsp\_ \_Verified\_ \_c | When selected, either manually or by an NPSP or Data Integrity update, excludes the address from standardization. |

### National Change of Address

National Change of Address updates can access these fields:

   
| Object Name | Field Label | Field API Name | Access |
| --- | --- | --- | --- |
| Account | ID | Id | Read |
| npsp\_ \_Address\_ \_c | ID | Id | Read |
| npsp\_ \_Address\_ \_c | Mailing Street | npsp\_ \_MailingStreet\_ \_c | Read/Write |
| npsp\_ \_Address\_ \_c | Mailing Street2 | npsp\_ \_MailingStreet2\_ \_c | Read/Write |
| npsp\_ \_Address\_ \_c | Mailing City | npsp\_ \_MailingCity\_ \_c | Read/Write |
| npsp\_ \_Address\_ \_c | Mailing State/Province | npsp\_ \_MailingState\_ \_c | Read/Write |
| npsp\_ \_Address\_ \_c | Mailing Country | npsp\_ \_MailingCountry\_ \_c | Read/Write |
| npsp\_ \_Address\_ \_c | Mailing Zip/Postal Code | npsp\_ \_MailingPostalCode\_ \_c | Read/Write |
| npsp\_ \_Address\_ \_c | Default Address | npsp\_ \_Default\_Address\_ \_c | Read/Write |
| npsp\_ \_Address\_ \_c | Address Type | npsp\_ \_Address\_Type\_ \_c | Read/Write |
| npsp\_ \_Address\_ \_c | NCOA Evaluation Date | npsp\_ \_NCOA\_Evaluation\_Date\_ \_c | Read/Write |
| npsp\_ \_Address\_ \_c | NCOA Result Code | npsp\_ \_NCOA\_Result\_Code\_ \_c | Write |
| npsp\_ \_Address\_ \_c | Verified | npsp\_ \_Verified\_ \_c | Read/Write |
| npsp\_ \_Address\_ \_c | Verified Date | npsp\_ \_Verified\_Date\_ \_c | Read/Write |
| Contact | First Name | FirstName | Read |
| Contact | Last Name | LastName | Read |

National Change of Address updates use the values of these fields on npsp\_ \_Address\_ \_c to determine which records to include in updates:

  
| Field Label | Field API Name | Comment |
| --- | --- | --- |
| Default Address | npsp\_ \_Default\_Address\_ \_c | When selected, indicates that the address is the default address. Allows updates to be run only on default addresses. |
| Exclude from Updates | npsp\_ \_Exclude\_from\_Updates\_ \_c | When selected, excludes the address from scheduled address standardization and NCOA updates within Data Integrity. |
| Mailing Country | npsp\_ \_MailingCountry\_ \_c | Determines the country of the address. Only US addresses are supported. |
| NCOA Evaluation Date | npsp\_ \_NCOA\_Evaluation\_Date\_ \_c | The most recent date and time that an address was evaluated for NCOA updates, regardless of if a new address was found. Allows updates to be run only on records that haven't been evaluated within a specified time frame. |

### Contact Standardization

Contact Standardization can access these fields in the Contact object:

  
| Field Label | Field API Name | Access |
| --- | --- | --- |
| Deceased | npsp\_\_Deceased\_\_c | Read / Write |
| Deceased Date | insights\_\_Deceased\_Date\_\_c | Read / Write |
| Deceased Reviewed Date | insights\_\_Deceased\_Reviewed\_Date\_\_c | Read / Write |
| Email Reviewed Date | insights\_\_Email\_Reviewed\_Date\_\_c | Read / Write |
| Email Status | insights\_\_Email\_Status\_\_c | Read / Write |
| Email Verified | insights\_\_Email\_Verified\_\_c | Read / Write |
| Phone Reviewed Date | insights\_\_Phone\_Reviewed\_Date\_\_c | Read / Write |
| Phone Status | insights\_\_Phone\_Status\_\_c | Read / Write |
| Phone Verified | insights\_\_Phone\_Verified\_\_c | Read / Write |

Contact Standardization uses the values of these fields in the Contact object to determine which records to include in updates:

  
| Field Label | Field API Name | Access |
| --- | --- | --- |
| First Name | First Name | Read |
| Last Name | Last Name | Read |
| Email | Email | Read |
| Phone | Phone | Read |
| Mailing City | Mailing City | Read |
| Mailing Country | Mailing Country | Read |
| Mailing Postal Code | Mailing Postal Code | Read |
| Mailing Street | Mailing Street | Read |
| Mailing State | Mailing State | Read |