Uploaded image for project: 'i2b2 Core Software'
  1. i2b2 Core Software
  2. CORE-220

SqlServer Age at Visit incorrect for 24, 80, 81 and 89

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.7.07
    • 1.7.08
    • Data
    • None
    • SQL Server
    • 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

        Activity

          Ascending order - Click to sort in descending order
          lcp5 Lori Phillips created issue -
          lcp5 Lori Phillips added a comment -
          This script should run on SQLSERVER only. Postgres computes age differently and oracle does not have the bug.
          lcp5 Lori Phillips added a comment - This script should run on SQLSERVER only. Postgres computes age differently and oracle does not have the bug.
          lcp5 Lori Phillips made changes -
          Field Original Value New Value
          Attachment AgeAtVisitUpdate.sql [ 10433 ]
          Component/s Data [ 10050 ]
          Affects Version/s 1.7.07 [ 10201 ]
          lcp5 Lori Phillips added a comment -
          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



          lcp5 Lori Phillips added a comment - 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
          lcp5 Lori Phillips made changes -
          Assignee Janice Donahoe [ jmd86 ]
          Status New [ 10000 ] Open [ 1 ]
          lcp5 Lori Phillips made changes -
          Affects Database/s SQL Server [ 10189 ]
          Developer Notes Affects SQLSERVER ontology metadata table i2b2 only.
          lcp5 Lori Phillips made changes -
          Assignee Janice Donahoe [ jmd86 ] Lori Phillips [ lcp5 ]
          lcp5 Lori Phillips made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          lcp5 Lori Phillips made changes -
          Assignee Lori Phillips [ lcp5 ] Janice Donahoe [ jmd86 ]
          Status In Progress [ 3 ] Ready to Test [ 10001 ]
          jmd86 Janice Donahoe made changes -
          Status Ready to Test [ 10001 ] Testing [ 10002 ]
          jmd86 Janice Donahoe made changes -
          Fix Version/s 1.7.08 [ 10204 ]
          jmd86 Janice Donahoe made changes -
          Resolution Fixed [ 1 ]
          Status Testing [ 10002 ] Resolved [ 5 ]
          jmd86 Janice Donahoe added a comment -
          This change was included in version 1.7.08, which was released on 10/07/2016.
          jmd86 Janice Donahoe added a comment - This change was included in version 1.7.08, which was released on 10/07/2016.
          jmd86 Janice Donahoe made changes -
          Status Resolved [ 5 ] Closed [ 6 ]

          People

            jmd86 Janice Donahoe
            lcp5 Lori Phillips
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: