A Keyword Type's Data Type determines the kind of values that can stored in the database for that Keyword Type. Selecting a Data Type is a necessary step for Configuring a Keyword Type.
After initial configuration, a Keyword Type's Data Type cannot be changed without the use of the -ROMANZO switch, except to increase the Maximum Length of an Alphanumeric Keyword Type. For more information on changing a Keyword Type's Data Type, see Changing a Keyword Type's Data Type.
The following Data Type options are available:
|
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. |