| Contents: | Main | Chapter | See Also: | Getting Started Manual | Advanced User Manual | |||
Each entry in a file corresponds to a positive-valued key subscript, the internal entry number, of the file global. All data pertaining to an entry is stored in Global nodes descendent from that subscript. The value of the .01 field of an entry is always stored in the first ^-piece of subscript Zero, descendent from the internal entry number subscript. Thus, for entry #1, an employee named THREE FMEMPLOYEE, you would have:
Figure 359: File Entries (Data Storage)—Sample File Entry
^EMP(1,0)="FMEMPLOYEE,THREE^"
Suppose you want to store the following data:
You would have what is shown in Figure 360:
Figure 360: File Entries (Data Storage)—Sample File Entry with Additional Data Fields
^EMP(1,0)="FMEMPLOYEE,THREE^M^2341225^3"
Notice that the entry for the employee's department in this file is a number. This means that the employee's department is internal entry number 3 in the (fictitious) DEPARTMENT file; and to find the employee's department, you would have to consult that file. The 7-digit number representing the employee's date of birth (e.g., 2341225) is VA FileMan's way of internally representing 12/25/1934.
How is Multiple-valued data (e.g., skill) stored? There can be one or five or ten skills on file for a given employee and they obviously cannot all be stored (in the general case) in a single subscript. VA FileMan's answer is to make the skills list a subfile within the employee entry. This requires adding subscripts beyond the first internal key subscript that are different in value from the Zero subscript that stores each employee's name, sex, and birth date. For example, if THREE FMEMPLOYEE currently has two (FREE TEXT) skills on file, you can consider those to be entries #1 and #2 in a two-entry file, which can extend at a lower level from any unused subscript, say from SX as shown in Figure 361:
Figure 361: File Entries (Data Storage)—Sample File Entry with Multiple Data Fields
^EMP(0)="EMPLOYEE^3I^9^3"
^EMP(1,0)="FMEMPLOYEE,THREE^M^2341225^3"
^EMP(1,"SX",0)="^3.01A^2^2"
^EMP(1,"SX",1,0)="TYPING"
^EMP(1,"SX",2,0)="STENOGRAPHY"
Notice that the (fictitious) data global ^EMP has ^EMP(1,"SX",0) for the SKILL Multiple. The Zero node, except for the first ^-piece, has the same structure as ^EMP(0). The second ^-piece is the subfile ^DD number. This tells VA FileMan which subsidiary dictionary to use for the data stored in this node. The actual data (the employee's skills in the example) are stored in the next lower level of subscripting. In the same manner that entries in the (fictitious) EMPLOYEE file have internal entry numbers, entries in the Multiple field also have internal entry numbers in the subfile. In the example above, TYPING is the first entry and STENOGRAPHY the second.
Reviewed/Updated: May 2026