[CORE-220] SqlServer Age at Visit incorrect for 24, 80, 81 and 89 - i2b2 JIRA

XML

Word

Printable

Details

Type: Bug
Status: Closed
Priority: Major
Resolution: Fixed
Affects Version/s: 1.7.07
Fix Version/s: 1.7.08
Component/s: Data
Labels:
None

Affects Database/s:

SQL Server

Developer Notes:
Affects SQLSERVER ontology metadata table i2b2 only.

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.

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

AgeAtVisitUpdate.sql
2 kB
10/Aug/16 3:00 PM

Activity

People

Assignee:: Janice Donahoe

Reporter:: Lori Phillips

Participant/s:: Janice Donahoe, Lori Phillips

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 10/Aug/16 2:58 PM

Updated:: 17/Oct/16 11:35 AM

Resolved:: 21/Sep/16 12:51 PM