Changes between Version 6 and Version 7 of i2b2 - UHL clinical informatics system integration PATS v1
- Timestamp:
- 03/13/13 09:00:46 (12 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
i2b2 - UHL clinical informatics system integration PATS v1
v6 v7 31 31 An invetsigation showed 56 records in which the start date was NULL. All of these records were from one record on the EPS_EPSINIVW table. This might be an error or there may be a valid reason for this. 32 32 33 The field DateOfAdmission is used as the start date for the EPS_EPSINIVW table. Alternative fields for start date on this table are date_timeOfProcedure and procedureStartTime. Both of these, however, also have records where the date is NULL. All three fields could be coalesced to reduce the risk of an error.33 The field !DateOfAdmission is used as the start date for the EPS_EPSINIVW table. Alternative fields for start date on this table are date_timeOfProcedure and procedureStartTime. Both of these, however, also have records where the date is NULL. All three fields could be coalesced to reduce the risk of an error. 34 34 35 35 '''''ACTION (RB): Ask Claire Hutton if she deals with this data set. If she does, could she check that the start date is NULL in the PATS system. If it is, is there a valid reason for this?''''' 36 36 37 '''''ACTION (RB): As per duplicate, Nick says use COALESCE( ProcedureStartTime, Date_timeOfProcedure)'''''37 '''''ACTION (RB): As per duplicate, Nick says use COALESCE(!ProcedureStartTime, Date_timeOfProcedure)''''' 38 38 39 39 == Duplicate Records … … 42 42 43 43 ||Table||No. Duplicates||Start Date Field|| 44 ||CATH_CATHINITIALVW||5|| DateOfCatheter||45 ||CS2003F_PostProcedure||1|| DateOfDischargeOrDeath||46 ||CS2010F_PostProcedure||1|| DateOfDischargeOfDeath||47 ||EPS_EPSINIVW||1|| DateOfAdmission||48 ||GGHPCI_FLWGGHPCIVIEW||169|| DateOfFollowup||49 ||GGHPCI_INITIALGGHPCIVIEW||2|| DateOfProcedureCCAD||44 ||CATH_CATHINITIALVW||5||!DateOfCatheter|| 45 ||CS2003F_PostProcedure||1||!DateOfDischargeOrDeath|| 46 ||CS2010F_PostProcedure||1||!DateOfDischargeOfDeath|| 47 ||EPS_EPSINIVW||1||!DateOfAdmission|| 48 ||GGHPCI_FLWGGHPCIVIEW||169||!DateOfFollowup|| 49 ||GGHPCI_INITIALGGHPCIVIEW||2||!DateOfProcedureCCAD|| 50 50 51 51 === Duplicate CATH_CATHINITIALVW investigation … … 61 61 a. 2 procedures. One of which has very little data. 62 62 63 DateOfDischargeOrDeath is the only relevant date against the record. However, there is a days post op field that is different for both records which could be used to calculate a date. However, this could still produce duplicates.63 !DateOfDischargeOrDeath is the only relevant date against the record. However, there is a days post op field that is different for both records which could be used to calculate a date. However, this could still produce duplicates. 64 64 65 65 === Duplicate CS2010F_PostProcedure investigation … … 76 76 a. Field 'IsThisARe_Do' is set to yes. 77 77 78 The field DateOfAdmission is used as the start date for the EPS_EPSINIVW table. Alternative fields for start date on this table are date_timeOfProcedure and procedureStartTime. Both of these, however, also have records where the date is NULL. All three fields could be coalesced to reduce the risk of an error.78 The field !DateOfAdmission is used as the start date for the EPS_EPSINIVW table. Alternative fields for start date on this table are date_timeOfProcedure and procedureStartTime. Both of these, however, also have records where the date is NULL. All three fields could be coalesced to reduce the risk of an error. 79 79 80 '''''ACTION (RB): Nick says use COALESCE( ProcedureStartTime, Date_timeOfProcedure)''''''80 '''''ACTION (RB): Nick says use COALESCE(!ProcedureStartTime, Date_timeOfProcedure)'''''' 81 81 82 82 === Duplicate GGHPCI_FLWGGHPCIVIEW investigation … … 94 94 a. More than one procedure on the same day for both duplicates. 95 95 96 DateAndTimeOfOperation seems to be unique.96 !DateAndTimeOfOperation seems to be unique. 97 97 98 '''''ACTION (RB): Check with Claire that DateAndTimeOfOperation means what it sounds like.'''''98 '''''ACTION (RB): Check with Claire that !DateAndTimeOfOperation means what it sounds like.'''''
