STANDARD DATA DICTIONARY #23450 -- ISIJ DYNAMIC QUERY STATS FILE 3/24/25 PAGE 1
STORED IN ^ISI(23450, *** NO DATA STORED YET *** SITE: WWW.BMIRWIN.COM UCI: VISTA,VISTA (VERSION 1.1)
DATA NAME GLOBAL DATA
ELEMENT TITLE LOCATION TYPE
-----------------------------------------------------------------------------------------------------------------------------------
This file collects statistical data for the ISI Rad Dynamic Query feature, for each time a query is run.
DD ACCESS: @
RD ACCESS: @
WR ACCESS: @
DEL ACCESS: @
LAYGO ACCESS: @
AUDIT ACCESS: @
IDENTIFIED BY: USER (#1)
INDEXED BY: SESSION (B), USER & DATE (CA), DATE (CD)
LAST MODIFIED: DEC 18,2023@14:47:44
23450,.01 SESSION 0;1 NUMBER (Required)
INPUT TRANSFORM: K:+X'=X!(X>99999999)!(X<1)!(X?.E1"."1N.N) X
LAST EDITED: JUN 22, 2018
HELP-PROMPT: Type a number between 1 and 99999999, 0 decimal digits.
DESCRIPTION:
Unique identifier for each logon session; value is from the IMAGING WINDOWS SESSIONS entry.
FIELD INDEX: B (#310) REGULAR IR LOOKUP & SORTING
Short Descr: B-index, but backwards collation
Set Logic: S ^ISI(23450,"B",$E(X,1,8),DA)=""
Kill Logic: K ^ISI(23450,"B",$E(X,1,8),DA)
Whole Kill: K ^ISI(23450,"B")
X(1): SESSION (23450,.01) (Subscr 1) (Len 8) (backwards)
23450,1 USER 0;2 POINTER TO NEW PERSON FILE (#200)
LAST EDITED: FEB 06, 2023
HELP-PROMPT: Enter the user who ran the query.
DESCRIPTION:
Identifies the user for this session.
RECORD INDEXES: CA (#311)
23450,2 N-FULLSCANS 0;3 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999)!(X<1)!(X?.E1"."1N.N) X
LAST EDITED: JUN 05, 2018
HELP-PROMPT: Type a number between 1 and 999, 0 decimal digits.
DESCRIPTION: Count of the number of "full scans" that were run in this session. A full scan traverses the raw
database files to compile the Query list. Contrast with "ReScans" described in N-RESCANS.
23450,3 N-RESCANS 0;4 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999)!(X<1)!(X?.E1"."1N.N) X
LAST EDITED: JUN 05, 2018
HELP-PROMPT: Type a number between 1 and 999, 0 decimal digits.
DESCRIPTION: Count of the number of "re-scans" that were run in this session. A re-scan traverses an index of
record results previously compiled in a Full Scan to compile the Query list. This allows a
re-display of an unchanged query to compile more or less instantaneously. Contrast with "Full
Scans" described in N-FULLSCANS.
23450,4 SCANS 1;0 Multiple #23450.04 (Add New Entry without Asking)
DESCRIPTION: Each separate compile of the Query during this session produces an entry here for capturing
additional statistics.
23450.04,.01 SCAN TERMS 0;1 FREE TEXT
INPUT TRANSFORM: K:$L(X)>60!($L(X)<1) X
MAXIMUM LENGTH: 60
LAST EDITED: JUN 05, 2018
HELP-PROMPT: Answer must be 1-60 characters in length.
DESCRIPTION: This is a comma-delimited list of numbers that are the IEN values within the VistARad list
subsystem for the various data elements that are used in the exam lists. The stored string
captures which data elements were used for defining the search criteria for this Query instance.
This information can later be examined to determine patterns of use that can be evaluated for
making possible enhancements to the query feature, e.g., to allow more efficient processing
(faster compile times), or to tailor for the kinds of uses being made (i.e., custom Unread
lists).
CROSS-REFERENCE: 23450.04^B
1)= S ^ISI(23450,DA(1),1,"B",$E(X,1,30),DA)=""
2)= K ^ISI(23450,DA(1),1,"B",$E(X,1,30),DA)
23450.04,1 FULLSCAN 0;2 SET
'Y' FOR Yes;
LAST EDITED: FEB 06, 2023
HELP-PROMPT: Enter "Y" if this scan was a Full scan.
DESCRIPTION:
Truth value to indicate this was a Full Scan (true) or a Re-Scan.
23450.04,2 N-SECONDS 0;3 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>9999)!(X<0)!(X?.E1"."2N.N) X
LAST EDITED: JUN 05, 2018
HELP-PROMPT: Type a number between 0 and 9999, 1 decimal digit.
DESCRIPTION:
Number of seconds this compile took to complete.
23450.04,3 DAYS OFFSET 0;4 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>1825)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: JUN 05, 2018
HELP-PROMPT: Type a number between 0 and 1825, 0 decimal digits.
DESCRIPTION: The number of days back from today (session date) to the most recent date that was included in
the search criteria.
23450.04,4 START DAYS BACK 0;5 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>1825)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: JUN 05, 2018
HELP-PROMPT: Type a number between 0 and 1825, 0 decimal digits.
DESCRIPTION: The number of days back from today (session date) to the oldest date that was included in the
search criteria.
23450.04,5 DAYS TOTAL 0;6 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>1825)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: JUN 05, 2018
HELP-PROMPT: Type a number between 0 and 1825, 0 decimal digits.
DESCRIPTION:
The total number of days scanned.
23450.04,6 N-RESULTS 0;7 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>9999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: JUN 05, 2018
HELP-PROMPT: Type a number between 0 and 9999, 0 decimal digits.
DESCRIPTION:
The total number of result records returned.
23450.04,7 N-WAITING 0;8 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>9999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: JUN 05, 2018
HELP-PROMPT: Type a number between 0 and 9999, 0 decimal digits.
DESCRIPTION:
The total number of records returned having Exam Status WAITING.
23450.04,8 N-EXAMINED 0;9 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>9999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: JUN 05, 2018
HELP-PROMPT: Type a number between 0 and 9999, 0 decimal digits.
DESCRIPTION:
The total number of records returned having Exam Status EXAMINED.
23450.04,9 N-INTERP 0;10 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>9999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: JUN 05, 2018
HELP-PROMPT: Type a number between 0 and 9999, 0 decimal digits.
DESCRIPTION:
The total number of records returned having Exam Status INTERPRETED.
23450.04,10 N-COMPLETE 0;11 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>9999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: JUN 05, 2018
HELP-PROMPT: Type a number between 0 and 9999, 0 decimal digits.
DESCRIPTION:
The total number of records returned having Exam Status COMPLETE.
23450.04,11 N-OTHER 0;12 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>9999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: JUN 05, 2018
HELP-PROMPT: Type a number between 0 and 9999, 0 decimal digits.
DESCRIPTION:
The total number of records returned having an unknown Exam Status.
23450,5 DATE 0;5 DATE
INPUT TRANSFORM: S %DT="EX" D ^%DT S X=Y K:Y<1 X
LAST EDITED: FEB 08, 2023
HELP-PROMPT: Enter the date the scan was run.
DESCRIPTION:
Date on which this session occurred.
FIELD INDEX: CD (#312) REGULAR IR LOOKUP & SORTING
Short Descr: DATE INDEX
Set Logic: S ^ISI(23450,"CD",$E(X,1,8),DA)=""
Kill Logic: K ^ISI(23450,"CD",$E(X,1,8),DA)
Whole Kill: K ^ISI(23450,"CD")
X(1): DATE (23450,5) (Subscr 1) (Len 8) (backwards)
RECORD INDEXES: CA (#311)
FILES POINTED TO FIELDS
NEW PERSON (#200) USER (#1)
File #23450
Record Indexes:
CA (#311) RECORD REGULAR IR LOOKUP & SORTING
Short Descr: USER NAME & DATE
Set Logic: S ^ISI(23450,"CA",$E(X(1),1,30),$E(X(2),1,8),DA)=""
Kill Logic: K ^ISI(23450,"CA",$E(X(1),1,30),$E(X(2),1,8),DA)
Whole Kill: K ^ISI(23450,"CA")
X(1): USER (23450,1) (Subscr 1) (Len 30) (forwards)
X(2): DATE (23450,5) (Subscr 2) (Len 8) (backwards)
INPUT TEMPLATE(S):
PRINT TEMPLATE(S):
ISIJ QUERY STATS** JUN 05, 2018@14:10 USER #0 QUERY STATS List
SORT TEMPLATE(S):
** = CANONIC TEMPLATE
FORM(S)/BLOCK(S):