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