FCT_BNK_NEEDS_ANALYSIS_TRANS_INSIGHT

Database

INSNZP02_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 NEEDS_ANALYSIS_ID NUMERIC(19,0) 19
2 PERIOD_DIM_ID BIGINT 8
3 CREATE_DATE DATE 4
4 CREATE_DATETIMESTAMP TIMESTAMP 8
5 WEEK_END_ID BIGINT 8
6 WEEK_END_DT DATE 4
7 WEEK_END_RANK BIGINT 8
8 MONTH_END_ID BIGINT 8
9 MONTH_END_DT DATE 4
10 MONTH_END_RANK BIGINT 8
11 DAY_END_RANK BIGINT 8
12 ANALYSED_BY_ID CHARACTER VARYING(255) 255
13 ANALYSED_BY_NAME CHARACTER VARYING(50) 50
14 CUSTOMER_ID CHARACTER VARYING(255) 255
15 NEEDS_ANALYSIS_COMPLETED INTEGER 4
16 NEEDS_ANALYSIS_SAVED INTEGER 4
17 BANK_ACCOUNTS_OC_COMPL INTEGER 4
18 LENDING_OC_COMPL INTEGER 4
19 INSURANCE_OC_COMPL INTEGER 4
20 INVESTMENT_OC_COMPL INTEGER 4
21 ABOUT_YOU_CURRENT CHARACTER VARYING(2000) 2000
22 ABOUT_YOU_FUTURE CHARACTER VARYING(2000) 2000
23 ABOUTYOU_REQ_FLAG CHARACTER VARYING(1) 1
24 ACCESS_FUNDS_CURRENT CHARACTER VARYING(2000) 2000
25 ACCESS_FUNDS_FUTURE CHARACTER VARYING(2000) 2000
26 ACCESSFUND_REQ_FLAG CHARACTER VARYING(1) 1
27 PURCH_PWR_CURRENT CHARACTER VARYING(2000) 2000
28 PURCH_PWR_FUTURE CHARACTER VARYING(2000) 2000
29 PURCHPWR_REQ_FLAG CHARACTER VARYING(1) 1
30 PROT_ASSET_CURRENT CHARACTER VARYING(2000) 2000
31 PROT_ASSET_FUTURE CHARACTER VARYING(2000) 2000
32 PROT_REQ_FLAG CHARACTER VARYING(1) 1
33 INV_DEPOSIT_CURRENT CHARACTER VARYING(2000) 2000
34 INV_DEPOSIT_FUTURE CHARACTER VARYING(2000) 2000
35 EARNPWR_REQ_FLAG CHARACTER VARYING(1) 1
36 OTHER_INFO CHARACTER VARYING(2000) 2000
37 OTHER_INFO_FLAG CHARACTER VARYING(1) 1
38 DEPOSIT_ADVICE_TYPE CHARACTER VARYING(10) 10
39 DEPOSIT_ADVICE_FACTUAL INTEGER 4
40 DEPOSIT_ADVICE_PERSONAL INTEGER 4
41 DEPOSIT_ACCESS_FLAG CHARACTER VARYING(1) 1
42 DEPOSIT_FEATURES_FLAG CHARACTER VARYING(1) 1
43 DEPOSIT_FEE_STRCT_FLAG CHARACTER VARYING(1) 1
44 DEPOSIT_INT_RATE_FLAG CHARACTER VARYING(1) 1
45 DEPOSIT_SERVICE_FLAG CHARACTER VARYING(1) 1
46 DEPOSIT_OTHER_FLAG CHARACTER VARYING(1) 1
47 DEPOSIT_OTHER CHARACTER VARYING(2000) 2000
48 DEPOSIT_PRD_DISCUSSED CHARACTER VARYING(2000) 2000
49 DEPOSIT_PRD_RECC CHARACTER VARYING(2000) 2000
50 DEPOSIT_REQ_FLAG CHARACTER VARYING(1) 1
51 DOC_PROVIDED CHARACTER VARYING(2000) 2000
52 DOC_REQ_FLAG CHARACTER VARYING(1) 1
53 INS_PRD_DISCUSSED CHARACTER VARYING(2000) 2000
54 INS_PRD_RECC CHARACTER VARYING(2000) 2000
55 INS_COMMENT_REQ_FLAG CHARACTER VARYING(1) 1
56 INVSTMT_ADVICE_TYPE CHARACTER VARYING(10) 10
57 INVSTMT_ADVICE_FACTUAL INTEGER 4
58 INVSTMT_ADVICE_PERSONAL INTEGER 4
59 INVSTMT_ACCESS_FLAG CHARACTER VARYING(1) 1
60 INVSTMT_FEATURES_FLAG CHARACTER VARYING(1) 1
61 INVSTMT_FEE_STRCT_FLAG CHARACTER VARYING(1) 1
62 INVSTMT_INT_RATE_FLAG CHARACTER VARYING(1) 1
63 INVSTMT_SERVICE_FLAG CHARACTER VARYING(1) 1
64 INVSTMT_OTHER_FLAG CHARACTER VARYING(1) 1
65 INVSTMT_OTHER CHARACTER VARYING(2000) 2000
66 INVSTMT_PRD_DISCUSSED CHARACTER VARYING(2000) 2000
67 INVSTMT_PRD_RECC CHARACTER VARYING(2000) 2000
68 INVSTMT_COMMENT_REQ_FLAG CHARACTER VARYING(1) 1
69 LEND_PRD_DISCUSSED CHARACTER VARYING(2000) 2000
70 LEND_PRD_RECC CHARACTER VARYING(2000) 2000
71 LENDING_REQ_FLAG CHARACTER VARYING(1) 1
72 CONSULTANT_FLAG NUMERIC(1,0) 19
73 FIN_PLAN_FLAG NUMERIC(1,0) 19
74 LENDER_FLAG NUMERIC(1,0) 19
75 REFERRAL_REQ_FLAG CHARACTER VARYING(1) 1
76 STATUS CHARACTER VARYING(15) 15
77 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
78 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
79 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
80 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
81 NAME_LINK CHARACTER VARYING(209) 209