This page contains information about the prefixes used in the naming of the sample i2b2 Test Cases delivered with the CRC Tester plug-in.
Initial Prefixes for All Test Queries
The following are the initial prefixes used for all test cases. They will be used at the beginning of the name for every test case.
SQ = Simple Queries
CQ = Constraint Queries
TQ = Timing Queries
MQ = Modifier Queries
MCQ = Modifier Constraint Queries
QIQ = Query-in-Query
Prefixes Specific to Simple Queries
P + Number = the number of panels in the query
Example:
P1 = Single Panel
P2 = Second Panel
P3 = Third Panel
I + Number = the number of items in a panel
Example:
I1 = Single Item
I2 = Two Items
I3 = Three Items
Conventions Specific to Constraint Queries (including modifier constraints)
Dt = Date
Ocr = Occurrence
Ex = Exclude
Val = Value
Flg = Flag
A = Abnormal
H = High
L = Low
Enm = Enumerated
SV = Single Enumerated Value
MV= Multiple Enumerated Value
Txt = Text
ST = String Text Value
LG = Large Text Value
Db = Use database operator
Num = Numerical
LT = Less than operator
LTE = Less than or Equal to operator
E = Equals operator
Btw = Between operator
GT = Greater than operator
GTE = Greater than or Equal to operator
Unt = Units
Mix = Mixture of different types of value constraints
Conventions Specific to Timing Queries
Q = Query level timing (Temporal constraint)
P = Panel level timing
A = Any
SV = Same Visit
SI = Same Instance
Table of All Prefixes
Type of Query |
Prefix for Test Case |
Simple Queries |
SQ |
Single panel; Single item |
SQP1I1 |
Single panel; Two items |
SQP1I2 |
Single panel; 5 items |
SQP1I5 |
Single panel; 10 items |
SQP1I10 |
Single panel; 20 items |
SQP1I20 |
Single panel; 50 items |
SQP1I50 |
Two panels; Each panel has 1 item |
SQP1I1P2I1 |
Two panels; Panel 1 has multiple items and panel two has a single item |
SQP1I2P2I1 |
Two panels; Panel 1 has a single item and panel two has multiple items |
SQP1I1P2I2 |
Two panels; Panel 1 has multiple items and panel two has multiple items |
SQP1I2P2I2 |
Follow same naming convention for all panels used and combination of items |
|
|
|
Constraint Queries |
CQ |
Date Constraint |
CQDt |
Number of Occurrences Constraint |
CQOcr |
Exclude Constraint |
CQEx |
Value Constraint – Flag |
CQValFlg |
Value Constraint – Flag, Abnormal |
CQValFlgA |
Value Constraint – Flag, High |
CQValFlgH |
Value Constraint – Flag, Low |
CQValFlgL |
Value Constraint – Enumerated |
CQValEnm |
Value Constraint – Enumerated, single value |
CQValEnmSV |
Value Constraint – Enumerated, multiple values |
CQValEnmMV |
Value Constraint – Text, string |
CQValTxtST |
Value Constraint – Text, large |
CQValTxtLG |
Value Constraint – Text, large, use database operator |
CQValTxtLGDb |
Value Constraint – Numerical |
CQValNum |
Value Constraint – Numerical, Less than operator |
CQValNumLT |
Value Constraint – Numerical, Less than or equal to operator |
CQValNumLTE |
Value Constraint – Numerical, Equal to operator |
CQValNumE |
Value Constraint – Numerical, Between operator |
CQValNumBtw |
Value Constraint – Numerical, Greater than operator |
CQValNumGT |
Value Constraint – Numerical, Greater than or Equal to operator |
CQValNumGTE |
Value Constraint – Units |
CQValNumUnt |
|
|
Timing Query – Any Visit |
TQQAPA |
Timing Query – Query is same visit; panels are same visit |
TQQSVPSV |
Timing Query – Query is same visit; panels are mixed with any and same visit |
TQQSVPASV |
Timing Query – Query is same instance; panels are same instance |
TQQSIPSI |
Timing Query – Query is same instance; panels are mixed with any and same instance |
TQQSIPASI |
|
|
Modifier Query |
MQ |
Modifier Value Constraint - |
MCQ |
Modifier Value Constraint – Enumerated |
MCQ ValEnm |
Modifier Value Constraint – Enumerated, single value |
MCQ ValEnmSV |
Modifier Value Constraint – Enumerated, multiple values |
MCQ ValEnmMV |
Modifier Value Constraint – Text, string |
MCQ ValTxtST |
Modifier Value Constraint – Text, large |
MCQ ValTxtLG |
Modifier Value Constraint – Text, large, use database operator |
MCQValTxtLGDb |
Modifier Value Constraint – Numerical |
MCQValNum |
Modifier Value Constraint – Numerical, Less than operator |
MCQValNumLT |
Modifier Value Constraint – Numerical, Less than or Equal to operator |
MCQValNumLTE |
Modifier Value Constraint – Numerical, Equal to operator |
MCQValNumE |
Modifier Value Constraint – Numerical, Between operator |
MCQValNumBtw |
Modifier Value Constraint – Numerical, Greater than operator |
MCQValNumGT |
Modifier Value Constraint – Numerical, Greater than or Equal to operator |
MCQValNumGTE |
Modifier Value Constraint – Units |
MCQValNumUnt |
