Page History
...
| 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) example: 78 |
QT_QUERY_RESULT_TYPE
The data table definitions are logged as breakdowns in the QT_QUERY_RESULT_TYPE table. The values are populated dynamically when the user saves the data table definition.
Following values are stored
RESULT_TYPE_ID: <TABLE_INSTANCE_ID>NAME: Auto generated number
NAME: RPDO_<<TABLE_<n>INSTANCE_ID>>
VISUAL_ATTRIBUTE_TYPE_ID is set to LU
...
- The Table_instance_id is logged in the Name column when the user saves the table_definition.
- The Value column logs the EXEC statement of the stored procedure that generates the data file. The result_instance_id variable gets updated with the the numeric value from the QueryQUERY_resultRESULT_instance INSTANCE where ptset the Ptset query result_type_id =1 at the time of creation of Data file.
...
