Within a domain listing a user can define a date range to see new, changed, and deleted records. Records identified as new are highlighted green and records identified as changed are highlighted orange. Users can also access a link to a list of deleted records for the defined time period. 

Important: This feature must first be enabled in Study Configuration, and all datasets must have identifying keys configured in the ETL tab. (Datasets from Rave automatically have keys defined.) 

Apply a Data Variance to a Domain Listing

1. Access a domain listing.
2. Click the Data Variance icon in the panel toolbar. The Data Variance popout opens.
   
3. Update the Between and dates by typing over the dates displayed, or use the calendar icon in each date field.
   1. Optionally, update the time.

4. By default, Highlight New Records and Highlight Updated Records are selected. Clear either option to exclude new or updated records.

   Note: When both options are selected, records that did not exist on the first date but exist on the second date highlight green as new records. Records that existed on the first date and changed by the second date highlight orange as changed records.
   
   To identify records that did not exist at the first date but were created and updated before the second date, clear Highlight New Records to remove the overriding highlight. When Highlight New Records is selected, records display as new. When identifying changed records, records display as changed. 

5. To view deleted records within the defined date range, click the Show Deleted Records link. A separate listing displays the list of deleted records. 
   
6. Click Close to close the deleted records window.
7. Click Apply in the Data Variance popout. The popout closes, and the Data Variance icon appears active. New data highlights Green. Changed data highlights orange.

Tip: To see highlighted rows for all records in the panel, use the arrows in the panel toolbar to page through all records in the panel.

View New or Changed Data in Record Details View

Open the Details View for a highlighted record.

If Data Variance is applied to a Domain listing, changes display in the Record Details view.

Tip: A Data Variance may also be applied to any open Record Details view by clicking on the Data Variance icon and updating the date and time range without exiting the Record Details view.

Changed Record Details View

• Columns display data for the defined dates and current data. Scroll to see all columns.
• The Data Variance icon displays at the left of the field name for the fields with changed data, and the value displays in the defined date fields.
• Click the Data Variance icon to open a window with a summary of changes for each field that has new, updated, or deleted data.

New Record Details View

• Columns display for dates records were inserted and current data. Scroll to see all columns.

Deactivate Data Variance

1. Click the active Data Variance icon.
2. Click Clear. 

Note: Clicking the Data Variance icon again displays the most recent dates entered.