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 Filter & View Options popout opens, with filtering, highlighting, and date range options on one side and Domain Details on the other, including Domain Created On, Domain Last Refreshed, and Data File Date.
   
3. Update the Between and And dates by typing over the dates displayed, or use the calendar icon in each date field.
   • Optionally, update the time.

4. By default, the Highlight checkbox is selected in both the New Records and Updated Records sections. Deselect either Highlight checkbox to exclude new or updated records from highlighting.
   To display only new or updated records within the defined date range, select the Filter Rows checkbox in the New Records or Updated Records section. Filter Rows can be used independently or combined with the Highlight options to isolate changed records while retaining the visual distinction between new and updated data.

   Note: When both Highlight checkboxes 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, deselect the New Records Highlight checkbox to remove the overriding highlight.

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.

Note: Active Data Variance filters display in the filter popout accessed from the panel's badge, and in the Local section of the Filter Panel.

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 next to the field name for fields with changed data. The value for each field displays in the defined date columns.
  
• Click the Data Variance icon to open a popout showing the field's change history, including the Change Date, Current Value, and Previous Value for each change.
  

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 in the panel toolbar.
2. Click Clear. 

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