Data Model Updates
The following new tables were added in this release to support the Data Pipeline updates:
- FCC_EMP_LOOKUP
- FCC_EMP
- FCC_EMP_EMAIL_ADDR
- FCC_PEER_GRP_LOOKUP
- FCC_ACCT_PEER_GRP
- FCC_PEER_GRP
- FCC_ACCT_PEER_GRP_SMRY_MNTH
- FCC_ACCT_PEER_GRP_SMRY_MNTH_AUD
New columns have been added to the data model for the following tables:
- FCC_DERIVED_ADDR Table
- V_ADDRESS_DISTRICT
- V_ADDRESS_FLOOR
- V_ADDRESS_PURPOSE
- V_BUILDING_NAME
- V_BUILDING_NUMBER
- V_DEPARTMENT
- V_SUB_DEPARTMENT
- FCC_ACCT_DIM Table
- V_RPTNG_CRNCY_CD
- FCC_CUST_DIM Table
- V_NATIONALITY_REGION
- V_LEI_CODE
- N_AGE
- V_RELATIONSHIP_TEAM_CD
These data model updates support the new features in this release while also allowing the data model to consume the granular payment information offered by the new ISO20022 standard.
Steps to enable and configure
You don't need to do anything to enable this feature.
Tips and considerations
- Customers must populate Party Type Master and Party Role Map tables with the required data. Both tables are essential for the proper operation of the customer dimension table and other business tables.
- These new tables will only apply to new implementations or existing clients who have provisioned post 24.08.01.