Details
-
Story
-
Status: To Do
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
Description
Currently in the query tool, users are able to add a date constraint to a panel that contains age concept(s). When a date constraint is defined, the query will use the START_DATE in the OBSERVATION_FACT table. Ages that are stored in the PATIENT_DIMENSION will not have a START_DATE and therefore the date constraint is not valid.
General i2b2 users do not know whether or not an age has a start date and if they select a date constraint their query may not return the expected results. This becomes a bigger issue when you are using the i2b2 in a larger network in which some sites may store it in the PATIENT_DIMENSION and others in the OBSERVATION_FACT. This scenario will definitely result in misleading results and the user will be unaware of the discrepancy.
SOLUTION:
The solution is to disable the ability to add a Date Constraint to a panel if one of the concepts in the panel is an age concept.
We also need to evaluate whether or not this should be extended to all demographic data that may be stored in the PATIENT_DIMENSION table instead of the OBSERVATION_FACT table.
General i2b2 users do not know whether or not an age has a start date and if they select a date constraint their query may not return the expected results. This becomes a bigger issue when you are using the i2b2 in a larger network in which some sites may store it in the PATIENT_DIMENSION and others in the OBSERVATION_FACT. This scenario will definitely result in misleading results and the user will be unaware of the discrepancy.
SOLUTION:
The solution is to disable the ability to add a Date Constraint to a panel if one of the concepts in the panel is an age concept.
We also need to evaluate whether or not this should be extended to all demographic data that may be stored in the PATIENT_DIMENSION table instead of the OBSERVATION_FACT table.
Attachments
Activity
Field | Original Value | New Value |
---|---|---|
Fix Version/s | 1.7.07 [ 10201 ] | |
Assignee | Mike Mendis [ mem61 ] | |
i2b2 Related Project/s | SHRINE [ 10202 ] | |
i2b2 Sponsored Project/s | i2b2 Web Client [ 10197 ] | |
Status | New [ 10000 ] | Open [ 1 ] |
Fix Version/s | 1.7.08 [ 10204 ] | |
Fix Version/s | 1.7.07 [ 10201 ] |
Fix Version/s | 1.7.09 [ 10306 ] | |
Fix Version/s | 1.7.08 [ 10204 ] |
Fix Version/s | 1.7.09 [ 10306 ] |
Component/s | Workbench [ 10057 ] | |
Key | CORE-183 | WORKBENCH-6 |
Affects Version/s | 1.7.06 [ 10200 ] | |
Workflow | i2b2 Issues Workflow [ 10860 ] | Software Simplified Workflow for Project WORKBENCH [ 11387 ] |
Issue Type | Improvement [ 4 ] | Story [ 10001 ] |
Project | i2b2 Core Software [ 10034 ] | i2b2 Workbench [ 10333 ] |
Status | Open [ 1 ] | To Do [ 10006 ] |