5 Loading Custom Data - Placeholder Tables

We can load the custom data related to Case status.

You can use the following CSV files to insert the custom data. And these CSV files have to be uploaded to the Object Store. Then execute the Batch MonitorCSPlaceholderLoad to load the data to the tables.

The following are CSV files to be uploaded to the Object Store:

• YYYYMMDD_PLACEHOLDER1.csv
• YYYYMMDD_PLACEHOLDER1_MAP.csv

Sample files of the above CSV files are available at Financial Crime and Compliance Management Monitor Cloud Service Reference Documents.

The CSV file formats are as follows:

File Name: YYYYMMDD_PLACEHOLDER1.csv

Table 5-1 Sample Data

PLACEHOLDER1_ID	PLACEHOLDER1_CODE	PLACEHOLDER1_CODE_DESC	PLACEHOLDER1_CODETYPE
1	L1	Status of Level 1 Employee	Status
2	L2	Status of Level 2 Employee	Status
3	L4	Status of Level 4 Employee	Status

File Format:

File Name: YYYYMMDD_PLACEHOLDER1_MAP.csv

Table 5-2 Sample Data

PLACEHOLDER1_ID	PLACEHOLDER1_CODEVAL	PLACEHOLDER1_CODETYPE
1	INV	Case Status
1	NW	Case Status
2	INV	Case Status
2	CLS	Case Status
3	NW	Case Status

Note:

The sample text file name YYYYMMDD_FILEWATCHER.txt (empty file) must be pushed along with the above mentioned CSV files.