Changes between Version 4 and Version 5 of i2b2 - UHL clinical informatics system integration PATS v1
- Timestamp:
- 03/12/13 13:48:58 (11 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
i2b2 - UHL clinical informatics system integration PATS v1
v4 v5 33 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 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 ACTION (RB): As per duplicate, Nick says use COALESCE(ProcedureStartTime, Date_timeOfProcedure) 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 37 '''ACTION (RB): As per duplicate, Nick says use COALESCE(ProcedureStartTime, Date_timeOfProcedure)''' 37 38 38 39 == Duplicate Records … … 66 67 Same reason and patient as for CS2003F_PostProcedure. 67 68 68 ACTION (RB): Why is the data for this procedure in both CS2003 and CS2010? It was thought that this data was split chronologically between these two tables. I.e, 2003-2010 in CS2003, 2010- in CS2010. 69 ACTION (RB): Is there any way to get the true date of procedure? Ask Claire if she knows? 69 '''ACTION (RB): Why is the data for this procedure in both CS2003 and CS2010? It was thought that this data was split chronologically between these two tables. I.e, 2003-2010 in CS2003, 2010- in CS2010.''' 70 71 '''ACTION (RB): Is there any way to get the true date of procedure? Ask Claire if she knows?''' 70 72 71 73 === Duplicate EPS_EPSINIVW investication … … 76 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. 77 79 78 ACTION (RB): Nick says use COALESCE(ProcedureStartTime, Date_timeOfProcedure) 80 '''ACTION (RB): Nick says use COALESCE(ProcedureStartTime, Date_timeOfProcedure)'''' 79 81 80 82 === Duplicate GGHPCI_FLWGGHPCIVIEW investigation … … 86 88 The dates look like they might be from an import, so this might explain it? 87 89 88 ACTION (RB): Check with Claire what is being monitored in this table. If nothing important, Nick is inclined to stop importing it. 90 '''ACTION (RB): Check with Claire what is being monitored in this table. If nothing important, Nick is inclined to stop importing it.''' 89 91 90 92 === Duplicate GGHPCI_INITIALGGHPCIVIEW investigation … … 94 96 DateAndTimeOfOperation seems to be unique. 95 97 96 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.'''
