5.4 AML Event Scoring

This section explains about AML Event Scoring use case.

Prerequisites

Before creating the sandbox workspace, the user should follow these steps:

1. Create the Tablespace
2. Create the Sandbox Schema
3. Assign Grants to the Sandbox Schema
4. Create a new data store for the sandbox schema
5. Register Conda Environment in BD Production Workspace

To create tablespace, sandbox schema and assign grants to sandbox schema, see the OFS Compliance Studio Installation Guide.

To create the data store, see How to Create Data Store section.

To register Conda Environment in BD Production Workspace, see How to Register Conda Environment in BD Production Workspace section.

Schema Grants for AML Event Scoring

In Production Workspace:

For AML event scoring, production workspace is attached to the BD atomic schema, whereas AML event scoring reads tables/data from ECM atomic schema.

Assuming both BD and ECM atomic schemas are on the same database, hence SELECT grant on few of the listed ECM tables, to be provided to BD atomic schema by running set of grants in ECM atomic schema.

To grant schema for AML Event scoring in the Production workspace, follow these steps:

1. Execute the following query in the ECM atomic schema and replace <BD_ATOMIC_SCHEMA> placeholder with actual value of the BD atomic schema:

   select 'GRANT SELECT ON '||TABLE_NAME ||' TO <BD_ATOMIC_SCHEMA>;'
   GRANTS FROM USER_TABLES WHERE TABLE_NAME like 'FCC_%';

   select 'GRANT SELECT ON '||TABLE_NAME ||' TO <BD_ATOMIC_SCHEMA>;'
   GRANTS FROM USER_TABLES WHERE TABLE_NAME like 'KDD_%';

   These two queries will return you set of grants which needs to be executed in the ECM atomic schema.

2. Copy the grants and execute them in the ECM atomic schema.

In Sandbox Workspace:

Create a new schema in the database where sandbox target schema exists. Use ECM production data dump to populate this new schema and let’s call this new schema as ECM Dump Schema.

For AML event scoring, Sandbox workspace is attached to empty target schema called as Sandbox Schema, where data has to come from ECM Dump schema. The ECM Dump and Sandbox schemas are on the same database, hence SELECT grant on few of the listed ECM Dump tables, to be provided to Sandbox schema by running set of grants in the ECM Dump atomic schema.

To grant schema for AML Event scoring in the Sandbox workspace, follow these steps:

1. Execute the following query in the ECM Dump schema and replace <SANDBOX_SCHEMA> placeholder with actual value of the sandbox schema:

   select 'GRANT SELECT ON '||TABLE_NAME ||' TO <SANDBOX_SCHEMA>;' GRANTS
   FROM USER_TABLES WHERE TABLE_NAME like 'FCC_%';

   select 'GRANT SELECT ON '||TABLE_NAME ||' TO <SANDBOX_SCHEMA>;' GRANTS
   FROM USER_TABLES WHERE TABLE_NAME like 'KDD_%';

   These two queries will return the set of grants which needs to be executed in the ECM Dump schema.

2. Copy the grants and execute them in the ECM Dump schema.