Data Quality

Your Application Table Columns

Use this page to View Your Application Table Columns.

To access this page:

  1. Select Data Quality > Your Applications in the Navigation pane.
  2. Click the Tables icon.
  3. Click the Columns icon.

Field

Description

TABLE NAME

Display the name of the table.

COLUMN NAME

Displays the name of the column.

SIGMA LEVEL

Displays the sigma level based on data quality score calculations.

The Enable Sigma Level check box on the Parameters page must be checked for this field to display.

OPPORTUNITIES

Displays the number of records in the opportunity view, which contains the full set of possible records that could potentially fail in the error report.

DEFECTS

Displays the number of errors on the report.

DPMO

Displays the Defects Per Million Opportunities as calculated based on Opportunities and Defects.

DPMO = (Total Defects / Total Opportunities) * 1,000,000

DEFECT PERCENTAGE

Displays the defect percentage.

(Total Defects / Total Opportunities)* 100%

DATA QUALITY SCORE

Displays the data quality score.

(100 - %Defects)

ERROR COST

Displays the cost of data quality issues for all reports based on data in the application table columns. Error cost is calculated by multiplying the number of errors on a report by the report's cost per failure, entered on the Vertical View of the Repository Reports page.Refer to Configure the Business Value Dashboard for more information.

STATUS

Displays status based on defect percentage and data quality score thresholds. Statuses are Red (critical), Yellow (warning) and Green. Hover over a Status icon to view the threshold.

NOTE: A Warning icon (yellow triangle) in the Status field indicates that none of the associated reports have an opportunity view, or that in all reports, the number of opportunities is less than the number of number of defects in the rolled up calculations.

Reports

Click to open the Your Application Table Column Reports page to view the reports.