Search

Help

Page 7 of 76. Showing 757 results (0.009 seconds)

  1. 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_FACT
    Health Ontology Mapper / … / HOM HomeDec 20, 2010
  2. OntoMapper 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 screen
    Health Ontology Mapper / … / HOM HomeDec 20, 2010
  3. Panel 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 fact
  4. Use 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 statements
  5. Release 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 "turn
    OMOPMay 24, 2017
  6. C_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.
    Server (Cells) DesignSep 04, 2018
  7. 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 file
    OMOPApr 05, 2017
  8. QT_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) PK
  9. i2b2-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 table
  10. ONTRESP.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