Register Field Types

This page allows data types for Codes 1-12 to be modified to be properly entered and stored. Options are Text (default), Numeric, or Date. Changes to these Field Types will change the column data type in the database tables after saving. For these flexible Code fields, if using Code1 as a numeric value, it is not necessary to refer to |Code1| as !|Code1| to return a number instead of a string if stored as a string (text), though that syntax is still supported.

The Administrator can only change the data type before data is stored.

NOTE: If an Administrator changes the data type on this screen so it differs from Text, they must change the default Excel load templates in the header tokens to reference the proper data type, since Text is the default. Otherwise, loads from these template fail.