The SAS Enterprise Case Management Data Dictionary specifies a definition for database table columns. However, the definition is incorrect for the column named FORMAT_TXT in all tables with a name ending with "_SEARCH_RESULT_FIELD".

The Data Dictionary says that the FORMAT_TXT column is the name of the resource bundle key that contains the display format for numeric and date fields. However, the FORMAT_TXT column is not used for a resource bundle key. Instead, the FORMAT_TXT column contains one of two values:

• The text "user_name" (without the surrounding quotation marks). In this case the search result column is expected to be a user ID, and that user's display name is rendered.
• A number format understood by the java.text.DecimalFormat class. In this case the search result column is expected to contain a number, and the java.text.DecimalFormat class is used to render the number.

Operating System and Release Information