Format Options for Pattern Roles

The following table describes the most commonly used format options for this field (case-sensitive).

Table 6-3 Format Options for Pattern Roles

Format Option	Description
STRING	Does not apply formatting to the value returned from the database. This format is also useful for numbers that should not have thousands separators, for example, numeric account numbers.
INTEGER	Applies thousands separators to whole numbers.
REAL2	Applies thousands separators to real numbers, truncating to two digits of fractional data.
REAL5	Applies thousands separators to real numbers, truncating to five digits of fractional data.
$.00	Applies thousands separators and a currency symbol, e.g., $, to a number. Fractions are displayed. For example, a positive number is displayed as $1,234.56 and a negative number is displayed as ($1,234.56).
$	Applies thousands separators and a currency symbol to a number. Fractions are rounded to the nearest whole number. For example, positive numbers are displayed as $1,234 and negative numbers are displayed as ($1,234).
$K	Applies thousands separators and a currency symbol to a number. Fractions are rounded to the nearest whole number. If the number is 1,000,000 or greater, the system rounds the number to the nearest thousand, and replaces the final three digits with the letter K.For example, positive numbers display as $1,234or $2,346K for $2,345678.90, while negative numbers display as ($1,234) or ($2,346K) for -$2,345678.90.
CURRENCY	Applies the appropriate currency format (base currency of installation) to a value.
MMDDYY	Displays the short form of the date, for example, 02/28/01.
MMDDYYYY	Displays the long form of the date is displayed, for example, 02/ 28/2001.
DATETIME	Displays the short date format and time format in the 24-hour clock,for example, 02/28/01 23:59:59.
HHMMSS	Displays the long time format in 24-hour clock. The expected input is an integer that represents a number of seconds. For example, the display of 93599 seconds is 25:59:59.
HHMMSS_PT	Displays the long Time format in 24-hour clock with milliseconds precision. For example, the display of 103001500 willbe as 10:30:01:500
%	Displays the data as a percentage.
ALT_CUR	Used for cases where all highlights/roles are of the same currency, but NOT base currency. The format for the amount(s) should be ALT_CUR. Then, the scenarios will record an additional binding with binding name Alt_Currency_Code that holds the currency code. The highlights generator would then/take find the value from the Alt_Currency_Code binding and use it to format all of the bindings with format ALT_CUR. For example: OrderPrice role with format ALT_CUR and Alt_Currency_Code binding with value as ISSUE_CRNCY_CD from pattern, let's say value is EUR. Thus OrderPrice will be displayed as xxx EUR. Here xxx is the value coming from pattern.
REF_CUR	Used for cases where all highlights/roles are not of the same currency (including base currency) or different bindings having different currencies to display, use a format code REF_CUR for the amount, and then have an additional binding with the same name, but with _CUR on the end and contain the currency to be used. For example, define TradePrice and ActivityPrice roles with format REF_CUR and TradePrice_CUR, and ActivityPrice_CUR binding to hold the Currency to be used for the above, say EUR and USD respectively. Thus they will be displayed as TradePrice : xxx EUR & ActivityPrice : zzz USD. Here xxx and zzz are the values coming from pattern.