[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.

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.

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.