[CORE-179] Difference between documentation and table concept_dimension Created: 27/May/15 Updated: 18/Aug/15 Resolved: 23/Jul/15 |
|
| Status: | Closed |
| Project: | i2b2 Core Software |
| Component/s: | CRC Cell |
| Affects Version/s: | 1.7.05 |
| Fix Version/s: | 1.7.06 |
| Type: | Documentation | Priority: | Trivial |
| Reporter: | Andreas Keil | Assignee: | Janice Donahoe |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Rank: | 0|i001zr: |
| i2b2 Sponsored Project/s: |
i2b2 Web Client
|
| Affects Database/s: |
All databases
|
| Reproduction Notes: | 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. |
| Participant/s: |
| 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 |
| Comments |
| Comment by Andreas Keil [ 27/May/15 ] |
| The same happens with MODIFIER_CD. |
| Comment by Janice Donahoe [ 23/Jul/15 ] |
| The updated document will be added to the i2b2 web site when version 1.7.06.0001 is released. |
| Comment by Janice Donahoe [ 18/Aug/15 ] |
|
The fix for this issue was included in the 1.7.06 release.
i2b2 version 1.7.06 was released on August 12, 2015. |