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

Difference between documentation and table concept_dimension

Details

    • Documentation
    • Status: Closed
    • Trivial
    • Resolution: Fixed
    • 1.7.05
    • 1.7.06
    • CRC Cell
    • None
    • i2b2 Web Client
    • All databases
    • Hide
      It appears the problem is the CRC Design document that is available on the i2b2 web site is an older version. This issue is fixed in version 1.7.02 of this document. The INSTANCE_NUM column is not a nullable field as it is part of the primary key. This holds true for all supported databases (oracle, postgresql, and sqlserver).

      I have verified that the correct version of the CRC Design document is included in the i2b2core-doc-1705.zip file that can be downloaded from the i2b2 web site. The file can be found with the other i2b2 Source files.

      This issue will address updating the CRC Design document that displays when selecting it from the list of documentation that appears when hovering over the Data Repository cell in the hive image.
      Show
      It appears the problem is the CRC Design document that is available on the i2b2 web site is an older version. This issue is fixed in version 1.7.02 of this document. The INSTANCE_NUM column is not a nullable field as it is part of the primary key. This holds true for all supported databases (oracle, postgresql, and sqlserver). I have verified that the correct version of the CRC Design document is included in the i2b2core-doc-1705.zip file that can be downloaded from the i2b2 web site. The file can be found with the other i2b2 Source files. This issue will address updating the CRC Design document that displays when selecting it from the list of documentation that appears when hovering over the Data Repository cell in the hive image.

    Description

      The document Data Repository Cell [1] says on page 8 that the field INSTANCE_NUM may be null (NULLABLE = YES in table column). In fact, the column instance_num in the table observation_fact is not nullable.
      I could only test this in an Oracle database so I can't tell if Postgres is also affected by this documentation gap.


      [1] https://www.i2b2.org/software/files/PDF/current/CRC_Design.pdf

      Attachments

        Activity

          Descending order - Click to sort in ascending order
          jmd86 Janice Donahoe added a comment -
          The fix for this issue was included in the 1.7.06 release.

          i2b2 version 1.7.06 was released on August 12, 2015.
          jmd86 Janice Donahoe added a comment - The fix for this issue was included in the 1.7.06 release. i2b2 version 1.7.06 was released on August 12, 2015.
          jmd86 Janice Donahoe added a comment -
          The updated document will be added to the i2b2 web site when version 1.7.06.0001 is released.
          jmd86 Janice Donahoe added a comment - The updated document will be added to the i2b2 web site when version 1.7.06.0001 is released.
          akeil Andreas Keil added a comment -
          The same happens with MODIFIER_CD.
          akeil Andreas Keil added a comment - The same happens with MODIFIER_CD.

          People

            jmd86 Janice Donahoe
            akeil Andreas Keil
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: