3.2.17 Reporting Data Population Job

This topic provides information about the Reporting Data Population Job process.

This job is used to populate data from various tables across schemas into CR_DATAEXCHNG schema, which can then be used to generate various reports.

Configuration for this job is similar to what is explained for data transfer job above.

Mandatory Headers:

Table 3-74 Mandatory Headers for Configuration endpoint:

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

Table 3-75 Mandatory Headers for Trigger endpoint:

Parameter Name Value Mandatory Description
appld CRDATAEXCHNG Yes The application ID of the host service.
Details of source and target schema and tables are mentioned below:

Table 3-76 source and target schema

Source-SCHEMA NAME Source-TABLE NAMES Destination-SCHEMA NAME Destination-TABLE NAMES
CR_ACTION DM_ACCOUNT_COLLECTION_STATUS CR_DATAEXCHNG DM_RPT_ACCOUNT_COLLECTION_STATUS
DM_ACCOUNT_COLLECTION_STATUS_HISTORY CR_DATAEXCHNG DM_RPT_ACCOUNT_COLLECTION_STATUS_HISTORY
DM_ACTION_RESULTS CR_DATAEXCHNG DM_RPT_ACTION_RESULTS
CR_ACTIVITY DM_ACTIVITY CR_DATAEXCHNG DM_RPT_ACTIVITY
CR_DASHBOARD DM_KPI CR_DATAEXCHNG DM_RPT_KPI
DM_KPI_HIST CR_DATAEXCHNG DM_RPT_KPI_HIST
CR_ENTITY DM_ACCOUNT CR_DATAEXCHNG DM_RPT_ACCOUNT
DM_ACCOUNT_DEL_HISTORY CR_DATAEXCHNG DM_RPT_ACCOUNT_DEL_HISTORY
DM_ACCOUNT_PARTY CR_DATAEXCHNG DM_RPT_ACCOUNT_PARTY
DM_COLLATERAL CR_DATAEXCHNG DM_RPT_COLLATERAL
DM_COLLATERAL_LINKAGE CR_DATAEXCHNG DM_RPT_COLLATERAL_LINKAGE
DM_CURED_ACCOUNT CR_DATAEXCHNG DM_RPT_CURED_ACCOUNT
DM_CURED_ACCOUNT_HIST CR_DATAEXCHNG DM_RPT_CURED_ACCOUNT_HIST
DM_PARTY CR_DATAEXCHNG DM_RPT_PARTY
DM_PARTY_NAME CR_DATAEXCHNG DM_RPT_PARTY_NAME
DM_PAYMENT CR_DATAEXCHNG DM_RPT_PAYMENT
CR_FEECHRG DM_FEESCHARGES_ACCT_ASSO CR_DATAEXCHNG DM_RPT_FEESCHARGES_ACCT_ASSO
DM_FEESCHARGES_ACCT_ASSO_HIST CR_DATAEXCHNG DM_RPT_FEESCHARGES_ACCT_ASSO_HIST
CR_PTP DM_PTP CR_DATAEXCHNG DM_RPT_PTP
DM_PTP_HIST CR_DATAEXCHNG DM_RPT_PTP_HIST
CR_SEG DM_SEGMENT_ACCOUNT_ASSO CR_DATAEXCHNG DM_RPT_SEGMENT_ACCOUNT_ASSO
DM_SEGMENT_ACCOUNT_ASSO_HIST CR_DATAEXCHNG DM_RPT_SEGMENT_ACCOUNT_ASSO_HIST
DM_SEGMENT_STGY_ACCOUNT_ASSO CR_DATAEXCHNG DM_RPT_SEGMENT_STGY_ACCOUNT_ASSO
CR_STRTGY DM_CASE CR_DATAEXCHNG DM_RPT_CASE
DM_CASE_ACCOUNT_ASSO CR_DATAEXCHNG DM_RPT_CASE_ACCOUNT_ASSO
DM_CASE_ACCOUNT_ASSO_HIST CR_DATAEXCHNG DM_RPT_CASE_ACCOUNT_ASSO_HIST
DM_CASE_HIST CR_DATAEXCHNG DM_RPT_CASE_HIST
CR_TASK DM_TASK CR_DATAEXCHNG DM_RPT_TASK
DM_TASK_ASSIGN_HIST CR_DATAEXCHNG DM_RPT_TASK_ASSIGN_HIST
DM_TASK_HISTORY CR_DATAEXCHNG DM_RPT_TASK_HISTORY
CR_USERMGMT DM_ACCOUNT_ASSIGN CR_DATAEXCHNG DM_RPT_ACCOUNT_ASSIGN
DM_ACCOUNT_ASSIGN_HISTORY CR_DATAEXCHNG DM_RPT_ACCOUNT_ASSIGN_HISTORY
DM_STRATEGY_ASSIGN CR_DATAEXCHNG DM_RPT_STRATEGY_ASSIGN
DM_STRATEGY_ASSIGN_HISTORY CR_DATAEXCHNG DM_RPT_STRATEGY_ASSIGN_HISTORY
DM_TM_USER_GROUP CR_DATAEXCHNG DM_TM_RPT_USER_GROUP
DM_TM_USER_GROUP_MEMBERS CR_DATAEXCHNG DM_TM_RPT_USER_GROUP_MEMBERS