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 the schema for AML Event Scoring in the Production workspace, execute the following query in the ECM atomic schema.

grant select on FCC_EVENT_BINDING to <BD_ATOMIC_SCHEMA>;
grant select on FCC_EVENT_ENTITY_MAP to <BD_ATOMIC_SCHEMA>;
grant select on FCC_EVENT_INVESTIGATION_STATUS to <BD_ATOMIC_SCHEMA>;
grant select on FCC_SCENARIO_MASTER to <BD_ATOMIC_SCHEMA>;
grant select on FCC_EVENT_DETAILS to <BD_ATOMIC_SCHEMA>;
grant select on FCC_EVENT_DETAILS to <BD_ATOMIC_SCHEMA>;
grant select on FCC_EVENTS to <BD_ATOMIC_SCHEMA>;
grant select on FCC_EVENT_STATUS_B to <BD_ATOMIC_SCHEMA>;
grant select on FCC_EVENT_STATUS_TL to <BD_ATOMIC_SCHEMA>;
grant select on KDD_JRSDCN to <BD_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 the schema for AML Event Scoring in the Sandbox workspace, execute the following query in the ECM Dump schema.


grant select on FCC_EVENT_BINDING to <SANDBOX_SCHEMA>;
grant select on FCC_EVENT_ENTITY_MAP to <SANDBOX_SCHEMA>;
grant select on FCC_EVENT_INVESTIGATION_STATUS to <SANDBOX_SCHEMA>;
grant select on FCC_SCENARIO_MASTER to <SANDBOX_SCHEMA>;
grant select on FCC_EVENT_DETAILS to <SANDBOX_SCHEMA>;
grant select on FCC_EVENT_DETAILS to <SANDBOX_SCHEMA>;
grant select on FCC_EVENTS to <SANDBOX_SCHEMA>;
grant select on FCC_EVENT_STATUS_B to <SANDBOX_SCHEMA>;
grant select on FCC_EVENT_STATUS_TL to <SANDBOX_SCHEMA>;
grant select on KDD_JRSDCN to <SANDBOX_SCHEMA>;