Integer, Number, Boolean, and Calendar Data Types

• Integer The Integer data type stores integer values. This field can have a minimum or maximum value.

  • Modifiers
    • None- Functions exactly as described.
    • Value/Label List- Allows the user to supply a list of all possible values this field can assume, instead of the default attributes. If a user attempts to set a value for a field that is not found on this list, the system will return an error. Each possible integer value is paired with alabel, a string that is displayed on reports and can be input into this field, though Routines still have access to the underlying value.

• Number The Number data type stores floating point values. This field can have a minimum or maximum value. Additionally, the Number data type has a Scale attribute, which is the number of decimal places to display on reports. This attribute does not change the value stored in the system's underlying database, so the number is stored precisely even if no decimal places are shown on reports.

  • Modifiers

    • None- Functions exactly as described.
    • Units- User can select a Measurement attribute, such as length, mass, speed, power, pressure, volume, energy, and others. The user must also select the unit in which the selected measurement is quantified, such as meters for length, kilograms for mass, etc.

    

    If a user selects this modifier, the abbreviation of the selected unit will appear next to the value whenever the system displays the field on reports.

• Boolean The Boolean data type is used to set flags. This data type is used when an object can be one of two states. The field can have the underlying value of True or False, but the user can also supply labels for each of these states.

For example, a field titled "Availability" could have the label "Available" for the true state and "Not Available" for the false state. Such fields appear on embedded editors or filters as a single checkbox with the label of the true state, under the title of the field, but they appear on reports as simply the label of their current states.

• Calendar- The Calendar data type is used to store a date and time. This data type is useful, for example, to store the date and time the system last updated an object. The user can select from a number of possible output formats, such as "17 Jul 2015, 7:13:14 PM", "07/17/15 19:13 PM GMT ", etc.

  • Modifiers

    • Format- The format only controls the way the system displays the field on reports; even if the format is changed after the fact, the stored date/time in all objects remains the same. On an embedded editor, fields of this data type can be set either by an input text box, or by a calendar tooltip that appears on every such input box.