Cognos data model for replicating data

To help you manage a replicated database that can be used to run the Cognos® reports and dashboards, CDC Replication scripts are provided. If you don't want to use these CDC Replication scripts, you can use your own replication tools to manage the replicated database. The following information is needed to set up your own replication.

The archive file names, package names, report names, and data sources for the Common Services Cognos sample reports are shown in the following table.

Cognos archive file name	Cognos package name	Report names	Data source name	Data source type
Cognos_Customer_Activity.zip	`pkg_customer_activity`	`rpt_customer_activity`	`ftmdb_source`	`CQM`
Cognos_Return_Items_Archive.zip	`pkg_return_items`	`rpt_return_items_originator_return_items rpt_return_items_originator_return_rates rpt_return_items_summary_by_period rpt_return_items_unauthorized_payments rpt_return_items_unresolved_return_items`	`ftmdb_source`	`CQM`
PFS_Alerts.zip	`pkg_pfs_alerts`	`rpt_alerts`	`ftmdb_source`	`CQM`
PFS_Distribution.zip	`pkg_pfs_distribution`	`rpt_distribution_endpoint_summary rpt_orphaned_payments`	`ftmdb_source`	`CQM`
PFS_Failures.zip	`pkg_pfs_failures`	`rpt_detailed_failures_by_bday`	`ftmdb_source`	`CQM`
PFS_Performance.zip	`pkg_pfs_performance`	`rpt_distribution_performance rpt_gateway_performance rpt_sf_performance`	`ftmdb_source`	`CQM`
Risk_Monitor.zip	`pkg_risk_monitor`	`rpt_override rpt_rejected_work rpt_reviewed_work rpt_suspended_work`	`ftmdb_source`	`CQM`
TCR_UOW_ADJUSTMENTS.zip	`pkg_tcr_uow_adjustments`	`rpt_tcr_adjustment_statistics rpt_tcr_adjustment_statistics_by_operator rpt_tcr_inbound_batch_life_cycle rpt_tcr_product_life_cycle`	`ftmdb_source`	`CQM`
Transaction_Authorization.zip	`pkg_transaction_authorization`	`rpt_exception_decisions rpt_payment_authorization_configuration rpt_unauthorized_payments rpt_unhandled_exceptions`	`ftmdb_source`	`CQM`

To run the Cognos dashboards and reports against a replicated database, it must have all of the views and tables that are used by the dashboards and reports. Your custom replication scripts need to replicate the data from the database tables and views that are shown in the following table.

Cognos package name	Database public views	Database tables to replicate
`pkg_customer_activity`	ACCOUNT_TYPES_V BUSINESS_DAY_VIEW CORE_PROPERTIES_DATA ERROR_CODES_V GET_OPERATIONAL_TZ_TIME_NOW_V INBOUND_CASHLETTER_DATA INBOUND_ITEM_REC ITEM_V J_GET_OPER_TS_WITH_TZID (UDF) NOC_ITEM_V PARTNER_ACCOUNTS_V PARTNER_PROFILE PARTNER_V PAYMENT_DATA PAYMENT_V REASON_CODES_V	ACCOUNT_TYPES BANK BUSINESS_DAY CASH_LETTER CORE_PROPERTIES DEPOSITOR_ATTR DEPOSITOR_CHANNEL_DEF DEPOSITOR_PRODUCTS ERROR_CATEGORIES ERROR_CODES ITEM ITEM_RECORD NOC_ITEM PARTNER_ACCOUNTS PARTNER_ADDRESS PARTNER_GENERAL PARTNER_ROLE PAYMENT PAYMENT_MESSAGE_TYPE PAYMENT_STANDARD_TYPE PPTYPE PRES_PRES_XREF PRESENTMENT PRESENTMENT_GROUP PRESENTMENT_TYPE PROCESSING_WINDOW REASON_CODES REJECT_LEVELS ROLE_TYPES
`pkg_pfs_alerts`	ALERTS_V BUSINESS_DAY_VIEW CORE_PROPERTIES_DATA GET_OPERATIONAL_TZ_TIME_NOW_V J_GET_OPER_TS_WITH_TZID (UDF)	ALERT ALERT_NOTES APP_LOG BUSINESS_DAY CORE_PROPERTIES PRODUCT_INSTANCE
`pkg_pfs_distribution`	BUSINESS_DAY_VIEW CORE_PROPERTIES_DATA ENDPOINT_VIEW GET_OPERATIONAL_TZ_TIME_NOW_V J_GET_OPER_TS_WITH_TZID (UDF) OUTBOUND_PRESENTMENT_V OUTBOUND_PRESENTMENT_VIEW PRES_FILE_DEADLINE_RPT PRES_FILE_EXCEPT_RPT PRESENTMENT_FILE_EXPORT_REPORT PRES_FILE_SUM_TOTALS_RPT PRES_FILE_TRANSM_GRP_PRD_RPT PRES_FILE_TRANSM_GRP_RPT PRES_ORPHANED_PAY_RPT PRES_PRODUCT_CFG_RPT	BANK BUILDING_OPTS BUSINESS_DAY CHANNEL_DEF CORE_PROPERTIES DEADLINE ENDPOINT_GENERAL FILE_DEF ITEM OUTBOUND_PRES_GROUP OUTBOUND_PRESENTMENT PARTNER_ADDRESS PARTNER_GENERAL PARTNER_ROLE PAYMENT PRESENTMENT PRESENTMENT_GROUP PRESENTMENT_PRODUCTS PROCESSING_WINDOW PROCESSING_WINDOW_ACTIVITY ROLE_TYPES
`pkg_pfs_failures`	BUSINESS_DAY_VIEW CORE_PROPERTIES_DATA DEPOSIT_STATES ERROR_CODES_V GET_OPERATIONAL_TZ_TIME_NOW_V J_GET_OPER_TS_WITH_TZID (UDF) PARTNER_PROFILE VVAL_BUNDLE_DETAIL_BY_DAY VVAL_CASHLETTER_DETAIL_BY_DAY VVAL_FILE_DETAIL_BY_DAY VVAL_ITEM_BY_DAY VVAL_ITEM_BY_ORIG VVAL_ITEM_BY_PROD VVAL_ITEM_DETAIL_BY_DAY VVAL_ITEM_DETAIL_BY_ORIG VVAL_ITEM_EXT	BUNDLE_VAL BUSINESS_DAY CASH_LETTER CASH_LETTER_VAL CORE_PROPERTIES DEPOSIT_PRODUCTS DEPOSITOR_ATTR DEPOSITOR_CHANNEL_DEF ERROR_CATEGORIES ERROR_CODES FILE FILE_VAL ITEM_VAL PARTNER_ADDRESS PARTNER_ROLE PAYMENT PPTYPE PRES_PRES_XREF PRESENTMENT PRESENTMENT_GROUP REJECT_LEVELS ROLE_TYPES SEGMENT
`pkg_pfs_performance`	BUSINESS_DAY_VIEW CORE_PROPERTIES_DATA GET_OPERATIONAL_TZ_TIME_NOW_V J_GET_OPER_TS_WITH_TZID (UDF) PERF_DETAIL_V SERVICES_PERFORMANCE_V	BUSINESS_DAY CORE_PROPERTIES PERF_DETAIL PERF_SAMPLE PRODUCT_INSTANCE TASK_CONFIGURATION
`pkg_return_items`	BUSINESS_DAY_VIEW CORE_PROPERTIES_DATA GET_OPERATIONAL_TZ_TIME_NOW_V INBOUND_CASHLETTER_DATA ITEM_V J_GET_OPER_TS_WITH_TZID (UDF) OBJ_OBJ_REL_V PAYMENT_DATA REASON_CODES_V	BANK BUSINESS_DAY CASH_LETTER CORE_PROPERTIES DEPOSITOR_PRODUCTS ITEM OBJ_OBJ_REL PARTNER_GENERAL PAYMENT PAYMENT_MESSAGE_TYPE PAYMENT_STANDARD_TYPE PRES_PRES_XREF PRESENTMENT PRESENTMENT_GROUP PRESENTMENT_TYPE PROCESSING_WINDOW REASON_CODES
`pkg_risk_monitor`	BUSINESS_DAY_VIEW CORE_PROPERTIES_DATA ERROR_CODES_V GET_OPERATIONAL_TZ_TIME_NOW_V INBOUND_CASHLETTER_DATA J_GET_OPER_TS_WITH_TZID (UDF) PARTNER_PROFILE PAYMENT_DATA RISK_ACT_MONITOR_V RISK_DEPOSIT_REJECT_V RISK_MONITOR_DEF_V RISK_PAYMENT_MONITOR_REJECT_V RISK_REJECT_V RISK_TEMP_MONITOR_CHANGE_V RISK_TRANSMISSION_ACT_MONITORED_V	BANK BUSINESS_DAY CASH_LETTER CASH_LETTER_VAL CORE_PROPERTIES DEPOSITOR_ATTR DEPOSITOR_CHANNEL_DEF DEPOSITOR_PRODUCTS ERROR_CATEGORIES ERROR_CODES FILE FILE_VAL ITEM ITEM_VAL PARTNER_ADDRESS PARTNER_GENERAL PARTNER_ROLE PAYMENT PAYMENT_MESSAGE_TYPE PAYMENT_STANDARD_TYPE PPTYPE PRES_PRES_XREF PRESENTMENT PRESENTMENT_GROUP PRESENTMENT_TYPE PROCESSING_WINDOW REJECT_LEVELS RISK_ACT_MONITOR RISK_DEPOSIT_REJECT RISK_MONITOR_DEF RISK_PAYMENT_MONITOR_REJECT RISK_PAYMENT_REJECT RISK_TEMP_MONITOR_CHANGE RISK_TRANSMISSION_REJECT ROLE_TYPES
`pkg_tcr_uow_adjustments`	BUSINESS_DAY_VIEW CORE_PROPERTIES_DATA GET_OPERATIONAL_TZ_TIME_NOW_V J_GET_OPER_TS_WITH_TZID (UDF) TCR_ACTIONS_AUDIT_V TCR_ACTIVE_WORK_AUDIT_V	BUSINESS_DAY CORE_PROPERTIES TCR_ACTIONS_AUDIT TCR_ACTIVE_WORK_AUDIT
`pkg_transaction_authorization`	BUSINESS_DAY_VIEW CORE_PROPERTIES_DATA ERROR_CODES_V GET_OPERATIONAL_TZ_TIME_NOW_V INBOUND_CASHLETTER_DATA J_GET_OPER_TS_WITH_TZID (UDF) PAY_AUTH_CONFIG_REPORT_V PAYMENT_DATA RISK_REJECT_V	BANK BUSINESS_DAY CASH_LETTER CORE_PROPERTIES DEPOSITOR_PRODUCTS ERROR_CATEGORIES ERROR_CODES ITEM PARTNER_GENERAL PAYMENT PAYMENT_MESSAGE_TYPE PAYMENT_STANDARD_TYPE PRES_PRES_XREF PRESENTMENT PRESENTMENT_GROUP PRESENTMENT_TYPE PROCESSING_WINDOW REJECT_LEVELS RISK_PAYMENT_AUTH RISK_PAYMENT_FILTER RISK_PAYMENT_REJECT