STANDARD DATA DICTIONARY #232.6 -- EDP WORKSHEET SPECIFICATION FILE                                               3/24/25    PAGE 1
STORED IN ^EDPB(232.6,  (3 ENTRIES)   SITE: WWW.BMIRWIN.COM   UCI: VISTA,VISTA                                     (VERSION 2.0)   

DATA          NAME                  GLOBAL        DATA
ELEMENT       TITLE                 LOCATION      TYPE
-----------------------------------------------------------------------------------------------------------------------------------
This file contains the specifications for worksheets. Worksheets are comprised of sections. Each of the sections may contain many
'worksheet components'.  


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

POINTED TO BY: DEFAULT WORKSHEET field (#.04) of the CPE ROLE File (#232.5) 
               

CROSS
REFERENCED BY: NAME(B), ROLES(D)

INDEXED BY:    INSTITUTION & AREA (C)




232.6,.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:
                                This is the section name.  

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


232.6,.02     INSTITUTION            0;2 POINTER TO INSTITUTION FILE (#4) (Required)

              LAST EDITED:      MAY 19, 2009 
              HELP-PROMPT:      Enter the institution for this worksheet. 
              RECORD INDEXES:   C (#1091)

232.6,.03     AREA                   0;3 POINTER TO TRACKING AREA FILE (#231.9)

              LAST EDITED:      MAY 19, 2009 
              HELP-PROMPT:      Enter the Tracking Area for this worksheet. 
              RECORD INDEXES:   C (#1091)

232.6,.04     TYPE                   0;4 SET

                                'V' FOR Visit; 
                                'A' FOR Assess; 
                                'P' FOR Plan; 
                                'E' FOR Edit Closed; 
              LAST EDITED:      JUN 13, 2012 
              HELP-PROMPT:      Enter the worksheet type. 

232.6,.05     ROLE                   0;5 POINTER TO USR CLASS FILE (#8930)

              LAST EDITED:      MAY 26, 2009 

232.6,.06     DISABLED               0;6 SET

                                '0' FOR False; 
                                '1' FOR True; 
              LAST EDITED:      JUN 02, 2009 
              HELP-PROMPT:      Enter 'True' if this worksheet should be disabled. 
              DESCRIPTION:
                                This holds the disabled status for the worksheet.  


232.6,.07     EDITABLE               0;7 SET

                                '1' FOR true; 
                                '0' FOR false; 
              LAST EDITED:      MAY 18, 2012 
              HELP-PROMPT:      Enter 'true' if this worksheet should be editable. 
              DESCRIPTION:
                                This holds the editable state for this worksheet.  


232.6,1       SPEC                   1;0   WORD-PROCESSING #232.61   (NOWRAP)   (IGNORE "|")


                LAST EDITED:      APR 16, 2009 
                HELP-PROMPT:      Enter the XML for the worksheet specification. 



232.6,2       SECTIONS               2;0 Multiple #232.62 (Add New Entry without Asking)

              DESCRIPTION:      This multiple holds 'instances' of the sections of the worksheet. Each instance is tied to the
                                worksheet so that its behavior can change on a case by case basis.  

              IDENTIFIED BY:    SECTION(#.02)

232.62,.01      SECTION SEQUENCE       0;1 NUMBER (Multiply asked)

                INPUT TRANSFORM:  K:+X'=X!(X>999)!(X<1)!(X?.E1"."1N.N) X
                LAST EDITED:      MAY 10, 2012 
                HELP-PROMPT:      Type a Number between 1 and 999, 0 Decimal Digits 
                DESCRIPTION:
                                  This is the sequence in which the section will be displayed.  

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


232.62,.02      SECTION                0;2 POINTER TO EDP WORKSHEET SECTION FILE (#232.71)

                LAST EDITED:      MAY 10, 2012 
                HELP-PROMPT:      Enter the section. 
                DESCRIPTION:
                                  This is the section associated with the sequence.  


232.62,.03      INITIALLY OPEN         0;3 SET

                                  '0' FOR FALSE; 
                                  '1' FOR TRUE; 
                LAST EDITED:      MAY 27, 2009 
                HELP-PROMPT:      Enter TRUE if the section should automatically open when loaded. 
                DESCRIPTION:
                                  This is the flag to control whether the section is initially open or closed in the UI.  


232.62,1        CONFIGURATON           1;0   WORD-PROCESSING #232.621   (NOWRAP)   (IGNORE "|")

                DESCRIPTION:      This field is not currently used. It was part of original worksheet development and does not fit
                                  the current models for worksheets.  


                  LAST EDITED:      MAY 27, 2009 
                  HELP-PROMPT:      Enter the configuration XML. 
                  DESCRIPTION:
                                    This is the XML configuration for a section. Currently not used.  




232.62,2        COMPONENTS               2;0 Multiple #232.622

                  DESCRIPTION:
                                    This multiple contains components of this section.  


232.622,.01       COMPONENT SEQUENCE       0;1 NUMBER (Multiply asked)

                    INPUT TRANSFORM:  K:+X'=X!(X>999)!(X<1)!(X?.E1"."1N.N) X
                    LAST EDITED:      MAY 10, 2012 
                    HELP-PROMPT:      Type a number between 1 and 999, 0 decimal digits. 
                    DESCRIPTION:
                                      This is the sequence in which the component will appear within this section.  

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


232.622,.02       COMPONENT                0;2 POINTER TO EDP WORKSHEET COMPONENT FILE (#232.72)

                    LAST EDITED:      APR 05, 2012 
                    HELP-PROMPT:      Select a component. 
                    DESCRIPTION:
                                      This is the component.  


232.622,.03       EDITABLE                 0;3 SET

                                      '1' FOR true; 
                                      '0' FOR false; 
                    LAST EDITED:      MAY 10, 2012 
                    HELP-PROMPT:      Select whether this component will be editable or not. 
                    DESCRIPTION:
                                      This holds the editable status of this component, for this worksheet and section.  


232.622,.04       VISIBLE                  0;4 SET

                                      '1' FOR true; 
                                      '0' FOR false; 
                    LAST EDITED:      MAY 09, 2012 
                    HELP-PROMPT:      Select 'true' if this component will be visible. 
                    DESCRIPTION:
                                      This field controls the visibility of a component.  


232.622,.05       INCLUDE IN SUMMARY       0;5 SET

                                      '0' FOR false; 
                                      '1' FOR true; 
                    LAST EDITED:      MAY 09, 2012 
                    HELP-PROMPT:      Select 'true' to include this component in the summary. 
                    DESCRIPTION:      Setting this field to true will cause the component information to show up in the label
                                      within the section on the UI.  






232.6,3       ROLES                  3;0 POINTER Multiple #232.63

              DESCRIPTION:
                                This multiple holds the roles that can use this worksheet.  


232.63,.01      ROLES                  0;1 POINTER TO CPE ROLE FILE (#232.5) (Multiply asked)

                LAST EDITED:      MAY 10, 2012 
                HELP-PROMPT:      Enter a role for this worksheet. 
                DESCRIPTION:
                                  This is the role associated with this worksheet.  

                CROSS-REFERENCE:  232.63^B 
                                  1)= S ^EDPB(232.6,DA(1),3,"B",$E(X,1,30),DA)=""
                                  2)= K ^EDPB(232.6,DA(1),3,"B",$E(X,1,30),DA)

                CROSS-REFERENCE:  232.6^D 
                                  1)= S ^EDPB(232.6,"D",$E(X,1,30),DA(1),DA)=""
                                  2)= K ^EDPB(232.6,"D",$E(X,1,30),DA(1),DA)





      FILES POINTED TO                      FIELDS

CPE ROLE (#232.5)                 ROLES:ROLES (#.01)

EDP WORKSHEET COMPONENT (#232.72)  COMPONENTS:COMPONENT (#.02)

EDP WORKSHEET SECTION (#232.71)   SECTIONS:SECTION (#.02)

INSTITUTION (#4)                  INSTITUTION (#.02)

TRACKING AREA (#231.9)            AREA (#.03)

USR CLASS (#8930)                 ROLE (#.05)


File #232.6

  Record Indexes:

  C (#1091)    RECORD    REGULAR    IR    LOOKUP & SORTING
      Short Descr:  Index by site and area
        Set Logic:  S ^EDPB(232.6,"C",X(1),X(2),DA)=""
       Kill Logic:  K ^EDPB(232.6,"C",X(1),X(2),DA)
       Whole Kill:  K ^EDPB(232.6,"C")
             X(1):  INSTITUTION  (232.6,.02)  (Subscr 1)  (forwards)
             X(2):  AREA  (232.6,.03)  (Subscr 2)  (forwards)


INPUT TEMPLATE(S):

PRINT TEMPLATE(S):

SORT TEMPLATE(S):

FORM(S)/BLOCK(S):