DIM_BNK_ACCOUNT_SECURITY_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Synonyms

SDSNZP02_BANK..UBAR_DIM_BNK_ACCOUNT_SECURITY_INSIGHT

Columns
# Name Data Type Length
1 ACCOUNT_SECURITY_DIM_ID BIGINT 8
2 MORTGAGE_INSURANCE_FLAG CHARACTER VARYING(5) 5
3 LOWDOC_FLAG CHARACTER VARYING(5) 5
4 SECURED_FLAG CHARACTER VARYING(5) 5
5 ELIGIBLE_RSDNT_MORTGAGE_FLAG CHARACTER VARYING(5) 5
6 FIRST_HOME_BUYER_FLAG CHARACTER VARYING(5) 5
7 BROKER_ORIGINATED_FLAG CHARACTER VARYING(5) 5
8 BUSINESS_LOAD_DATE TIMESTAMP 8
9 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
10 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
11 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
12 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8