Skip to main content
. 2019 Aug 2;7(1):38. doi: 10.5334/egems.298

Table 3.

Level 2 Data Quality Sections and Sub Sections needing to be addressed.

Level 2 DQ Section and Subsection areas Explanation
1. Area of interest/question to be investigated What is the area of interest/question to be investigated through the data analysis
2. Area of interest/question and sub question requirement context This will provide context on the area of interest/question and what is required to ensure the correct context is being used when assessing the quality of the data in the data warehouse and what needs to be addressed within the framework:

  1. Location of the research client’s documented variable/data item list for the data required to be extracted, that contains in generic non-system specific terms:

    1. Category/Area i.e. current prescriptions, past prescriptions, past history, reason for visit, patient demographic information
    2. Variable/data item within each category/area

  2. Number of source systems and the names of the source systems required to be extracted from

  3. Location of the client’s documented restrictions on the data to be provided – i.e. age-specific conditions only

  4. Data extraction and storage type: extract all data and over-write what is stored each time, or extract complete data first and then only changes after that

  5. Source data extraction type: database, delimited text file, Excel file, other file type
3. Table requirements assessment This lists out the tables required to answer the area of interest/question and what needs to be addressed within the framework:

  1. Location of the documented mapping between the secondary user’s area/category list and the tables that can be supplied

  2. Number of tables that can be supplied for required category/areas

  3. Location of the tables that cannot be supplied and justification as to why this is not possible – e.g. not available within the Best Practice™ source system

  4. Section to list out DQ characteristic assessment requirements

    1. Expected result of the characteristic
    2. Actual result of the characteristic
    3. Result of the characteristic – Pass/Fail
      1. If a fail, why did it fail
4. Field name 1 This lists out the tables required to answer the area of interest/question and what needs to be addressed within the framework:

  1. Location of the documented mapping between the secondary user’s variable/data item list and the fields that can be supplied

  2. Number of fields that can be supplied for required category/areas

  3. Location of the documentation containing which fields that cannot be supplied and justification as to why this is not possible – e.g. not available within Best Practice™

  4. Section to list out DQ characteristic assessment requirements

    1. Expected result of the characteristic
    2. Actual result of the characteristic
    3. Result of the characteristic – Pass/Fail
      1. If a fail, why did it fail

  5. Document the data accuracy of the field held within the data warehouse relating to the secondary user’s area of interest or question only

  6. Data interpretation, integrity and limitations

    1. Document any data interpretation issues known through the process or known through experience
    2. Document any data issues with the data in the data warehouse
    3. Document any known data limitations