STANDARD DATA DICTIONARY #409.97 -- SD Audit Statistics FILE 9/29/25 PAGE 1
STORED IN ^SDAUDIT( *** NO DATA STORED YET *** SITE: WWW.BMIRWIN.COM UCI: VISTA,VISTA (VERSION 5.3)
DATA NAME GLOBAL DATA
ELEMENT TITLE LOCATION TYPE
-----------------------------------------------------------------------------------------------------------------------------------
The SD Audit Statistics file contains counts of activities performed by a scheduler on a date. The statistics are compiled early
each morning by the audit statistics compiler routine (SDECAUD) from data in files 403.5, 409.3, 409.84 and 409.85."
DD ACCESS: @
WR ACCESS: @
DEL ACCESS: @
LAYGO ACCESS: @
AUDIT ACCESS: @
CROSS
REFERENCED BY: SCHEDULER(B), DATE(C)
INDEXED BY: DATE & SCHEDULER (D), SCHEDULER & DATE (E)
LAST MODIFIED: JAN 22,2020@16:11:06
409.97,.01 SCHEDULER 0;1 POINTER TO NEW PERSON FILE (#200) (Required)
LAST EDITED: FEB 20, 2018
HELP-PROMPT: Enter name of scheduler.
DESCRIPTION:
Scheduler (user of VSE GUI) who performs actions (e.g., enter appointment requests).
TECHNICAL DESCR:
Scheduler is extracted from activity files (e.g., 409.84, 409.85) by audit compiler (SDECAUD).
CROSS-REFERENCE: 409.97^B
1)= S ^SDAUDIT("B",$E(X,1,30),DA)=""
2)= K ^SDAUDIT("B",$E(X,1,30),DA)
RECORD INDEXES: D (#1561), E (#1562)
409.97,1 DATE 0;2 DATE
INPUT TRANSFORM: S %DT="EX" D ^%DT S X=Y K:Y<1 X
LAST EDITED: FEB 20, 2018
HELP-PROMPT: Enter the date the action was performed.
DESCRIPTION:
Date the scheduler performed the action.
TECHNICAL DESCR:
Date is extracted from the relevant file (e.g., 409.84) by the audit statistics compiler (SDECAUD).
CROSS-REFERENCE: 409.97^C
1)= S ^SDAUDIT("C",$E(X,1,30),DA)=""
2)= K ^SDAUDIT("C",$E(X,1,30),DA)
Date cross-reference for report of statistics by date.
RECORD INDEXES: D (#1561), E (#1562)
409.97,2 PATIENT CONTACTS 0;3 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>99999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: FEB 20, 2018
HELP-PROMPT: Type a number between 0 and 99999999, 0 decimal digits.
DESCRIPTION:
Count of patient contacts performed by the scheduler on the date.
TECHNICAL DESCR:
Counts are extracted by audit statistics compiler (SDECAUD) from files 409.85 and 409.3.
409.97,3 APPT REQUESTS 0;4 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>99999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: FEB 20, 2018
HELP-PROMPT: Type a number between 0 and 99999999, 0 decimal digits.
DESCRIPTION:
Number of appointments requests entered by the scheduler on the date.
TECHNICAL DESCR:
Data is extracted by the audit statistics compiler (SDECAUD) from file #409.84.
409.97,4 APPT APPOINTMENTS MADE 0;5 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>99999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: FEB 20, 2018
HELP-PROMPT: Type a number between 0 and 99999999, 0 decimal digits.
DESCRIPTION:
Count of appointments performed by the scheduler on the date.
TECHNICAL DESCR:
Data is extracted by the audit statistics compiler (SDECAUD) from file 409.84.
409.97,5 APPT CLOSED 0;6 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>99999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: FEB 20, 2018
HELP-PROMPT: Type a number between 0 and 99999999, 0 decimal digits.
DESCRIPTION:
Number of appointments cancelled by the scheduler on the date.
TECHNICAL DESCR:
Data is extracted by the audit statistics compiler (SDECAUD).
409.97,6 MRTC OPENED 0;7 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>99999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: FEB 20, 2018
HELP-PROMPT: Type a number between 0 and 99999999, 0 decimal digits.
DESCRIPTION:
Number of MRTC appointment requests opened by the scheduler on the date.
TECHNICAL DESCR:
Counts are extracted by the audit statistics compiler (SDECAUD) from file 409.85.
409.97,7 MRTC CLOSED 0;8 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>99999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: FEB 20, 2018
HELP-PROMPT: Type a number between 0 and 99999999, 0 decimal digits.
DESCRIPTION:
Number of MRTC appointment requests closed by the scheduler on the date.
TECHNICAL DESCR:
Counts are extracted by the audit statictics compiler (SDECAUD) from file 409.85.
409.97,8 EWL ENTRIES 0;9 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>99999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: FEB 20, 2018
HELP-PROMPT: Type a number between 0 and 99999999, 0 decimal digits.
DESCRIPTION:
Number of wait list entries created by the scheduler on the date.
TECHNICAL DESCR:
Data is extracted by the audit statistics compiler (SDECAUD) from file 409.3.
409.97,9 EWL APPOINTMENTS MADE 0;10 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>99999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: FEB 20, 2018
HELP-PROMPT: Type a number between 0 and 99999999, 0 decimal digits.
DESCRIPTION:
Number of appointments made off of the EWL by the scheduler on a date.
TECHNICAL DESCR:
Data is extracted by the audit statistics compiler (SDECAUD) from file 409.84.
409.97,10 EWL CLOSED 0;11 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>99999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: FEB 20, 2018
HELP-PROMPT: Type a number between 0 and 99999999, 0 decimal digits.
DESCRIPTION:
Number of EWL appointment requests closed by the scheduler on the date.
TECHNICAL DESCR:
Data is extracted by the audit statistics compiler (SDECAUD) from file 409.3.
409.97,11 PtCSch ENTRIES 0;12 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>99999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: FEB 20, 2018
HELP-PROMPT: Type a number between 0 and 99999999, 0 decimal digits.
DESCRIPTION:
Number of patient recall (PtCSch) requests entered by the scheduler on the date.
TECHNICAL DESCR:
Data is extracted by the audit statistics compiler (SDECAUD) from file 403.5.
409.97,12 PtCSch APPOINTMENTS MADE 0;13 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>99999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: FEB 20, 2018
HELP-PROMPT: Type a number between 0 and 99999999, 0 decimal digits.
DESCRIPTION:
Number of patient recall (PtCSch) appointments entered by the scheduler on the date.
TECHNICAL DESCR:
Data is extracted by the audit statistics compiler (SDECAUD) from file 409.84.
409.97,13 CONSULT APPOINTMENTS MADE 0;14 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>99999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: FEB 20, 2018
HELP-PROMPT: Type a number between 0 and 99999999, 0 decimal digits.
DESCRIPTION:
Number of consult appointments entered by the scheduler on the date.
TECHNICAL DESCR:
Data is extracted by the audit statistics compiler (SDECAUD) from file 409.84.
409.97,14 APPOINTMENTS CANCELLED 0;15 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>99999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: FEB 20, 2018
HELP-PROMPT: Type a number between 0 and 99999999, 0 decimal digits.
DESCRIPTION:
Number of appointments cancelled by the scheduler on the date.
TECHNICAL DESCR:
Data is extracted by the audit statistics compiler (SDECAUD) from file 409.84.
409.97,15 TOTAL ACTIONS ; COMPUTED
MUMPS CODE: X ^DD(409.97,15,9.3) S X=X+$P(Y(409.97,15,1),U,14)+$P(Y(409.97,15,1),U,15)
9.2 = S Y(409.97,15,1)=$S($D(^SDAUDIT(D0,0)):^(0),1:"") S X=$P(Y(409.97,15,1),U,3)+$P(Y(409.97,15,1
),U,4)+$P(Y(409.97,15,1),U,5)+$P(Y(409.97,15,1),U,6)+$P(Y(409.97,15,1),U,7)
9.3 = X ^DD(409.97,15,9.2) S X=X+$P(Y(409.97,15,1),U,8)+$P(Y(409.97,15,1),U,9)+$P(Y(409.97,15,1),U,
10)+$P(Y(409.97,15,1),U,11)+$P(Y(409.97,15,1),U,12)+$P(Y(409.97,15,1),U,13)
ALGORITHM: PATIENT CONTACTS+APPT REQUESTS+APPT APPOINTMENTS MADE+APPT CLOSED+MRTC OPENED+MRTC CLOSED+EWL ENTRI
ES+EWL APPOINTMENTS MADE+EWL CLOSED+PtCSch ENTRIES+PtCSch APPOINTMENTS MADE+CONSULT APPOINTMENTS MA
DE+APPOINTMENTS CANCELLED
FILES POINTED TO FIELDS
NEW PERSON (#200) SCHEDULER (#.01)
File #409.97
Record Indexes:
D (#1561) RECORD REGULAR IR LOOKUP & SORTING
Short Descr: DATE AND SCHEDULER
Description: Used to select records for printing on report by date.
Set Logic: S ^SDAUDIT("D",$E(X(1),1,7),$E(X(2),1,20),DA)=""
Kill Logic: K ^SDAUDIT("D",$E(X(1),1,7),$E(X(2),1,20),DA)
Whole Kill: K ^SDAUDIT("D")
X(1): DATE (409.97,1) (Subscr 1) (Len 7) (forwards)
Lookup Prompt: DATE AND SCHEDULER
X(2): SCHEDULER (409.97,.01) (Subscr 2) (Len 20) (forwards)
Lookup Prompt: SCHEDULER
E (#1562) RECORD REGULAR IR LOOKUP & SORTING
Short Descr: SCHEDULER AND DATE
Description: Used to select records for printing on report by scheduler for a date range.
Set Logic: S ^SDAUDIT("E",$E(X(1),1,20),$E(X(2),1,7),DA)=""
Kill Logic: K ^SDAUDIT("E",$E(X(1),1,20),$E(X(2),1,7),DA)
Whole Kill: K ^SDAUDIT("E")
X(1): SCHEDULER (409.97,.01) (Subscr 1) (Len 20) (forwards)
X(2): DATE (409.97,1) (Subscr 2) (Len 7) (forwards)
Lookup Prompt: DATE
INPUT TEMPLATE(S):
PRINT TEMPLATE(S):
SDEC AUDIT DATE PRINT MAR 12, 2018@06:48 USER #0 SD Audit Statistics STATISTICS
SORT TEMPLATE(S):
SDEC AUDIT REPORT BY DATE MAR 07, 2018@10:24 USER #0
SORT BY: DATE// (User is asked range)
WITHIN DATE, SORT BY: SCHEDULER// ( SCHEDULER not null)
FORM(S)/BLOCK(S):