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 or LH (based on visibility table definitions panel) |
| REQUIRED | |
| GENERATED_SQL | |
| DELETE_DATE | |
| CREATE_DATE | |
| USE_AS_COHORT |
...
Stores the parameters for the data Manager email, address, Subject line and email details for the User and data Manager
Software Changes:
- Data: New entries Entries in RPDO_TABLE_REQUEST, HIVE_CELL_PARAMS, PM_PROJECT_PARAMS, QT_QUERY_RESULT_TYPE, and QT_BREAKDOWN_PATH, QT_XML_RESULT define the data exporter configurationfunctionality.
- Java code: New breakdown classes and updates to existing java classes to support the data exporter functionality.
...
