5 Loading Custom Data - Placeholder Tables

We can load the custom data related to Case status.

Note:

Monitor CS Placeholder Load Batch is failing at FCCRPLACEHOLDER1DIM_FILETRANSFER TASK due to network issue, and therefore there can be some entries in fcc_m_metadata_import_log table which are in unsuccessful state.

Workaround is to delete the entries in the table fcc_m_metadata_import_log which are in unsuccessful status and redeploy MonitorCS Metadata job.

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

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 must be pushed along with the above mentioned CSV files.