Home   Package List   Routine Alphabetical List   Global Alphabetical List   FileMan Files List   FileMan Sub-Files List   Package Component Lists   Package-Namespace Mapping  
Info |  Desc |  Pointer To FileMan Files |  Fields
Print Page as PDF
Global: ^ISI(23450

Package: Vendor - ISI

Global: ^ISI(23450


Information

FileMan FileNo FileMan Filename Package
23450 ISIJ DYNAMIC QUERY STATS Vendor - ISI

Description

Pointer To FileMan Files, Total: 1

Package Total FileMan Files
Kernel 1 NEW PERSON(#200)[1]    

Fields, Total: 6

Field # Name Loc Type Details
.01 SESSION 0;1 NUMBER
************************REQUIRED FIELD************************

  • 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 (#1727) 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)
1 USER 0;2 POINTER TO NEW PERSON FILE (#200) NEW PERSON(#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 (#1728)
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.
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.
4 SCANS 1;0 Multiple #23450.04 23450.04

  • DESCRIPTION:  
    Each separate compile of the Query during this session produces an entry here for capturing additional statistics.
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 (#1729) 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 (#1728)
Info |  Desc |  Pointer To FileMan Files |  Fields