Description
Lists the data problems found in an agency’s data.
Report Columns
Refer to the sub-reports.
Parameters
- Data Problem – specifies the data problems to report on. Users can select one or more data problems to report on or enter “*” for all data problems. NOTE: Please refer to the list below for the available options.
- Admission Date Range – specifies the admission date range to report on, i.e. reports cases that were admitted during this date range only.
- Include Non-Admitted Clients – indicates whether non-admitted clients, i.e. clients with no admission, should be included in the report.
Sub-reports
Data Cleaning Report – Summary:
Lists the number of cases by data problem.
Report Columns:
- Problem – The data problem description.
- No. of Cases – The number of cases, admitted in the reporting period, with the specified problem.
Data Cleaning Report – Details:
Lists the cases with the selected data problems.
Report Columns:
- Chart/File # – The client’s chart/file number.
- Firstname – The client’s first name.
- Lastname – The client’s last name.
- DATIS Key – The DATIS Key of the client.
- Adm # - The admission number of the admission that contains the data problem.
- Admission Date – The admission date of the admission that contains the data problem.
- Screen - The screen that contains the problem field.
- Description – The description of the problem.
Available Options for the Data Problems parameter:
- * All Problems
- Blank DOB.
- Blank Education in a Closed Case.
- Blank Employment in a Closed Case.
- Blank Firstname.
- Blank Hearing Impairment Code in a Closed Case.
- Blank Lastname.
- Blank Lastname at Birth.
- Blank Legal Status in a Closed Case.
- Blank Mobility/Physical Impairment Code in a Closed Case.
- Blank Non Medical IDU in a Closed Case.
- Blank or Invalid Postal Code.
- Blank or Unknown Client Type.
- Blank or Unknown County.
- Blank or Unknown Ethnicity.
- Blank or Unknown Gender.
- Blank or Unknown Preferred Language.
- Blank or Unknown Reason For Termination.
- Blank Pregnant Code in a Closed Case.
- Blank Presenting Problem Substances in a Closed Case.
- Blank Referral Source in a Closed Case.
- Blank Referred On.
- Blank Relationship Status in a Closed Case.
- Blank Treatment Mandated By in a Closed Case.
- Blank Visual Impairment Code in a Closed Case.
- Difference between Admission Date and DOB is less than 10 years.
- Difference between Admission Date and DOB is more than 100 years.
- Discharge Date is before the admission date.
- DOB is equal to or after the admission date.
- Missing PPS.
- Missing PPS Frequency.
- Substances used is none and PPS are not blank.
- Unknown Condition Surrounding Contact.
- Unknown Education.
- Unknown Employment.
- Unknown Hearing Impairment Code.
- Unknown Last Name at Birth.
- Unknown Legal Status.
- Unknown Mobility/Physical Impairment Code.
- Unknown Non Medical IDU.
- Unknown Pregnant Code.
- Unknown Presenting Problem Substances.
- Unknown PPS Frequency.
- Unknown Relationship Status.
- Unknown Visual Impairment Code.
- Unknown Referral Source Two.
- Unknown Referral Source One.