Data Source

lynnyu008
Mind Map by lynnyu008, updated more than 1 year ago
lynnyu008
Created by lynnyu008 almost 5 years ago
4
0

Description

a mind map for data source
Tags

Resource summary

Data Source
1 M4V
1.1 bb_profit DB
1.1.1 M4V_Cust
1.1.1.1 OCIS ID (PTY_ID)
1.1.1.2 GRP_PTY_ID
1.1.1.2.1 OCIS ID (PTY_ID)
1.1.1.2.2 OCIS ID (PTY_ID)
1.1.2 M4V_Prod
1.1.2.1 Shows all sorts of products which the client has . i.e lending limit
1.1.3 cepm
2 Migration DB
2.1 COL/ LOLI/ DIAL UP
2.1.1 COG
2.1.1.1 Reg ID
2.1.1.2 Reg ID
2.1.1.3 Reg ID
2.1.1.3.1 COM CMD ID
2.1.1.3.2 CRISP GRO ID
2.1.1.3.3 OCIS MRG ID
2.1.2 Each channel shows clients' usage, such as last logon time , status, model
2.1.2.1 Vol & Val of payments
2.1.2.1.1 BACS
2.1.2.1.2 CHAPS
2.1.2.1.3 Faster Pay
2.1.2.1.4 Inter Pay
2.1.3 Single Client VIew
2.1.3.1 SCV1_ACC
2.1.3.1.1 REG_ID

Annotations:

  • 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 
2.1.3.1.1.1 COL -agreementnumber
2.1.3.1.1.2 LOLI - cus_ID
2.1.3.1.1.3 Dial up - Customer_ID
2.1.3.1.2 Account
2.1.3.1.3 MRG_PTY_ID
2.1.3.1.3.1 OCIS_PTY_ID
2.1.3.1.4 CMD_ID
2.1.3.1.5 GRO_ID
2.1.3.2 SCV1_REG
2.1.3.2.1 REG_ID

Annotations:

  • 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 
2.1.3.2.2 COG

Annotations:

  • 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
3.1 Star Schema -OLAP
3.2 SQL Server
3.2.1 Event audit
3.2.2 webseries (payments)
3.2.3 Client series
3.2.3.1 Users
3.2.3.1.1 Device
3.2.3.2 Legal Entity
3.2.4 Daily Reg & System report
4 OneMI
4.1 Financial performance
4.1.1 RWA
4.1.2 RAI
4.1.3 Balances
4.1.3.1 Drawn lending
4.1.3.2 Off B/S lending
4.1.3.3 CB PE Assets
4.1.3.4 CB PE Liabilities
4.1.4 Income from different prod
4.1.4.1 NII
4.1.4.2 OOI
4.2 Client View MM GC FI
4.2.1 Supergroup / Ultimate Relationship Group Crisp ID
4.2.1.1 Legal Entity ID
4.2.1.2 Lgl Ent ID
4.2.1.3 Lgl Ent ID
4.2.2 Complex group (A brand)
4.2.2.1 URG
4.2.2.2 URG
5 CB DB
5.1 CB CUST_All
5.1.1 Cust ID
5.1.2 COM CMD ID
5.1.3 CRISP ID
Show full summary Hide full summary

Similar

Statistics, Data and Area (Semester 2 Exam)
meg willmington
Mathematics
Corey Lance
Chapter 7: Investigating Data
Sarah L
Maths Summarising Data
Will Thorpe
PRINCIPLES OF MARKETING
Greta Morrill
Computer Science - Binary
ethansung11
Quadratic MindMap:
Kitty Thomas
Real Estate
rozellejoseph
Comm 101 Mindmap
acostaa.maria
Mapa mental Outplacement
carlossepul_1991