| entity_id | physical_name | origin | data_type | dialect_type | dialect | business_type | business_type_params | data_type_info | order | scale | is_primary_key | is_foreign_key | is_unique | is_nullable | is_autoincrement | is_surrogate_key | is_business_key | is_audit_column | is_scd_column | audit_role | scd_role | pii_level | pcidss_attribute | hipaa_identifier | id | name | description | created_by_id | updated_by_id | created_at | updated_at | version | deleted |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 00000000-demo-bank-e201-000000000001 | null | null | STRING | VARCHAR | null | null | null | null | 5 | null | null | null | PIILevel.SENSITIVE | null | HIPAAIdentifier.SSN | 00000000-demo-bank-a201-000000000006 | NAT_ID | National ID number | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e201-000000000001 | null | null | DATE | null | null | null | null | null | 4 | null | null | null | PIILevel.DIRECT | null | HIPAAIdentifier.DATES | 00000000-demo-bank-a201-000000000005 | DOB | Date of birth | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e201-000000000001 | null | null | STRING | VARCHAR | null | null | null | null | 3 | null | null | null | PIILevel.DIRECT | null | HIPAAIdentifier.NAMES | 00000000-demo-bank-a201-000000000004 | LAST_NM | Last name | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e201-000000000001 | null | null | STRING | VARCHAR | null | null | null | null | 2 | null | null | null | PIILevel.DIRECT | null | HIPAAIdentifier.NAMES | 00000000-demo-bank-a201-000000000003 | FIRST_NM | First name | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e201-000000000001 | null | null | CHAR | null | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-bank-a201-000000000002 | CUST_TYPE | Customer type code | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e201-000000000001 | null | null | STRING | VARCHAR | null | null | null | null | 0 | null | null | null | PIILevel.INDIRECT | null | null | 00000000-demo-bank-a201-000000000001 | CUST_ID | Customer identifier | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e401-000000000009 | null | null | STRING | TIMESTAMP_NTZ | null | null | null | null | 7 | null | null | null | null | null | null | 00000000-demo-bank-a409-000000000008 | _LOADED_AT | ETL load timestamp | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e401-000000000009 | null | null | STRING | VARCHAR | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-bank-a409-000000000007 | RATE_SOURCE | Rate source | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e401-000000000009 | null | null | DATE | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-bank-a409-000000000006 | EFFECTIVE_DATE | Effective date | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e401-000000000009 | null | null | STRING | NUMBER | null | null | null | null | 4 | 8 | null | null | null | null | null | 00000000-demo-bank-a409-000000000005 | EXCHANGE_RATE | Exchange rate | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e401-000000000009 | null | null | STRING | VARCHAR | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-bank-a409-000000000004 | RATE_TYPE | Rate type (MID/BUY/SELL) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e401-000000000009 | null | null | CHAR | null | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-bank-a409-000000000003 | TO_CURRENCY_CODE | To currency | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e401-000000000009 | null | null | CHAR | null | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-bank-a409-000000000002 | FROM_CURRENCY_CODE | From currency | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e401-000000000009 | null | null | STRING | NUMBER | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-bank-a409-000000000001 | EXCHANGE_RATE_SK | Surrogate key | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e401-000000000008 | null | null | STRING | TIMESTAMP_NTZ | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-bank-a408-000000000007 | _UPDATED_AT | Last update timestamp | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e401-000000000008 | null | null | STRING | TIMESTAMP_NTZ | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-bank-a408-000000000006 | _LOADED_AT | ETL load timestamp | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e401-000000000008 | null | null | BOOLEAN | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-bank-a408-000000000005 | IS_ACTIVE | Active flag | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e401-000000000008 | null | null | INTEGER | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-bank-a408-000000000004 | DECIMAL_PLACES | Decimal places | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e401-000000000008 | null | null | STRING | VARCHAR | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-bank-a408-000000000003 | CURRENCY_SYMBOL | Currency symbol | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e401-000000000008 | null | null | STRING | VARCHAR | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-bank-a408-000000000002 | CURRENCY_NAME | Currency name | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e401-000000000008 | null | null | CHAR | null | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-bank-a408-000000000001 | CURRENCY_CODE | ISO currency code | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e401-000000000007 | null | null | STRING | TIMESTAMP_NTZ | null | null | null | null | 7 | null | null | null | null | null | null | 00000000-demo-bank-a407-000000000008 | _UPDATED_AT | Last update timestamp | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e401-000000000007 | null | null | STRING | TIMESTAMP_NTZ | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-bank-a407-000000000007 | _LOADED_AT | ETL load timestamp | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e401-000000000007 | null | null | BOOLEAN | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-bank-a407-000000000006 | IS_SEPA_MEMBER | SEPA member flag | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e401-000000000007 | null | null | BOOLEAN | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-bank-a407-000000000005 | IS_EU_MEMBER | EU member flag | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e401-000000000007 | null | null | STRING | VARCHAR | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-bank-a407-000000000004 | REGION | Geographic region | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e401-000000000007 | null | null | STRING | VARCHAR | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-bank-a407-000000000003 | COUNTRY_NAME | Country name | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e401-000000000007 | null | null | CHAR | null | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-bank-a407-000000000002 | COUNTRY_CODE_3 | ISO 3-letter country code | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e401-000000000007 | null | null | CHAR | null | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-bank-a407-000000000001 | COUNTRY_CODE | ISO 2-letter country code | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e401-000000000006 | null | null | STRING | TIMESTAMP_NTZ | null | null | null | null | 15 | null | null | null | null | null | null | 00000000-demo-bank-a406-000000000016 | _LOADED_AT | ETL load timestamp | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e401-000000000006 | null | null | STRING | VARCHAR | null | null | null | null | 14 | null | null | null | null | null | null | 00000000-demo-bank-a406-000000000015 | SOURCE_SYSTEM | Source system identifier | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e401-000000000006 | null | null | STRING | NUMBER | null | null | null | null | 13 | 2 | null | null | null | null | null | 00000000-demo-bank-a406-000000000014 | SENTIMENT_SCORE | Sentiment score (-1 to 1) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e401-000000000006 | null | null | STRING | VARCHAR | null | null | null | null | 12 | null | null | null | null | null | null | 00000000-demo-bank-a406-000000000013 | TOPIC | Interaction topic | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e401-000000000006 | null | null | STRING | VARCHAR | null | null | null | null | 11 | null | null | null | null | null | null | 00000000-demo-bank-a406-000000000012 | DISPOSITION | Disposition code | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e401-000000000006 | null | null | INTEGER | null | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-bank-a406-000000000011 | HANDLE_TIME_SECONDS | Handle time in seconds | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e401-000000000006 | null | null | INTEGER | null | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-bank-a406-000000000010 | WAIT_TIME_SECONDS | Wait time in seconds | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e401-000000000006 | null | null | STRING | TIMESTAMP_NTZ | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-bank-a406-000000000009 | END_TIMESTAMP | End timestamp | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e401-000000000006 | null | null | STRING | TIMESTAMP_NTZ | null | null | null | null | 7 | null | null | null | null | null | null | 00000000-demo-bank-a406-000000000008 | START_TIMESTAMP | Start timestamp | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e401-000000000006 | null | null | STRING | VARCHAR | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-bank-a406-000000000007 | AGENT_ID | Agent identifier | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e401-000000000006 | null | null | STRING | VARCHAR | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-bank-a406-000000000006 | QUEUE_ID | Queue identifier | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e401-000000000006 | null | null | STRING | VARCHAR | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-bank-a406-000000000005 | DIRECTION | Direction (INBOUND/OUTBOUND) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e401-000000000006 | null | null | STRING | VARCHAR | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-bank-a406-000000000004 | CHANNEL | Channel (VOICE/CHAT/EMAIL) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e401-000000000006 | null | null | STRING | VARCHAR | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-bank-a406-000000000003 | CUSTOMER_BK | Customer business key | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e401-000000000006 | null | null | STRING | VARCHAR | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-bank-a406-000000000002 | INTERACTION_BK | Business key | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e401-000000000006 | null | null | STRING | NUMBER | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-bank-a406-000000000001 | INTERACTION_SK | Surrogate key | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e401-000000000005 | null | null | STRING | TIMESTAMP_NTZ | null | null | null | null | 18 | null | null | null | null | null | null | 00000000-demo-bank-a405-000000000019 | _LOADED_AT | ETL load timestamp | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e401-000000000005 | null | null | STRING | VARCHAR | null | null | null | null | 17 | null | null | null | null | null | null | 00000000-demo-bank-a405-000000000018 | SOURCE_SYSTEM | Source system identifier | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e401-000000000005 | null | null | BOOLEAN | null | null | null | null | null | 16 | null | null | null | null | null | null | 00000000-demo-bank-a405-000000000017 | IS_CONTACTLESS | Contactless transaction flag | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e401-000000000005 | null | null | BOOLEAN | null | null | null | null | null | 15 | null | null | null | null | null | null | 00000000-demo-bank-a405-000000000016 | IS_ONLINE | Online transaction flag | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 | ||||||||||
| 00000000-demo-bank-e401-000000000005 | null | null | STRING | VARCHAR | null | null | null | null | 14 | null | null | null | null | null | null | 00000000-demo-bank-a405-000000000015 | STATUS | Transaction status | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 |