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 example: 1282,1283, 1284 |
| TABLE_INSTANCE_ID | unique for each Data table ( same value for all the concepts underneath) example: 17 |
| TABLE_INSTANCE_NAME | Data table definition name |
| USER_ID | data request user |
| GROUP_ID | project id |
| SET_INDEX | auto incremented for each concept row for the table instance |
| C_FACTTABLECOLUMN | "concept_cd" for the fact table or "patient_num" for the patient_dimension |
| C_TABLENAME | corresponds to table storing concept_cd/patient_num( concept_dimension or patient_dimension ) |
| COLUMN_NAME | The column name of the data table definition |
| C_FULLPATH | corresponds to the concept's c_fullname in the ontology table |
| C_COLUMNNAME | usually "concept_path" for concept_dimension |
| C_COLUMNDATATYPE | corresponds to ontology table column value |
| C_OPERATOR | corresponds to ontology table column value |
| C_DIMCODE | corresponds to ontology table column value |
| AGG_TYPE | corresponds to Aggregate option selection in data table definition |
| CONSTRAIN_BY_DATE_TO | corresponds to date constraint option selection in data table definition |
| CONSTRAIN_BY_DATE_TO | corresponds to date constraint option selection in data table definition |
| CONSTRAIN_BY_DATE_FROM | corresponds to date constraint option selection in data table definition |
| CONSTRAIN_BY_VALUE_OPERATOR | corresponds to set value constraint selection in data table definition |
| CONSTRAIN_BY_VALUE_CONSTRAINT | corresponds to set value constraint selection in data table definition |
| CONSTRAIN_BY_VALUE_UNIT_OF_MEASURE | corresponds to set value constraint selection in data table definition |
| CONSTRAIN_BY_VALUE_TYPE | corresponds to set value constraint selection in data table definition |
| CREATE_DATE | corresponds data table definition creation date |
| SHARED | Y (for project and system shared table definitions); N (User table definition) |
| DELETE_FLAG | Y (if deleted) or N |
| C_VISUALATTRIBUTES | values are LA or LH (based on visibility table definitions in the panel) |
| REQUIREDNA? | Y for default variables ( race, age, sex); N for other variables |
| JASON_DATA | logs the table definition variables details needed for the execution of the stored procedure to create the data file |
| GENERATED_SQL | logs the SQL query that is generated by stored procedure call for each variable |
| DELETE_DATE | date of table definition deletion |
| CREATE_DATE | date of table definition creation |
| USE_AS_COHORTNA | N by default; not used currently |
Example:
QT_QUERY_RESULT_TYPE
...
