Data Reconciliation Changes

Use the Data Reconciliation Changes report to review changes that were made to each data section of a producer record in Producer Manager as the result of an automated data reconciliation operation. The side-by-side comparison of the record prior to and after the operation can be useful audit information.

ClosedView screen capture

To open the Data Reconciliation Changes report, in the Reports section of the Data Reconciliation Requests page, click the Producer Record Updates link. The report will open in a separate window.

The Data Reconciliation Changes report contains updated producer information grouped in the following sections:

ClosedDemographics

Displays side-by-side changes made by the selected automated data reconciliation operation to the following fields in the Details data section of the producer record:

  • First Name (individual producer records only)

  • Middle Name (individual producer records only)

  • Last Name (individual producer records only)

  • Suffix Name (individual producer records only)

  • Firm Name (firm producer records only)

  • Birth Date (individual producer records only)

  • SSN (individual producer records only)

  • EIN (firm producer records only)

  • NPN (added to the producer record if non-existent)

  • Last Sync Date (if the automated data reconciliation completed successfully)

  • Licensee (confirms that the selected producer holds at least one active insurance license)

Fields and controls include the following:

  • Added: Displays a numeric value indicating the number of data types that the automated data reconciliation operation added to this section of the producer record.

  • Updated: Displays a numeric value indicating the number of data types that the automated data reconciliation operation updated in this section of the producer record.

  • Deleted: Displays a numeric value indicating the number of data types that the automated data reconciliation operation deleted from this section of the producer record.

  • Field Name: Displays the data field name in the producer record that was potentially affected by the automated data reconciliation operation.

  • Original Value: Displays the value of the data field identified in Field Name prior to the automated data reconciliation operation.

  • Updated Value: Displays the value of the data field identified in Field Name following the automated data reconciliation operation. If a value was changed or added it will appear colored green. If a value was deleted it will appear colored red.

ClosedAddresses

Displays side-by-side changes made by the selected automated data reconciliation operation to the following fields for business location, residential (individual producers only), and mailing address types recorded in the Contact Information data section of the producer record:

  • Address Type

  • Line One

  • Line Two

  • Line Three

  • City

  • State

  • Postal Code

Fields and controls include the following:

  • Added: Displays a numeric value indicating the number of data types that the automated data reconciliation operation added to this section of the producer record.

  • Updated: Displays a numeric value indicating the number of data types that the automated data reconciliation operation updated in this section of the producer record.

  • Deleted: Displays a numeric value indicating the number of data types that the automated data reconciliation operation deleted from this section of the producer record.

  • Field Name: Displays the data field name in the producer record that was potentially affected by the automated data reconciliation operation.

  • Original Value: Displays the value of the data field identified in Field Name prior to the automated data reconciliation operation.

  • Updated Value: Displays the value of the data field identified in Field Name following the automated data reconciliation operation. If a value was changed or added it will appear colored green. If a value was deleted it will appear colored red.

ClosedAliases

Displays side-by-side changes made by the selected automated data reconciliation operation to the following fields in the Aliases data section of the producer record:

  • Alias Name

  • Alias Type

  • State

  • Effective Date

Fields and controls include the following:

  • Added: Displays a numeric value indicating the number of data types that the automated data reconciliation operation added to this section of the producer record.

  • Updated: Displays a numeric value indicating the number of data types that the automated data reconciliation operation updated in this section of the producer record.

  • Deleted: Displays a numeric value indicating the number of data types that the automated data reconciliation operation deleted from this section of the producer record.

  • Field Name: Displays the data field name in the producer record that was potentially affected by the automated data reconciliation operation.

  • Original Value: Displays the value of the data field identified in Field Name prior to the automated data reconciliation operation.

  • Updated Value: Displays the value of the data field identified in Field Name following the automated data reconciliation operation. If a value was changed or added it will appear colored green. If a value was deleted it will appear colored red.

ClosedResident States

Displays side-by-side changes made by the selected automated data reconciliation operation to the following fields in the Resident States data section of the producer record:

  • State

Fields and controls include the following:

  • Added: Displays a numeric value indicating the number of data types that the automated data reconciliation operation added to this section of the producer record.

  • Updated: Displays a numeric value indicating the number of data types that the automated data reconciliation operation updated in this section of the producer record.

  • Deleted: Displays a numeric value indicating the number of data types that the automated data reconciliation operation deleted from this section of the producer record.

  • Field Name: Displays the data field name in the producer record that was potentially affected by the automated data reconciliation operation.

  • Original Value: Displays the value of the data field identified in Field Name prior to the automated data reconciliation operation.

  • Updated Value: Displays the value of the data field identified in Field Name following the automated data reconciliation operation. If a value was changed or added it will appear colored green. If a value was deleted it will appear colored red.

ClosedLicenses

Displays side-by-side changes made by the selected automated data reconciliation operation to the following fields in the Licenses data section of the producer record:

  • License Number

  • License Type

  • State

  • Residency

  • Status

  • Status Date

  • Original Issue Date

  • Expiration Date

  • Inactivation Reason

Fields and controls include the following:

  • Added: Displays a numeric value indicating the number of data types that the automated data reconciliation operation added to this section of the producer record.

  • Updated: Displays a numeric value indicating the number of data types that the automated data reconciliation operation updated in this section of the producer record.

  • Deleted: Displays a numeric value indicating the number of data types that the automated data reconciliation operation deleted from this section of the producer record.

  • Field Name: Displays the data field name in the producer record that was potentially affected by the automated data reconciliation operation.

  • Original Value: Displays the value of the data field identified in Field Name prior to the automated data reconciliation operation.

  • Updated Value: Displays the value of the data field identified in Field Name following the automated data reconciliation operation. If a value was changed or added it will appear colored green. If a value was deleted it will appear colored red.

ClosedQualifications

Displays side-by-side changes made by the selected automated data reconciliation operation to the following fields in the Qualifications data section of the producer record:

  • Qualification Type

  • State

  • Status

  • Status Date

  • Original Issue Date

  • Expiration Date

  • Inactivation Reason

Fields and controls include the following:

  • Added: Displays a numeric value indicating the number of data types that the automated data reconciliation operation added to this section of the producer record.

  • Updated: Displays a numeric value indicating the number of data types that the automated data reconciliation operation updated in this section of the producer record.

  • Deleted: Displays a numeric value indicating the number of data types that the automated data reconciliation operation deleted from this section of the producer record.

  • Field Name: Displays the data field name in the producer record that was potentially affected by the automated data reconciliation operation.

  • Original Value: Displays the value of the data field identified in Field Name prior to the automated data reconciliation operation.

  • Updated Value: Displays the value of the data field identified in Field Name following the automated data reconciliation operation. If a value was changed or added it will appear colored green. If a value was deleted it will appear colored red.

ClosedAppointments

Displays side-by-side changes made by the selected automated data reconciliation operation to the following fields in the Appointments data section of the producer record:

  • Company NAIC ID

  • Appointment Type

  • State

  • Status

  • Active Date

  • Termination Date

  • Termination Reason

  • State Verified

Fields and controls include the following:

  • Added: Displays a numeric value indicating the number of data types that the automated data reconciliation operation added to this section of the producer record.

  • Updated: Displays a numeric value indicating the number of data types that the automated data reconciliation operation updated in this section of the producer record.

  • Deleted: Displays a numeric value indicating the number of data types that the automated data reconciliation operation deleted from this section of the producer record.

  • Field Name: Displays the data field name in the producer record that was potentially affected by the automated data reconciliation operation.

  • Original Value: Displays the value of the data field identified in Field Name prior to the automated data reconciliation operation.

  • Updated Value: Displays the value of the data field identified in Field Name following the automated data reconciliation operation. If a value was changed or added it will appear colored green. If a value was deleted it will appear colored red.

ClosedCourse Completions

Displays side-by-side changes made by the selected automated data reconciliation operation to the following fields in the Course Completions data section of the producer record:

  • Regulatory Body

  • Category

  • Course Name

  • Provider

  • Provider Subscriber ID

  • Provider Course ID

  • Credit Hours

  • Completion Date

  • Verified by Data Source

Fields and controls include the following:

  • Added: Displays a numeric value indicating the number of data types that the automated data reconciliation operation added to this section of the producer record.

  • Updated: Displays a numeric value indicating the number of data types that the automated data reconciliation operation updated in this section of the producer record.

  • Deleted: Displays a numeric value indicating the number of data types that the automated data reconciliation operation deleted from this section of the producer record.

  • Field Name: Displays the data field name in the producer record that was potentially affected by the automated data reconciliation operation.

  • Original Value: Displays the value of the data field identified in Field Name prior to the automated data reconciliation operation.

  • Updated Value: Displays the value of the data field identified in Field Name following the automated data reconciliation operation. If a value was changed or added it will appear colored green. If a value was deleted it will appear colored red.

ClosedThird Party Certifications

Displays side-by-side changes made by the selected automated data reconciliation operation to the following fields in the Third Party Certifications data section of the producer record:

  • Regulatory Body

  • Verified Date

  • Expiration Date

  • Source

  • Status

  • Status Reason

Fields and controls include the following:

  • Added: Displays a numeric value indicating the number of data types that the automated data reconciliation operation added to this section of the producer record.

  • Updated: Displays a numeric value indicating the number of data types that the automated data reconciliation operation updated in this section of the producer record.

  • Deleted: Displays a numeric value indicating the number of data types that the automated data reconciliation operation deleted from this section of the producer record.

  • Field Name: Displays the data field name in the producer record that was potentially affected by the automated data reconciliation operation.

  • Original Value: Displays the value of the data field identified in Field Name prior to the automated data reconciliation operation.

  • Updated Value: Displays the value of the data field identified in Field Name following the automated data reconciliation operation. If a value was changed or added it will appear colored green. If a value was deleted it will appear colored red.

ClosedPage Controls

Fields and controls include the following:

  • : Click to open the Filter Options panel. To filter the report by selections in the Sections, Change Types or States filter option groups, click to checkmark the checkboxes corresponding the desired filter criteria.

  • : Click to hide the Filter Options panel.

  • Apply Filter: Available only with the Filter Options panel displaying. After selecting filter options, click to apply filter options.

  • Print Document: Click to print a hard copy of the Data Reconciliation Changes page.

 

Notes

Note: Changes to the name fields in the Demographics section and any information in the Addresses section reflect updated information obtained from a producer's primary residence state.

Note: When an automated data reconciliation updates a producer record, Producer Manager automatically records historical name and address information, which you may review in the Aliases and Address History data sections, respectively, of the producer's record open in the Review/Update Producer page.

Note: The Course Completions section appears only if your company subscribes to the Vertafore education data service. Through the subscription-based service, Producer Manager can obtain continuing education or product-specific training course completion information directly from "Sircon States" (i.e., states for which Vertafore developed or hosts their regulatory management system) or from the Vertafore education bank, which contains course completion information uploaded by education providers belonging to the exclusive Vertafore Authorized Provider Network. For more information, contact your Vertafore representative.

Note: The Third Party Certifications section appears only if your company subscribes to an external source of producer product certification, such as ClearCert, and also subscribes to the Vertafore third-party certification integration service. For more information, consult your Vertafore representative

Note: The Data Reconciliation Changes report does not reflect any changes made to producer information by a data normalizer, as logged in the Automatically Resolved Data Issues section of the Data Reconciliation Details page. For more information about data normalizers, see Automated Data Reconciliation Data Normalizers and Processing Messages Guide.