Page 25 of 28. Showing 277 results (0.008 seconds)
3. Table and Field Definitions and Descriptions
https://community.i2b2.org/wiki/display/ServerSideDesign/MODIFIER_DIMENSION+Table The relationships between these dimension tables and the fact table are described3. Query Tool
The items (facts) can occur at any time in the patient's history. Patient has a medication with a dose greater than 500 mg and a medication that is taken once a day documented at any time in their history. Same Financial Encounter The items (facts) occur during the same visit (financial encounter). WhenABSTRACT-
in the fact and dimension tables. DATA_DEID DEID = De-identified Data The user can see all fields including those that are encrypted. An example of an encrypted field is the blob fields in the fact and dimension tables. DATA_PROT PROT = Protected The user can see all data, includingONTQRY.xsd
representation of the term. <metadataxml> Additional xml that may be associated with the term (optional). <facttablecolumn> The observation fact … with the term (optional). <facttablecolumn> The observation fact table column associated with the term. <tablename> The dimension table associatedText search in i2b2
. For the row of the fact table whose observation_blob field contains the text, perhaps a vist note or a radiology report, the letter "B" is placed in the ValueType352. Editing
to a new i2b2 project, the patient facts in the observation_fact table will be enriched by corresponding dates from the source data. IMT editor dates.png Merging345. Import Standardterminologies
combine the two data elements into one and modify facts referencing the concepts accordingly (schema and data mapping). The result is easier to query and easierDEFINITION OF TERMS
of observations represented by this fact. units_cd A textual description of the units associated with a value. end_date The dateAUG Email 2011-Dec
, the age is computed from the patient_dim as you see below. In 1.4 this was done by placing a static 'fact' into the obs_fact table. In this case it doesnt matter when you run the query, the patient is always listed as a 10 year old (unless the record is modified and updated). If you want to run age facts the same way youAUG Email 2011-Apr
. I see sga_target=2449473536 in one of the relevant config files. of facts: ~0.5B (~3 years of data on ~300K patients, with demographics on ~1M patients … suggest more RAM would be beneficial of facts: ~300 million (10 years of data on ~500,000 members) of users/usage: light enough that we don't worry much