Customizing Field Names

Customizing Field Names

  1. Click the System Admin
  2. In the Navigation pane, click the plus sign (+) next to System Settings. Click Field Customization.
  3. The Field Customization list appears, displaying the names of all the database tables. Double click the table name.
  4. The Field Customization window opens displaying the selected table’s field names. The following columns of information display with read only columns italicized:
    • Original Field Name* – displays the default field name. This is a read only field.
    • Custom Field Name – type-in the new field name. If this field appears in multiple tables’ CAIRS automatically changes each instance of this field.
    • Mask – type-in the mask for the field. A mask defines allowable character types within the field. For instance, if you entered in a group of pound (#) signs as the mask, only numbers would be allowed in the field.
    • Minimum Length – type-in the minimum number of characters allowed in the field.
    • Maximum Length – type-in the maximum number of characters allowed in the field.
    • Data Type – displays the type of data. This is a read only field.
    • Is Drop Down – click on the field to insert a checkmark in the box indicating this field will have a drop-down box associated within it.
    • Is Currency – click the field to insert a checkmark in the box indicating this field is for currency.
    • Required By Admin – click the field to insert a checkmark in the box indicating that your CAIRS administrator requires the field.
    • Required by System – if this field is a system requirement, the box contains a checkmark; these fields are required to maintain a consistent and relational database.
    • Custom Field Help – type-in a brief statement that appears when the customer scrolls over the field name.
  1. Within the Actions ribbon group, click Save (to save and stay), or Save & Close (to save and exit).