Page 7 of 76. Showing 757 results (0.009 seconds)
Mapper_Schema_Design_v1.1 (2).doc
/20081.0Initial versionPrakash Lakshminarayanan07/16/20081.1Incorporated changes pertaining to Map data fact tablePrakash Lakshminarayanan … the source data and also to keep the i2b2 fact table (OBSERVATION_FACT) design intact. Mapper functionality required several design changes on the OBSERVATION_FACTOntoMapper Minutes 8 19 08.doc
Ontology Mapper Minutes 8/29/08 Present on call: Hillari, Prakash, Marco, Davera, Maggie and Mark We walked through the schema design for OntoMapper and the choices we made regarding the Mapped Data Fact Table design. We walked through the new UI screen designs. We are really trying to get every little screenPanel Definition Details
in the fact table. | panel_number A serial number starting with 1. panel_date_from Apply the observation fact's start date … > constrain_by_modifier Apply modifier constraint for the item. The MODIFIER_CD column in the fact table is used to apply this constraint to the factUse 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 statementsRelease 1.7.09-RC1
project includes the following features: Ability to query multiple fact tables as specified by the CDM. This is a departure from the standard i2b2 star schema where you can only query one fact table (observation_fact). A new parameter has been added to the crc.properties file. This parameter will "turnC_FACTTABLECOLUMN
The _C_FACTTABLECOLUMN_ is the name of a key in the fact table (OBSERVATION_FACT) that links to the dimension code we are querying for. Typical entries will be CONCEPT_CD, PATIENT_NUM, ENCOUNTER_NUM, or PROVIDER_ID.Next 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 tables … https://community.i2b2.org/wiki/download/attachments/6684832/checkbox_checked.png i2b2 hivedata and pmdata tables were installed and loaded with the data provided in the standard i2b2 data fileQT_PRIVILEGE
This table holds the minimum user role required in CRC operation like whether to obfuscate the result or whether the user has access to blob field in the fact table, etc. QT_PRIVILEGE Key Column Name Column Definition Nullable? (Default = YES) PKi2b2-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/rename … Design Utilizing i2b2's reusable application programming interface (API), the OMOP data model is now supported. The ENACT-OMOP ontology queries OMOP tableONTRESP.xsd
representation of the term. <metadataxml> Additional xml that may be associated with the term (optional). <facttablecolumn> The observation fact table … . <metadataxml> Additional xml that may be associated with the modifier (optional). <facttablecolumn> The observation fact table column associated