IWeb Health Promotion Module User Guide

Data Quality

This area of the application (Health Promotion > Data Quality) allows reports to be run to ensure the quality of data. Whenever possible, the application attempts to automatically correct issues and displays them in a report.

Note that the user must have the UFM Access user permission and that an Organization (IRMS) must be selected before the Health Promotion > Data Quality menu link becomes available.

Data quality is examined for all patients who meet the following criteria:

Children six years old or younger
Mail is not blocked
Children are not marked as inactive = Deceased

Data Quality Report Descriptions

These are the available reports to assist with data quality:

Restricted Addresses

Displays all patients and the restricted address line, city, state, zip code, and addresses containing CPS. Restricted addresses are stored in the registry database. Optionally enter updated from and through dates and click the Run Restricted Addresses Report button to run this report. The application logic performs the following:

The logic compares the normalized address (address mangled) which includes city, state, and zip code, and is applicable with the zip code that is populated in the h33_hp_restricted_addresses table.
Additional logic has been added to compare on Address only. In the address comparison, all spaces are removed and the address is compared in uppercase. This logic ignores differences with spaces and capitalization, but not differences such as "St." versus "Street." Thus, all variations need to be added to the h33_hp_restricted_addresses table. The variations are as follows: PO Box, PO Box 000, C/O, CO, ICO, %, Bad Address, Information Refused By Parents, Lives in Shelter, Mail Returned, Mail Return, Mail Ret, Need New Address, Not Active, Not Applicable, Same as above, Statement Hold Mail Returned, Undeliverable Address, Unk, Unknown, and Verify Address. Additional addresses can be added manually as needed via SQL*Plus.
DTT logic was applied to manually enter or update the Patient Demographics and Vaccination records with a "previously known bad address" and causes the Address to be blocked from updating the master record, plus the address is marked as invalid on the reserve. The provider does not see the invalid address flag on their record. However, if the address is invalid, the only way to switch the address back to valid is to update the record from the Health Promotions page. When this is done, the history still shows the address as having been invalid in the past. Any other manual update (other than a previously known bad address) is promoted to the master record.

Address Missing

Displays all patients that do not have a city, state or zip code, or those that have a city, state, and zip code but are missing a street address. These can be manually corrected. Optionally enter updated from and through dates, selected a minimum address length, and click the Run Addresses Missing Report button to run this report. Example results:

Zip code is not a valid zip code in the state of Washington.
Addresses that start with something other than 1-9, PO Box, Rural Route, or General Delivery. Also identifies addresses that contain no numbers (text only) and that contain numbers only (no text characters).
Mismatch between city, state, and zip code when one or more of these is in Washington.
Patients with Washington zip codes, but WA is not listed as the state
Patient with non-Washington zip codes and WA listed as the state.

Promote Reserve Addresses

Displays a list of patients (age 0 to 6) with invalid and missing addresses. The report runs based on the invalid address flag so that if the address is missing, the Missing Address report should be run first to mark the address invalid. Optionally enter updated from and through dates and birthdate from and through dates, then click the Run Promote Reserve Addresses Report button to run this report.

When the user selects a patient from this report, the Health Promotions Patient [Update] page opens for the selected patient.
The address history section has radio buttons by each address and only displays valid addresses. Valid addresses are determined by two criteria: (1) valid address flag; (2) address completeness (must have street address, city, state, and zip code).
Under the address history section is a button, Promote Address. When clicked, the master record updates with the selected address.

Unusable Names

Displays all patients that have unusable names and do not have a mailing name specified. Unusable names are stored in the registry database. Possible examples: John Doe, Jane Doe, Unknown. Optionally enter updated from and through dates and click the Run Unusable Name Report button to run this report.

In the deduplication procedure, if only one of the names is present in the table, neither the first name nor the last name is updated. Additionally, the Unusable Names table is used when determining whether a merge should overwrite the patient's name in the Master table.

Language Switch

Displays all patients that had edits to the Language field. Optionally enter updated from and through dates and click the Run Language Switch Report button to run this report.

Long Names

Displays all patients with names longer than 32 characters. The user can provide a Mailing Name to be used in place of the patient's long name. No changes are made to the patient's original data. To run this report, Optionally enter updated from and through dates, select whether or not to automatically fix long names, and click the Run Long Name Report button. The Automatically Fix Long Names option attempts to shorten names longer than 32 characters with this logic:

The middle name is removed
If the name is still too long, only the first initial is used
Any names that cannot be automatically fixed are listed in the Long Names report, allowing the user to provide a Mailing Name.

Suspicious Birth Dates

Displays the number of suspicious birth dates for children under the age of six. To run this report, optionally enter updated from and through dates and birthdate from and through dates, then click the Run Suspicious Birth Dates Report button. The application checks for any patient whose birthdate is the same as an immunization date, excluding HepB and HBIG. This prevents mailing to persons over the age of six when a bad birthdate has been received from batch or manual entry. When the report is run with a birthdate range, the list of records is displayed in order of birthdate, starting with the most recent.

Includes patients who have deleted vaccinations with vaccination dates prior to their birthdate
A list of patients is returned with an option to allow updating or correction of data

Schedule Bad Address Report

Displays a list of potentially bad addresses for evaluation.. To run this report, click the Schedule Bad Address Report button. The Health Promotions Bad Address Report page opens. Enter the scheduler information (see Schedule a Report in the IWeb User Guide) and click Schedule. The following criteria is used (along with other criteria) to retrieve the potential bad addresses:

Age is <= 72 months (6 years)
Valid_address is 'Y'
Address field in Patient Master contains values of Mail Returned, Need New Address, Unknown, and Information Refused by Parents

Schedule Health Promotions Mailings Summary

Displays a list of patients currently on the mailing list. To schedule this report click the Run Suspicious Birth Dates Report button. The Health Promotions Mailings Summary Report page opens. Enter the scheduler information (see Schedule a Report in the IWeb User Guide) and click Schedule.

Run the Report

To run a data quality report, first click Health Promotion > Data Quality from the menu (an Organization (IRMS) must be selected first). The Data Quality Reports page opens. Enter/select any options if needed, then click one of the report run buttons (i.e., Run Restricted Addresses Report) to run that report. If the report is successful, the total number of records found appears below the report button, along with a button to view the report. If there are no results, a message stating that fact appears below the report button. If there are errors, the total number of records found appears below the report button, along with a Make Corrections/View Report button to access and correct the errors.

View/Correct Data Quality Errors

To view and correct the data quality errors, first run the report and then click the Make Corrections/View Report button. The related patient list page opens (i.e., Suspicious Birth Dates Patient List). To view details about a patient, click the arrow button in the Select column next to their name in the patient list. To correct an error, click the related button. For example, click the Confirm DOB button to confirm that a patient's birthdate is correct on the Suspicious Birth Dates Patient List page. You may be sent to different pages depending on the type of report that was run.