Type and format of Custom Field values. For example, a custom field defined as a ZIPCODE field can store up to 10 characters in the format XXXXX-XXXX.
NONE is the default.
These values are case-sensitive.
Value | Description |
---|---|
Audit | Audit - Login id, name of the user or last-change date time of the user information for the specified field Id. |
X | Checkbox - A single character alpha field that functions as a checkbox and accepts only X. |
DATE | DATE - A date value in the format yyyy-MM-dd |
DECIMAL | DECIMAL - A numeric field with one or more decimal digits |
DECIMAL_1 | DECIMAL_1 - A numeric field allowing up to 1 decimal digits |
DECIMAL_2 | DECIMAL_2 - A numeric field allowing up to 2 decimal digits. |
DECIMAL_3 | DECIMAL_3 - A numeric field allowing up to 3 decimal digits. |
DECIMAL_4 | DECIMAL_4 - A numeric field allowing up to 4 decimal digits. |
DECIMAL_5 | DECIMAL_5 - A numeric field allowing up to 5 decimal digits. |
DECIMAL_6 | DECIMAL_6 - A numeric field allowing up to 6 decimal digits. |
DECIMAL_7 | DECIMAL_7 - A numeric field allowing up to 7 decimal digits. |
DECIMAL_9 | DECIMAL_9 - A numeric field allowing up to 9 decimal digits |
DECIMAL_10 | DECIMAL_10 - A numeric field allowing up to 10 decimal digits |
DROPDOWNLIST | DROPDOWNLIST - A dropdown list from which the user selects a predefined value. |
DROPDOWN | DROPDOWN - Editable - A dropdown list that allows the user to enter text. The user can type a value or select from the list of predefined values. |
INTEGER | INTEGER - A numeric field, with no decimal places. |
MONTHDAY | MONTHDAY - A 5-character numeric field for recording a date in the format mm-dd. |
PHONE | PHONE - A 17-character alpha/numeric field for recording a phone number in the format 111-111-1111 1111. Positions 4 and 8 contain dashes (-), and position 13 is a blank space. |
SSN | SSN - An 11-character numeric field for recording a social security number. Positions 4 and 7 contain dashes. |
STATE | STATE - A 2-character alpha field for recording a state abbreviation. |
STRING | STRING - An alpha/numeric field used to type a series of characters. If the values are numbers, they cannot be used for calculations. A typical use of the String field type is for a street address. |
Y/N | Y/N - A single character alpha field that accepts only Y (for yes) or N (for no). |
ZIPCODE | ZIPCODE - A 10-character numeric field for recording zip codes in the format 11111-1111. Position 6 contains a dash (-). |