7.10 Configuring Additional Columns on the Alert List page

This configurability allows you to add additional column(s) on the Alert Search and List page and view additional information.

It also provides configurability to execute the customized query to fetch the data in the columns against each Alert ID and shows the new columns in the Columns drop-down list while saving the view.

To add a column on the Search and List page and filters, follow these steps:

1. Add an entry in this table "FCC_SANC_LIST_PAGE_CONFIG" to configure a new value in the column drop-down section for FCC_ZCS_ENTITY_ALERTS.
   See fcc_sanc_list_page_config.xlsx file with sample entries for Case ID and Watchlist primary name.

   Note:

   Add an entry only for the DEFAULT view. "TABLE_NAME" column must have 'FCC_ZCS_ENTITY_ALERTS' value "COLUMN_NAME" column must have actual column name value in the parent table like V_CASE_ID, WATCHLIST_PRIMARY_NAME, and so on.
2. Add an entry in this table "FCC_SAN_LIST_CONFIG" to configure a new value in the filter search section for CS_LIST_FILTER.
   See fcc_san_list_config.xlsx file with sample entries for Case ID and Watchlist primary name.
3. Add an entry in this table "FCC_SAN_LIST_CONFIG_TL" to configure a new value in the filter search section.
   See fcc_san_list_config_tl.xlsx file with sample entries for Case ID and Watchlist primary name.

   Note:

   N_CONFIG_ID column value in this table must match with N_CONFIG_ID value in "fcc_san_list_config" table.
4. Update "v_query" column in this table "FCC_SANC_LIST_PAGE_QUERY_CONF" where "V_QUERY_IDENTIFIER" column value is 'CS_ALERT_LIST_GRID', with the new column details in select query to get the data for new column.
5. (Optional step): If you are trying to configure the column from the existing listed tables in the query. If not, follow the below step, Update "v_query" column in this table "FCC_SANC_LIST_PAGE_QUERY_CONF" where "V_QUERY_IDENTIFIER " column value is 'CS_ALERT_LIST_COUNT' with the new column details in select query to get the updated count value.
6. Now insert the below script in the config schema where application is installed. Make an entry into messages_en_us table with MSG_IDENTIFIER column value starting with 'ZCS_'and BUSINESS_DISPLAY_NAME column value given in FCC_SANC_LIST_PAGE_CONFIG table. MSG_DESCRIPTION value should be the name which should be displayed on the UI.

   Note:

   If there is any space exist's in BUSINESS_DISPLAY_NAME column value replace with underscore('_').For Example: If BUSINESS_DISPLAY_NAME column value is Alert ID then the MSG_IDENTIFIER column value should be like ZCS_Alert_ID.

   After insertion please restart the server.

7. Next open the CSMessageConstants.jsp file from the <Installed Sanctions Path>/Customer Screening Directory. For example, ECM808SAN.war path }/CustomerScreening
   Add the below line:
   CSMessageConstants.MSG_IDENTIFIER = "%=MessageFramework.getMessageFromLocaleSpeficCache("RENDERER.MSG_IDENTIFIER", currentMsgLocale.toString())%>"; Search for alertListColMap and add the below line: alertListColMap.set(MSG_IDENTIFIER,CSMessageConstants.MSG_IDENTIFIER);

   Note:

   Replace MSG_IDENTIFIER with the actual Value which is inserted into messages_en_us table in the above step.