|
00000000-demo-bank-mod2-000000000001
|
null
|
null
|
null
|
UseType.SOURCE
|
EntityType.TABLE
|
null
|
CRM
|
null
|
null
|
null
|
null
|
null
|
null
|
00000000-demo-bank-e201-000000000006
|
CRM_ACCOUNT
|
CRM - Business account/company
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:29
|
2
|
|
-481
|
-1489
|
|
00000000-demo-bank-mod2-000000000001
|
null
|
null
|
null
|
UseType.SOURCE
|
EntityType.TABLE
|
null
|
CRM
|
null
|
null
|
null
|
null
|
null
|
null
|
00000000-demo-bank-e201-000000000005
|
CRM_CONTACT
|
CRM - Contact/lead information
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:29
|
2
|
|
9
|
-1090
|
|
00000000-demo-bank-mod2-000000000001
|
null
|
null
|
null
|
UseType.SOURCE
|
EntityType.TABLE
|
null
|
Core Banking
|
null
|
null
|
null
|
null
|
null
|
null
|
00000000-demo-bank-e201-000000000004
|
CBS_FUNDS_TRANSFER
|
Core Banking System - Funds transfer transactions
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:29
|
2
|
|
-697
|
632
|
|
00000000-demo-bank-mod2-000000000001
|
null
|
null
|
null
|
UseType.SOURCE
|
EntityType.TABLE
|
null
|
Core Banking
|
null
|
null
|
null
|
null
|
null
|
null
|
00000000-demo-bank-e201-000000000003
|
CBS_LOAN
|
Core Banking System - Loan master data
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:29
|
2
|
|
-462
|
507
|
|
00000000-demo-bank-mod2-000000000001
|
null
|
null
|
null
|
UseType.SOURCE
|
EntityType.TABLE
|
null
|
Core Banking
|
null
|
null
|
null
|
null
|
null
|
null
|
00000000-demo-bank-e201-000000000002
|
CBS_ACCOUNT
|
Core Banking System - Account master data
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:29
|
2
|
|
-673
|
398
|
|
00000000-demo-bank-mod2-000000000001
|
null
|
null
|
null
|
UseType.SOURCE
|
EntityType.TABLE
|
null
|
Core Banking
|
null
|
null
|
null
|
null
|
null
|
null
|
00000000-demo-bank-e201-000000000001
|
CBS_CUSTOMER
|
Core Banking System - Customer master data
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:29
|
2
|
|
-455
|
259
|
|
00000000-demo-bank-mod4-000000000001
|
null
|
null
|
null
|
UseType.SOURCE
|
EntityType.TABLE
|
null
|
Silver - Reference
|
null
|
null
|
null
|
null
|
null
|
null
|
00000000-demo-bank-e401-000000000009
|
REF_EXCHANGE_RATE
|
Reference exchange rate data
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:29
|
2
|
|
785
|
125
|
|
00000000-demo-bank-mod4-000000000001
|
null
|
null
|
null
|
UseType.SOURCE
|
EntityType.TABLE
|
null
|
Silver - Reference
|
null
|
null
|
null
|
null
|
null
|
null
|
00000000-demo-bank-e401-000000000008
|
REF_CURRENCY
|
Reference currency data
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:29
|
2
|
|
508
|
20
|
|
00000000-demo-bank-mod4-000000000001
|
null
|
null
|
null
|
UseType.SOURCE
|
EntityType.TABLE
|
null
|
Silver - Reference
|
null
|
null
|
null
|
null
|
null
|
null
|
00000000-demo-bank-e401-000000000007
|
REF_COUNTRY
|
Reference country data
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:29
|
2
|
|
260
|
163
|
|
00000000-demo-bank-mod4-000000000001
|
null
|
null
|
null
|
UseType.SOURCE
|
EntityType.TABLE
|
null
|
Silver - Contact Center
|
null
|
null
|
null
|
null
|
null
|
null
|
00000000-demo-bank-e401-000000000006
|
STG_INTERACTION
|
Cleansed contact center interactions (append-only)
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:29
|
2
|
|
-128
|
-626
|
|
00000000-demo-bank-mod4-000000000001
|
null
|
null
|
null
|
UseType.SOURCE
|
EntityType.TABLE
|
null
|
Silver - Cards
|
null
|
null
|
null
|
null
|
null
|
null
|
00000000-demo-bank-e401-000000000005
|
STG_CARD_TRANSACTION
|
Cleansed card transactions (append-only)
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:29
|
2
|
|
-1251
|
-82
|
|
00000000-demo-bank-mod4-000000000001
|
null
|
null
|
null
|
UseType.SOURCE
|
EntityType.TABLE
|
null
|
Silver - Transactions
|
null
|
null
|
null
|
null
|
null
|
null
|
00000000-demo-bank-e401-000000000004
|
STG_TRANSACTION
|
Cleansed funds transfer transactions (append-only)
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:29
|
2
|
|
-909
|
-932
|
|
00000000-demo-bank-mod4-000000000001
|
null
|
null
|
null
|
UseType.SOURCE
|
EntityType.TABLE
|
null
|
Silver - Lending
|
null
|
null
|
null
|
null
|
null
|
null
|
00000000-demo-bank-e401-000000000003
|
STG_LOAN
|
Cleansed and conformed loan data with SCD Type 2
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:29
|
2
|
|
-31
|
700
|
|
00000000-demo-bank-mod4-000000000001
|
null
|
null
|
null
|
UseType.SOURCE
|
EntityType.TABLE
|
null
|
Silver - Account
|
null
|
null
|
null
|
null
|
null
|
null
|
00000000-demo-bank-e401-000000000002
|
STG_ACCOUNT
|
Cleansed and conformed account data with SCD Type 2
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:29
|
2
|
|
-612
|
284
|
|
00000000-demo-bank-mod4-000000000001
|
null
|
null
|
null
|
UseType.SOURCE
|
EntityType.TABLE
|
null
|
Silver - Customer
|
null
|
null
|
null
|
null
|
null
|
null
|
00000000-demo-bank-e401-000000000001
|
STG_CUSTOMER
|
Cleansed and conformed customer data with SCD Type 2
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:29
|
2
|
|
175
|
-1597
|
|
00000000-demo-bank-mod5-000000000001
|
null
|
null
|
null
|
UseType.SOURCE
|
EntityType.TABLE
|
null
|
Gold - Marts
|
null
|
null
|
null
|
null
|
null
|
null
|
00000000-demo-bank-e501-000000000015
|
MART_DAILY_TRANSACTIONS
|
Daily transaction summary mart
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:29
|
2
|
|
-489
|
1156
|
|
00000000-demo-bank-mod5-000000000001
|
null
|
null
|
null
|
UseType.SOURCE
|
EntityType.TABLE
|
null
|
Gold - Marts
|
null
|
null
|
null
|
null
|
null
|
null
|
00000000-demo-bank-e501-000000000014
|
MART_LOAN_PORTFOLIO
|
Loan portfolio analytics mart
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:29
|
2
|
|
-531
|
182
|
|
00000000-demo-bank-mod5-000000000001
|
null
|
null
|
null
|
UseType.SOURCE
|
EntityType.TABLE
|
null
|
Gold - Marts
|
null
|
null
|
null
|
null
|
null
|
null
|
00000000-demo-bank-e501-000000000013
|
MART_CUSTOMER_360
|
Customer 360 aggregated view
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:29
|
2
|
|
-674
|
449
|
|
00000000-demo-bank-mod5-000000000001
|
null
|
null
|
null
|
UseType.SOURCE
|
EntityType.TABLE
|
null
|
Gold - Facts
|
null
|
null
|
null
|
null
|
null
|
null
|
00000000-demo-bank-e501-000000000012
|
FACT_INTERACTION
|
Contact center interaction fact
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:29
|
2
|
|
122
|
456
|
|
00000000-demo-bank-mod5-000000000001
|
null
|
null
|
null
|
UseType.SOURCE
|
EntityType.TABLE
|
null
|
Gold - Facts
|
null
|
null
|
null
|
null
|
null
|
null
|
00000000-demo-bank-e501-000000000011
|
FACT_LOAN_SNAPSHOT
|
Monthly loan balance snapshot fact
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:29
|
2
|
|
985
|
377
|
|
00000000-demo-bank-mod5-000000000001
|
null
|
null
|
null
|
UseType.SOURCE
|
EntityType.TABLE
|
null
|
Gold - Facts
|
null
|
null
|
null
|
null
|
null
|
null
|
00000000-demo-bank-e501-000000000010
|
FACT_CARD_TRANSACTION
|
Card transaction fact table
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:29
|
2
|
|
367
|
624
|
|
00000000-demo-bank-mod5-000000000001
|
null
|
null
|
null
|
UseType.SOURCE
|
EntityType.TABLE
|
null
|
Gold - Facts
|
null
|
null
|
null
|
null
|
null
|
null
|
00000000-demo-bank-e501-000000000009
|
FACT_TRANSACTION
|
Transaction fact table
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:29
|
2
|
|
962
|
713
|
|
00000000-demo-bank-mod5-000000000001
|
null
|
null
|
null
|
UseType.SOURCE
|
EntityType.TABLE
|
null
|
Gold - Facts
|
null
|
null
|
null
|
null
|
null
|
null
|
00000000-demo-bank-e501-000000000008
|
FACT_ACCOUNT_BALANCE
|
Daily account balance snapshot fact
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:29
|
2
|
|
681
|
595
|
|
00000000-demo-bank-mod5-000000000001
|
null
|
null
|
null
|
UseType.SOURCE
|
EntityType.TABLE
|
null
|
Gold - Bridges
|
null
|
null
|
null
|
null
|
null
|
null
|
00000000-demo-bank-e501-000000000007
|
BRIDGE_CUSTOMER_ACCOUNT
|
Bridge table for customer-account many-to-many
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:29
|
2
|
|
-57
|
1809
|
|
00000000-demo-bank-mod5-000000000001
|
null
|
null
|
null
|
UseType.SOURCE
|
EntityType.TABLE
|
null
|
Gold - Dimensions
|
null
|
null
|
null
|
null
|
null
|
null
|
00000000-demo-bank-e501-000000000006
|
DIM_MERCHANT_CATEGORY
|
Merchant category code dimension
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:29
|
2
|
|
-1127
|
-1259
|
|
00000000-demo-bank-mod5-000000000001
|
null
|
null
|
null
|
UseType.SOURCE
|
EntityType.TABLE
|
null
|
Gold - Dimensions
|
null
|
null
|
null
|
null
|
null
|
null
|
00000000-demo-bank-e501-000000000005
|
DIM_CHANNEL
|
Channel dimension
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:29
|
2
|
|
-472
|
-1765
|
|
00000000-demo-bank-mod5-000000000001
|
null
|
null
|
null
|
UseType.SOURCE
|
EntityType.TABLE
|
null
|
Gold - Dimensions
|
null
|
null
|
null
|
null
|
null
|
null
|
00000000-demo-bank-e501-000000000004
|
DIM_DATE
|
Date dimension (role-playing)
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:29
|
2
|
|
-518
|
-1611
|
|
00000000-demo-bank-mod5-000000000001
|
null
|
null
|
null
|
UseType.SOURCE
|
EntityType.TABLE
|
null
|
Gold - Dimensions
|
null
|
null
|
null
|
null
|
null
|
null
|
00000000-demo-bank-e501-000000000003
|
DIM_LOAN
|
Loan dimension with SCD Type 2
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:29
|
2
|
|
-761
|
-1758
|
|
00000000-demo-bank-mod5-000000000001
|
null
|
null
|
null
|
UseType.SOURCE
|
EntityType.TABLE
|
null
|
Gold - Dimensions
|
null
|
null
|
null
|
null
|
null
|
null
|
00000000-demo-bank-e501-000000000002
|
DIM_ACCOUNT
|
Account dimension with SCD Type 2
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:29
|
2
|
|
-294
|
-1044
|
|
00000000-demo-bank-mod5-000000000001
|
null
|
null
|
null
|
UseType.SOURCE
|
EntityType.TABLE
|
null
|
Gold - Dimensions
|
null
|
null
|
null
|
null
|
null
|
null
|
00000000-demo-bank-e501-000000000001
|
DIM_CUSTOMER
|
Customer dimension with SCD Type 2
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:29
|
2
|
|
-235
|
-1772
|
|
00000000-demo-bank-mod3-000000000001
|
null
|
null
|
null
|
UseType.SOURCE
|
EntityType.TABLE
|
null
|
Bronze - Reference
|
null
|
null
|
null
|
null
|
null
|
null
|
00000000-demo-bank-e301-000000000011
|
RAW_REF_EXCHANGE_RATE
|
Raw exchange rate reference data
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:29
|
2
|
|
-258
|
596
|
|
00000000-demo-bank-mod3-000000000001
|
null
|
null
|
null
|
UseType.SOURCE
|
EntityType.TABLE
|
null
|
Bronze - Reference
|
null
|
null
|
null
|
null
|
null
|
null
|
00000000-demo-bank-e301-000000000010
|
RAW_REF_CURRENCY
|
Raw currency reference data
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:29
|
2
|
|
-431
|
851
|
|
00000000-demo-bank-mod3-000000000001
|
null
|
null
|
null
|
UseType.SOURCE
|
EntityType.TABLE
|
null
|
Bronze - Reference
|
null
|
null
|
null
|
null
|
null
|
null
|
00000000-demo-bank-e301-000000000009
|
RAW_REF_COUNTRY
|
Raw country reference data
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:29
|
2
|
|
-533
|
576
|
|
00000000-demo-bank-mod3-000000000001
|
null
|
null
|
null
|
UseType.SOURCE
|
EntityType.TABLE
|
null
|
Bronze - Contact Center
|
null
|
null
|
null
|
null
|
null
|
null
|
00000000-demo-bank-e301-000000000008
|
RAW_CC_INTERACTION
|
Raw interaction data from Contact Center
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:29
|
2
|
|
711
|
-160
|
|
00000000-demo-bank-mod3-000000000001
|
null
|
null
|
null
|
UseType.SOURCE
|
EntityType.TABLE
|
null
|
Bronze - Card Processing
|
null
|
null
|
null
|
null
|
null
|
null
|
00000000-demo-bank-e301-000000000007
|
RAW_CARD_TRANSACTION
|
Raw card transaction data from Card Processing
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:29
|
2
|
|
431
|
657
|
|
00000000-demo-bank-mod3-000000000001
|
null
|
null
|
null
|
UseType.SOURCE
|
EntityType.TABLE
|
null
|
Bronze - CRM
|
null
|
null
|
null
|
null
|
null
|
null
|
00000000-demo-bank-e301-000000000006
|
RAW_CRM_OPPORTUNITY
|
Raw opportunity data from CRM
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:29
|
2
|
|
-1029
|
-297
|
|
00000000-demo-bank-mod3-000000000001
|
null
|
null
|
null
|
UseType.SOURCE
|
EntityType.TABLE
|
null
|
Bronze - CRM
|
null
|
null
|
null
|
null
|
null
|
null
|
00000000-demo-bank-e301-000000000005
|
RAW_CRM_CONTACT
|
Raw contact data from CRM
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:29
|
2
|
|
-723
|
-324
|
|
00000000-demo-bank-mod3-000000000001
|
null
|
null
|
null
|
UseType.SOURCE
|
EntityType.TABLE
|
null
|
Bronze - Core Banking
|
null
|
null
|
null
|
null
|
null
|
null
|
00000000-demo-bank-e301-000000000004
|
RAW_CBS_FUNDS_TRANSFER
|
Raw funds transfer data from Core Banking System
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:29
|
2
|
|
76
|
-1188
|
|
00000000-demo-bank-mod3-000000000001
|
null
|
null
|
null
|
UseType.SOURCE
|
EntityType.TABLE
|
null
|
Bronze - Core Banking
|
null
|
null
|
null
|
null
|
null
|
null
|
00000000-demo-bank-e301-000000000003
|
RAW_CBS_LOAN
|
Raw loan data from Core Banking System
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:29
|
2
|
|
352
|
-1170
|
|
00000000-demo-bank-mod3-000000000001
|
null
|
null
|
null
|
UseType.SOURCE
|
EntityType.TABLE
|
null
|
Bronze - Core Banking
|
null
|
null
|
null
|
null
|
null
|
null
|
00000000-demo-bank-e301-000000000002
|
RAW_CBS_ACCOUNT
|
Raw account data from Core Banking System
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:29
|
2
|
|
-59
|
-925
|
|
00000000-demo-bank-mod3-000000000001
|
null
|
null
|
null
|
UseType.SOURCE
|
EntityType.TABLE
|
null
|
Bronze - Core Banking
|
null
|
null
|
null
|
null
|
null
|
null
|
00000000-demo-bank-e301-000000000001
|
RAW_CBS_CUSTOMER
|
Raw customer data from Core Banking System
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:29
|
2
|
|
215
|
-903
|