i2b2TM

i2b2/tranSMART Resource Interface

Introduction

Installation

1. Download the latest version of the ExAC setup.sql script which can be found here.

2. Edit the following script parameters:

• {{transmartresourcename}} - The name of i2b2/tranSMART Service (e.g. Local i2b2/TM)
• {{transmartresourceurl}} - The URL of the i2b2/tranSMART service (e.g. http://localhost)
• {{i2b2resourceurl}} - The URL of the i2b2 service that tranSMART uses
• {{i2b2domain}} - The domain of the i2b2 user
• {{i2b2username}} - The username of i2b2 user
• {{i2b2password}} - The password of the i2b2 user
• {{auth0clientid.msg}} - The Auth0 Client Id
• {{auth0domain.msg}} - The Auth0 Domain

3. Run the sql script against the IRCT DB.
4. Restart the IRCT

Where Clauses (Predicates)

- Contains

• Display Name: Contains
• Name: CONTAINS
• Description: Contains value

Fields

Name	Path	Description	Required	Types	Supported Values
By Encounter	ENCOUNTER	By Encounter	True	NA	YES, NO

- Constrain By Modifier

• Display Name: Constrain By Modifier
• Name: CONSTRAIN_MODIFIER
• Description: Constrain By Modifier

Fields

Name	Path	Description	Required	Types	Supported Values
Constrain Modifier	MODIFIER_KEY	Constrain by a modifier of this entity	True	MODIFIER	NA
By Encounter	ENCOUNTER	By Encounter	True	NA	YES, NO

- Constrain By Value

• Display Name: Constrain By Value
• Name: CONSTRAIN_VALUE
• Description: Constrain By Value

Fields

Name	Path	Description	Required	Types	Supported Values
Operator	OPERATOR	Operator	True	NA	EQ, NE, GT, GE, LT, LE, BETWEEN, LIKE(exact), LIKE(begin), LIKE(end), LIKE(contains)
Constraint	CONSTRAINT	Constraint	True	String, Integer, Float	NA
Unit of Measure	UNIT_OF_MEASURE	Unit of Measure	False	String	NA
By Encounter	ENCOUNTER	By Encounter	True	NA	YES, NO

- Constrain By Date

• Display Name: Constrain By Date
• Name: CONSTRAIN_DATE
• Description: Constrain By Date

Fields

Name	Path	Description	Required	Types	Supported Values
From Inclusive	FROM_INCLUSIVE	Inclusive From Date	True	NA	YES, NO
From Time	FROM_TIME	From Date Start or End	True	NA	START_DATE, END_DATE
From Date	FROM_DATE	From Date	True	Date	NA
To Inclusive	TO_INCLUSIVE	Inclusive Tp Date	True	NA	YES, NO
To Time	TO_TIME	To Date Start or End	True	NA	START_DATE, END_DATE
To Date	TO_DATE	To Date	True	Date	NA
By Encounter	ENCOUNTER	By Encounter	True	NA	YES, NO

Select Fields

Name	Path	Description	Required	Types	Supported Values
Compact	COMPACT	Compact the wildcard columns down to the parent level	False	NA	TRUE, FALSE
Remove Prepend	REMOVEPREPEND	Removes the prepend of the column names	False	NA	TRUE, FALSE