Fields and Field Types

Fields represent the smallest units of data storage in an APPX application. Each field contains an item of information in a database. While a domain establishes a set of common attributes (such as required physical storage space) for one or more fields, it is the field that is used to store application data. The data information stored in a field is referred to as a field value. Fields are grouped together as records stored within files.

There are thirteen types of fields in the APPX data dictionary:

Domain

Fields are fields that directly express the attributes defined in a domain while they define and occupy new physical space in a file. There are nine distinct domain-type fields: Alpha, Format, System, Text, Token, Date, Logic, Numeric, and Same As. Refer to the Domains and Domain Types section for additional information. You can choose to set up physical fields to exclusively reference domains, or you can set up individual field types directly.

Alpha

Fields are comprised of numbers, letters, and special characters (-, #, or &, for example).

Format

Fields are like alpha fields except that an edit mask is the primary characteristic.

System

Fields, often referred to as audit fields, display data that is provided by the system.

Text

Fields allow the user to enter blocks of text on the data entry screen.

Token

Fields are like alpha fields, except that they have specific values that are stored as corresponding numbers.

Numeric

Fields are restricted to number, decimal (.), and sign (-) entries.

Date

Fields are patterns for fields that contain dates and/or times, from centuries through hundredths of a second.

Logic

Fields are fields with possible values of yes or no , or to represent an unknown value.

Synonym

Fields provide alternative names for referencing existing APPX fields. They occupy no physical space in a file aside from the fields they reference.

Substring

Fields represent discrete portions of longer alphanumeric fields. They occupy no physical space in a file aside from the fields they are a part of.

Group header

Fields are used to group other fields by identifying the beginning and ending fields in a group of fields. The group can then be referenced by the name of the group header field. Group headers occupy no physical space in a file aside from the fields that comprise the group.

Group trailer

Fields are optional placeholders to allow for terminating a group without referencing a physical field. They provide a streamlined method to allow for additions to the end of groups. They also provide visual clues as to the ends of groups when scanning the Data Dictionary. Group trailers occupy no physical space in files.