Uploaded image for project: 'i2b2 Core Software'
  1. i2b2 Core Software
  2. CORE-265

OMOP Data Views: Need to add a view for the Provider table

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.7.09-RC1
    • Fix Version/s: 1.7.09
    • Component/s: Data
    • Labels:
      None
    • Rank:
      0|i003f3:
    • Affects Database/s:
      All databases
    • Developer Notes:
      Hide
      script to create provider_dimension added.
      Modifier_dim also added for possible future use.
      Show
      script to create provider_dimension added. Modifier_dim also added for possible future use.
    • Testing Notes:
      provider_dimension table has been added to the scripts and everything appears to be working correctly.

      Description

      Currently, the timeline is generating an error and this is because it is looking for the provider_dimension table. This table is part of the standard i2b2, the OMOP CDM has its own provider table. For i2b2 on OMOP a provider view needs to be created so any plugins like the timeline will not generate errors looking for the i2b2 provider_dimension table.

      This view needs to be created for Oracle, PostgreSQL, and SQLServer databases.

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Git Source Code