STANDARD DATA DICTIONARY #404.95 -- SCHEDULING REPORT QUERY TEMPLATE FILE 6/27/25 PAGE 1
STORED IN ^SD(404.95, (1 ENTRY) SITE: WWW.BMIRWIN.COM UCI: VISTA,VISTA (VERSION 5.3)
DATA NAME GLOBAL DATA
ELEMENT TITLE LOCATION TYPE
-----------------------------------------------------------------------------------------------------------------------------------
This file stores report criteria specifications used to print reports defined in the SCHEDULING REPORT DEFINITION (#404.92) file.
These user-defined templates can then be access by the user, eliminating the need to specify the criteria each time a report needs
to be executed.
The user can created/edit/copy/delete his or her own templates. The user can also specify whether the template is a 'personal' or
'public' template. Personal templates can only be used by the user who created it. Public templates can be used by anyone but can
only be edited by the template creator. However, another user can copy and edit a public template specification by using the 'Save
As...' command.
Templates are only available on client workstation.
DD ACCESS: @
RD ACCESS: d
WR ACCESS: @
DEL ACCESS: @
LAYGO ACCESS: @
AUDIT ACCESS: Ss
POINTED TO BY: DEFAULT PCMM REPORT QUERY field (#1.15) of the SCHEDULING USER PREFERENCE File (#403.35)
CROSS
REFERENCED BY: CREATOR(AC), ACCESS LEVEL(AD), NAME(B), REPORT(C)
404.95,.01 NAME 0;1 FREE TEXT (Required)
INPUT TRANSFORM: K:$L(X)>30!(X?.N)!($L(X)<3)!'(X'?1P.E) X
HELP-PROMPT: NAME MUST BE 3-30 CHARACTERS, NOT NUMERIC OR STARTING WITH PUNCTUATION
DESCRIPTION: Name of the query template specified by the creator/user.
Two templates cannot have the same name for a given user. Templates can have the same name but
they must be created by different users.
TECHNICAL DESCR:
The template name and the creator is the composite primary key for this file.
CROSS-REFERENCE: 404.95^B
1)= S ^SD(404.95,"B",$E(X,1,30),DA)=""
2)= K ^SD(404.95,"B",$E(X,1,30),DA)
404.95,.02 CREATOR 0;2 POINTER TO NEW PERSON FILE (#200)
LAST EDITED: MAR 13, 1996
DESCRIPTION:
This field contains the name of the creator of the template.
CROSS-REFERENCE: 404.95^AC
1)= S ^SD(404.95,"AC",$E(X,1,30),DA)=""
2)= K ^SD(404.95,"AC",$E(X,1,30),DA)
404.95,.03 ACCESS LEVEL 0;3 SET
'1' FOR PRIVATE;
'2' FOR PUBLIC;
LAST EDITED: APR 19, 1996
DESCRIPTION: When a template is created, the creator designates whether the template is a private template or a
public template. Public templates can be used by other users but can only be edited by the creator.
Another user can copy the template with the 'save as' command and then make modifications.
CROSS-REFERENCE: 404.95^AD
1)= S ^SD(404.95,"AD",$E(X,1,30),DA)=""
2)= K ^SD(404.95,"AD",$E(X,1,30),DA)
Allows quick retrieval of 'public' templates.
404.95,.04 REPORT 0;4 POINTER TO SCHEDULING REPORT DEFINITION FILE (#404.92)
LAST EDITED: MAR 06, 1996
DESCRIPTION:
This field indicates the report that the template's pre-defined specifications are applied against.
CROSS-REFERENCE: 404.95^C
1)= S ^SD(404.95,"C",$E(X,1,30),DA)=""
2)= K ^SD(404.95,"C",$E(X,1,30),DA)
404.95,.05 LAST SAVED DATE/TIME 0;5 DATE
INPUT TRANSFORM: S %DT="ESTXR" D ^%DT S X=Y K:Y<1 X
LAST EDITED: APR 08, 1996
DESCRIPTION:
Date and time the user lasted saved this template.
404.95,10 DESCRIPTION 1;0 WORD-PROCESSING #404.9501
DESCRIPTION:
Personal description for template specified by the template's creator.
LAST EDITED: MAR 06, 1996
404.95,30 FIELDS FIELDS;0 POINTER Multiple #404.9502
DESCRIPTION:
This multiple contains the field names and user specified values needed by the REPORT (#.04).
404.9502,.01 FIELDS 0;1 POINTER TO SCHEDULING REPORT FIELDS DEFINITION FILE (#404.93) (Multiply asked)
LAST EDITED: MAR 06, 1996
DESCRIPTION:
Name of the field used by the REPORT (#.04).
CROSS-REFERENCE: 404.9502^B
1)= S ^SD(404.95,DA(1),"FIELDS","B",$E(X,1,30),DA)=""
2)= K ^SD(404.95,DA(1),"FIELDS","B",$E(X,1,30),DA)
404.9502,.02 VALUE 0;2 FREE TEXT
INPUT TRANSFORM: K:$L(X)>100!($L(X)<1) X
LAST EDITED: MAR 06, 1996
HELP-PROMPT: Answer must be 1-100 characters in length.
DESCRIPTION: Criteria value specified by the user for the field. This value is used during report execution
and displayed to the user in the Query Template Utility.
404.95,40 SELECTIONS FILES;0 VARIABLE POINTER Multiple #404.9503
DESCRIPTION: This multiple contains the list of file entries selected by the user to meet the report criteria
selection requirements.
404.9503,.01 SELECTIONS 0;1 VARIABLE POINTER (Multiply asked)
FILE ORDER PREFIX LAYGO MESSAGE
4 1 D n DIVISION
403.46 2 R n ROLE
404.51 3 T n TEAM
200 4 P n PRACTITIONER
44 5 C n CLINIC
8930 6 U User Class
SCREEN ON FILE 44: SET DIC("S")="IF $P(^(0),U,3)[""C"""
SCREEN EXPLANATION: Allows only clinics.
LAST EDITED: MAR 06, 1996
DESCRIPTION: This field contains the user selected file entry. The entry meets one of the report criteria
selection requirements.
CROSS-REFERENCE: 404.9503^B
1)= S ^SD(404.95,DA(1),"FILES","B",$E(X,1,30),DA)=""
2)= K ^SD(404.95,DA(1),"FILES","B",$E(X,1,30),DA)
3)= Required Index for Variable Pointer
FILES POINTED TO FIELDS
NEW PERSON (#200) CREATOR (#.02)
SCHEDULING REPORT DEFINITION
(#404.92) REPORT (#.04)
SCHEDULING REPORT FIELDS DEFIN
(#404.93) FIELDS:FIELDS (#.01)
INPUT TEMPLATE(S):
PRINT TEMPLATE(S):
SORT TEMPLATE(S):
FORM(S)/BLOCK(S):