Page History
...
The Create Data Table feature allows User to design a table of variables of interest using the Design table feature. The table can then be saved as a template that can be loaded and re-used to request data export.
Design Table
The DESIGN TABLE panel allows User to create a data table with list of variables of interest.
User logs into the webclient and accesses Data Export tool under the Analysis Tools plugin
The design table panel displays list of predefined variables that will be included by default in the data export file. These predefined variables are Gender, Age, Race, and Ethnicity
From the Ontology Terms tab, drag and drop additional variables of interest onto the DESIGN TABLE grid. These variables will be added to the list of variables included in the data export. The predefined variables are locked and cannot be unchecked since they are required for every data table. Other variables can be deleted under Actions column to exclude them from the data set file.
Aggregation method for the variable can be applied by clicking on the Value in the Aggregation Method column to assign aggregate options to each variable
AVAILABLE AGGREGATE OPTIONS
The availability of aggregation options depends on the type of concept it aggregates on.
...
Aggregation Options | Explanation |
Existence (Yes/No) | Whether the patient has an observation of this concept. This is the default option. |
Count: Number of Concepts | Total number of concepts |
Count: Number of Dates | Total number of dates for the participant |
Count: Number of Encounters | Total number of encounters for the participant |
Count: Number of Facts | Total number of observations |
Count: Number of Providers | Total number of providers for the participant |
Date (First) | Date of earliest observation |
Date (Most Recent) | Date of the most recent observation |
Count | Total number of observations |
All Concepts (Names/Text) | All concept names are listed |
Most Frequent Concept (Names/Text) | Most frequent concept name |
All Concepts (Codes) | All concept codes are listed |
Most Frequent Concept (Codes) | Most frequent concept code |
Minimum Value | Minimum value of all numeric values observations |
Maximum Value | Maximum value of all numeric values observations |
Median Value | Median value of all numeric values observations |
Average Value | Average value of all numeric values observations |
Mode (Most Frequent Value) | Most frequent value for numeric, enum, blob observations |
List of All Values | List of all values for numeric, enum, blob observations |
Preview and Save
...
Table
Table Design can be previewed to get a preview of the data export file that will be generated.
...
| Info |
|---|
DESIGN AND PREVIEW is an iterative process where you can add and remove variables. Then assign an Aggregate Method in the DESIGN TABLE tab to the newly added varibles. |
Load Table
Data Export - Request Data Export (User process)
...
