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.

...

The data requests are configured as breakdowns in the QT_QUERY_RESULT_TYPE table. The values are populated dynamically when the user run user  saves the data request querytable definition.

Following values are stored when the query is run.

RESULT_TYPE_ID: <TABLE_INSTANCE_ID>

NAME: Auto generated number: RPDO_<n>

VISUAL_ATTRIBUTE_TYPE_ID is set to LU 

USER_ROLE_CD is set to DATA_LDS /NULL?

DISPLAY_TYPE_ID: CATNUM

CLASSNAME: 

Example:

RESULT_TYPE_IDNAMEDESCRIPTIONDISPLAYTYPE_IDVISUAL_ATTRIBUTE_TYPE_IDUSER_ROLE_CDCLASSNAME
<TABLE_INSTANCE_ID>RPDO_78User-created Demographics Data RequestCATNUMLUDATA_LDSedu.harvard.i2b2.crc.dao.setfinder.QueryResultPatientRequest


Info

We recommend data requests be limited to DATA_LDS users (irrespective of Admin path role - admin, user, manager) and data exports be limited to MANAGER users (irrespective of data path role - data_lds, data_agg,data_obf, data_deid). The user role determines if exports/requests are visible and runnable. 

 QT_QUERY_RESULT_TYPEuser roleUser-created data requestdata Request Manager

 DATA_LDS

DATA_LDS

Success

non-display

MANAGER with

DATA_LDS

DATA_LDS

Success

Success

MANAGER

without DATA_LDS

MANAGER

non-display

non-display


...

Developers Getting Started With i2b2 getstarted