STANDARD DATA DICTIONARY #102.24 -- CPRS QUERY DISPLAY FIELDS FILE                                                3/24/25    PAGE 1
STORED IN ^ORD(102.24,  (20 ENTRIES)   SITE: WWW.BMIRWIN.COM   UCI: VISTA,VISTA                                    (VERSION 3.0)   

DATA          NAME                  GLOBAL        DATA
ELEMENT       TITLE                 LOCATION      TYPE
-----------------------------------------------------------------------------------------------------------------------------------
This file contains display fields that may be selected.  Each display field may be a column in the results of a query.  For each
display field, the file contains information about how the column should be sorted when clicked and some sample data to assist the
user when setting up the columns.  


              DD ACCESS: @
              RD ACCESS: @
              WR ACCESS: @
             DEL ACCESS: @
           LAYGO ACCESS: @
           AUDIT ACCESS: @

POINTED TO BY: DISPLAY FIELD field (#2) of the FORMAT sub-field (#102.212) of the CPRS QUERY DEFINITION File (#102.21) 
               

CROSS
REFERENCED BY: NAME(B), NAME(C)



102.24,.01    NAME                   0;1 FREE TEXT (Required)

              INPUT TRANSFORM:  K:$L(X)>30!($L(X)<3)!'(X'?1P.E) X
              LAST EDITED:      SEP 29, 2002 
              HELP-PROMPT:      Answer must be 3-30 characters in length. 
              DESCRIPTION:
                                Reference field name (used by software).  

              CROSS-REFERENCE:  102.24^B 
                                1)= S ^ORD(102.24,"B",$E(X,1,30),DA)=""
                                2)= K ^ORD(102.24,"B",$E(X,1,30),DA)

              CROSS-REFERENCE:  102.24^C^MUMPS 
                                1)= S ^ORD(102.24,"C",$$UP^XLFSTR(X),DA)=""
                                2)= K ^ORD(102.24,"C",$$UP^XLFSTR(X),DA)
                                Uppercase index for lookup 



102.24,2      DISPLAY TEXT           0;2 FREE TEXT (Required)

              INPUT TRANSFORM:  K:$L(X)>30!($L(X)<3) X
              LAST EDITED:      SEP 24, 2002 
              HELP-PROMPT:      Answer must be 3-30 characters in length. 
              DESCRIPTION:
                                This is the text that is displayed in the listbox when selecting fields for the report.  


102.24,3      HEADER TEXT            0;3 FREE TEXT

              INPUT TRANSFORM:  K:$L(X)>30!($L(X)<3) X
              LAST EDITED:      SEP 24, 2002 
              HELP-PROMPT:      Answer must be 3-30 characters in length. 
              DESCRIPTION:
                                This is the default text to be used in the header of the report.  


102.24,4      SORT TYPE              0;4 SET

                                'D' FOR date/time; 
                                'F' FOR free text; 
                                'N' FOR numeric; 
              LAST EDITED:      SEP 25, 2002 
              HELP-PROMPT:      Enter the type of sorting that applies to this field. 
              DESCRIPTION:      Specifies the type of sort when the column is sorted.  Date/Time sorts use the internal date/time
                                to sort.  Free text sorts use the visible text for the sort.  


102.24,10     SAMPLE DATA            1;0 Multiple #102.241

              DESCRIPTION:
                                This multiple contains sample data for this type of field that may be in a preview report.  


102.241,.01     VALUE                  0;1 FREE TEXT (Multiply asked)

                INPUT TRANSFORM:  K:$L(X)>80!($L(X)<1) X
                LAST EDITED:      SEP 25, 2002 
                HELP-PROMPT:      Answer must be 1-80 characters in length. 
                DESCRIPTION:
                                  This value should be either a string of text or a date/time in internal Fileman format.  

                CROSS-REFERENCE:  102.241^B 
                                  1)= S ^ORD(102.24,DA(1),1,"B",$E(X,1,30),DA)=""
                                  2)= K ^ORD(102.24,DA(1),1,"B",$E(X,1,30),DA)





INPUT TEMPLATE(S):

PRINT TEMPLATE(S):

SORT TEMPLATE(S):

FORM(S)/BLOCK(S):