Changes between Version 27 and Version 28 of i2b2 Database Structure

Timestamp:

02/21/11 10:56:41 (15 years ago)

Author:

jeff.lusted

Comment:

--

i2b2 Database Structure

@@ -140 +140 @@
 Columns UPDATE_DATE, DOWNLOAD_DATE, IMPORT_DATE, SOURCESYSTEM_CD and UPLOAD_ID are administrative/info columns only. Ignore these. 
 
-||= Key  =||= Column Name =||= Column Definition               =||= Nullable (default=YES) =||
-|| PK     || encounter_num || Encoded i2b2 patient visit number ||           NO             ||
-||        || patient_num   || Encoded i2b2 patient number       ||           NO             ||
-|| PK     || concept_cd    || Code for observation of interest  ||           NO             ||
-|| PK     || provider_id   || Practitioner id or provider id    ||           NO             ||
-|| PK     || start_date    || Starting date-time of observation (mm/dd/yyyy) ||    NO       ||
+||= Key =||= Column Name =||= Column Definition               =||= Nullable (default=YES) =||
+|| PK    || encounter_num || Encoded i2b2 patient visit number ||           NO             ||
+||       || patient_num   || Encoded i2b2 patient number       ||           NO             ||
+|| PK    || concept_cd    || Code for observation of interest  ||           NO             ||
+|| 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  ||