Configuring Status To User Role Table

Within Watch List Management, each watch list and watch list entry (referred to as a “Watch List Member” on the Watch List Management UI) is assigned a status.

In addition to the rules defined earlier in this chapter for accessing Watch List Management, OFS AM uses this status to limit user access to watch lists and watch list entries within the Watch List Management. For example. a WLM Supervisor user role can view "Active" watch lists and watch list entries only if the user role "WLM Supervisor" is mapped to status "Active". These mappings reside in the Status To User Role table and are applicable only to the Watch List Management. Each mapping of status to user role applies to both watch lists and watch list entries.

Mapping Status to Role in the Database through Scripts

You can create a Status to User Role mapping in the database by following these steps:

1. Add the appropriate record to the KDD_STATUS_ROLE database table, which the following table describes.

   Table 8-10 KDD_STATUS_ROLE Table Attributes

   Business Field	Column Name	Date Type	Definition	Null
   Status Code	STATUS_CD	CHAR(3)	Status that can be accessed by the user role on this record.	Yes
   User Role	USER_ROLE_CD	CHAR(50)	User role that is being assigned access to this status.	Yes

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

   insert into kdd_status_role (status_cd,user_role_cd) values ('ACT','WLSUPVISR')
   insert into kdd_status_role (status_cd,user_role_cd) values ('REJ','WLSUPVISR')

Note:

The KDD_STATUS_ROLE table is pre populated after system initialization with the following records:

Table 8-11 KDD_STATUS_ROLE

STATUS_CD	USER_ROLE_CD
ACT	AMEXAUDITR
ACT	AMEXCUTIVE
ACT	AMINAUDITR
ACT	WLSUPVISR
DAC	WLSUPVISR