5.2.1.2 Uploading Data using Excel

Excel upload helps you to upload all ready-to-use metadata for multiple jurisdictions across different rules or risk parameters. If there is data for one jurisdiction from the UI, you can copy data from one jurisdiction to the other.

You can upload the following Excel sheets in the UI:

• APPLN_REREVIEW_PARAMS: Enter the appropriate values in all the columns.
• APPLN_RISK_RATING_PARAMS: Ensure that the total weight of all the risk parameters you have uploaded equals 100.
• DIM_RISK_CATEGORY: Ensure that the minimum range of consecutive rows equals the previous maximum range. For example, if the value in one row is 5-10, the value in the next row must be 10-15.

  Note:

  The value in the N_RISK_CATEGORY_KEY column must be a unique value across jurisdictions and customer type codes.
• DIM_ACCT_CUST_ROLE_TYPE: Ensure that the value in the F_CONTROLLING_ROLE column is Y to consider the risk parameter for interested party calculations.

  APPLN_PARAMS

  APPLN_RB_PROCESSING

  DIM_WLS_FEEDBACK

  Note:

  After uploading data, you can modify the values in the columns of all the excels except for the DIM_ACCT_CUST_ROLE_TYPE excel through the UI. All column values must be according to the data types and expected character length. Refer to the sample values shown for the default jurisdiction to know what values must be provided.

You can also add a new rule, rule value, or risk parameter through the UI. For more information, see Adding Risk Parameters and Rules (KYC Batch).