Page 45 of 55. Showing 548 results (0.011 seconds)
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.Storing Group Templates
By using the mouse, users can drag group templates from the locations listed below into their workplace. Query Tool Panel (Group label) worddav19cbfe8cafb6557fa2ae7208981b4b9e.pngONT_QRY.xsd
Describes the request message body for all the operations described in section 3 of this document; a query for retrieving information from rows in the metadata tables.Observation Fact
Any observation made on a patient can be stored as fact information in the CRC data mart. The user can fetch the fact information via the PDO queries.C_COLUMNNAME
The _C_COLUMNNAME_ is the name of the field in the C_TABLENAME that holds the dimension code we are querying for. Typical entries might be CONCEPT_PATH, BIRTH_DATE, INCOME_CD, INOUT_CD, LENGTH_OF_STAY, or PROVIDER_PATH.Volumes
Estimated new setfinder query: 100 a day, with peaks in the morning Average Patientset size 100,00 CRC registered individual user: about 150WORK_QRY.xsd
Describes the request message body for all the operations described in section 3 of this document; a query for retrieving information from rows in the workplace tables.C_DIMCODE
The _C_DIMCODE_ is the actual value of the dimension table C_COLUMNNAME that we are querying for. Typical entries are an actual: CONCEPT_PATH like (\Diagnoses\Circulatory system) BIRTH_DATE range ('getdate() - 365.25(10)' INOUT_CD like ('I') PROVIDER_PATH like (\Providers\Emergency)Exporting Nodes
By using the mouse, users can store XML Results such as patient count from Previous Queries. Right click on the node and select Export then specify a name for the XML file.S4: Distributed Computing, TranSMART, & Big Data
Herrick and Lori Phillips Information Commons i2b2 Cell: The Canonical Software Module Distributed Queries: Central and Remote Hives Presentation 4: Developing Specialized Hives to Contribute to the i2b2 Ecosystem Presenters: Shawn Murphy and Mike Mendis Distributed Query System links