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 i2b2 User to create a data table definition with list of variables of interest.
...
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 | Date of earliest observation |
Date: Last Date | Date of the most recent observation |
Calc: First Value | Minimum value of all numeric values observations |
Calc: Last Value | Maximum value of all numeric values observations |
Preview TableTable
Table Design can be previewed to get a preview of the data export file that will be generated.
User clicks on Preview Table PREVIEW TABLE to verify the variables added are displayed in the data columns in the format desired.
...
| Info |
|---|
Design and Preview is an iterative process where User to tcan add and remove variables as well as to assign or edit Aggregate options |
Save Table
- Click on Save Table.
- The table definiton can be either saved under My Tables or Project Shared Tables
...
