Page History
...
| User Role | Create Data Table | Data Request | Data Request Manager View Details | Data Export/Generate Data file | Change Request Status |
|---|---|---|---|---|---|
| Obfuscated | Enabled | Enabled | Enabled | Disabled | Disabled |
| Aggregate | Enabled | Enabled | Enabled | Disabled | Disabled |
| Protected | Enabled | Enabled | Enabled | Disabled | Disabled |
| LDS | Enabled | Enabled | Enabled | Disabled | Disabled |
| Manager/No LDS | Disabled since no LDS | Disabled | Enabled | Enabled | Enabled |
| Manager/LDS | Enabled | Enabled | Enabled | Enabled | Enabled |
| Admin/no LDS | disabled since no LDS | Disabled | Enabled | Enabled | Enabled |
| Admin/LDS | Enabled | Enabled | Enabled | Enabled | Enabled |
Database changes
RPDO_TABLE_REQUEST Configuration
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.
...
There are 4 patient_dimension default concepts that that are loaded into the RPDO_TABLE_REQUEST which are required. These are: race_cd (ethnicity), reace_cd(race), age_in_years_num, sex_cd and gender
| Info |
|---|
The default row insert script is provided in the data install folder of the release |
Any other user created concepts in the data table design will be stored in the RPDO_TABLE_REQUEST. Below is the list that correspond to values in the Data Table
| RPDO_TABLE_REQUEST PARAMETERS | DATA TABLE Values |
|---|---|
| Table_Request_id | auto generated incremental value, corresponding to each concept in the data table. Unique for each concept |
| Table_instance_id | unique for each Data table, auto generated incremental value( same value for all the concepts underneath) |
...
Database
...
Updates
Data table definition details
...
Data Request definition details
QT_BREAKDOWN_PATH
QtQT_breakdown_path logs the table_instance_id value and the result_instance_id. to be associated with the ptset. query.
...
