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.

...

User RoleCreate Data TableData RequestData Request Manager View DetailsData Export/Generate Data file Change Request Status
ObfuscatedEnabledEnabledEnabledDisabledDisabled
AggregateEnabledEnabledEnabledDisabledDisabled
ProtectedEnabledEnabledEnabledDisabledDisabled
LDSEnabledEnabledEnabledDisabledDisabled
Manager/No LDSDisabled since no LDSDisabledEnabledEnabledEnabled
Manager/LDSEnabledEnabledEnabledEnabledEnabled
Admin/no LDSdisabled since no LDSDisabledEnabledEnabledEnabled
Admin/LDSEnabledEnabledEnabledEnabledEnabled


Database Configuration 

RPDO_TABLE_REQUEST Configuration

In order to support the  the data Table  Table design, a new table RPDO_TABLE_REQUEST is added.  The metadata in Data Table design is stored in the table when the data Table is saved.

...

Info

The default rows insert script is provided in the data install folder of the release 


QT_BREAKDOWN_PATH

QR_Breakdown_Path table has been modified to include a new column Group_id. It logs the Project_id value.

Database Updates

RPDO_TABLE_REQUEST 

...

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 ManagerVisibility/Actions

 DATA_LDS

DATA_LDS

Success

Success

Only  user-created requests

MANAGER with

DATA_LDS

DATA_LDS

Success

Success

All user-created requests

MANAGER

without DATA_LDS

MANAGER

?

??

Admin

Admin

?

??


QT_BREAKDOWN_PATH

QT_breakdown_path logs the table_instance_id value and the result_instance_id. to be associated with the ptset. query.

...

Developers Getting Started With i2b2 getstarted