FCT_BNK_ACCOUNT_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

OBP Daily Account attributes for last 90 days or all week ends or month ends for 3 years, records all the dimensions valid for an account at the end of each day

Synonyms

SDSNZP02_BANK..UBAR_FCT_BNK_ACCOUNT_INSIGHT

Columns
# Name Data Type Length
1 ACCOUNT_DIM_ID BIGINT 8
2 ACCOUNT_STATUS_DIM_ID BIGINT 8
3 PERIOD_DIM_ID BIGINT 8
4 BRANCH_DIM_ID BIGINT 8
5 SOURCE_PRODUCT_DIM_ID BIGINT 8
6 SOURCE_PRODUCT_CODE CHARACTER VARYING(104) 104
7 BALANCE_SHEET_INDICATOR CHARACTER VARYING(20) 20
8 PERS_INV_USAGE_TYPE_DIM_ID BIGINT 8
9 ORIG_TERM_MATURITY_DIM_ID BIGINT 8
10 ACCT_CREDIT_RISK_DIM_ID BIGINT 8
11 ACCOUNT_SECURITY_DIM_ID BIGINT 8
12 ACCT_CLASSIFER_DIM_ID BIGINT 8
13 DAYS_PAST_DUE_DIM_ID BIGINT 8
14 SECURITISATION_DIM_ID BIGINT 8
15 OF_GL_PRINCIPAL_BALANCE_DIM_ID BIGINT 8
16 OF_GL_INT_INCOME_ACR_DIM_ID BIGINT 8
17 OF_GL_INBA_DIM_ID BIGINT 8
18 GCIS_CUSTOMER_DIM_ID BIGINT 8
19 CUSTOMER_DIM_ID BIGINT 8
20 CUSTOMER_ADDRESS_DIM_ID BIGINT 8
21 ANZSIC_DIM_ID BIGINT 8
22 COUNTERPARTY_TYPE_DIM_ID BIGINT 8
23 CUST_CLASSIFIER_DIM_ID BIGINT 8
24 SOURCE_CURRENCY_DIMENSION_ID BIGINT 8
25 RSDL_TERM_MATURITY_DIM_ID BIGINT 8
26 INTEREST_RATE_TERM_DIM_ID BIGINT 8
27 INTEREST_RATE_DIM_ID BIGINT 8
28 LOAN_PURPOSE_DIM_ID BIGINT 8
29 MATERIALITY_DIM_ID BIGINT 8
30 CHANNEL_DIM_ID BIGINT 8
31 BILL_TYPE_DIM_ID BIGINT 8
32 PORTFOLIO_FACILITY_DIM_ID BIGINT 8
33 OF_GL_INT_INCOME_MVMT_DIM_ID BIGINT 8
34 OF_GL_INT_EXPENSE_ACR_DIM_ID BIGINT 8
35 OF_GL_INT_EXPENSE_MVMT_DIM_ID BIGINT 8
36 OF_GL_UNAPPLIED_FUNDS_DIM_ID BIGINT 8
37 OF_GL_UNEARNED_INT_DIM_ID BIGINT 8
38 SDW_IGNITE_SOURCE CHARACTER VARYING(1) 1
39 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
40 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
41 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
42 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8