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 |
Parent topic: Batch Execution