Page 21 of 28. Showing 277 results (0.007 seconds)
Algorithm Outline
binary variables by determining which patients have facts of the required types during the measure period, using a site-configurable table of ontology paths (i.e … + Medications At least two routine care fact types (bold-faced) N/A 2+ Routine Care Facts Body Mass Index measurement I BMI4. Tutorials: Using the i2b2 CDM
common use cases, and progress to more advanced concepts. 4.1 Diagnoses and Demographics (Basic Facts) Below are examples of basic facts in the i2b2 CDM … and Allergies (Modifiers) A single observation can be represented in the i2b2 CDM as a fact with an unlimited number of modifier codes. A medication710. Best Practices for Performance Optimization
Summary The simple, generic database schema used by i2b2 has very much contributed to its success, as it simplifies the loading of data and does not require changes to its table structure when new data elements are added. However, with large datasets, the placement of all fact data in a single table canNext Steps
After completing the installation of the CRC, Ontology, and Workplace tables, the next step is to configure the i2b2 software to query multiple fact tablesPatient Set Query Request and Response Object Model
Data From Observation Fact x xUse Case_ Run a query from Panel Definition
Validate the user by calling the Project Management cell. Select a data mart based on the combination of domain_id, project_id, and user_id. Call the Ontology cell with the item key and determine the dimension table to join with the fact table. Save the query panel definition and the generated SQL statementsAUG Email 2011-Jan
dimension as a "fact grouper", the 1.6 UI would allow the end user to remove the false positives by using the "same visit" in each column- am I correct? Sounds like … for this patient. In 1.6 the use of modifiers should be able to take care of this use case. You could use the visit dimension as a "fact grouper" as welli2b2-on-OMOP With ENACT-OMOP Ontology v4.1
i2b2 is configured for multiple fact tables by changing the appropriate entry in the database. 3.11 Multiple Fact Tables Be sure to drop/rename347. Import from Biomaterial Bank
in order to integrate with the other components of the IDRT toolkit. The driver creates CSV files for the full ontology and fact data generated from the source … and preparation of ontology and fact CSV files. Extraction All required raw data tables are copied from the source system into a staging area. Read-accessExample of Value Constraints Used in Queries
Value Constraint by Number If the fact with a numerical value didn't have the normalized numerical value with a single UNIT_CD for a particular concept … performance load, the numerical fact values in the in the normalized units and do not enable this option. Greater than operator