| 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-e301-000000000003 | null | null | STRING | VARCHAR | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-bank-a303-000000000011 | MONTHLY_PMT | 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-e301-000000000003 | null | null | STRING | VARCHAR | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-bank-a303-000000000010 | TERM_MONTHS | 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-e301-000000000003 | null | null | STRING | VARCHAR | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-bank-a303-000000000009 | RATE_TYPE | Rate type | 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-e301-000000000003 | null | null | STRING | VARCHAR | null | null | null | null | 7 | null | null | null | null | null | null | 00000000-demo-bank-a303-000000000008 | INT_RATE | 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-e301-000000000003 | null | null | STRING | VARCHAR | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-bank-a303-000000000007 | CCY_CD | Currency code | 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-e301-000000000003 | null | null | STRING | VARCHAR | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-bank-a303-000000000006 | OUTSTAND_AMT | Outstanding 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-e301-000000000003 | null | null | STRING | VARCHAR | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-bank-a303-000000000005 | PRINCIPAL_AMT | Principal 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-e301-000000000003 | null | null | STRING | VARCHAR | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-bank-a303-000000000004 | LOAN_TYPE | Loan type | 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-e301-000000000003 | null | null | STRING | VARCHAR | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-bank-a303-000000000003 | LOAN_NO | Loan number | 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-e301-000000000003 | null | null | STRING | VARCHAR | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-bank-a303-000000000002 | LOAN_ID | Loan ID | 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-e301-000000000003 | null | null | STRING | VARCHAR | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-bank-a303-000000000001 | RAW_ID | Unique raw record identifier | 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-e301-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 18 | null | null | null | null | null | null | 00000000-demo-bank-a302-000000000019 | _BATCH_ID | Batch identifier | 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-e301-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 17 | null | null | null | null | null | null | 00000000-demo-bank-a302-000000000018 | _SOURCE_FILE | Source file 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-e301-000000000002 | null | null | STRING | TIMESTAMP_NTZ | null | null | null | null | 16 | null | null | null | null | null | null | 00000000-demo-bank-a302-000000000017 | _LOAD_TS | Data load timestamp | 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-e301-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 15 | null | null | null | null | null | null | 00000000-demo-bank-a302-000000000016 | SRC_UPD_TS | Source update timestamp | 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-e301-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 14 | null | null | null | null | null | null | 00000000-demo-bank-a302-000000000015 | CUST_ID | Customer ID | 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-e301-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 13 | null | null | null | null | null | null | 00000000-demo-bank-a302-000000000014 | PROD_CD | Product code | 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-e301-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 12 | null | null | null | null | null | null | 00000000-demo-bank-a302-000000000013 | BRANCH_CD | Branch code | 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-e301-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 11 | null | null | null | null | null | null | 00000000-demo-bank-a302-000000000012 | STATUS_CD | Status code | 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-e301-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-bank-a302-000000000011 | CLOSE_DT | Closing date | 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-e301-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-bank-a302-000000000010 | OPEN_DT | Opening date | 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-e301-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-bank-a302-000000000009 | INT_RATE | 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-e301-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 7 | null | null | null | null | null | null | 00000000-demo-bank-a302-000000000008 | OD_LIMIT | Overdraft limit | 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-e301-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-bank-a302-000000000007 | AVAIL_BAL | Available balance | 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-e301-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-bank-a302-000000000006 | CURR_BAL | Current balance | 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-e301-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-bank-a302-000000000005 | CCY_CD | Currency code | 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-e301-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-bank-a302-000000000004 | ACCT_TYPE | Account type | 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-e301-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-bank-a302-000000000003 | ACCT_NO | Account number | 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-e301-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-bank-a302-000000000002 | ACCT_ID | Account ID | 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-e301-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-bank-a302-000000000001 | RAW_ID | Unique raw record identifier | 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-e301-000000000001 | null | null | STRING | VARCHAR | null | null | null | null | 18 | null | null | null | null | null | null | 00000000-demo-bank-a301-000000000019 | _BATCH_ID | Batch identifier | 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-e301-000000000001 | null | null | STRING | VARCHAR | null | null | null | null | 17 | null | null | null | null | null | null | 00000000-demo-bank-a301-000000000018 | _SOURCE_FILE | Source file 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-e301-000000000001 | null | null | STRING | TIMESTAMP_NTZ | null | null | null | null | 16 | null | null | null | null | null | null | 00000000-demo-bank-a301-000000000017 | _LOAD_TS | Data load timestamp | 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-e301-000000000001 | null | null | STRING | VARCHAR | null | null | null | null | 15 | null | null | null | null | null | null | 00000000-demo-bank-a301-000000000016 | SRC_UPD_TS | Source update timestamp | 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-e301-000000000001 | null | null | STRING | VARCHAR | null | null | null | null | 14 | null | null | null | null | null | null | 00000000-demo-bank-a301-000000000015 | STATUS_CD | Status code | 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-e301-000000000001 | null | null | STRING | VARCHAR | null | null | null | null | 13 | null | null | null | null | null | null | 00000000-demo-bank-a301-000000000014 | ONBOARD_DT | Onboarding date | 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-e301-000000000001 | null | null | STRING | VARCHAR | null | null | null | null | 12 | null | null | null | null | null | null | 00000000-demo-bank-a301-000000000013 | KYC_STATUS | KYC 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-e301-000000000001 | null | null | STRING | VARCHAR | null | null | null | null | 11 | null | null | null | null | null | null | 00000000-demo-bank-a301-000000000012 | COUNTRY_CD | Country code | 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-e301-000000000001 | null | null | STRING | VARCHAR | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-bank-a301-000000000011 | POSTAL_CD | Postal code | 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-e301-000000000001 | null | null | STRING | VARCHAR | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-bank-a301-000000000010 | CITY | City | 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-e301-000000000001 | null | null | STRING | VARCHAR | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-bank-a301-000000000009 | ADDR_LINE1 | Address line 1 | 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-e301-000000000001 | null | null | STRING | VARCHAR | null | null | null | null | 7 | null | null | null | null | null | null | 00000000-demo-bank-a301-000000000008 | TAX_ID | Tax ID | 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-e301-000000000001 | null | null | STRING | VARCHAR | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-bank-a301-000000000007 | NAT_ID | National ID | 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-e301-000000000001 | null | null | STRING | VARCHAR | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-bank-a301-000000000006 | DOB | Date of birth | 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-e301-000000000001 | null | null | STRING | VARCHAR | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-bank-a301-000000000005 | LAST_NM | Last 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-e301-000000000001 | null | null | STRING | VARCHAR | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-bank-a301-000000000004 | FIRST_NM | First 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-e301-000000000001 | null | null | STRING | VARCHAR | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-bank-a301-000000000003 | CUST_TYPE | Customer type | 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-e301-000000000001 | null | null | STRING | VARCHAR | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-bank-a301-000000000002 | CUST_ID | Source customer ID | 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-e301-000000000001 | null | null | STRING | VARCHAR | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-bank-a301-000000000001 | RAW_ID | Unique raw record identifier | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 |