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.


  • No labels