data_attributes - DATADA.AI Server

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	audit_role	scd_role	pii_level	pcidss_attribute	hipaa_identifier	id	name	description	created_by_id	updated_by_id	created_at	updated_at	version
00000000-demo-bank-e401-000000000003	null	null	STRING	VARCHAR	null	null	null	null	8	null	null	null	null	null	null	00000000-demo-bank-a403-000000000009	RATE_TYPE	Rate type (FIXED/VARIABLE)	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	7	5	null	null	null	null	null	00000000-demo-bank-a403-000000000008	INTEREST_RATE	Current interest 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-000000000003	null	null	CHAR	null	null	null	null	null	6	null	null	null	null	null	null	00000000-demo-bank-a403-000000000007	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-000000000003	null	null	STRING	NUMBER	null	null	null	null	5	2	null	null	null	null	null	00000000-demo-bank-a403-000000000006	OUTSTANDING_PRINCIPAL	Outstanding principal	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	4	2	null	null	null	null	null	00000000-demo-bank-a403-000000000005	PRINCIPAL_AMOUNT	Original principal	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	3	null	null	null	null	null	null	00000000-demo-bank-a403-000000000004	LOAN_TYPE	Loan type (MORTGAGE/PERSONAL/AUTO/BUSINESS)	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	2	null	null	null	null	null	null	00000000-demo-bank-a403-000000000003	LOAN_NUMBER	Loan reference 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-e401-000000000003	null	null	STRING	VARCHAR	null	null	null	null	1	null	null	null	null	null	null	00000000-demo-bank-a403-000000000002	LOAN_BK	Business key (source LOAN_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-000000000003	null	null	STRING	NUMBER	null	null	null	null	0	null	null	null	null	null	null	00000000-demo-bank-a403-000000000001	LOAN_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-000000000002	null	null	STRING	TIMESTAMP_NTZ	null	null	null	null	21	null	null	null	null	null	null	00000000-demo-bank-a402-000000000022	_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-000000000002	null	null	STRING	TIMESTAMP_NTZ	null	null	null	null	20	null	null	null	null	null	null	00000000-demo-bank-a402-000000000021	_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-000000000002	null	null	STRING	VARCHAR	null	null	null	null	19	null	null	null	null	null	null	00000000-demo-bank-a402-000000000020	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-000000000002	null	null	BOOLEAN	null	null	null	null	null	18	null	null	null	null	null	null	00000000-demo-bank-a402-000000000019	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-000000000002	null	null	STRING	TIMESTAMP_NTZ	null	null	null	null	17	null	null	null	null	null	null	00000000-demo-bank-a402-000000000018	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-000000000002	null	null	STRING	TIMESTAMP_NTZ	null	null	null	null	16	null	null	null	null	null	null	00000000-demo-bank-a402-000000000017	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-000000000002	null	null	STRING	VARCHAR	null	null	null	null	15	null	null	null	null	null	null	00000000-demo-bank-a402-000000000016	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-000000000002	null	null	STRING	VARCHAR	null	null	null	null	14	null	null	null	null	null	null	00000000-demo-bank-a402-000000000015	PRIMARY_CUSTOMER_BK	Primary 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-000000000002	null	null	STRING	VARCHAR	null	null	null	null	13	null	null	null	null	null	null	00000000-demo-bank-a402-000000000014	PRODUCT_CODE	Product 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-000000000002	null	null	STRING	VARCHAR	null	null	null	null	12	null	null	null	null	null	null	00000000-demo-bank-a402-000000000013	BRANCH_CODE	Branch 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-000000000002	null	null	STRING	VARCHAR	null	null	null	null	11	null	null	null	null	null	null	00000000-demo-bank-a402-000000000012	STATUS	Account 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-000000000002	null	null	DATE	null	null	null	null	null	10	null	null	null	null	null	null	00000000-demo-bank-a402-000000000011	CLOSING_DATE	Account closing 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-000000000002	null	null	DATE	null	null	null	null	null	9	null	null	null	null	null	null	00000000-demo-bank-a402-000000000010	OPENING_DATE	Account opening 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-000000000002	null	null	STRING	NUMBER	null	null	null	null	8	5	null	null	null	null	null	00000000-demo-bank-a402-000000000009	INTEREST_RATE	Interest 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-000000000002	null	null	STRING	NUMBER	null	null	null	null	7	2	null	null	null	null	null	00000000-demo-bank-a402-000000000008	OVERDRAFT_LIMIT	Overdraft limit	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-000000000002	null	null	STRING	NUMBER	null	null	null	null	6	2	null	null	null	null	null	00000000-demo-bank-a402-000000000007	AVAILABLE_BALANCE	Available balance	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-000000000002	null	null	STRING	NUMBER	null	null	null	null	5	2	null	null	null	null	null	00000000-demo-bank-a402-000000000006	CURRENT_BALANCE	Current balance	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-000000000002	null	null	CHAR	null	null	null	null	null	4	null	null	null	null	null	null	00000000-demo-bank-a402-000000000005	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-000000000002	null	null	STRING	VARCHAR	null	null	null	null	3	null	null	null	null	null	null	00000000-demo-bank-a402-000000000004	ACCOUNT_TYPE	Account type (CURRENT/SAVINGS/TERM_DEPOSIT)	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-000000000002	null	null	STRING	VARCHAR	null	null	null	null	2	null	null	null	null	null	null	00000000-demo-bank-a402-000000000003	ACCOUNT_NUMBER	IBAN/Account 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-e401-000000000002	null	null	STRING	VARCHAR	null	null	null	null	1	null	null	null	null	null	null	00000000-demo-bank-a402-000000000002	ACCOUNT_BK	Business key (source ACCT_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-000000000002	null	null	STRING	NUMBER	null	null	null	null	0	null	null	null	null	null	null	00000000-demo-bank-a402-000000000001	ACCOUNT_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-000000000001	null	null	STRING	TIMESTAMP_NTZ	null	null	null	null	24	null	null	null	null	null	null	00000000-demo-bank-a401-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-000000000001	null	null	STRING	TIMESTAMP_NTZ	null	null	null	null	23	null	null	null	null	null	null	00000000-demo-bank-a401-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-000000000001	null	null	STRING	VARCHAR	null	null	null	null	22	null	null	null	null	null	null	00000000-demo-bank-a401-000000000023	RECORD_HASH	Hash of business attributes for CDC	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-000000000001	null	null	BOOLEAN	null	null	null	null	null	21	null	null	null	null	null	null	00000000-demo-bank-a401-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-000000000001	null	null	STRING	TIMESTAMP_NTZ	null	null	null	null	20	null	null	null	null	null	null	00000000-demo-bank-a401-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-000000000001	null	null	STRING	TIMESTAMP_NTZ	null	null	null	null	19	null	null	null	null	null	null	00000000-demo-bank-a401-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-000000000001	null	null	STRING	VARCHAR	null	null	null	null	18	null	null	null	null	null	null	00000000-demo-bank-a401-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-000000000001	null	null	STRING	VARCHAR	null	null	null	null	17	null	null	null	null	null	null	00000000-demo-bank-a401-000000000018	STATUS	Status (ACTIVE/INACTIVE/BLOCKED)	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-000000000001	null	null	DATE	null	null	null	null	null	16	null	null	null	null	null	null	00000000-demo-bank-a401-000000000017	ONBOARDING_DATE	Onboarding 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-000000000001	null	null	STRING	VARCHAR	null	null	null	null	15	null	null	null	null	null	null	00000000-demo-bank-a401-000000000016	CUSTOMER_SEGMENT	Customer segment (CRM enriched)	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-000000000001	null	null	STRING	VARCHAR	null	null	null	null	14	null	null	null	null	null	null	00000000-demo-bank-a401-000000000015	KYC_STATUS	KYC status (VERIFIED/PENDING/REJECTED)	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-000000000001	null	null	CHAR	null	null	null	null	null	13	null	null	null	null	null	null	00000000-demo-bank-a401-000000000014	COUNTRY_CODE	ISO 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-000000000001	null	null	STRING	VARCHAR	null	null	null	null	12	null	null	null	null	null	null	00000000-demo-bank-a401-000000000013	POSTAL_CODE	Postal 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-000000000001	null	null	STRING	VARCHAR	null	null	null	null	11	null	null	null	null	null	null	00000000-demo-bank-a401-000000000012	CITY	City	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-000000000001	null	null	STRING	VARCHAR	null	null	null	null	10	null	null	null	null	null	null	00000000-demo-bank-a401-000000000011	ADDRESS_LINE_1	Address line 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-000000000001	null	null	STRING	VARCHAR	null	null	null	null	9	null	null	null	null	null	null	00000000-demo-bank-a401-000000000010	PHONE_NUMBER	Phone (E.164 format)	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-000000000001	null	null	STRING	VARCHAR	null	null	null	null	8	null	null	null	null	null	null	00000000-demo-bank-a401-000000000009	EMAIL	Email (lowercased, validated)	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-000000000001	null	null	STRING	VARCHAR	null	null	null	null	7	null	null	null	null	null	null	00000000-demo-bank-a401-000000000008	TAX_ID	Tax ID (standardized)	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-000000000001	null	null	STRING	VARCHAR	null	null	null	null	6	null	null	null	null	null	null	00000000-demo-bank-a401-000000000007	NATIONAL_ID	National ID (standardized)	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	2026-01-03 15:41:28	2026-01-03 15:41:28	1

Attribute	Record 9401	Record 9402	Record 9403	Record 9404	Record 9405	Record 9406	Record 9407	Record 9408	Record 9409	Record 9410	Record 9411	Record 9412	Record 9413	Record 9414	Record 9415	Record 9416	Record 9417	Record 9418	Record 9419	Record 9420	Record 9421	Record 9422	Record 9423	Record 9424	Record 9425	Record 9426	Record 9427	Record 9428	Record 9429	Record 9430	Record 9431	Record 9432	Record 9433	Record 9434	Record 9435	Record 9436	Record 9437	Record 9438	Record 9439	Record 9440	Record 9441	Record 9442	Record 9443	Record 9444	Record 9445	Record 9446	Record 9447	Record 9448	Record 9449	Record 9450
entity_id	00000000-demo-bank-e401-000000000003	00000000-demo-bank-e401-000000000003	00000000-demo-bank-e401-000000000003	00000000-demo-bank-e401-000000000003	00000000-demo-bank-e401-000000000003	00000000-demo-bank-e401-000000000003	00000000-demo-bank-e401-000000000003	00000000-demo-bank-e401-000000000003	00000000-demo-bank-e401-000000000003	00000000-demo-bank-e401-000000000002	00000000-demo-bank-e401-000000000002	00000000-demo-bank-e401-000000000002	00000000-demo-bank-e401-000000000002	00000000-demo-bank-e401-000000000002	00000000-demo-bank-e401-000000000002	00000000-demo-bank-e401-000000000002	00000000-demo-bank-e401-000000000002	00000000-demo-bank-e401-000000000002	00000000-demo-bank-e401-000000000002	00000000-demo-bank-e401-000000000002	00000000-demo-bank-e401-000000000002	00000000-demo-bank-e401-000000000002	00000000-demo-bank-e401-000000000002	00000000-demo-bank-e401-000000000002	00000000-demo-bank-e401-000000000002	00000000-demo-bank-e401-000000000002	00000000-demo-bank-e401-000000000002	00000000-demo-bank-e401-000000000002	00000000-demo-bank-e401-000000000002	00000000-demo-bank-e401-000000000002	00000000-demo-bank-e401-000000000002	00000000-demo-bank-e401-000000000001	00000000-demo-bank-e401-000000000001	00000000-demo-bank-e401-000000000001	00000000-demo-bank-e401-000000000001	00000000-demo-bank-e401-000000000001	00000000-demo-bank-e401-000000000001	00000000-demo-bank-e401-000000000001	00000000-demo-bank-e401-000000000001	00000000-demo-bank-e401-000000000001	00000000-demo-bank-e401-000000000001	00000000-demo-bank-e401-000000000001	00000000-demo-bank-e401-000000000001	00000000-demo-bank-e401-000000000001	00000000-demo-bank-e401-000000000001	00000000-demo-bank-e401-000000000001	00000000-demo-bank-e401-000000000001	00000000-demo-bank-e401-000000000001	00000000-demo-bank-e401-000000000001	00000000-demo-bank-e401-000000000001
physical_name	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null
origin	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null
data_type	STRING	STRING	CHAR	STRING	STRING	STRING	STRING	STRING	STRING	STRING	STRING	STRING	BOOLEAN	STRING	STRING	STRING	STRING	STRING	STRING	STRING	DATE	DATE	STRING	STRING	STRING	STRING	CHAR	STRING	STRING	STRING	STRING	STRING	STRING	STRING	BOOLEAN	STRING	STRING	STRING	STRING	DATE	STRING	STRING	CHAR	STRING	STRING	STRING	STRING	STRING	STRING	STRING
dialect_type	VARCHAR	NUMBER	null	NUMBER	NUMBER	VARCHAR	VARCHAR	VARCHAR	NUMBER	TIMESTAMP_NTZ	TIMESTAMP_NTZ	VARCHAR	null	TIMESTAMP_NTZ	TIMESTAMP_NTZ	VARCHAR	VARCHAR	VARCHAR	VARCHAR	VARCHAR	null	null	NUMBER	NUMBER	NUMBER	NUMBER	null	VARCHAR	VARCHAR	VARCHAR	NUMBER	TIMESTAMP_NTZ	TIMESTAMP_NTZ	VARCHAR	null	TIMESTAMP_NTZ	TIMESTAMP_NTZ	VARCHAR	VARCHAR	null	VARCHAR	VARCHAR	null	VARCHAR	VARCHAR	VARCHAR	VARCHAR	VARCHAR	VARCHAR	VARCHAR
dialect	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null
business_type	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null
business_type_params	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null
data_type_info	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null
order	8	7	6	5	4	3	2	1	0	21	20	19	18	17	16	15	14	13	12	11	10	9	8	7	6	5	4	3	2	1	0	24	23	22	21	20	19	18	17	16	15	14	13	12	11	10	9	8	7	6
scale	null	5	null	2	2	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	5	2	2	2	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null
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	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null
scd_role	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null
pii_level	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null
pcidss_attribute	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null
hipaa_identifier	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null
id	00000000-demo-bank-a403-000000000009	00000000-demo-bank-a403-000000000008	00000000-demo-bank-a403-000000000007	00000000-demo-bank-a403-000000000006	00000000-demo-bank-a403-000000000005	00000000-demo-bank-a403-000000000004	00000000-demo-bank-a403-000000000003	00000000-demo-bank-a403-000000000002	00000000-demo-bank-a403-000000000001	00000000-demo-bank-a402-000000000022	00000000-demo-bank-a402-000000000021	00000000-demo-bank-a402-000000000020	00000000-demo-bank-a402-000000000019	00000000-demo-bank-a402-000000000018	00000000-demo-bank-a402-000000000017	00000000-demo-bank-a402-000000000016	00000000-demo-bank-a402-000000000015	00000000-demo-bank-a402-000000000014	00000000-demo-bank-a402-000000000013	00000000-demo-bank-a402-000000000012	00000000-demo-bank-a402-000000000011	00000000-demo-bank-a402-000000000010	00000000-demo-bank-a402-000000000009	00000000-demo-bank-a402-000000000008	00000000-demo-bank-a402-000000000007	00000000-demo-bank-a402-000000000006	00000000-demo-bank-a402-000000000005	00000000-demo-bank-a402-000000000004	00000000-demo-bank-a402-000000000003	00000000-demo-bank-a402-000000000002	00000000-demo-bank-a402-000000000001	00000000-demo-bank-a401-000000000025	00000000-demo-bank-a401-000000000024	00000000-demo-bank-a401-000000000023	00000000-demo-bank-a401-000000000022	00000000-demo-bank-a401-000000000021	00000000-demo-bank-a401-000000000020	00000000-demo-bank-a401-000000000019	00000000-demo-bank-a401-000000000018	00000000-demo-bank-a401-000000000017	00000000-demo-bank-a401-000000000016	00000000-demo-bank-a401-000000000015	00000000-demo-bank-a401-000000000014	00000000-demo-bank-a401-000000000013	00000000-demo-bank-a401-000000000012	00000000-demo-bank-a401-000000000011	00000000-demo-bank-a401-000000000010	00000000-demo-bank-a401-000000000009	00000000-demo-bank-a401-000000000008	00000000-demo-bank-a401-000000000007
name	RATE_TYPE	INTEREST_RATE	CURRENCY_CODE	OUTSTANDING_PRINCIPAL	PRINCIPAL_AMOUNT	LOAN_TYPE	LOAN_NUMBER	LOAN_BK	LOAN_SK	_UPDATED_AT	_LOADED_AT	RECORD_HASH	IS_CURRENT	EFFECTIVE_TO	EFFECTIVE_FROM	SOURCE_SYSTEM	PRIMARY_CUSTOMER_BK	PRODUCT_CODE	BRANCH_CODE	STATUS	CLOSING_DATE	OPENING_DATE	INTEREST_RATE	OVERDRAFT_LIMIT	AVAILABLE_BALANCE	CURRENT_BALANCE	CURRENCY_CODE	ACCOUNT_TYPE	ACCOUNT_NUMBER	ACCOUNT_BK	ACCOUNT_SK	_UPDATED_AT	_LOADED_AT	RECORD_HASH	IS_CURRENT	EFFECTIVE_TO	EFFECTIVE_FROM	SOURCE_SYSTEM	STATUS	ONBOARDING_DATE	CUSTOMER_SEGMENT	KYC_STATUS	COUNTRY_CODE	POSTAL_CODE	CITY	ADDRESS_LINE_1	PHONE_NUMBER	EMAIL	TAX_ID	NATIONAL_ID
description	Rate type (FIXED/VARIABLE)	Current interest rate	ISO currency code	Outstanding principal	Original principal	Loan type (MORTGAGE/PERSONAL/AUTO/BUSINESS)	Loan reference number	Business key (source LOAN_ID)	Surrogate key	Last update timestamp	ETL load timestamp	Hash of business attributes	Current record flag	SCD2 effective to	SCD2 effective from	Source system identifier	Primary customer business key	Product code	Branch code	Account status	Account closing date	Account opening date	Interest rate	Overdraft limit	Available balance	Current balance	ISO currency code	Account type (CURRENT/SAVINGS/TERM_DEPOSIT)	IBAN/Account number	Business key (source ACCT_ID)	Surrogate key	Last update timestamp	ETL load timestamp	Hash of business attributes for CDC	Current record flag	SCD2 effective to	SCD2 effective from	Source system identifier	Status (ACTIVE/INACTIVE/BLOCKED)	Onboarding date	Customer segment (CRM enriched)	KYC status (VERIFIED/PENDING/REJECTED)	ISO country code	Postal code	City	Address line 1	Phone (E.164 format)	Email (lowercased, validated)	Tax ID (standardized)	National ID (standardized)
created_by_id	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001
updated_by_id	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001	00000000-demo-user-0000-000000000001
created_at	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28
updated_at	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28	2026-01-03 15:41:28
version	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1
deleted

Page 189 of 197 (9849 total records)