Data Source

Data Source

1. M4V

   • bb_profit DB
     • M4V_Cust
       • OCIS ID (PTY_ID)
       • GRP_PTY_ID
         • OCIS ID (PTY_ID)
         • OCIS ID (PTY_ID)
     • M4V_Prod
       • Shows all sorts of products which the client has . i.e lending limit
     • cepm

2. Migration DB

   • COL/ LOLI/ DIAL UP
     • COG
       • Reg ID
       • Reg ID
       • Reg ID
         • COM CMD ID
         • CRISP GRO ID
         • OCIS MRG ID
     • Each channel shows clients' usage, such as last logon time , status, model
       • Vol & Val of payments
         • BACS
         • CHAPS
         • Faster Pay
         • Inter Pay
     • Single Client VIew
       • SCV1_ACC
         • REG_ID
           • Instead of having three different columns for each channel ,Migration developers decided to put customer identifiers as REG_ID in Migrated DB.This column represents different column name in underlined channel tables or databases 
           • COL -agreementnumber
           • LOLI - cus_ID
           • Dial up - Customer_ID
         • Account
         • MRG_PTY_ID
           • OCIS_PTY_ID
         • CMD_ID
         • GRO_ID
       • SCV1_REG
         • REG_ID
           • Instead of having three different columns for each channel ,Migration developers decided to put customer identifiers as REG_ID in Migrated DB.This column represents different column name in underlined channel tables or databases 
         • COG
           • COG - it is something similar to super group in OneMI but not exacty same.When they want to move clients to new digital platform (CBO) they want to move clients which come under one group at same time or in same batch.They grouped clients which have relation between then under one COG.basically they migrate clients who come under one COG in one batch.But this may not be the case always,as they found an issue with FI (Eg. AVIVA) .The COG AVIVA come under have more cliets which may not be directly linked to AVIVA ,so they may not want migrate all indirect linked clients to new digital platform at same time. From Digita reporting point of view: Roray may want slice and dice data from super group and COG point of view 

3. CBO MI

   • Star Schema -OLAP
   • SQL Server
     • Event audit
     • webseries (payments)
     • Client series
       • Users
         • Device
       • Legal Entity
     • Daily Reg & System report

4. OneMI

   • Financial performance
     • RWA
     • RAI
     • Balances
       • Drawn lending
       • Off B/S lending
       • CB PE Assets
       • CB PE Liabilities
     • Income from different prod
       • NII
       • OOI
   • Client View MM GC FI
     • Supergroup / Ultimate Relationship Group Crisp ID
       • Legal Entity ID
       • Lgl Ent ID
       • Lgl Ent ID
     • Complex group (A brand)
       • URG
       • URG

5. CB DB

   • CB CUST_All
     • Cust ID
     • COM CMD ID
     • CRISP ID