[CORE-265] OMOP Data Views: Need to add a view for the Provider table Created: 10/May/17  Updated: 29/Jun/17  Resolved: 13/Jun/17

Status: Closed
Project: i2b2 Core Software
Component/s: Data
Affects Version/s: 1.7.09-RC1
Fix Version/s: 1.7.09

Type: Bug Priority: Major
Reporter: Janice Donahoe Assignee: Janice Donahoe
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Rank: 0|i003f3:
Affects Database/s:
All databases
Developer Notes: 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.
Participant/s:

 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.

 Comments   
Comment by Lori Phillips [ 11/May/17 ]
Create table statement added for PROVDER_DIMENSION. I also added MODIFIER_DIMENSION for possible future use.
Comment by Janice Donahoe [ 13/Jun/17 ]
This issue has been fixed and will be included in release 1.7.09.
Generated at Sat Jun 06 07:57:08 UTC 2020 using JIRA 7.6.3#76005-sha1:8a4e38d34af948780dbf52044e7aafb13a7cae58.