10.5 Viewing Controls

To view the controls, follow these steps:

  1. From Financial Services Data Governance for North America Regulatory Reporting window navigate to Controls.
    The Control summary window is displayed. After you execute the batch DGS_DQ_CTL_BATCH, the Control summary window displays the stage tables for which the controls are defined. It also displays the assessments and open issues if any.

    Figure 10-2 Data Governance Controls


    This illustration shows the Control summary window. It shows the stage tables for which the controls are defined. It also displays the assessments and open issues if any.

  2. Select a stage table and then click the View Controls icon to view the details.
    For example, the stage table “Stage Investment” and control “Instrument Code in Stage Investments” is selected here.

    Figure 10-3 Data Governance Controls – Stage investments


    This illustration shows the Data Governance Controls – Stage investments Governance Controls details.

  3. Click Properties to view the control properties.

    Figure 10-4 Data Governance Controls – Properties


    This illustration shows the control property details.

    The control information is displayed:

    • Name: Name of the control
    • Type: Type of the Control – Quality Control
    • Methodology: Method used – OFSAA Method
    • Financial Accuracy Check: Yes or No
    • Owner: Name of the Owner
    • Comments: Add comments if any
  4. Click Data Quality to view the DQ information on which the control is created.

    Figure 10-5 Data Governance Controls – Data Quality


    This illustration shows the Data Quality information on which the control is created.

    The DQ information is displayed:

    • DQ Name: Name of the DQ contributing to the control.
    • DQ Weight: Weight of the DQ contributing to the control. In case there is one DQ the number is 100. If there are more than one the number is divided to make it 100.
    • Attribute: Name of the attribute on the entity column where the DQ is defined.
    • Entity: Name of the stage table name.
  5. Click Assessments to view the Control Assessments.

    Figure 10-6 Data Governance Controls – Assessments


    This illustration shows the Control Assessments details.

    The control assessment information is displayed:

    • Effectiveness Score: Control Assessment Score.
    • Effectiveness Rating: Control Assessment Rating. It can be Ineffective or Effective depending on the effectiveness score.
    • Effectiveness Status: Control Assessment Status.
    • Execution Date: Assessment date and time.
  6. Click Issues & Actions to view the system-generated issues created for control. To edit a system-generated issue, see section Editing an Issue.

    Figure 10-7 Data Governance Controls – Issues & Actions


    This illustration shows the details of system-generated issues created for control.