VA FileMan V. 22.0 Getting Started HTML Manual Banner


 

Main Chapter Getting Started Manual Programmer Manual

List File Attributes


Standard and Modified Standard Data Dictionaries

The most complete information about a file is obtained by using the Standard data dictionary format, which is the default for the List File Attributes option. In addition to detailed information about every field in the file, the Standard data dictionary format gives the file access, identifiers, cross-references, other files pointing to the file, files pointed to by the file, and any templates (including forms and blocks) associated with the file.

Here is a sample data dictionary in Standard format:

STANDARD DATA DICTIONARY #16026 -- PATIENT FILE              05/31/91  PAGE 1
STORED IN ^DIZ(16026,  (1 ENTRY)   SITE: KDEMO V7   UCI: VAH,KXX               

DATA          NAME                  GLOBAL        DATA
ELEMENT       TITLE                 LOCATION      TYPE
-------------------------------------------------------------------------------
A sample file containing some of the fields found in a file of patient 
information in a hospital database.  


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


CROSS
REFERENCED BY: NAME(B)


   CREATED ON: MAR 22,1991


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

              INPUT TRANSFORM:  K:$L(X)>30!($L(X)<3)!'(X'?1P.E) X
              LAST EDITED:      MAR 29, 1991 
              HELP-PROMPT:      Answer must be 3-30 characters in length. 
              GROUP:            DEMOG
              CROSS-REFERENCE:  16026^B 
                                1)= S ^DIZ(16026,"B",$E(X,1,30),DA)=""
                                2)= K ^DIZ(16026,"B",$E(X,1,30),DA)
                                Automatically created regular x-ref used to 
                                look-up and sort entries based on the value in 
                                the .01 (NAME) field.


16026,1       SEX                    0;2 SET (Required)

                                'm' FOR MALE; 
                                'f' FOR FEMALE; 
              LAST EDITED:      MAR 22, 1991 
              GROUP:            DEMOG

16026,2       DATE OF BIRTH          0;3 DATE (Required)

              INPUT TRANSFORM:  S %DT="E" D ^%DT S X=Y K:2630000<X!(1600101>X) 
                                X
              LAST EDITED:      MAR 22, 1991 
              HELP-PROMPT:      TYPE A DATE BETWEEN 1/1/1860 AND 1963 
              GROUP:            DEMOG

16026,3       RELIGION               0;4 POINTER TO RELIGION FILE (#13)

              LAST EDITED:      MAR 22, 1991 

16026,4       DIAGNOSIS              1;0 Multiple #16026.04
                                 (Add New Entry without Asking)

(Page 2)

STANDARD DATA DICTIONARY #16026 -- PATIENT FILE              05/31/91  PAGE 2
STORED IN ^DIZ(16026,  (1 ENTRY)   SITE: KDEMO V7   UCI: VAH,KXX               

DATA          NAME                  GLOBAL        DATA
ELEMENT       TITLE                 LOCATION      TYPE
-------------------------------------------------------------------------------
16026.04,.01    DIAGNOSIS              0;1 FREE TEXT (Multiply asked)

                INPUT TRANSFORM:  K:$L(X)>30!($L(X)<3) X
                LAST EDITED:      MAR 22, 1991 
                HELP-PROMPT:      Answer must be 3-30 characters in length. 
                CROSS-REFERENCE:  16026.04^B 
                                  1)= S ^DIZ(16026,DA(1),1,"B",$E(X,1,30),DA)=""
                                  2)= K ^DIZ(16026,DA(1),1,"B",$E(X,1,30),DA)


16026.04,1      AGE AT ONSET           0;2 NUMBER

                INPUT TRANSFORM:  K:+X'=X!(X>100)!(X<0)!(X?.E1"."1N.N) X
                LAST EDITED:      APR 29, 1991 
                HELP-PROMPT:      Type a Number between 0 and 100, 0 Decimal 
                                  Digits 

16026.04,2      HISTORY                1;0   WORD-PROCESSING #16026.42

16026,5       PROVIDER               2;1          VARIABLE POINTER

              FILE  ORDER  PREFIX    LAYGO  MESSAGE
                 6    1    S            n   STAFF PROVIDER 
                 16   2    O            y   OTHER PROVIDER 
                                         
              LAST EDITED:      MAR 22, 1991 

16026,6       SSN                    2;2 FREE TEXT (Required) (audited)

              Social Security Number    
              INPUT TRANSFORM:  K:$L(X)>9!($L(X)<9)!'(X?9N) X
              LAST EDITED:      MAR 22, 1991 
              HELP-PROMPT:      Enter 9 numbers without dashes. 
              DESCRIPTION:      An entry is required.  If you do not know this
                                patient's Social Security Number, enter
                                '000000000' to indicate the number is unknown.  

              GROUP:            DEMOG

      FILES POINTED TO                      FIELDS

PROVIDER (#6)                     PROVIDER (#5)

PERSON (#16)                      PROVIDER (#5)

RELIGION (#13)                    RELIGION (#3)

INPUT TEMPLATE(S):

PRINT TEMPLATE(S):
CAPTIONED                                         USER #0    
ZZDIAGPRINT                   MAR 29, 1991@12:18  USER #140
   Used to print information from the DIAGNOSIS multiple.

SORT TEMPLATE(S):

FORM(S)/BLOCKS(S):

Modified Standard Format

Another data dictionary format is the Modified Standard format, which allows you to suppress printing the M code and to restrict the listing to specified groups of fields.

For example, the following dialogue eliminates the M code from the Standard listing and only prints those fields in the DEMOG group (NAME, SEX, DATE OF BIRTH, and SSN):

Select LISTING FORMAT: STANDARD// MODIFIED STANDARD
WANT THE LISTING TO INCLUDE MUMPS CODE? N// 
WANT TO RESTRICT LISTING TO CERTAIN GROUPS OF FIELDS? NO// Y 
Include GROUP: DEMOG
And include GROUP: 

NOTE: If you answer the question concerning M code YES and do not specify any groups, the output from the Modified Standard format will be the same as that of the Standard format.

 


Reviewed/Updated: March 4, 2007