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

          lcp5 Lori Phillips created issue -
          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 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 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: