STANDARD DATA DICTIONARY #1.5213 -- SQLI_KEY_FORMAT FILE                                                          3/24/25    PAGE 1
STORED IN ^DMSQ("KF",  *** NO DATA STORED YET ***   SITE: WWW.BMIRWIN.COM   UCI: VISTA,VISTA                      (VERSION 22.2)   

DATA          NAME                  GLOBAL        DATA
ELEMENT       TITLE                 LOCATION      TYPE
-----------------------------------------------------------------------------------------------------------------------------------
Strategies for converting base values into key values.  Soundex and upper case conversion are common examples. This implies that 
comparisons of key values with base values must be preceded by conversion of the base value to key value. Key formats are
frequently lossy; they can't be converted uniquely back to base format.  


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

POINTED TO BY: P_KEY_FORMAT field (#7) of the SQLI_PRIMARY_KEY File (#1.5218) 
               

CROSS
REFERENCED BY: KF_NAME(B), KF_DATA_TYPE(C)



1.5213,.01    KF_NAME                0;1 FREE TEXT (Required)

              Key Format   
              INPUT TRANSFORM:  K:$L(X)>30!($L(X)<3)!'($TR(X,"_")?1U.UN) X
              LAST EDITED:      AUG 20, 1996 
              HELP-PROMPT:      Answer must be 3-30 characters in length. 
              WRITE AUTHORITY:  ^
              CROSS-REFERENCE:  1.5213^B 
                                1)= S ^DMSQ("KF","B",$E(X,1,30),DA)=""
                                2)= K ^DMSQ("KF","B",$E(X,1,30),DA)


1.5213,1      KF_DATA_TYPE           0;2 POINTER TO SQLI_DATA_TYPE FILE (#1.5211) (Required)

              LAST EDITED:      AUG 23, 1996 
              HELP-PROMPT:      Enter the ODBC data type of this key 
              WRITE AUTHORITY:  ^
              CROSS-REFERENCE:  1.5213^C 
                                1)= S ^DMSQ("KF","C",$E(X,1,30),DA)=""
                                2)= K ^DMSQ("KF","C",$E(X,1,30),DA)
                                KEY FORMAT BY DATA TYPE 



1.5213,2      KF_COMMENT             0;3 FREE TEXT

              INPUT TRANSFORM:  K:$L(X)>60!($L(X)<3) X
              LAST EDITED:      AUG 20, 1996 
              HELP-PROMPT:      Answer must be 3-60 characters in length. 
              WRITE AUTHORITY:  ^

1.5213,3      KF_INT_EXPR            1;E1,245 MUMPS

              INPUT TRANSFORM:  K:$L(X)>245 X D:$D(X) ^DIM
              LAST EDITED:      AUG 20, 1996 
              HELP-PROMPT:      This is Standard MUMPS code. 
              DESCRIPTION:
                                An M expression which converts X to it's key format 

              WRITE AUTHORITY:  ^

1.5213,4      KF_INT_EXEC            2;E1,245 MUMPS

              INPUT TRANSFORM:  K:$L(X)>245 X D:$D(X) ^DIM
              LAST EDITED:      AUG 20, 1996 
              HELP-PROMPT:      This is Standard MUMPS code. 
              DESCRIPTION:
                                A line of M code which converts X to its key format 

              WRITE AUTHORITY:  ^


      FILES POINTED TO                      FIELDS

SQLI_DATA_TYPE (#1.5211)          KF_DATA_TYPE (#1)



INPUT TEMPLATE(S):

PRINT TEMPLATE(S):

SORT TEMPLATE(S):

FORM(S)/BLOCK(S):