Page History
...
The Create Data Table feature allows User to design a table of variables of interest using the Design table feature. The table design can then be saved as a template that can be loaded and re- used to request data export.
...
User logs into the web client and accesses create data table for export tool under the 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 (by default) Gender, Age, Race
From the Ontology Terms tab, drag and drop additional variables of interest onto the DESIGN TABLE grid. These variables will be added as a 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 file.
Aggregation method for the variable can be applied by clicking on the drop down box in the Aggregation Method column to assign aggregate options to each variable
...
| Info |
|---|
Design and Preview is an interactive, iterative process where User tcan can add and remove variables as well as assign or edit Aggregate options |
...
- Click on Save
- The table definition can be either saved under MY TABLES or PROJECT SHARED TABLES
| Info |
|---|
MY TABLES are editable and will appear as Run Query options only for the current user PROJECT SHARED TABLES are editable and will appear as Run Query options for any user in the current i2b2 project SYSTEM SHARED TABLES is available editable only for Admins where per-defined templates but are made available as Run Query options to all i2b2 Users MY TABLES and PROJECT SHARED TABLES table definitions are editable. SYSTEM SHARED TABLE definitions are non-editable |
Load Table
Load table definition enables the User to Load a saved table definition to be used for data exportdefinition
- User clicks on Load menu option to display Load Table Definition with list of user saved definitions
- Select desired table definition and clicks on LOAD button
...
| Info |
|---|
Data file definitions from Load Table definitions can be further refined and saved for submitting data requestsaved |
Data Request - User process
...
Request 1.8.1 data exports
User can now request data for 1.8.1-style data request breakdowns (long fact-oriented tables) along with 1.8.2 requests (custom tables).
4. Select 1.8.1 data request check boxes
...
5. The table definition name with the FINISHED status is displayed as one of the breakdown items in the previous query resutlsresults.
Data Request Manager
User's Data Requests List
User-submitted data requests (both 1.8.2 and 1.8.1) are logged under the Data Request Manager tool.
...
The Data Request Manager displays data requests along with their status and details
| Info |
|---|
Only the User created data For non-managers, only the user's data requests are displayed under the Request Data Manager. |
...
