STANDARD DATA DICTIONARY #102.21 -- CPRS QUERY DEFINITION FILE 3/24/25 PAGE 1
STORED IN ^ORD(102.21, (49 ENTRIES) SITE: WWW.BMIRWIN.COM UCI: VISTA,VISTA (VERSION 3.0)
DATA NAME GLOBAL DATA
ELEMENT TITLE LOCATION TYPE
-----------------------------------------------------------------------------------------------------------------------------------
The CPRS query tool provides a mechanism by which clinical users may search for items typically managed by CPRS. These are very
limited types of queries. A wizard helps the user construct the criteria used in the query.
This file contains definitions of queries used to build reports of CPRS items (orders, consults, documents). Each query definition
contains a list of constraints. These constraints are used by the query routines to return a subset of CPRS items.
This file also contains definitions of report criteria. These criteria are selected and modified by the user when building custom
reports. A report criterion contains a list of constraints that apply to the particular criterion. A critieron behaves much like a
"mini-report".
The other part of a query definition stored in this file is the list of fields to be displayed after the query is run. The query
produces a columnar report with the selected display field in each column.
DD ACCESS: @
RD ACCESS: @
WR ACCESS: @
DEL ACCESS: @
LAYGO ACCESS: @
AUDIT ACCESS: @
POINTED TO BY: PARENT field (#6) of the CPRS QUERY DEFINITION File (#102.21)
CRITERION field (#2) of the QUERY TEXT sub-field (#102.211) of the CPRS QUERY DEFINITION File (#102.21)
CROSS
REFERENCED BY: NAME(B), NAME(C), TAG(T)
102.21,.01 NAME 0;1 FREE TEXT (Required)
INPUT TRANSFORM: K:$L(X)>30!(X?.N)!($L(X)<3)!'(X'?1P.E) X
LAST EDITED: SEP 24, 2002
HELP-PROMPT: NAME MUST BE 3-30 CHARACTERS, NOT NUMERIC OR STARTING WITH PUNCTUATION
DESCRIPTION: This is the name of the report or criterion. Personally created reports are stored as RPTUduz
user-created-name. This assures uniqueness of personal custom reports.
CROSS-REFERENCE: 102.21^B
1)= S ^ORD(102.21,"B",$E(X,1,30),DA)=""
2)= K ^ORD(102.21,"B",$E(X,1,30),DA)
CROSS-REFERENCE: 102.21^C^MUMPS
1)= S ^ORD(102.21,"C",$$UP^XLFSTR(X),DA)=""
2)= K ^ORD(102.21,"C",$$UP^XLFSTR(X),DA)
Upper case xref for full lookup
102.21,2 DISPLAY TEXT 0;2 FREE TEXT
INPUT TRANSFORM: K:$L(X)>30!($L(X)<3) X
LAST EDITED: SEP 08, 2002
HELP-PROMPT: Answer must be 3-30 characters in length.
DESCRIPTION:
This is the text that is displayed in the list box when selecting a criterion or a report.
102.21,3 DISABLE 0;3 FREE TEXT
INPUT TRANSFORM: K:$L(X)>30!($L(X)<3) X
LAST EDITED: SEP 08, 2002
HELP-PROMPT: Answer must be 3-30 characters in length.
DESCRIPTION:
This is the text that is desplayed when the definition is disabled.
102.21,4 TYPE 0;4 SET (Required)
'C' FOR constraint;
'R' FOR report;
'S' FOR search item;
'B' FOR baseline;
LAST EDITED: SEP 16, 2002
HELP-PROMPT: Enter the type of this definition (constraint, search item, or report).
DESCRIPTION:
This specifies whether the record is a report or a criterion.
102.21,5 OWNER 0;5 POINTER TO NEW PERSON FILE (#200)
LAST EDITED: SEP 08, 2002
HELP-PROMPT: Enter the person to whom this report belongs.
DESCRIPTION:
This contains the owner of a custom report.
102.21,6 PARENT 0;6 POINTER TO CPRS QUERY DEFINITION FILE (#102.21)
LAST EDITED: SEP 16, 2002
HELP-PROMPT: Select the search item that this entry is subordinate to.
DESCRIPTION:
This identifies the entry that is the parent criterion. Criteria may appear in a hierarchy.
SCREEN: I $P(^ORD(102.21,Y,0),U,4)="C"
EXPLANATION: Only criteria may have a hierarchical relationship at this time.
102.21,7 TAG 0;7 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>9999999)!(X<1000000)!(X?.E1"."1N.N) X
LAST EDITED: NOV 03, 2002
HELP-PROMPT: Type a Number between 1000000 and 9999999, 0 Decimal Digits
DESCRIPTION: This contains an integer that matches the Tag property of the Windows control that references this
criterion.
CROSS-REFERENCE: 102.21^T
1)= S ^ORD(102.21,"T",$E(X,1,30),DA)=""
2)= K ^ORD(102.21,"T",$E(X,1,30),DA)
Allows looking up a report name by the windows tag
102.21,10 QUERY TEXT 1;0 Multiple #102.211 (Add New Entry without Asking)
DESCRIPTION: This multiple allows a sequence of captions to be defined that comprise the default text of a query
description.
INDEXED BY: SEQUENCE (AC)
102.211,.01 SEQUENCE 0;1 NUMBER (Multiply asked)
INPUT TRANSFORM: K:+X'=X!(X>9999)!(X<1)!(X?.E1"."3N.N) X
LAST EDITED: FEB 07, 2003
HELP-PROMPT: Type a Number between 1 and 9999, 2 Decimal Digits
DESCRIPTION:
This specifies the sequence of each caption that appears in the query text.
CROSS-REFERENCE: 102.211^B
1)= S ^ORD(102.21,DA(1),1,"B",$E(X,1,30),DA)=""
2)= K ^ORD(102.21,DA(1),1,"B",$E(X,1,30),DA)
FIELD INDEX: AC (#211) MUMPS IR ACTION
Short Descr: TEST
Set Logic: Q
Kill Logic: Q
X(1): SEQUENCE (102.211,.01) (Len 30) (forwards)
102.211,2 CRITERION 0;2 POINTER TO CPRS QUERY DEFINITION FILE (#102.21)
LAST EDITED: SEP 08, 2002
HELP-PROMPT: Enter the criterion to which this caption applies.
DESCRIPTION:
This is the criterion that is the 'parent' of the specific query text caption.
102.211,3 CONSTRAINT 0;3 POINTER TO CPRS QUERY CONSTRAINT FILE (#102.22)
LAST EDITED: SEP 08, 2002
HELP-PROMPT: Enter the constraint (parameter) which is mapped to the editor for this value.
DESCRIPTION: This identifies the constraint (parameter) used for this query and the range of values possible
along with the editor that should be used.
102.211,4 CAPTION 0;4 FREE TEXT
INPUT TRANSFORM: K:$L(X)>80!($L(X)<1) X
LAST EDITED: SEP 08, 2002
HELP-PROMPT: Answer must be 1-80 characters in length.
DESCRIPTION:
This is the caption text that appears for the query.
102.211,10 VALUES 1;0 Multiple #102.2111
102.2111,.01 VALUE 0;1 FREE TEXT (Multiply asked)
INPUT TRANSFORM: K:$L(X)>235!($L(X)<1) X
LAST EDITED: SEP 18, 2002
HELP-PROMPT: Answer must be 1-235 characters in length.
DESCRIPTION:
This constains the actual values passed as constraints to this query.
CROSS-REFERENCE: 102.2111^B
1)= S ^ORD(102.21,DA(2),1,DA(1),1,"B",$E(X,1,30),DA)=""
2)= K ^ORD(102.21,DA(2),1,DA(1),1,"B",$E(X,1,30),DA)
102.21,20 FORMAT 2;0 Multiple #102.212
DESCRIPTION:
This multiple contains formatting information for the columns of the report.
102.212,.01 COLUMN 0;1 NUMBER (Multiply asked)
INPUT TRANSFORM: K:+X'=X!(X>9999999)!(X<0)!(X?.E1"."3N.N) X
LAST EDITED: SEP 28, 2002
HELP-PROMPT: Type a Number between 0 and 9999999, 2 Decimal Digits
DESCRIPTION:
This is the sequence number for the column.
CROSS-REFERENCE: 102.212^B
1)= S ^ORD(102.21,DA(1),2,"B",$E(X,1,30),DA)=""
2)= K ^ORD(102.21,DA(1),2,"B",$E(X,1,30),DA)
102.212,2 DISPLAY FIELD 0;2 POINTER TO CPRS QUERY DISPLAY FIELDS FILE (#102.24)
LAST EDITED: SEP 24, 2002
HELP-PROMPT: Select the Display Field for this sequence (column) number.
DESCRIPTION:
This specifies which field should be displayed in this column of the report.
102.212,3 PIXEL WIDTH 0;3 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>99999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: SEP 24, 2002
HELP-PROMPT: Type a Number between 0 and 99999999, 0 Decimal Digits
DESCRIPTION:
This specifies the initial width of the column in pixels.
FILES POINTED TO FIELDS
CPRS QUERY CONSTRAINT (#102.22) QUERY TEXT:CONSTRAINT (#3)
CPRS QUERY DEFINITION (#102.21) PARENT (#6)
QUERY TEXT:CRITERION (#2)
CPRS QUERY DISPLAY FIELDS
(#102.24) FORMAT:DISPLAY FIELD (#2)
NEW PERSON (#200) OWNER (#5)
INPUT TEMPLATE(S):
PRINT TEMPLATE(S):
SORT TEMPLATE(S):
FORM(S)/BLOCK(S):