14M D1: CCRSM072 'Multiple Credit Card Relationships' Incorrect Sourcing Column
(Doc ID 2607017.1)
Last updated on NOVEMBER 11, 2019
Applies to:Oracle Financial Services - Regulatory Reporting for US Federal Reserve - Lombard Risk Integration Pack - Version 8.0.7 and later
Information in this document applies to any platform.
Report FR-Y1 4M Schedule D1- MDRM: CCRSM072 (Multiple Credit Card Relationships)
The OFSAA lineage file for shows STG_CARDS.N_NO_ADD_ON_CARDS as the source. The MDRM requires identifying when the bank has issued more than one credit card to the primary or joint account holder.
The MDRM uses FCT_CARDS_SUMMARY.F_MULTIPLE_CARDS_ISSUED. The sourcing for this is based on expression in T2T_FCT_CARDS_SUMMARY (FSDF 80710 Technical metadata) of ‘CASE WHEN STG_CARDS.N_NO_ADD_ON_CARDS > 0 THEN 'Y' ELSE 'N' END’
STG_CARDS.N_NO_ADD_ON_CARDS has column description “This column stores the number of Add-on cards taken on a card.” Also an add-on card is simply an additional card offered to the spouse, parents or children of the primary credit card holder (of a single card account). NO_ADD_ON_CARDS captures for a particular single credit card account, additional add-on cards have been issued. Hence this Staging table column does not meet the requirement of multiple credit card relationships.
Issue: An appropriate logic required to satisfy the requirement to determine reporting accounts where the bank has issued more than one credit card to the primary or joint account holder(s).
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document