Page History
...
RPDO_TABLE_REQUEST PARAMETERS | DATA TABLE Values |
---|---|
TableTABLE_RequestREQUEST_idID | auto generated incremental value, corresponding to each concept in the data table. Unique for each concept example: 1282,1283, 1284 |
TableTABLE_instanceINSTANCE_idID | unique for each Data table ( same value for all the concepts underneath) example: 17 |
TABLE_INSTANCE_NAME | Data table definition name |
USER_ID | logged in user |
GROUP_ID | project id |
SET_INDEX | auto incremented for each concept name for the table instance |
C_FACTTABLECOLUMN | |
C_TABLENAME | |
COLUMN_NAME | |
C_FULLPATH | |
C_COLUMNNAME | |
C_COLUMNDATATYPE | |
C_OPERATOR | |
C_DIMCODE | |
AGG_TYPE | |
CONSTRAIN_BY_DATE_TO | |
CONSTRAIN_BY_DATE_TO | |
CONSTRAIN_BY_DATE_FROM | |
CONSTRAIN_BY_VALUE_OPERATOR | |
CONSTRAIN_BY_VALUE_CONSTRAINT | |
CONSTRAIN_BY_VALUE_UNIT_OF_MEASURE | |
CONSTRAIN_BY_VALUE_TYPE | |
CREATE_DATE |
QT_QUERY_RESULT_TYPE
The data table definitions are logged as breakdowns in the QT_QUERY_RESULT_TYPE table. The rows are inserted dynamically when the user saves the data table definition.
...