Changes between Version 46 and Version 47 of i2b2 Data Import PATS Mapping v1


Ignore:
Timestamp:
03/15/13 09:21:09 (12 years ago)
Author:
Richard Bramley
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • i2b2 Data Import PATS Mapping v1

    v46 v47  
    102102'''''COMMENT (RB): Which fields should be removed?'''''
    103103
    104 '''''COMMENT (RB): All date fields are ignored, but could they be converted into numeric fields.  For example, length of stay, time between stays, etc.  This may already be being done.'''''
     104'''''~~COMMENT (RB): All date fields are ignored, but could they be converted into numeric fields.  For example, length of stay, time between stays, etc.  This may already be being done.~~'''''  Nicks says that generally this information is not important for cohorting.
    105105
    106106'''''COMMENT (RB): There are quite a few denormalised fields. For example: drug1, drug2 - could these be normalised into one concept code.  Or: readmittedDate1, readmittedDate2 - could these be different encounters?  Are these already being recorded?'''''
    … …  
    111111
    112112'''''ACTION (RB): Rewrite extracting of varchar fields to check that there are any entries in the ENUM Data Dictionary for that field.  This should reduce the number of queries that need to be run in the for each and speed things up quite a bit.'''''
     113
     114== Registries
     115
     116=== MINAP
     117
     118Minap data is contained within the following tables
     119
     120* [[i2b2 - UHL clinical informatics system integration PATS GGHMINAP_GGHMINAP|GGHMINAP_GGHMINAP]]
     121* [[i2b2 - UHL clinical informatics system integration PATS GGHMINAPNEW|GGHMINAPNEW]]
     122* [[i2b2 - UHL clinical informatics system integration PATS GGHMINAPNEW_GGHMINAPINIVW|GGHMINAPNEW_GGHMINAPINIVW]]
     123* [[i2b2 - UHL clinical informatics system integration PATS LRIMINAPNEW|LRIMINAPNEW]]
     124* [[i2b2 - UHL clinical informatics system integration PATS LRIMINAPNEW_LRIMINAPNEWINITIALVW|LRIMINAPNEW_LRIMINAPNEWINITIALVW]]
     125
     126
     127
     128
    113129
    114130
    … …  
    125141=== [[i2b2 - UHL clinical informatics system integration PATS EPS_EPSINIVW|EPS_EPSINIVW]]
    126142
    127 === [[i2b2 - UHL clinical informatics system integration PATS GGHMINAP_GGHMINAP|GGHMINAP_GGHMINAP]]
    128 
    129 === [[i2b2 - UHL clinical informatics system integration PATS GGHMINAPNEW|GGHMINAPNEW]]
    130 
    131 === [[i2b2 - UHL clinical informatics system integration PATS GGHMINAPNEW_GGHMINAPINIVW|GGHMINAPNEW_GGHMINAPINIVW]]
    132143
    133144=== [[i2b2 - UHL clinical informatics system integration PATS GGHPACEICD_GGHPACEICDINIALVW|GGHPACEICD_GGHPACEICDINIALVW]]
    … …  
    136147
    137148=== [[i2b2 - UHL clinical informatics system integration PATS GGHPCI_INITIALGGHPCIVIEW|GGHPCI_INITIALGGHPCIVIEW]]
    138 
    139 === [[i2b2 - UHL clinical informatics system integration PATS LRIMINAPNEW|LRIMINAPNEW]]
    140 
    141 === [[i2b2 - UHL clinical informatics system integration PATS LRIMINAPNEW_LRIMINAPNEWINITIALVW|LRIMINAPNEW_LRIMINAPNEWINITIALVW]]
    142149
    143150=== [[i2b2 - UHL clinical informatics system integration PATS VERTED_VERTEDINIALVW|VERTED_VERTEDINIALVW]]