Page History
...
The patient data file specifications are configured in the database using configuration parameters in the database.
Data Export Workflow
Data Table Creation - User
...
process
...
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.
...
| Info |
|---|
The loaded table definition can be further refined and previewed before saving it for final datafile request |
Data Request - User
...
process
...
- User logs into webclient and creates and runs a query.
- In the Run Query dialog box, 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.
...
View Data Request Details
Data Export
...
-
...
Manager process
...
User-created data requests are managed by Data Request Manager tool where a manager user can view the request details and generate data files
...
Below is the list of Actions available based on the User role.
| User Role | Create Data Table | Data Request | Data Request Manager View Details | Data Export/Generate Data file |
|---|---|---|---|---|
| Obfuscated | Enabled | Enabled | Enabled | Disabled |
| Aggregate | Enabled | Enabled | Enabled | Disabled |
| Protected | Enabled | Enabled | Enabled | Disabled |
| LDS | Enabled | Enabled | Enabled | Disabled |
| Manager/No LDS | Enabled | Enabled | Enabled | Disabled |
| Manager/LDS | Enabled | Enabled | Enabled | Enabled |
| Admin/No LDS | Enabled | Enabled | Enabled | Disabled |
| Admin/ LDS | Enabled | Enabled | Enabled | Enabled |
Database changes
In order to support the data Table design, a new table RPDO_TABLE_REQUEST is added. The metadata in Data Table design is stored in the table when the data Table is saved.
...
