OMOP
Space shortcuts
Space Tools

Versions Compared

Key

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

 

Order of Configuration

Update crc.properties file

Configure Data Sources

Update data lookup tables

CRC Properties Configuration

In order for the CRC to know there are multiple fact tables the queryprocessor.multifacttable property in the crc.properties file needs to be updated. By default this property is set to false, however for the i2b2 on OMOP project this needs to be set to true.

Property: queryprocessor.multifacttable

ValueBehavior
falseThe CRC will continue to work as it does in the classic i2b2. Only one fact table (observation_fact) will be queried
trueThe CRC will query multiple fact tables as defined in the OMOP CDM version 5

 

Update crc.properties file

 

indent
Level1

1. Open the crc.properties file and scroll to the section called Derived/Multi fact table parameter

indent
Level1

2. Edit the queryprocessor.multifacttable property to tell the CRC to query multiple fact tables.

Panel
borderColor#ccc
bgColor#ffffff
titleBGColor#E5DFEC
borderStylesolid
titleProject Management Cell

indent
Level2

# Derived/Multi fact table parameter

indent
Level2

queryprocessor.multifacttable=true

indent
Level1

4. Save your changes and close the file.

Set up a new project

Verify service account is setup