Page History
...
Configuring Database Parameters
...
Data table definition details
QT_QUERY_RESULT_TYPE
The data requests table definitions are configured as breakdowns in the QT_QUERY_RESULT_TYPE table. The values are populated dynamically when the user saves the data table definition.
...
Info | |||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
We recommend data requests be limited to DATA_LDS users (irrespective of Admin path role - admin, user, manager) and data exports be limited to MANAGER users (irrespective of data path role - data_lds, data_agg,data_obf, data_deid). The user role determines if exports/requests are visible and runnable.
|
Data Request definition details
...
QT_BREAKDOWN_PATH defines the table definition value and the result_instance_id. to be associated with the ptset. query.
...