Data Transfer Job

3.1.4 Data Transfer Job

This topic provides information about the Data Transfer Job process.

All records processed in the above batches, along with their status (success or failure, including failure reasons), will be transferred to a separate schema through this job. A similar job can then be configured to relay these details to the source system, allowing it to review failed records, make necessary corrections, and resend them for processing.

This Job having two categories such as app configuration and trigger endpoint. Through the App configuration job, source and destination schema tables and column details are mapped. And Trigger endpoint job will transfer data from the source driver tables to destination system.

Mandatory Headers:

Table 3-8 Mandatory Headers

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

Source Schema: CR_ENTITY

Destination Schema: CR_DATAEXCHNG.

Destination Tables: As provided by the host system.

Specify following parameters while executing this batch:

Table 3-9 Data Transfer sample configuration:

Endpoint	Configurations
Host location	https://host:port/plato-fast-data-transfer-service/configurations/applications/CR_DATAEXCHNG/CR_ENTITY_PROCESS_STATUS
Method	POST
Header	`appId:PLATOFDT entityId:DEFAULTENTITY Content-Type:application/json branchCode:BCR userId:AUTOUSER`
Request Body	[ { "srcTable": "DM_ACCOUNT_STG", "destTable": "DM_ACCOUNT_STG_PROCESS_STATUS", "customConfigDatas": [ { "key": "ACCT_NBR", "value": "ACCT_NBR", "configType": "COLUMN_MAPPING" }, { "key": "RCD_TYPE", "value": "RCD_TYPE", "configType": "COLUMN_MAPPING" }, { "key": "PRD_PROCESSR_CD", "value": "PRD_PROCESSR_CD", "configType": "COLUMN_MAPPING" }, { "key": "CRET_DTTM", "value": "CRET_DTTM", "configType": "COLUMN_MAPPING" }, { "key": "LAST_UPDT_DTTM", "value": "LAST_UPDT_DTTM", "configType": "COLUMN_MAPPING" }, { "key": "PROCESS_STATUS", "value": "PROCESS_STATUS", "configType": "COLUMN_MAPPING" }, { "key": "ERROR_MSG", "value": "ERROR_MSG", "configType": "COLUMN_MAPPING" } ] }, { "srcTable": "DM_ACCOUNT_ARREARS_STG", "destTable": "DM_ACCOUNT_ARREARS_STG_PROCESS_STATUS", "customConfigDatas": [ { "key": "ACCT_NBR", "value": "ACCT_NBR", "configType": "COLUMN_MAPPING" }, { "key": "RCD_TYPE", "value": "RCD_TYPE", "configType": "COLUMN_MAPPING" }, { "key": "PRD_PROCESSR_CD", "value": "PRD_PROCESSR_CD", "configType": "COLUMN_MAPPING" }, { "key": "CRET_DTTM", "value": "CRET_DTTM", "configType": "COLUMN_MAPPING" }, { "key": "LAST_UPDT_DTTM", "value": "LAST_UPDT_DTTM", "configType": "COLUMN_MAPPING" }, { "key": "PROCESS_STATUS", "value": "PROCESS_STATUS", "configType": "COLUMN_MAPPING" }, { "key": "ERROR_MSG", "value": "ERROR_MSG", "configType": "COLUMN_MAPPING" }, { "key": "ARS_TYP_CD", "value": "ARS_TYP_CD", "configType": "COLUMN_MAPPING" }, { "key": "REFERENCE_VAL", "value": "REFERENCE_VAL", "configType": "COLUMN_MAPPING" } ] }, { "srcTable": "DM_ACCOUNT_BILL_DTLS_STG", "destTable": "DM_ACCOUNT_BILL_DTLS_STG_PROCESS_STATUS", "customConfigDatas": [ { "key": "ACCT_NBR", "value": "ACCT_NBR", "configType": "COLUMN_MAPPING" }, { "key": "RCD_TYPE", "value": "RCD_TYPE", "configType": "COLUMN_MAPPING" }, { "key": "PRD_PROCESSR_CD", "value": "PRD_PROCESSR_CD", "configType": "COLUMN_MAPPING" }, { "key": "CRET_DTTM", "value": "CRET_DTTM", "configType": "COLUMN_MAPPING" }, { "key": "LAST_UPDT_DTTM", "value": "LAST_UPDT_DTTM", "configType": "COLUMN_MAPPING" }, { "key": "PROCESS_STATUS", "value": "PROCESS_STATUS", "configType": "COLUMN_MAPPING" }, { "key": "ERROR_MSG", "value": "ERROR_MSG", "configType": "COLUMN_MAPPING" }, { "key": "BILL_GENERATE_DT", "value": "BILL_GENERATE_DT", "configType": "COLUMN_MAPPING" } ] }, { "srcTable": "DM_ACCOUNT_PARTY_STG", "destTable": "DM_ACCOUNT_PARTY_STG_PROCESS_STATUS", "customConfigDatas": [ { "key": "ACCT_NBR", "value": "ACCT_NBR", "configType": "COLUMN_MAPPING" }, { "key": "RCD_TYPE", "value": "RCD_TYPE", "configType": "COLUMN_MAPPING" }, { "key": "PRD_PROCESSR_CD", "value": "PRD_PROCESSR_CD", "configType": "COLUMN_MAPPING" }, { "key": "CRET_DTTM", "value": "CRET_DTTM", "configType": "COLUMN_MAPPING" }, { "key": "LAST_UPDT_DTTM", "value": "LAST_UPDT_DTTM", "configType": "COLUMN_MAPPING" }, { "key": "PROCESS_STATUS", "value": "PROCESS_STATUS", "configType": "COLUMN_MAPPING" }, { "key": "ERROR_MSG", "value": "ERROR_MSG", "configType": "COLUMN_MAPPING" }, { "key": "CUST_NBR", "value": "CUST_NBR", "configType": "COLUMN_MAPPING" } ] }, { "srcTable": "DM_ACCOUNT_REPAY_SCH_STG", "destTable": "DM_ACCOUNT_REPAY_SCH_STG_PROCESS_STATUS", "customConfigDatas": [ { "key": "ACCT_NBR", "value": "ACCT_NBR", "configType": "COLUMN_MAPPING" }, { "key": "RCD_TYPE", "value": "RCD_TYPE", "configType": "COLUMN_MAPPING" }, { "key": "PRD_PROCESSR_CD", "value": "PRD_PROCESSR_CD", "configType": "COLUMN_MAPPING" }, { "key": "CRET_DTTM", "value": "CRET_DTTM", "configType": "COLUMN_MAPPING" }, { "key": "LAST_UPDT_DTTM", "value": "LAST_UPDT_DTTM", "configType": "COLUMN_MAPPING" }, { "key": "PROCESS_STATUS", "value": "PROCESS_STATUS", "configType": "COLUMN_MAPPING" }, { "key": "ERROR_MSG", "value": "ERROR_MSG", "configType": "COLUMN_MAPPING" }, { "key": "INSTALLMENT_DT", "value": "INSTALLMENT_DT", "configType": "COLUMN_MAPPING" } ] }, { "srcTable": "DM_PAYMENT_STG", "destTable": "DM_PAYMENT_STG_PROCESS_STATUS", "customConfigDatas": [ { "key": "ACCT_NBR", "value": "ACCT_NBR", "configType": "COLUMN_MAPPING" }, { "key": "RCD_TYPE", "value": "RCD_TYPE", "configType": "COLUMN_MAPPING" }, { "key": "PRD_PROCESSR_CD", "value": "PRD_PROCESSR_CD", "configType": "COLUMN_MAPPING" }, { "key": "CRET_DTTM", "value": "CRET_DTTM", "configType": "COLUMN_MAPPING" }, { "key": "LAST_UPDT_DTTM", "value": "LAST_UPDT_DTTM", "configType": "COLUMN_MAPPING" }, { "key": "PROCESS_STATUS", "value": "PROCESS_STATUS", "configType": "COLUMN_MAPPING" }, { "key": "ERROR_MSG", "value": "ERROR_MSG", "configType": "COLUMN_MAPPING" }, { "key": "XREF_NO", "value": "XREF_NO", "configType": "COLUMN_MAPPING" } ] }, { "srcTable": "DM_COLLATERAL_CHARGE_STG", "destTable": "DM_COLLATERAL_CHARGE_STG_PROCESS_STATUS", "customConfigDatas": [ { "key": "COLLATERAL_CD", "value": "COLLATERAL_CD", "configType": "COLUMN_MAPPING" }, { "key": "RCD_TYPE", "value": "RCD_TYPE", "configType": "COLUMN_MAPPING" }, { "key": "PRD_PROCESSR_CD", "value": "PRD_PROCESSR_CD", "configType": "COLUMN_MAPPING" }, { "key": "CRET_DTTM", "value": "CRET_DTTM", "configType": "COLUMN_MAPPING" }, { "key": "LAST_UPDT_DTTM", "value": "LAST_UPDT_DTTM", "configType": "COLUMN_MAPPING" }, { "key": "PROCESS_STATUS", "value": "PROCESS_STATUS", "configType": "COLUMN_MAPPING" }, { "key": "ERROR_MSG", "value": "ERROR_MSG", "configType": "COLUMN_MAPPING" }, { "key": "CHRG_CD", "value": "CHRG_CD", "configType": "COLUMN_MAPPING" } ] }, { "srcTable": "DM_COLLATERAL_LINKAGE_STG", "destTable": "DM_COLLATERAL_LINKAGE_STG_PROCESS_STATUS", "customConfigDatas": [ { "key": "ACCT_NBR", "value": "ACCT_NBR", "configType": "COLUMN_MAPPING" }, { "key": "RCD_TYPE", "value": "RCD_TYPE", "configType": "COLUMN_MAPPING" }, { "key": "PRD_PROCESSR_CD", "value": "PRD_PROCESSR_CD", "configType": "COLUMN_MAPPING" }, { "key": "CRET_DTTM", "value": "CRET_DTTM", "configType": "COLUMN_MAPPING" }, { "key": "LAST_UPDT_DTTM", "value": "LAST_UPDT_DTTM", "configType": "COLUMN_MAPPING" }, { "key": "PROCESS_STATUS", "value": "PROCESS_STATUS", "configType": "COLUMN_MAPPING" }, { "key": "ERROR_MSG", "value": "ERROR_MSG", "configType": "COLUMN_MAPPING" }, { "key": "COLLATERAL_CD", "value": "COLLATERAL_CD", "configType": "COLUMN_MAPPING" } ] }, { "srcTable": "DM_COLLATERAL_OWNER_STG", "destTable": "DM_COLLATERAL_OWNER_STG_PROCESS_STATUS", "customConfigDatas": [ { "key": "CUST_NBR", "value": "CUST_NBR", "configType": "COLUMN_MAPPING" }, { "key": "RCD_TYPE", "value": "RCD_TYPE", "configType": "COLUMN_MAPPING" }, { "key": "PRD_PROCESSR_CD", "value": "PRD_PROCESSR_CD", "configType": "COLUMN_MAPPING" }, { "key": "CRET_DTTM", "value": "CRET_DTTM", "configType": "COLUMN_MAPPING" }, { "key": "LAST_UPDT_DTTM", "value": "LAST_UPDT_DTTM", "configType": "COLUMN_MAPPING" }, { "key": "PROCESS_STATUS", "value": "PROCESS_STATUS", "configType": "COLUMN_MAPPING" }, { "key": "ERROR_MSG", "value": "ERROR_MSG", "configType": "COLUMN_MAPPING" }, { "key": "COLLATERAL_CD", "value": "COLLATERAL_CD", "configType": "COLUMN_MAPPING" } ] }, { "srcTable": "DM_COLLATERAL_STG", "destTable": "DM_COLLATERAL_STG_PROCESS_STATUS", "customConfigDatas": [ { "key": "RCD_TYPE", "value": "RCD_TYPE", "configType": "COLUMN_MAPPING" }, { "key": "PRD_PROCESSR_CD", "value": "PRD_PROCESSR_CD", "configType": "COLUMN_MAPPING" }, { "key": "CRET_DTTM", "value": "CRET_DTTM", "configType": "COLUMN_MAPPING" }, { "key": "LAST_UPDT_DTTM", "value": "LAST_UPDT_DTTM", "configType": "COLUMN_MAPPING" }, { "key": "PROCESS_STATUS", "value": "PROCESS_STATUS", "configType": "COLUMN_MAPPING" }, { "key": "ERROR_MSG", "value": "ERROR_MSG", "configType": "COLUMN_MAPPING" }, { "key": "COLLATERAL_CD", "value": "COLLATERAL_CD", "configType": "COLUMN_MAPPING" } ] }, { "srcTable": "DM_PARTY_ADDRESS_STG", "destTable": "DM_PARTY_ADDRESS_STG_PROCESS_STATUS", "customConfigDatas": [ { "key": "CUST_NBR", "value": "CUST_NBR", "configType": "COLUMN_MAPPING" }, { "key": "RCD_TYPE", "value": "RCD_TYPE", "configType": "COLUMN_MAPPING" }, { "key": "PRD_PROCESSR_CD", "value": "PRD_PROCESSR_CD", "configType": "COLUMN_MAPPING" }, { "key": "CRET_DTTM", "value": "CRET_DTTM", "configType": "COLUMN_MAPPING" }, { "key": "LAST_UPDT_DTTM", "value": "LAST_UPDT_DTTM", "configType": "COLUMN_MAPPING" }, { "key": "PROCESS_STATUS", "value": "PROCESS_STATUS", "configType": "COLUMN_MAPPING" }, { "key": "ERROR_MSG", "value": "ERROR_MSG", "configType": "COLUMN_MAPPING" }, { "key": "ADDR_TYPE_CD", "value": "ADDR_TYPE_CD", "configType": "COLUMN_MAPPING" } ] }, { "srcTable": "DM_PARTY_CONTACT_STG", "destTable": "DM_PARTY_CONTACT_STG_PROCESS_STATUS", "customConfigDatas": [ { "key": "CUST_NBR", "value": "CUST_NBR", "configType": "COLUMN_MAPPING" }, { "key": "RCD_TYPE", "value": "RCD_TYPE", "configType": "COLUMN_MAPPING" }, { "key": "PRD_PROCESSR_CD", "value": "PRD_PROCESSR_CD", "configType": "COLUMN_MAPPING" }, { "key": "CRET_DTTM", "value": "CRET_DTTM", "configType": "COLUMN_MAPPING" }, { "key": "LAST_UPDT_DTTM", "value": "LAST_UPDT_DTTM", "configType": "COLUMN_MAPPING" }, { "key": "PROCESS_STATUS", "value": "PROCESS_STATUS", "configType": "COLUMN_MAPPING" }, { "key": "ERROR_MSG", "value": "ERROR_MSG", "configType": "COLUMN_MAPPING" }, { "key": "CONTACT_POINT_TYP_CD", "value": "CONTACT_POINT_TYP_CD", "configType": "COLUMN_MAPPING" } ] }, { "srcTable": "DM_PARTY_EMPLOYMENT_STG", "destTable": "DM_PARTY_EMPLOYMENT_STG_PROCESS_STATUS", "customConfigDatas": [ { "key": "CUST_NBR", "value": "CUST_NBR", "configType": "COLUMN_MAPPING" }, { "key": "RCD_TYPE", "value": "RCD_TYPE", "configType": "COLUMN_MAPPING" }, { "key": "PRD_PROCESSR_CD", "value": "PRD_PROCESSR_CD", "configType": "COLUMN_MAPPING" }, { "key": "CRET_DTTM", "value": "CRET_DTTM", "configType": "COLUMN_MAPPING" }, { "key": "LAST_UPDT_DTTM", "value": "LAST_UPDT_DTTM", "configType": "COLUMN_MAPPING" }, { "key": "PROCESS_STATUS", "value": "PROCESS_STATUS", "configType": "COLUMN_MAPPING" }, { "key": "ERROR_MSG", "value": "ERROR_MSG", "configType": "COLUMN_MAPPING" }, { "key": "EMP_SEQ_ID", "value": "EMP_SEQ_ID", "configType": "COLUMN_MAPPING" } ] }, { "srcTable": "DM_PARTY_IDENTITY_STG", "destTable": "DM_PARTY_IDENTITY_STG_PROCESS_STATUS", "customConfigDatas": [ { "key": "CUST_NBR", "value": "CUST_NBR", "configType": "COLUMN_MAPPING" }, { "key": "RCD_TYPE", "value": "RCD_TYPE", "configType": "COLUMN_MAPPING" }, { "key": "PRD_PROCESSR_CD", "value": "PRD_PROCESSR_CD", "configType": "COLUMN_MAPPING" }, { "key": "CRET_DTTM", "value": "CRET_DTTM", "configType": "COLUMN_MAPPING" }, { "key": "LAST_UPDT_DTTM", "value": "LAST_UPDT_DTTM", "configType": "COLUMN_MAPPING" }, { "key": "PROCESS_STATUS", "value": "PROCESS_STATUS", "configType": "COLUMN_MAPPING" }, { "key": "ERROR_MSG", "value": "ERROR_MSG", "configType": "COLUMN_MAPPING" }, { "key": "ID_TYPE_CD", "value": "ID_TYPE_CD", "configType": "COLUMN_MAPPING" } ] }, { "srcTable": "DM_PARTY_NAME_STG", "destTable": "DM_PARTY_NAME_STG_PROCESS_STATUS", "customConfigDatas": [ { "key": "CUST_NBR", "value": "CUST_NBR", "configType": "COLUMN_MAPPING" }, { "key": "RCD_TYPE", "value": "RCD_TYPE", "configType": "COLUMN_MAPPING" }, { "key": "PRD_PROCESSR_CD", "value": "PRD_PROCESSR_CD", "configType": "COLUMN_MAPPING" }, { "key": "CRET_DTTM", "value": "CRET_DTTM", "configType": "COLUMN_MAPPING" }, { "key": "LAST_UPDT_DTTM", "value": "LAST_UPDT_DTTM", "configType": "COLUMN_MAPPING" }, { "key": "PROCESS_STATUS", "value": "PROCESS_STATUS", "configType": "COLUMN_MAPPING" }, { "key": "ERROR_MSG", "value": "ERROR_MSG", "configType": "COLUMN_MAPPING" }, { "key": "NAME_TYP_CD", "value": "NAME_TYP_CD", "configType": "COLUMN_MAPPING" } ] }, { "srcTable": "DM_PARTY_STG", "destTable": "DM_PARTY_STG_PROCESS_STATUS", "customConfigDatas": [ { "key": "CUST_NBR", "value": "CUST_NBR", "configType": "COLUMN_MAPPING" }, { "key": "RCD_TYPE", "value": "RCD_TYPE", "configType": "COLUMN_MAPPING" }, { "key": "PRD_PROCESSR_CD", "value": "PRD_PROCESSR_CD", "configType": "COLUMN_MAPPING" }, { "key": "CRET_DTTM", "value": "CRET_DTTM", "configType": "COLUMN_MAPPING" }, { "key": "LAST_UPDT_DTTM", "value": "LAST_UPDT_DTTM", "configType": "COLUMN_MAPPING" }, { "key": "PROCESS_STATUS", "value": "PROCESS_STATUS", "configType": "COLUMN_MAPPING" }, { "key": "ERROR_MSG", "value": "ERROR_MSG", "configType": "COLUMN_MAPPING" } ] } ]

Trigger endpoint

Table 3-10 Trigger endpoint

Endpoint Configurations

Host location https://host:port/obcr-data-exchange-services/transfers/CR_DATAEXCHNG/CR_ENTITY_PROCESS_STATUS?operation=T&branchCode=BCR&runDate=24122024

Header

Endpoint	Configurations
Host location	https://host:port/obcr-data-exchange-services/transfers/CR_DATAEXCHNG/CR_ENTITY_PROCESS_STATUS?operation=T&branchCode=BCR&runDate=24122024
Header	`appId: CRDATAEXCHNG entityId:DEFAULTENTITY Content-Type:application/json branchCode:BCR userId:AUTOUSER`
Request Body	Request Body [ { "tableName": "DM_ACCOUNT_STG_PROCESS_STATUS", "truncateFlag": "N", "srcTableName": "DM_ACCOUNT_STG", "srcTruncateFlag": "Y", "srcWhereClause": "PROCESS_STATUS = '\''F'\'' OR PROCESS_STATUS = '\''S'\''" }, { "tableName": "DM_ACCOUNT_ARREARS_STG_PROCESS_STATUS", "truncateFlag": "N", "srcTableName": "DM_ACCOUNT_ARREARS_STG", "srcTruncateFlag": "Y", "srcWhereClause": "PROCESS_STATUS = '\''F'\'' OR PROCESS_STATUS = '\''S'\''" }, { "tableName": "DM_ACCOUNT_BILL_DTLS_STG_PROCESS_STATUS", "truncateFlag": "N", "srcTableName": "DM_ACCOUNT_BILL_DTLS_STG", "srcTruncateFlag": "Y", "srcWhereClause": "PROCESS_STATUS = '\''F'\'' OR PROCESS_STATUS = '\''S'\''" }, { "tableName": "DM_ACCOUNT_PARTY_STG_PROCESS_STATUS", "truncateFlag": "N", "srcTableName": "DM_ACCOUNT_PARTY_STG", "srcTruncateFlag": "Y", "srcWhereClause": "PROCESS_STATUS = '\''F'\'' OR PROCESS_STATUS = '\''S'\''" }, { "tableName": "DM_ACCOUNT_REPAY_SCH_STG_PROCESS_STATUS", "truncateFlag": "N", "srcTableName": "DM_ACCOUNT_REPAY_SCH_STG", "srcTruncateFlag": "Y", "srcWhereClause": "PROCESS_STATUS = '\''F'\'' OR PROCESS_STATUS = '\''S'\''" }, { "tableName": "DM_COLLATERAL_CHARGE_STG_PROCESS_STATUS", "truncateFlag": "N", "srcTableName": "DM_COLLATERAL_CHARGE_STG", "srcTruncateFlag": "Y", "srcWhereClause": "PROCESS_STATUS = '\''F'\'' OR PROCESS_STATUS = '\''S'\''" }, { "tableName": "DM_COLLATERAL_LINKAGE_STG_PROCESS_STATUS", "truncateFlag": "N", "srcTableName": "DM_COLLATERAL_LINKAGE_STG", "srcTruncateFlag": "Y", "srcWhereClause": "PROCESS_STATUS = '\''F'\'' OR PROCESS_STATUS = '\''S'\''" }, { "tableName": "DM_COLLATERAL_OWNER_STG_PROCESS_STATUS", "truncateFlag": "N", "srcTableName": "DM_COLLATERAL_OWNER_STG", "srcTruncateFlag": "Y", "srcWhereClause": "PROCESS_STATUS = '\''F'\'' OR PROCESS_STATUS = '\''S'\''" }, { "tableName": "DM_COLLATERAL_STG_PROCESS_STATUS", "truncateFlag": "N", "srcTableName": "DM_COLLATERAL_STG", "srcTruncateFlag": "Y", "srcWhereClause": "PROCESS_STATUS = '\''F'\'' OR PROCESS_STATUS = '\''S'\''" }, { "tableName": "DM_PARTY_ADDRESS_STG_PROCESS_STATUS", "truncateFlag": "N", "srcTableName": "DM_PARTY_ADDRESS_STG", "srcTruncateFlag": "Y", "srcWhereClause": "PROCESS_STATUS = '\''F'\'' OR PROCESS_STATUS = '\''S'\''" }, { "tableName": "DM_PARTY_CONTACT_STG_PROCESS_STATUS", "truncateFlag": "N", "srcTableName": "DM_PARTY_CONTACT_STG", "srcTruncateFlag": "Y", "srcWhereClause": "PROCESS_STATUS = '\''F'\'' OR PROCESS_STATUS = '\''S'\''" }, { "tableName": "DM_PARTY_EMPLOYMENT_STG_PROCESS_STATUS", "truncateFlag": "N", "srcTableName": "DM_PARTY_EMPLOYMENT_STG", "srcTruncateFlag": "Y", "srcWhereClause": "PROCESS_STATUS = '\''F'\'' OR PROCESS_STATUS = '\''S'\''" }, { "tableName": "DM_PARTY_IDENTITY_STG_PROCESS_STATUS", "truncateFlag": "N", "srcTableName": "DM_PARTY_IDENTITY_STG", "srcTruncateFlag": "Y", "srcWhereClause": "PROCESS_STATUS = '\''F'\'' OR PROCESS_STATUS = '\''S'\''" }, { "tableName": "DM_PARTY_NAME_STG_PROCESS_STATUS", "truncateFlag": "N", "srcTableName": "DM_PARTY_NAME_STG", "srcTruncateFlag": "Y", "srcWhereClause": "PROCESS_STATUS = '\''F'\'' OR PROCESS_STATUS = '\''S'\''" }, { "tableName": "DM_PARTY_STG_PROCESS_STATUS", "truncateFlag": "N", "srcTableName": "DM_PARTY_STG", "srcTruncateFlag": "Y", "srcWhereClause": "PROCESS_STATUS = '\''F'\'' OR PROCESS_STATUS = '\''S'\''" }, { "tableName": "DM_PAYMENT_STG_PROCESS_STATUS", "truncateFlag": "N", "srcTableName": "DM_PAYMENT_STG", "srcTruncateFlag": "Y", "srcWhereClause": "PROCESS_STATUS = '\''F'\'' OR PROCESS_STATUS = '\''S'\''" } ]


appId: CRDATAEXCHNG
entityId:DEFAULTENTITY 
Content-Type:application/json 
branchCode:BCR 
userId:AUTOUSER

Request Body

Request Body	[
    {
        "tableName": "DM_ACCOUNT_STG_PROCESS_STATUS",
        "truncateFlag": "N",
        "srcTableName": "DM_ACCOUNT_STG",
        "srcTruncateFlag": "Y",
        "srcWhereClause": "PROCESS_STATUS = '\''F'\'' OR PROCESS_STATUS = '\''S'\''"
    },
    {
        "tableName": "DM_ACCOUNT_ARREARS_STG_PROCESS_STATUS",
        "truncateFlag": "N",
        "srcTableName": "DM_ACCOUNT_ARREARS_STG",
        "srcTruncateFlag": "Y",
        "srcWhereClause": "PROCESS_STATUS = '\''F'\'' OR PROCESS_STATUS = '\''S'\''"
    },
    {
        "tableName": "DM_ACCOUNT_BILL_DTLS_STG_PROCESS_STATUS",
        "truncateFlag": "N",
        "srcTableName": "DM_ACCOUNT_BILL_DTLS_STG",
        "srcTruncateFlag": "Y",
        "srcWhereClause": "PROCESS_STATUS = '\''F'\'' OR PROCESS_STATUS = '\''S'\''"
    },
    {
        "tableName": "DM_ACCOUNT_PARTY_STG_PROCESS_STATUS",
        "truncateFlag": "N",
        "srcTableName": "DM_ACCOUNT_PARTY_STG",
        "srcTruncateFlag": "Y",
        "srcWhereClause": "PROCESS_STATUS = '\''F'\'' OR PROCESS_STATUS = '\''S'\''"
    },
    {
        "tableName": "DM_ACCOUNT_REPAY_SCH_STG_PROCESS_STATUS",
        "truncateFlag": "N",
        "srcTableName": "DM_ACCOUNT_REPAY_SCH_STG",
        "srcTruncateFlag": "Y",
        "srcWhereClause": "PROCESS_STATUS = '\''F'\'' OR PROCESS_STATUS = '\''S'\''"
    },
    {
        "tableName": "DM_COLLATERAL_CHARGE_STG_PROCESS_STATUS",
        "truncateFlag": "N",
        "srcTableName": "DM_COLLATERAL_CHARGE_STG",
        "srcTruncateFlag": "Y",
        "srcWhereClause": "PROCESS_STATUS = '\''F'\'' OR PROCESS_STATUS = '\''S'\''"
    },
    {
        "tableName": "DM_COLLATERAL_LINKAGE_STG_PROCESS_STATUS",
        "truncateFlag": "N",
        "srcTableName": "DM_COLLATERAL_LINKAGE_STG",
        "srcTruncateFlag": "Y",
        "srcWhereClause": "PROCESS_STATUS = '\''F'\'' OR PROCESS_STATUS = '\''S'\''"
    },
    {
        "tableName": "DM_COLLATERAL_OWNER_STG_PROCESS_STATUS",
        "truncateFlag": "N",
        "srcTableName": "DM_COLLATERAL_OWNER_STG",
        "srcTruncateFlag": "Y",
        "srcWhereClause": "PROCESS_STATUS = '\''F'\'' OR PROCESS_STATUS = '\''S'\''"
    },
    {
        "tableName": "DM_COLLATERAL_STG_PROCESS_STATUS",
        "truncateFlag": "N",
        "srcTableName": "DM_COLLATERAL_STG",
        "srcTruncateFlag": "Y",
        "srcWhereClause": "PROCESS_STATUS = '\''F'\'' OR PROCESS_STATUS = '\''S'\''"
    },
    {
        "tableName": "DM_PARTY_ADDRESS_STG_PROCESS_STATUS",
        "truncateFlag": "N",
        "srcTableName": "DM_PARTY_ADDRESS_STG",
        "srcTruncateFlag": "Y",
        "srcWhereClause": "PROCESS_STATUS = '\''F'\'' OR PROCESS_STATUS = '\''S'\''"
    },
    {
        "tableName": "DM_PARTY_CONTACT_STG_PROCESS_STATUS",
        "truncateFlag": "N",
        "srcTableName": "DM_PARTY_CONTACT_STG",
        "srcTruncateFlag": "Y",
        "srcWhereClause": "PROCESS_STATUS = '\''F'\'' OR PROCESS_STATUS = '\''S'\''"
    },
    {
        "tableName": "DM_PARTY_EMPLOYMENT_STG_PROCESS_STATUS",
        "truncateFlag": "N",
        "srcTableName": "DM_PARTY_EMPLOYMENT_STG",
        "srcTruncateFlag": "Y",
        "srcWhereClause": "PROCESS_STATUS = '\''F'\'' OR PROCESS_STATUS = '\''S'\''"
    },
    {
        "tableName": "DM_PARTY_IDENTITY_STG_PROCESS_STATUS",
        "truncateFlag": "N",
        "srcTableName": "DM_PARTY_IDENTITY_STG",
        "srcTruncateFlag": "Y",
        "srcWhereClause": "PROCESS_STATUS = '\''F'\'' OR PROCESS_STATUS = '\''S'\''"
    },
    {
        "tableName": "DM_PARTY_NAME_STG_PROCESS_STATUS",
        "truncateFlag": "N",
        "srcTableName": "DM_PARTY_NAME_STG",
        "srcTruncateFlag": "Y",
        "srcWhereClause": "PROCESS_STATUS = '\''F'\'' OR PROCESS_STATUS = '\''S'\''"
    },
    {
        "tableName": "DM_PARTY_STG_PROCESS_STATUS",
        "truncateFlag": "N",
        "srcTableName": "DM_PARTY_STG",
        "srcTruncateFlag": "Y",
        "srcWhereClause": "PROCESS_STATUS = '\''F'\'' OR PROCESS_STATUS = '\''S'\''"
    },
    {
        "tableName": "DM_PAYMENT_STG_PROCESS_STATUS",
        "truncateFlag": "N",
        "srcTableName": "DM_PAYMENT_STG",
        "srcTruncateFlag": "Y",
        "srcWhereClause": "PROCESS_STATUS = '\''F'\'' OR PROCESS_STATUS = '\''S'\''"
    }
]

Parent topic: Entity Creation