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
          jmd86 Janice Donahoe created issue -
          jmd86 Janice Donahoe made changes -
          Field Original Value New Value
          Assignee Lori Phillips [ lcp5 ]
          jmd86 Janice Donahoe made changes -
          Fix Version/s 1.7.09 [ 10306 ]
          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.
          lcp5 Lori Phillips made changes -
          Status New [ 10000 ] Open [ 1 ]
          lcp5 Lori Phillips made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          lcp5 Lori Phillips made changes -
          Developer Notes script to create provider_dimension added.
          Modifier_dim also added for possible future use.
          Assignee Lori Phillips [ lcp5 ] Janice Donahoe [ jmd86 ]
          Status In Progress [ 3 ] Ready to Test [ 10001 ]
          jmd86 Janice Donahoe made changes -
          Status Ready to Test [ 10001 ] Testing [ 10002 ]
          jmd86 Janice Donahoe made changes -
          Testing Notes provider_dimension table has been added to the scripts and everything appears to be working correctly.
          Status Testing [ 10002 ] Testing [ 10002 ]
          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.
          jmd86 Janice Donahoe made changes -
          Resolution Fixed [ 1 ]
          Status Testing [ 10002 ] Resolved [ 5 ]
          jmd86 Janice Donahoe made changes -
          Status Resolved [ 5 ] Closed [ 6 ]

          People

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

            Dates

              Created:
              Updated:
              Resolved: