Each option in the Data Type drop-down menu acts as a category that best represents the values to be stored in the database for a Keyword Type.
After initial configuration, a Keyword Type's data type cannot be changed in the Administration Portal.
The following options are available from the Data Type drop-down menu:
Data Type |
Description |
---|---|
Numeric (Up to 9 Digits) |
Numbers up to nine digits in length. Numeric data types truncate leading zeros. When leading zeros should remain (such as in a Social Security Number), use the Alphanumeric data type. Wildcard characters cannot be used when performing a document search by Numeric data type Keyword Types. For Keyword Types that should be searchable with wildcard characters, use the Alphanumeric data type. |
Numeric (Up to 20 Digits) |
Numbers up to twenty digits in length. Numeric data types truncate leading zeros. When leading zeros should remain (such as in a Social Security Number), use the Alphanumeric data type. Wildcard characters cannot be used when performing a document search by Numeric data type Keyword Types. For Keyword Types that should be searchable with wildcard characters, use the Alphanumeric data type. |
Date |
The date. It must be formatted as MM/DD/YYYY. This data type uses the Windows Regional Settings to determine the format required for input of date Keyword Types. Note:
Searching for documents by date and indexing documents with date Keyword Types using a workstation with a non-delimited date format is not supported in the OnBase Client. Note:
01/01/1753 is the earliest date that can be stored in OnBase. |
Date & Time |
The date and time. It must be formatted as MM/DD/YYYY HH:MM:SS: AM (or PM). This data type is usually associated with a computer generated value. If a Date & Time Keyword Type is going to be processed into the system, see the note below for the proper format. Note:
In any process that includes a date, Windows Regional Settings can affect date formatting. If the date or date and time Keyword Types are not being populated correctly, the Keyword Type may be configured incorrectly for your Regional Settings. The correct format is YYYY-MM-DD HH:MM:SS. This format will work regardless of what the Regional Settings are. Note:
Searching for documents by date and indexing documents with date and time Keyword Types using a workstation with a non-delimited date format is not supported in the OnBase Client. Note:
When indexing a document that contains the Date & Time Keyword Type, if a user does not enter a time, but does enter a date, the time will default to 12:00:00: AM. Note:
01/01/1753 is the earliest date that can be stored in OnBase. |
Currency |
Formatted as a monetary amount based on Regional Settings or configured Currency Formats.
|
Specific Currency |
Formatted as a monetary amount, but is used when multiple currency formats are used in the same Keyword Type based on configured Currency Formats. See the System Administration documentation for more information.
Note:
This setting is not supported for AutoFill Keyword Sets. |
Floating Point |
Numeric values that have variable decimal point locations. (Examples include interest rates and ratios.) Note:
Floating point Keyword Values are not recommended for tasks that rely on an exact value, such as cross-referencing and retrieving documents. For tasks that require exact values, use an alphanumeric Keyword Type to store the values. See Notes on Floating Point Keyword Values for more information. |
Alphanumeric |
Any value with letters and/or numbers. Note:
Only = and <> search operators are available for use when retrieving documents with alphanumeric Keyword Types. |
If the Alphanumeric data type is selected, there are additional settings to consider:
Alphanumeric Setting | Description |
---|---|
Max Length |
Specifies the maximum length of the Keyword Type. When entering or updating the value of this field, note the following:
|
Allow mixed-case values |
If enabled, any Keyword Value entered upon indexing is case-sensitive, using both upper and lower case characters. If disabled, values are stored in uppercase characters. When enabling or disabling this setting, note the following:
|
Use dual tables to reduce storage for repeated values |
If enabled, two tables are used to store the Keyword Values in the database, in order to minimize storage for repeated character strings and maintain fast retrieval of documents in these instances. If disabled, a single table is used to store the Keyword Values, and each table has a differently named row for the Keyword Value. When enabling or disabling this setting, note the following:
|