Changes between Version 28 and Version 29 of i2b2 Database Structure

Timestamp:

02/21/11 11:30:47 (14 years ago)

Author:

jeff.lusted

Comment:

--

i2b2 Database Structure

@@ -146 +146 @@
 || PK    || provider_id   || Practitioner id or provider id    ||           NO             ||
 || PK    || start_date    || Starting date-time of observation (mm/dd/yyyy) ||    NO       ||
-||       || modifier_cd   || Code for modifier of interest (i.e. “ROUTE”,” DOSE”), note that value columns are often used to hold the amounts such as “100” (mg) or “PO” ||  YES  ||
+||       || modifier_cd   || Code for modifier of interest (i.e. “ROUTE”,” DOSE”)[[BR]]note that value columns are often used to hold the amounts such as “100” (mg) or “PO”                             ||  YES  ||
+||       || instance_num  || Encoded instance number that allows more that one modifier to be provided for each concept_cd.[[BR]]Each row will have a different modifier_cd but a similar instance_num.       ||  YES  ||
+||       || valType_cd    || Format of the concept[[BR]] N = Numeric[[BR]] T = Text (enums/short messages)[[BR]] B = Raw Text (notes/reports)[[BR]] NLP = NLP result text                                   ||       ||
+||       || tval_char     || Used in conjunction with valType_cd = “T” or “N”... [[BR]] When valtType_cd = “T”: Stores the text value [[BR]] When valType_cd = “N”: [[BR]] E = Equals [[BR]] NE = Not equal [[BR]] L = Less Than [[BR]] LE = Less than and Equal to [[BR]] G = Greater Than [[BR]] GE = Greater than and Equal to                                 ||       ||
+||       || nval_num      || Used in conjunction with valType_cd = “N” to store a numerical value ||      ||  
+||       || valueFlag_cd  || Used in conjunction with valType_cd = “B”, “NLP”, “N”, or “T”... [[BR]] When valType_cd = “B” or “NLP” it is used to indicate whether or not the blob field is encrypted [[BR]] ( X = Encrypted text in blob field ) [[BR]] When valType_cd = “N” or “T” it is used to flag certain outlying or abnormal values [[BR]]( H = High, L = Low, A = Abnormal ) ||       ||
+||       || quantity_num  || Quantity of nval                  ||       ||
+||       || units_cd      || Units of measurement of nval      ||       ||
+||       || end_date      || The end date-time for the observation ||   ||
+||       || location_cd   || A location code, such as for a clinic ||   ||
+||       || confidence_num || Assessment of accuracy of data   ||       ||
+||       || observation_blob || Holds any raw or miscellaneous data that exists, often encrypted PHI  ||    ||
+