|
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:16:36
|
2026-01-03 15:16:37
|
2
|
|
1124
|
-364
|
|
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:16:36
|
2026-01-03 15:16:37
|
2
|
|
1051
|
-674
|
|
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:16:36
|
2026-01-03 15:16:37
|
2
|
|
-1428
|
-469
|
|
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:16:36
|
2026-01-03 15:16:37
|
2
|
|
-1681
|
-351
|
|
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:16:36
|
2026-01-03 15:16:37
|
2
|
|
-1456
|
-699
|
|
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:16:36
|
2026-01-03 15:16:37
|
2
|
|
-1222
|
-617
|
|
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:16:36
|
2026-01-03 15:16:37
|
2
|
|
564
|
170
|
|
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:16:36
|
2026-01-03 15:16:37
|
2
|
|
414
|
-134
|
|
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:16:36
|
2026-01-03 15:16:37
|
2
|
|
277
|
113
|
|
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:16:36
|
2026-01-03 15:16:37
|
2
|
|
-336
|
-666
|
|
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:16:36
|
2026-01-03 15:16:37
|
2
|
|
-1137
|
-100
|
|
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:16:36
|
2026-01-03 15:16:37
|
2
|
|
-636
|
204
|
|
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:16:36
|
2026-01-03 15:16:37
|
2
|
|
-1249
|
-1016
|
|
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:16:36
|
2026-01-03 15:16:37
|
2
|
|
195
|
707
|
|
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:16:36
|
2026-01-03 15:16:37
|
2
|
|
704
|
-1220
|
|
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:16:36
|
2026-01-03 15:16:37
|
2
|
|
-269
|
-406
|
|
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:16:36
|
2026-01-03 15:16:37
|
2
|
|
-186
|
-1103
|
|
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:16:36
|
2026-01-03 15:16:37
|
2
|
|
-486
|
-1365
|
|
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:16:36
|
2026-01-03 15:16:37
|
2
|
|
1571
|
361
|
|
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:16:36
|
2026-01-03 15:16:37
|
2
|
|
1597
|
-171
|
|
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:16:36
|
2026-01-03 15:16:37
|
2
|
|
1788
|
47
|
|
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:16:36
|
2026-01-03 15:16:37
|
2
|
|
1247
|
329
|
|
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:16:36
|
2026-01-03 15:16:37
|
2
|
|
1758
|
-432
|
|
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:16:36
|
2026-01-03 15:16:37
|
2
|
|
307
|
-442
|
|
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:16:36
|
2026-01-03 15:16:37
|
2
|
|
-1399
|
760
|
|
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:16:36
|
2026-01-03 15:16:37
|
2
|
|
-1383
|
236
|
|
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:16:36
|
2026-01-03 15:16:37
|
2
|
|
-1693
|
45
|
|
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:16:36
|
2026-01-03 15:16:37
|
2
|
|
-1995
|
13
|
|
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:16:36
|
2026-01-03 15:16:37
|
2
|
|
-1541
|
-193
|
|
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:16:36
|
2026-01-03 15:16:37
|
2
|
|
-1356
|
-522
|
|
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:16:36
|
2026-01-03 15:16:36
|
2
|
|
-270
|
535
|
|
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:16:36
|
2026-01-03 15:16:36
|
2
|
|
-445
|
789
|
|
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:16:36
|
2026-01-03 15:16:36
|
2
|
|
-545
|
513
|
|
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:16:36
|
2026-01-03 15:16:36
|
2
|
|
728
|
-254
|
|
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:16:36
|
2026-01-03 15:16:36
|
2
|
|
524
|
521
|
|
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:16:36
|
2026-01-03 15:16:36
|
2
|
|
-573
|
-61
|
|
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:16:36
|
2026-01-03 15:16:36
|
2
|
|
-856
|
-73
|
|
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:16:36
|
2026-01-03 15:16:36
|
2
|
|
145
|
-944
|
|
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:16:36
|
2026-01-03 15:16:36
|
2
|
|
-138
|
-944
|
|
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:16:36
|
2026-01-03 15:16:36
|
2
|
|
229
|
-1183
|
|
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:16:36
|
2026-01-03 15:16:36
|
2
|
|
-46
|
-1186
|