5.3.2.1 Creating Business Domain in the Database through scripts

To create a business domain, follow these steps:

1. Add the appropriate user record to the KDD_BUS_DMN database table as follows:

   Table 5-5 KDD_BUS_DMN Table Attributes

   Column Name	Description
   BUS_DMN_CD	Single-character code that represents a business domain (for example, a, b, or c).
   BUS_DMN_DESC_TX	Description of the business domain (for example, Institutional Broker Dealer or Retail Banking).
   BUS_DMN_DSPLY_NM	Display name of the business domain (for example, INST or RET).
   MANTAS_DMN_FL	Flag that indicates whether Behavior Detection specified the business domain (Y). If an Currency Transaction Reporting client specified the business domain, you should set the flag to N.

   The KDD_BUS_DMN table already contains predefined business domains for the Currency Transaction Reporting client.

2. Add more records to the table by using a SQL script similar to the sample script:

   INSERT INTO KDD_BUS_DMN (BUS_DMN_CD, BUS_DMN_DESC_TX,BUS_DMN_DSPLY_NM, MANTAS_DMN_FL)VALUES('a', 'Compliance Employees', 'COMP', 'N');INSERT INTO KDD_BUS_DMN (BUS_DMN_CD, BUS_DMN_DESC_TX,BUS_DMN_DSPLY_NM, MANTAS_DMN_FL)VALUES('b', 'Executives', 'EXEC', 'N');

3. Update the KDD_CENTRICITY table to reflect access to all focuses within the business domain with the following command:

   update KDD_CENTRICITY set bus_dmn_st = 'a' where KDD_CENTRICITY. CNTRY_TYPE_CD = 'SC'