Manage Validations

You can use the Validation wizard in Reference Data Center to create validations that raise errors and warning messages. Validations ensure the quality of your composited data. Using the wizard you can define the validations, fields, and the data strategy. You can also view and edit and validations from the Validation wizard.

You can only assign validations to data strategies when you manage field properties during your data strategy setup. 

Access the Validation Wizard

Use the validation wizard to create validations to confirm the legitimacy of the field values used in the composited record.

To display the validation wizard :

1. In the Setup workspace,in the left navigation pane, select Validations.
   You see the Validations workspace with Validation page displayed.

2. Click Create New and select a data type from drop-down list. Options include:
   –  Analytics
   –  Exchange Rate
   –  Issuer
   –  Issuer Analytics
   –  Issuer Ratings
   –  Legal Entity ESG
   –  Prepayment Time Series
   –  Price
   –  Ratings
   –  Relationships
   –  Roles
   –  Schedule
   –  Security
   –  Third Party Cash Flow
   –  Variable Rates
   You see the Create New Validation wizard with the Define tab highlighted.

Define the Validations

In the Define page you define the data to validate and enter a name and ID for the validation.

1. In the ID text box, enter a unique identifier. If you leave this option blank, the system assigns a unique identifier.

2. In the Name text box, enter a name for the validation.

3. In the Description text box, optionally enter a description of the validation.

4. In the Error Code field select an error from the drop-down list.
   You see the Select Errors dialog box.

5. Click Tests to display the Logic Builder and define the logic for the validation.

6. Select the Data to Validate. Valid options include:
   –  Gold Copy. Select gold copy if you want to apply the validation to the composited gold copy field. Or, clear if validations do not apply.
   –  Vendor Data. Select vendor data if you want to apply the validation to the vendor sourced field. Or, clear if validations do not apply.

7. Select Option. Valid options include:
   –  Apply this Validation when data is manually entered. Or, clear if validations do not apply.
   –  Apply this Validation for Benchmark Securities. Or, clear if validations do not apply.

8. Click Next to access the Field page.

Define the Fields 

On the field page, you select the fields to be included in the validations. 

1. From the list of fields that display in the Available fields column, select the fields to move to the Selected fields column by clicking Add or Remove .

2. You can also Add All or Remove all by clicking on the corresponding buttons.

3. Click Next to access the Data Strategy Settings page.

Define the Data Strategy

On the Data Strategy Settings page, you define the Data Strategy Validation.

1. In the Gold Copy drop-down box, select the data strategy. 

2.  Click Save & Close.
   A pop-up box displays indicating that the Validation test was saved successfully.

3. Click Ok.

View / Edit Validations

You can view and edit field validations from the Validation wizard.

To edit / view validations for composited fields:

1. From the Setup workspace, click Validations in the left navigation.
   You see the Validations workspace with the list of available validations.

2. Select the validation you wish to view / edit.

3. Click Edit.
   You see the Validation wizard.

4. Using the steps above, review the information, make the appropriate changes, and click Save.