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