DATADA.AI
Online v0.9.0
data_entities 791 records
Home
model_id color physical_name origin use_type entity_type materialization_type business_domain scd_type file_type dialect dwh_use_type schema_name database_name id name description created_by_id updated_by_id created_at updated_at version deleted x y
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