STANDARD DATA DICTIONARY #1.521 -- SQLI_SCHEMA FILE                                                               6/27/25    PAGE 1
STORED IN ^DMSQ("S",  *** NO DATA STORED YET ***   SITE: WWW.BMIRWIN.COM   UCI: VISTA,VISTA                       (VERSION 22.2)   

DATA          NAME                  GLOBAL        DATA
ELEMENT       TITLE                 LOCATION      TYPE
-----------------------------------------------------------------------------------------------------------------------------------
A set of tables and domains. A subset of catalog and environment 


              DD ACCESS: ^
              WR ACCESS: ^
             DEL ACCESS: ^
           LAYGO ACCESS: ^

POINTED TO BY: T_SCHEMA field (#1) of the SQLI_TABLE File (#1.5215) 
               

CROSS
REFERENCED BY: S_NAME(B)



1.521,.01     S_NAME                 0;1 FREE TEXT (Required)

              Schema   
              INPUT TRANSFORM:  K:$L(X)>30!($L(X)<1)!'($TR(X,"_")?1U.UN) X
              LAST EDITED:      AUG 20, 1996 
              HELP-PROMPT:      SQL identifier start with upper case letter, only letters, numbers and _. 
              DESCRIPTION:      In FileMan, application groups are assigned SQL schema names Names are valid SQL identifiers, and
                                are unique by site 

              WRITE AUTHORITY:  ^
              CROSS-REFERENCE:  1.521^B 
                                1)= S ^DMSQ("S","B",$E(X,1,30),DA)=""
                                2)= K ^DMSQ("S","B",$E(X,1,30),DA)


1.521,1       S_SECURITY             1;1 FREE TEXT

              Security   
              INPUT TRANSFORM:  K:$L(X)>12!($L(X)<4) X
              LAST EDITED:      SEP 26, 1996 
              HELP-PROMPT:      Answer must be 4-12 characters in length. 
              DESCRIPTION:
                                A routine to check security by application group.  

              EXECUTABLE HELP:  W ?5,"Routine to check access to schema"
              WRITE AUTHORITY:  ^

1.521,2       S_DESCRIPTION          0;2 FREE TEXT

              Description   
              INPUT TRANSFORM:  K:$L(X)>60!($L(X)<3) X
              LAST EDITED:      AUG 20, 1996 
              HELP-PROMPT:      Describe schema. Answer must be 3-60 characters in length. 
              DESCRIPTION:
                                A short description of the schema 

              WRITE AUTHORITY:  ^


INPUT TEMPLATE(S):

PRINT TEMPLATE(S):

SORT TEMPLATE(S):

FORM(S)/BLOCK(S):