Changes between Version 3 and Version 4 of i2b2 Data Import PATS Mapping v1


Ignore:
Timestamp:
03/14/13 09:12:27 (11 years ago)
Author:
Richard Bramley
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • i2b2 Data Import PATS Mapping v1

    v3 v4  
    1313||Provider_Id||"@"||
    1414||Start_Date||The source table observation date field (see below)||
     15||Modifier_Cd||"@"||
     16||ValType_Cd||"T"||
     17||Units_Cd||"@"||
     18||Location_Cd||"@"||
     19||Update_Date||The current date using the GETDATE() Function||
     20||SourceSystem_Cd||"BRICCS"||
     21||Upload_Id||"1"||
     22
     23'''''SOMETIME (RB): Convert Update_Date to use a date parameter.  It's just a little quicker.'''''
     24
     25'''''SOMETIME (RB): Should the SourceSystem_Cd not be "PATS"?'''''
     26
     27'''''SOMETIME (RB): The Upload_Id is presumably always one because everything is reloaded each time.  Might be nice to change this to something more meaningful.'''''
    1528
    1629=== Enum Lookup Value