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