Transcript Slide 1
Data Quality Issues - Multiple Open Episodes and Overlapping Episodes • An episode of treatment is defined from the Referral Date through to the Discharge Date. • A client should only have one open episode of treatment at any given time at one agency. • Episodes of treatment within an agency should not overlap. • Multiple open and overlapping episodes are usually created by the Referral Date being changed. South West Public Health Observatory Multiple Open Episodes AGNCY ATTRIB CLIENT REF FINITIAL SINITIAL DOB SEX REFLD SC**** BB02021970M BB020270M B B 1970/02/02 M 2009/03/30 SC**** BB02021970M BB020270M B B 1970/02/02 M 2009/01/30 DISD Referral Date: 30/03/2009 Referral Date: 30/01/2009 South West Public Health Observatory DISRSN Overlapping Episodes - example 1 AGNCY SC**** FINITIAL A SINITIAL A DOB 1960/01/01 M SEX REFLD DISD 2007/06/20 2007/06/30 REFLD1 DISD1 2007/06/25 2007/06/30 South West Public Health Observatory Overlapping Episodes – example 2 The episodes are valid but the discharge date needs to be updated AGNCY SC*** FINITIAL B SINITIAL B DOB 1967/02/02 M SEX REFLD DISD 2008/01/01 2008/01/30 REFLD1 DISD1 2008/01/26 2008/04/16 South West Public Health Observatory Overlapping Episodes – example 3 The episodes are valid but the referral date needs to be updated AGNCY SC**** FINITIAL C SINITIAL C DOB 1980/03/03 M SEX REFLD DISD 2008/07/01 2008/08/31 REFLD1 2008/08/22 South West Public Health Observatory DISD1 Data Quality Issues Multiple Open and Overlapping Modalities • A modality is defined from the date referred to modality through to the modality end date. • A client must not have an identical modality type open at the same time at any given time at one agency. • Multiple open and Overlapping Modalities are usually created by changing the referred to modality date. South West Public Health Observatory Multiple Open Modalities Attributers Agency Code Referral Date AA01011980M **** 01/01/200 7 Discharge Modalit Date y Code Modality Type: 3 (GP Prescribing ) Modality Type: 3 (GP Prescribing ) 3 Modality Referral Date Modality Start Date 01/03/2007 01/04/200 7 Modality Referral Date: 01/03/2007 Modality 1 Referral Date: 01/02/2007 Modality End Date Modality 1 Modality Referral 1 Code Date Modality1 Start Date 01/02/200 7 03/03/200 7 3 Modality Start Date : 01/04/2007 Modality Start Date : 03/03/2007 South West Public Health Observatory Modality1 End Date Overlapping Modalities – example 1 Attributers First Name Initial Last Name Initial Birth Date Sex code Agency Code Episode Referral Date Episode Discharge Date Modality 1 Code Modality 1 Referral Date Modality 1 Start Date AA01011980M A A 01-Jan-80 M ***** 01-Jan-08 01-Apr-09 3 01-Jan-08 05-Jan-08 Modality 2 Code Modality 2 Referral Date Modality 2 Start Date Modality 2 End Date 3 11-Mar-09 18-Mar-09 31-Mar-09 South West Public Health Observatory Modality 1 End Date Overlapping Modalities – example 2 Attributers First Name Initial Last Name Initial BB01011960F B B Birth Date 01-Jan60 Sex code Agency Code Episode Referral Date F ***** 06-Jun-07 Episode Discharge Date Modality 1 Code Modality 1 Referral Date Modality 1 Start Date Modality 1 End Date 2 18-Jun-10 26-Jun-10 05-Jul-10 Modality 2 Code Modality 2 Referral Date Modality 2 Start Date Modality 2 End Date 2 27-Jun-10 28-Jun-10 05-Jul-10 South West Public Health Observatory