Category Types
When you are setting up the definition of a category, you must choose the type of data that will be stored in the field. You can select from one of the following options. When data is being entered, Emplifi Agent will always verify that the data is of the correct type.
Type | Description |
|---|---|
String | A free-form string value. The length of the string, as well as any capitalization rules can be set by using the appropriate properties of the category. |
Category Code | This is a category that includes a listing of possible code values. You will define the available codes in a subsequent step once the category definition is complete.
|
Integer (n) | A numeric value with no decimal places. The value of N is specified by setting the Character Length field in the category definition. |
Numeric (n.2) | A numeric value that will always 2 decimal places. The total number of digits (N+2) is specified by setting the Character Length field in the category definition. |
DateTime | This field will include both a date and time component. The data formats will be the ones specified in the Emplifi Agent System Parameters. |
System DateTime | This is similar to the DateTime format, except that the value entered will be automatically adjusted based on the value of the Time Zone in the System Parameters prior to being written to the database. Likewise, when the value is read from the database, it will be re-adjusted to the local time based on the Time Zone defined. |
Date | A date is entered and displayed in the specified format. There are several different formats from which to choose:  Under normal circumstances, we recommend that you use only the first setting. Other settings are not supported for searching and filtering, and are therefore not as useful in many circumstances. Regional formatting is taken into account on the first two settings. In other words, if the standard date format in your locale is "dd/mm/yyyy," using the first setting will format dates in that format. |
Time (HH:MM 24hr) | A time value that is displayed and entered in 24-hour format. |
Julian (YJJJ) | These are special date fields that include the day of the year. This is represented by the "JJJ" in the format code.  |
Case ID Ref | This type of field allows you to create a reference to other cases in Emplifi Agent. This type of field enables some special functionality that is described in detail on the topic on Codes and Browsing in the User's Guide. |
Code + Table | This value is not user-selectable. It is set automatically by the system on certain pre-defined categories. This is similar to a Category Code, but each individual code can also have additional data associated with it that is stored in a separate table. An example would be the category for Product. Each product is a code, and each code may have additional details, such as a price, size, color, dimensions, or any other values that you define.
|
Other Table | This value is not user-selectable. It is set automatically by the system for certain categories. |
Special Code | This value is not user-selectable. It is set automatically by the system for certain categories. |
Sensitive Data | Data that is to be stored outside of the database in a secure audited repository. See Sensitive Data Storage and Service Overview. |
Real Integer | Similar to Integer but uses the database native data type. |
Real Number | Similar to Numeric but uses the database native data type. |
Real DateTime | Similar to DateTime but uses the database native data type. |
For codes defined with a Type of "Category Code" and a Capitalize Type set to "None," duplicate codes may be created due to inconsistent use of capitalization when entering the Category ID. We recommend that you set the capitalization type to either "All Upper," "All Lower," or "Force Mixed." This will eliminate a code from being added more than once due to difference of capitalization.