Data Source - created from Mind Map

Page 1

M4V

Migration DB

CBO MI

OneMI

CB DB

bb_profit DB

M4V_Cust

M4V_Prod

cepm

OCIS ID (PTY_ID)

GRP_PTY_ID

OCIS ID (PTY_ID)

OCIS ID (PTY_ID)

Shows all sorts of products which the client has . i.e lending limit

COL/ LOLI/ DIAL UP

COG

COG

Each channel shows clients' usage, such as last logon time , status, model

Single Client VIew

Reg ID

Reg ID

Reg ID

COM CMD ID

COM CMD ID

COM CMD ID

# of payments

BACS

CHAPS

Faster Pay

Inter Pay

SCV1_ACC

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

Account

MRG_PTY_ID

CMD_ID

GRO_ID

COL -agreementnumber

LOLI - cus_ID

Dial up ( we do't know yet)

REG_ID

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

Star Schema -OLAP

SQL Server

Event audit

webseries (payments)

Client series

Daily Reg & System report

Users

Legal Entity

Device

Financial performance

Client View MM GC FI

RWA

RAI

Balances

Income from different prod

Drawn lending

Off B/S lending

CB PE Assets

CB PE Liabilities

NII

OOI

Supergroup / Ultimate Relationship Group Crisp ID

Complex group (A brand)

Legal Entity ID

Lgl Ent ID

Lgl Ent ID

URG

URG

CB CUST_All

Cust ID

COM CMD ID

CRISP ID