Referential Integrity Validation Processes

The following table lists every background process that validates transaction data using the same program CIPVRNVB. These programs are typically run as part of the conversion and upgrade processes.

In all cases, the processes are not multi-threaded and do not include extra parameters. In addition, Records Between Commits and Minutes Between Cursor Re-Initiation are not applicable.

Fastpath:

Refer to Validate Information In The Staging Tables for more information about these processes and where their errors appear.

*Batch Control ID*	*Description*
CIPVAAPV	Foreign Key validation for Account Automatic Payment
CIPVACHV	Foreign Key validation for Account Characteristics
CIPVACPV	Foreign Key validation for Account Person Relationship
CIPVADCV	Foreign Key validation for Adjustment Characteristics
CIPVADJV	Foreign Key validation for Adjustment
CIPVADLV	Foreign Key validation for Adjustment Log
CIPVADPV	Foreign Key validation for Adjustment Log Parameters
CIPVALPV	Foreign Key validation Appeal Log Parameters
CIPVAPAV	Foreign Key validation for Location Alternate Address
CIPVAPCV	Foreign Key validation for Account Person Characteristics
CIPVAPEV	Foreign Key validation for Appeal Person
CIPVAPHV	Foreign Key validation for Appeal Characteristics
CIPVAPLV	Foreign Key validation for Appeal Log
CIPVAPOV	Foreign Key validation for Appeal Related Object
CIPVAPPV	Foreign Key validation fro Appeal
CIPVAPRV	Foreign Key validation for A/P Check Request
CIPVAPSV	Foreign Key validation for Appeal Suppressed Obligation
CIPVAREV	Foreign Key validation for Appeal Review
CIPVARHV	Foreign Key validation for Collection Agency Referral History
CIPVARSI	Foreign Key validation for Credit Review Schedule
CIPVARUV	Foreign Key validation for Appeal Responsible User
CIPVAUCV	Foreign Key validation for Audit Case Characteristics
CIPVAULV	Foreign Key validation for Audit Case Log
CIPVAUMV	Foreign Key validation for Audit Case Log Parameters
CIPVAUPV	Foreign Key validation for Audit Case Related Person
CIPVAURV	Foreign Key validation for Audit Case Review
CIPVAUSV	Foreign Key validation for Audit Case Audited Obligation
CIPVAUUV	Foreign Key validation for Audit Case Responsible User
CIPVBCGV	Foreign Key validation for Billable Charge
CIPVBCHV	Foreign Key validation for Bill Characteristic
CIPVBCLV	Foreign Key validation for Billable Charge Line
CIPVBFVV	Foreign Key validation for Rate Factor Value
CIPVBKAV	Foreign Key validation for Bankruptcy Log Parameters
CIPVBKCV	Foreign Key validation for Bankruptcy
CIPVBKHV	Foreign Key validation for Bankruptcy Characteristics
CIPVBKLV	Foreign Key validation for Bankruptcy Log
CIPVBKMV	Foreign Key validation for Bankruptcy Milestone
CIPVBKOV	Foreign Key validation for Bankruptcy Covered Obligation
CIPVBKPV	Foreign Key validation for Bankruptcy Related Person
CIPVBKUV	Foreign Key validation for Bankruptcy Responsible User
CIPVBLLV	Foreign Key validation for Bill Header
CIPVBLMV	Foreign Key validation for Bill Messages
CIPVBLRV	Foreign Key validation for Bill Routing
CIPVBSAV	Foreign Key validation for Bill - Obligation Balance Snapshot
CIPVBSCV	Foreign Key validation for Bill Segment Calc Header
CIPVBSLV	Foreign Key validation for Bill Segment Calc Line
CIPVCARV	Foreign Key validation for Collection Agency Referral
CIPVCCCV	Foreign Key validation for Collection Case Characteristics
CIPVCCHV	Foreign Key validation for Case Characteristics
CIPVCCLV	Foreign Key Validation for Collection Case Log
CIPVCCOV	Foreign Key Validation for Collection Case Overdue Process
CIPVCCPV	Foreign Key Validation for Collection Case Log Parameter
CIPVCCSV	Foreign Key Validation for Collection Case
CIPVCLCV	Foreign Key validation for Adjustment Calc Line Characteristics
CIPVCLGV	Foreign Key validation for Case Log
CIPVCPAV	Foreign Key validation for Case Log Parameters
CIPVCRTV	Foreign Key validation for Credit Rating History
CIPVCSCV	Foreign Key validation for Customer Contact
CIPVFTCV	Foreign Key validation for Financial Transaction Characteristics
CIPVFTFV	Foreign Key validation for Financial Transaction
CIPVFTGV	Foreign Key validation for Financial Transaction Gen Ledger
CIPVFTPV	Foreign Key validation for Financial Transaction Process
CIPVMSGV	Foreign Key validation for Account Bill Messages
CIPVNBSV	Foreign Key validation for Pay Plan / Obligation
CIPVNPMV	Foreign Key validation for Pay Plan Payment Schedule Parameter Values
CIPVNSPV	Foreign Key validation for Pay Plan Scheduled Payments
CIPVOPCV	Foreign Key validation for Overpayment Process Characteristics
CIPVOPLV	Foreign Key validation for Overpayment Process Log
CIPVOPMV	Foreign Key validation for Overpayment Process Log Parameter
CIPVOPPV	Foreign Key validation for Overpayment Process
CIPVPAOV	Foreign Key validation for Person Address Override
CIPVPAYV	Foreign Key validation for Payment Header
CIPVPYCV	Foreign Key validation for Payment Characteristic
CIPVPCHV	Foreign Key validation for Location Characteristic
CIPVPGOV	Foreign Key validation for Location Geographic location
CIPVPIDV	Foreign Key validation for Person Identifier
CIPVPNMV	Foreign Key validation for Person Name
CIPVPPEV	Foreign Key validation for Person to Person
CIPVPPHV	Foreign Key validation for Person Phone
CIPVPRCV	Foreign Key validation for Person Characteristics
CIPVPSAV	Foreign Key validation for Person Seasonal Address
CIPVPSGV	Foreign Key validation for Payment Segment
CIPVPYCV	Foreign Key validation for Payment Characteristics
CIPVREVV	Foreign Key validation for Review
CIPVRLPV	Foreign Key validation for Review Log Parameters
CIPVRVCV	Foreign Key validation for Review Characteristics
CIPVRVLV	Foreign Key validation for Review Log
CIPVSACV	Foreign Key validation for Obligation Characteristics
CIPVSAHV	Foreign Key validation for Obligation Rate Schedule History
CIPVSAOV	Foreign Key validation for Obligation Contract Terms
CIPVSAQV	Foreign Key validation for Obligation Contract Quantity
CIPVSARV	Foreign Key validation for Obligation Recurring Charge
CIPVSEGV	Foreign Key validation for Bill Segment
CIPVSMGV	Foreign Key validation for Obligation Message
CIPVSQTV	Foreign Key validation for Bill Segment Rate Quantity
CIPVSRRV	Foreign Key validation for Bill Segment Register Read
CIPVSUCV	Foreign Key validation for Suppression Characteristics
CIPVSUEV	Foreign Key validation for Suppression Entity
CIPVSULV	Foreign Key validation for Suppression Log
CIPVSUMV	Foreign Key validation for Suppression Log Parameters
CIPVSUPV	Foreign Key validation for Suppression
CIPVSURV	Foreign Key validation for Suppression Process
CIPVTFCV	Foreign Key Validation for Tax Form Characteristics
CIPVTFLV	Foreign Key Validation for Tax Form Log
CIPVTLPV	Foreign Key Validation for Tax Form Log Parameter
CIPVTNDV	Foreign Key validation for Payment Tender
CIPVTNCV	Foreign Key validation for Payment Tender Characteristics
CIPVTXCV	Foreign Key validation for Tax Role Characteristics
CIPVTXFV	Foreign Key validation for Tax Form
CIPVTXRV	Foreign Key validation for Tax Role

Please refer to Column Descriptions for more information on the columns used in the table above.