Online
v0.9.0
Tables
data_attributes 9849 records
| 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-e501-000000000013 | null | null | INTEGER | null | null | null | null | null | 12 | null | null | null | null | null | null | 00000000-demo-bank-a513-000000000013 | ACTIVE_CARDS | Active cards count | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000013 | null | null | INTEGER | null | null | null | null | null | 11 | null | null | null | null | null | null | 00000000-demo-bank-a513-000000000012 | TOTAL_CARDS | Total number of cards | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000013 | null | null | STRING | NUMBER | null | null | null | null | 10 | 2 | null | null | null | null | null | 00000000-demo-bank-a513-000000000011 | TOTAL_LOAN_EXPOSURE | Total loan exposure | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000013 | null | null | INTEGER | null | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-bank-a513-000000000010 | ACTIVE_LOANS | Active loans count | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000013 | null | null | INTEGER | null | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-bank-a513-000000000009 | TOTAL_LOANS | Total number of loans | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000013 | null | null | STRING | NUMBER | null | null | null | null | 7 | 2 | null | null | null | null | null | 00000000-demo-bank-a513-000000000008 | TOTAL_BALANCE | Total balance across accounts | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000013 | null | null | INTEGER | null | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-bank-a513-000000000007 | ACTIVE_ACCOUNTS | Active accounts count | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000013 | null | null | INTEGER | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-bank-a513-000000000006 | TOTAL_ACCOUNTS | Total number of accounts | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000013 | null | null | INTEGER | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-bank-a513-000000000005 | TENURE_MONTHS | Tenure in months | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000013 | null | null | STRING | VARCHAR | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-bank-a513-000000000004 | CUSTOMER_SEGMENT | Customer segment | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000013 | null | null | STRING | VARCHAR | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-bank-a513-000000000003 | FULL_NAME | Full name | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000013 | null | null | STRING | VARCHAR | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-bank-a513-000000000002 | CUSTOMER_BK | Business key | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000013 | null | null | STRING | NUMBER | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-bank-a513-000000000001 | CUSTOMER_SK | Customer key | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000012 | null | null | STRING | VARCHAR | null | null | null | null | 12 | null | null | null | null | null | null | 00000000-demo-bank-a512-000000000013 | SENTIMENT_CATEGORY | Sentiment category (POSITIVE/NEUTRAL/NEGATIVE) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000012 | null | null | STRING | NUMBER | null | null | null | null | 11 | 2 | null | null | null | null | null | 00000000-demo-bank-a512-000000000012 | SENTIMENT_SCORE | Sentiment score | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000012 | null | null | INTEGER | null | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-bank-a512-000000000011 | TOTAL_TIME_SECONDS | Total time in seconds | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000012 | null | null | INTEGER | null | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-bank-a512-000000000010 | HANDLE_TIME_SECONDS | Handle time in seconds | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000012 | null | null | INTEGER | null | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-bank-a512-000000000009 | WAIT_TIME_SECONDS | Wait time in seconds | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000012 | null | null | STRING | VARCHAR | null | null | null | null | 7 | null | null | null | null | null | null | 00000000-demo-bank-a512-000000000008 | DISPOSITION | Disposition | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000012 | null | null | STRING | VARCHAR | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-bank-a512-000000000007 | TOPIC | Interaction topic | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000012 | null | null | STRING | VARCHAR | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-bank-a512-000000000006 | DIRECTION | Direction | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000012 | null | null | INTEGER | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-bank-a512-000000000005 | CHANNEL_SK | Channel dimension key | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000012 | null | null | INTEGER | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-bank-a512-000000000004 | INTERACTION_DATE_SK | Interaction date key | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000012 | null | null | STRING | NUMBER | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-bank-a512-000000000003 | CUSTOMER_SK | Customer dimension key | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000012 | null | null | STRING | VARCHAR | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-bank-a512-000000000002 | INTERACTION_BK | Business key | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000012 | null | null | STRING | NUMBER | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-bank-a512-000000000001 | INTERACTION_SK | Surrogate key | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000011 | null | null | STRING | VARCHAR | null | null | null | null | 11 | null | null | null | null | null | null | 00000000-demo-bank-a511-000000000012 | STATUS | Loan status | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000011 | null | null | INTEGER | null | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-bank-a511-000000000011 | REMAINING_TERM_MONTHS | Remaining term in months | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000011 | null | null | STRING | VARCHAR | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-bank-a511-000000000010 | DPD_BUCKET | DPD bucket (CURRENT/1-30/31-60/61-90/90+) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000011 | null | null | INTEGER | null | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-bank-a511-000000000009 | DAYS_PAST_DUE | Days past due | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000011 | null | null | STRING | NUMBER | null | null | null | null | 7 | 2 | null | null | null | null | null | 00000000-demo-bank-a511-000000000008 | MONTHLY_PAYMENT | Monthly payment | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000011 | null | null | STRING | NUMBER | null | null | null | null | 6 | 5 | null | null | null | null | null | 00000000-demo-bank-a511-000000000007 | INTEREST_RATE | Current interest rate | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000011 | null | null | STRING | NUMBER | null | null | null | null | 5 | 2 | null | null | null | null | null | 00000000-demo-bank-a511-000000000006 | OUTSTANDING_PRINCIPAL | Outstanding principal | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000011 | null | null | STRING | NUMBER | null | null | null | null | 4 | 2 | null | null | null | null | null | 00000000-demo-bank-a511-000000000005 | PRINCIPAL_AMOUNT | Original principal | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000011 | null | null | INTEGER | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-bank-a511-000000000004 | SNAPSHOT_DATE_SK | Snapshot date key | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000011 | null | null | STRING | NUMBER | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-bank-a511-000000000003 | CUSTOMER_SK | Customer dimension key | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000011 | null | null | STRING | NUMBER | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-bank-a511-000000000002 | LOAN_SK | Loan dimension key | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000011 | null | null | STRING | NUMBER | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-bank-a511-000000000001 | SNAPSHOT_SK | Surrogate key | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000010 | null | null | STRING | VARCHAR | null | null | null | null | 17 | null | null | null | null | null | null | 00000000-demo-bank-a510-000000000018 | STATUS | Transaction status | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000010 | null | null | BOOLEAN | null | null | null | null | null | 16 | null | null | null | null | null | null | 00000000-demo-bank-a510-000000000017 | IS_CROSS_BORDER | Cross-border flag | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000010 | null | null | BOOLEAN | null | null | null | null | null | 15 | null | null | null | null | null | null | 00000000-demo-bank-a510-000000000016 | IS_CONTACTLESS | Contactless flag | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000010 | null | null | BOOLEAN | null | null | null | null | null | 14 | null | null | null | null | null | null | 00000000-demo-bank-a510-000000000015 | IS_ONLINE | Online transaction flag | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000010 | null | null | CHAR | null | null | null | null | null | 13 | null | null | null | null | null | null | 00000000-demo-bank-a510-000000000014 | MERCHANT_COUNTRY_CODE | Merchant country | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000010 | null | null | STRING | VARCHAR | null | null | null | null | 12 | null | null | null | null | null | null | 00000000-demo-bank-a510-000000000013 | MERCHANT_NAME | Merchant name | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000010 | null | null | STRING | NUMBER | null | null | null | null | 11 | 2 | null | null | null | null | null | 00000000-demo-bank-a510-000000000012 | AMOUNT_IN_BASE_CCY | Amount in base currency | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000010 | null | null | CHAR | null | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-bank-a510-000000000011 | BILLING_CURRENCY | Billing currency | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000010 | null | null | STRING | NUMBER | null | null | null | null | 9 | 2 | null | null | null | null | null | 00000000-demo-bank-a510-000000000010 | BILLING_AMOUNT | Billing amount | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000010 | null | null | CHAR | null | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-bank-a510-000000000009 | TRANSACTION_CURRENCY | Transaction currency | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000010 | null | null | STRING | NUMBER | null | null | null | null | 7 | 2 | null | null | null | null | null | 00000000-demo-bank-a510-000000000008 | TRANSACTION_AMOUNT | Transaction amount | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e501-000000000010 | null | null | STRING | VARCHAR | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-bank-a510-000000000007 | TRANSACTION_TYPE | Transaction type | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 |