3.1.7 Entity Staging Clean-up

This topic provides information about the Entity Staging Clean-up process.

This batch will clean up the data from the staging area like account, account party, payment, re-payment, bill details and will make staging area ready for the next batch run.

Prerequisite: All staging table for cleanup activity to be configured in lookup for lookup code ENTITY_STAGING_TABLES

Job Name: obcr-entity-staging-cleanup-batch

Dependent Batch/Job: Not Applicable

Multi-threaded: No

Multi-stream: No

URI: <protocol>://obcr-entity-services/jobLauncher/runBatch/

Mandatory Headers:

Table 3-14 Mandatory Headers

Parameter Name	Value	Mandatory	Description
appld	CRENTITY	Yes	The application ID of the host service.

Specify following parameters while executing this batch:

Table 3-15 Parameters

Parameter Name	Value	Mandatory	Description
runDate	16062019	Yes	It must be in ddmmyyyy format.
branchCode	DMO	Yes	Branch code of the project.
userId	ADMINUSER1	Yes	User id of the user.

Success/Failure Details:

• User can verify the record level status in the following tables in CR_ENTITY schema.

  DM_ENTITY_STAGING_DRIVER

• For a successful processing of a record, the below condition should be satisfied.

  ERROR_CODE = Success and PROCESS_RESULT = 1