Developers Getting Started With i2b2
Space shortcuts
Space Tools
Developers Getting Started With i2b2 getstarted

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

RPDO_TABLE_REQUEST PARAMETERSDATA 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_NAMEData table definition name
USER_IDlogged in user
GROUP_IDproject id
SET_INDEXauto 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.

...

Developers Getting Started With i2b2 getstarted