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

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.7.09-RC1
    • 1.7.09
    • Data
    • None
    • All databases
    • 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.
    • 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

          Ascending order - Click to sort in descending order
          lcp5 Lori Phillips added a comment -
          Create table statement added for PROVDER_DIMENSION. I also added MODIFIER_DIMENSION for possible future use.
          lcp5 Lori Phillips added a comment - Create table statement added for PROVDER_DIMENSION. I also added MODIFIER_DIMENSION for possible future use.
          jmd86 Janice Donahoe added a comment -
          This issue has been fixed and will be included in release 1.7.09.
          jmd86 Janice Donahoe added a comment - This issue has been fixed and will be included in release 1.7.09.

          People

            jmd86 Janice Donahoe
            jmd86 Janice Donahoe
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: