AgeAtVisitUpdate.sql
SQL Server
[CORE-220] SqlServer Age at Visit incorrect for 24, 80, 81 and 89 Created: 10/Aug/16 Updated: 17/Oct/16 Resolved: 21/Sep/16 |
|
| Status: | Closed |
| Project: | i2b2 Core Software |
| Component/s: | Data |
| Affects Version/s: | 1.7.07 |
| Fix Version/s: | 1.7.08 |
| Type: | Bug | Priority: | Major |
| Reporter: | Lori Phillips | Assignee: | Janice Donahoe |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Attachments: |
AgeAtVisitUpdate.sql
|
| Rank: | 0|i002yn: |
| Affects Database/s: |
SQL Server
|
| Developer Notes: | Affects SQLSERVER ontology metadata table i2b2 only. |
| Participant/s: |
| Description |
|
The c_dimcode field for Age at visit is incorrect for ages 24, 80, 81 and 89.
An AgeAtVisitUpgrade.sql script was created that should run on sqlserver only. |
| Comments |
| Comment by Lori Phillips [ 10/Aug/16 ] |
| This script should run on SQLSERVER only. Postgres computes age differently and oracle does not have the bug. |
| Comment by Lori Phillips [ 10/Aug/16 ] |
|
on new installs no new data install path is needed
However release notes need to mention a new data upgrade path for SQLSERVER only. ant –f data_build.xml upgrade_sqlserver_metadata_tables_release_1-7_08 |
| Comment by Janice Donahoe [ 17/Oct/16 ] |
| This change was included in version 1.7.08, which was released on 10/07/2016. |