Commercial Digital

Annotations:

• Questions ideas from Single client view Jan2015  slide -19

Annotations:

• Questions ideas from Single client view Jan2015  slide -19

1. ETL
   1. Migrated DB
      1. COL
      2. LOLI
      3. Dial -up Applications
   2. COB
   3. One MI
   4. M4V

1. Data Sources
   1. New Digital
      1. CBO
      2. Payments
   2. Old Digital
      1. COL
      2. LOLI
      3. Dial-up Applications
   3. GDW
      1. CMD
         1. All Legal Entity's
      2. MM ( Mid Markets)
   4. One MI
      1. Financial Data
         1. SQL SERVER ,SSAS & Excel
   5. M4V
      1. SME Data
         1. Might be Oracle or SQL Server ???
   6. OCIS
      1. All SME records
2. Client

   Annotations:

   • Client known as Untimate Relationship Group or Super Group. But all clients may not come under super group - some clients are big, they may have different COG's and different Legan Entity's. It could be one single big company who are group of clients ... ( can I assume like that ?) 
   1. URG (Ultimate Relationship Group) or Super Group
   2. Legal Entity
      1. Legal Entity will have CMDID
   3. Legal Entity Group
      1. Legal Entity Group will have CRISPID
   4. Client will have CRISPID
3. Channels
   1. Legacy System
      1. COL
      2. WID&V
      3. POLI
      4. THINLINK
      5. EBS/DIAL-UP
4. System
   1. OCIS MI

      Annotations:

      • Contains facility and account information for customers of Lloyds TSB Corporate and Wholesale Banking Operations.
   2. COM CMD

      Annotations:

      • Provides a view of the customer across LTSB heritage Corporate Markets
   3. CRISP

      Annotations:

      • Contains facility and account information for customers of Lloyds TSB Corporate and Wholesale Banking Operations.     
5. Business Units
   1. FI ( Financial Institutions)
   2. GC ( Global Corporate)
   3. MM ( Mid Markets)
   4. BSU/ Non-Core
   5. SME
   6. International
   7. RBB
   8. Private Banking
   9. Overall Average