DATADA.AI
Online v0.9.0
data_attributes 9849 records
Home
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-e401-000000000005 null null STRING VARCHAR null null null null 13 null null null null null null 00000000-demo-bank-a405-000000000014 AUTHORIZATION_CODE Authorization 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-000000000005 null null STRING TIMESTAMP_NTZ null null null null 12 null null null null null null 00000000-demo-bank-a405-000000000013 TRANSACTION_TIMESTAMP Transaction 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 CHAR null null null null null 11 null null null null null null 00000000-demo-bank-a405-000000000012 MERCHANT_COUNTRY Merchant country 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 CHAR null null null null null 10 null null null null null null 00000000-demo-bank-a405-000000000011 MCC_CODE Merchant category 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-000000000005 null null STRING VARCHAR null null null null 9 null null null null null null 00000000-demo-bank-a405-000000000010 MERCHANT_NAME Merchant 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-000000000005 null null STRING VARCHAR null null null null 8 null null null null null null 00000000-demo-bank-a405-000000000009 MERCHANT_ID Merchant 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 CHAR null null null null null 7 null null null null null null 00000000-demo-bank-a405-000000000008 BILLING_CURRENCY Billing 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-000000000005 null null STRING NUMBER null null null null 6 2 null null null null null 00000000-demo-bank-a405-000000000007 BILLING_AMOUNT Billing amount 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 CHAR null null null null null 5 null null null null null null 00000000-demo-bank-a405-000000000006 TRANSACTION_CURRENCY Transaction 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-000000000005 null null STRING NUMBER null null null null 4 2 null null null null null 00000000-demo-bank-a405-000000000005 TRANSACTION_AMOUNT Transaction amount 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 3 null null null null null null 00000000-demo-bank-a405-000000000004 TRANSACTION_TYPE Transaction type 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 2 null null null null null null 00000000-demo-bank-a405-000000000003 CARD_BK Card 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-000000000005 null null STRING VARCHAR null null null null 1 null null null null null null 00000000-demo-bank-a405-000000000002 CARD_TXN_BK Business key (source TXN_ID) 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 NUMBER null null null null 0 null null null null null null 00000000-demo-bank-a405-000000000001 CARD_TXN_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-000000000004 null null STRING TIMESTAMP_NTZ null null null null 19 null null null null null null 00000000-demo-bank-a404-000000000020 _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-000000000004 null null STRING VARCHAR null null null null 18 null null null null null null 00000000-demo-bank-a404-000000000019 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-000000000004 null null STRING NUMBER null null null null 17 2 null null null null null 00000000-demo-bank-a404-000000000018 FEE_AMOUNT Transaction fee 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-000000000004 null null STRING VARCHAR null null null null 16 null null null null null null 00000000-demo-bank-a404-000000000017 CHANNEL Transaction channel 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-000000000004 null null STRING VARCHAR null null null null 15 null null null null null null 00000000-demo-bank-a404-000000000016 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
00000000-demo-bank-e401-000000000004 null null DATE null null null null null 14 null null null null null null 00000000-demo-bank-a404-000000000015 VALUE_DATE Value 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-000000000004 null null STRING TIMESTAMP_NTZ null null null null 13 null null null null null null 00000000-demo-bank-a404-000000000014 PROCESSED_AT Processing 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-000000000004 null null STRING TIMESTAMP_NTZ null null null null 12 null null null null null null 00000000-demo-bank-a404-000000000013 INITIATED_AT Initiation 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-000000000004 null null STRING VARCHAR null null null null 11 null null null null null null 00000000-demo-bank-a404-000000000012 REMITTANCE_INFO Remittance information 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-000000000004 null null STRING VARCHAR null null null null 10 null null null null null null 00000000-demo-bank-a404-000000000011 BENEFICIARY_BIC Beneficiary bank BIC 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-000000000004 null null STRING VARCHAR null null null null 9 null null null null null null 00000000-demo-bank-a404-000000000010 BENEFICIARY_ACCOUNT Beneficiary account 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-000000000004 null null STRING VARCHAR null null null null 8 null null null null null null 00000000-demo-bank-a404-000000000009 BENEFICIARY_NAME Beneficiary 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-000000000004 null null CHAR null null null null null 7 null null null null null null 00000000-demo-bank-a404-000000000008 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-000000000004 null null STRING NUMBER null null null null 6 2 null null null null null 00000000-demo-bank-a404-000000000007 AMOUNT Transaction amount 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-000000000004 null null STRING VARCHAR null null null null 5 null null null null null null 00000000-demo-bank-a404-000000000006 CREDIT_ACCOUNT_BK Credit account 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-000000000004 null null STRING VARCHAR null null null null 4 null null null null null null 00000000-demo-bank-a404-000000000005 DEBIT_ACCOUNT_BK Debit account 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-000000000004 null null STRING VARCHAR null null null null 3 null null null null null null 00000000-demo-bank-a404-000000000004 TRANSACTION_TYPE Transaction type 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-000000000004 null null STRING VARCHAR null null null null 2 null null null null null null 00000000-demo-bank-a404-000000000003 TRANSACTION_REFERENCE Transaction reference 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-000000000004 null null STRING VARCHAR null null null null 1 null null null null null null 00000000-demo-bank-a404-000000000002 TRANSACTION_BK Business key (source TXN_ID) 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-000000000004 null null STRING NUMBER null null null null 0 null null null null null null 00000000-demo-bank-a404-000000000001 TRANSACTION_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-000000000003 null null STRING TIMESTAMP_NTZ null null null null 24 null null null null null null 00000000-demo-bank-a403-000000000025 _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-000000000003 null null STRING TIMESTAMP_NTZ null null null null 23 null null null null null null 00000000-demo-bank-a403-000000000024 _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-000000000003 null null STRING VARCHAR null null null null 22 null null null null null null 00000000-demo-bank-a403-000000000023 RECORD_HASH Hash of business attributes 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-000000000003 null null BOOLEAN null null null null null 21 null null null null null null 00000000-demo-bank-a403-000000000022 IS_CURRENT Current record 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-000000000003 null null STRING TIMESTAMP_NTZ null null null null 20 null null null null null null 00000000-demo-bank-a403-000000000021 EFFECTIVE_TO SCD2 effective to 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-000000000003 null null STRING TIMESTAMP_NTZ null null null null 19 null null null null null null 00000000-demo-bank-a403-000000000020 EFFECTIVE_FROM SCD2 effective from 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-000000000003 null null STRING VARCHAR null null null null 18 null null null null null null 00000000-demo-bank-a403-000000000019 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-000000000003 null null STRING VARCHAR null null null null 17 null null null null null null 00000000-demo-bank-a403-000000000018 DISBURSEMENT_ACCOUNT_BK Disbursement account 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-000000000003 null null STRING VARCHAR null null null null 16 null null null null null null 00000000-demo-bank-a403-000000000017 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-000000000003 null null STRING VARCHAR null null null null 15 null null null null null null 00000000-demo-bank-a403-000000000016 STATUS Loan status 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-000000000003 null null INTEGER null null null null null 14 null null null null null null 00000000-demo-bank-a403-000000000015 DAYS_PAST_DUE Days past due 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-000000000003 null null DATE null null null null null 13 null null null null null null 00000000-demo-bank-a403-000000000014 NEXT_PAYMENT_DATE Next payment 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-000000000003 null null DATE null null null null null 12 null null null null null null 00000000-demo-bank-a403-000000000013 MATURITY_DATE Maturity 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-000000000003 null null DATE null null null null null 11 null null null null null null 00000000-demo-bank-a403-000000000012 DISBURSEMENT_DATE Disbursement 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-000000000003 null null STRING NUMBER null null null null 10 2 null null null null null 00000000-demo-bank-a403-000000000011 MONTHLY_PAYMENT Monthly payment amount 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-000000000003 null null INTEGER null null null null null 9 null null null null null null 00000000-demo-bank-a403-000000000010 TERM_MONTHS Loan term in months 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1