...

The patient data export types, request options, and file specifications are configured in the database using specific request type entries and configuration parameters in the database.

Data Export Workflow

Image RemovedImage Added

Data Request (User Process)

1. User logs into webclient and creates and runs a query.

...

2. In the Run Query dialog box, select one or more Data Request checkboxes
   Image Added
3. An email is automatically sent to specified manager user to run the user's export request, and the previous query name is tagged with the query master id.

Image Removed

Data Export (Manager Process)

Image Removed

1. The manager logs into the webclient and finds the query from their e-mail by locating the query master id, which is now part of the title of the previous query.

2. Manager user then re-runs the previous query and clicks on export.  The export option is displayed selected in the Data export breakdown list.

   

3. Data export runs in the background and file is generated in a specified folder 

4. Manger user manually sends a confirmation email to the user on the file generation and retrieval info.

...

Currently QT_BREAKDOWN_PATH .value column has datatype of varchar(2000). Inorder In order to support the XML  structure needed for the Data Exporter, the value column has been modified to CLOB datatype. 

...