Page History
...
The DESIGN TABLE panel allows User to create a data table with list of variables of interest.
User logs into the webclient web client 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
...
User clicks on Preview Table to verify the variables added are displayed displayed in the data columns in the format desired.
...
| Info |
|---|
Design and Preview is an iterative process where User to add and remove variables and as well as to assign or edit Aggregate Methodoptions |
Save Table
- User clicks on Save Table
...
Saved table definition enables the User to Load Load a saved table definition to be used for data export
...
Data Request - User process
- User logs into webclient web client and creates and runs a query.
- In the Run Query dialog box, User created table definitions are displayed under Data Request(s) section
- Select select one or more User created Data table definition Request checkboxes and click run query
- Emails are automatically sent - one to the requester's e-mail, to inform them the request has been made; and one to the specified manager user to inform them to run the user's export request. The query name (in previous queries) is tagged with the query master id, so it can be identified by the manager.
Data Request Manager
View Data Request Details
...
