Data Model Updates
The following new tables were added in this release to support the Data Pipeline updates:
- FCC_CORRES_PEER_GRP_SMRY_MNTH
- FCC_CORRES_BANK_PEER_GRP
- FCC_CORRES_PEER_GRP_SMRY_MNTH_AUD
- FCC_CORRES_ADDITIONAL_ATTR
- FCC_CORRES_BANK_RISK
- FCC_CORRES_SMRY_MONTH_AUD
- FCC_CORRES_SMRY_MONTH
- FCC_CORRESPONDENT_BANK
- FCC_ACCT_INSTN_MAP
The Not NULL constraint was dropped from the V_BUS_DOMAIN_CD column of the following tables:
- FCC_NVSMT_MGR
- FCC_EMP
Column F_LRI_FL was renamed to F_ACTIVE_FLAG in the FCC_ACCT_PEER_GRP_SMRY_MNTH table.
These data model updates support the new features in this release.
Steps to enable and configure
You don't need to do anything to enable this feature.
Tips and considerations
- These new tables will only apply to new implementations or existing clients who have provisioned post 24.08.01.
- Differences can occur between the defined lengths of staging and business columns. To avoid ingestion failures, compare both column lengths and use the smaller length when processing the data.