- Correlation identifies differences
- Reconciliation re-aligns the data
Correlation
Correlation compares data from the systems involved in a partnership and identifies where the records agree or differ. For entitlement correlation, DVM compares partner entitlement data with the corresponding entitlement data held in DVM. Depending on the partnership, the wider operational process can involve data held by a reseller, DVM, and a content provider. Correlation can identify:- Records that match
- Records present in one dataset but missing from another
- Differences in values such as product, status, or customer identifiers
- Multiple differences on the same record
Entitlement correlation reports
Compare entitlement data and identify matching records and differences.
Charge correlation reports
Compare charge and refund data with the corresponding DVM records.
Reconciliation
Reconciliation is the process of investigating correlation results and correcting the relevant data so the systems agree. A typical flow is:1
Compare the data
Submit correlation data and receive the correlation results.
2
Review differences
Identify missing records and values that do not match.
3
Investigate the cause
Determine which system contains the correct value and why the difference occurred.
4
Correct the data
Update the relevant system through the appropriate operational process.
5
Confirm alignment
Run correlation again to confirm that the records now agree.