FCT_CMPS_INVESTOR_DETAIL_REPORT_INSIGHT

Database

INSNZP01_WEALTH

Schema

WEALTHPADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 MEMBER_ACCOUNT_ID INTEGER 4
2 INVESTOR_ID INTEGER 4
3 PRODUCT_TYPE_ID INTEGER 4
4 TITLE_NAME CHARACTER VARYING(40) 40
5 SALUTATION CHARACTER VARYING(50) 50
6 INVESTOR_GIVEN_NAME CHARACTER VARYING(121) 121
7 ADDRESS_TYPE CHARACTER VARYING(17) 17
8 ADDRESS_DETAIL CHARACTER VARYING(292) 292
9 ENTITY_GENDER CHARACTER VARYING(6) 6
10 BIRTH_DATE TIMESTAMP 8
11 DECEASED_DATE TIMESTAMP 8
12 PROBATE_DATE TIMESTAMP 8
13 PREF_CORRESPONDENCE_METHOD CHARACTER VARYING(9) 9
14 HOME_PHONE_NUMBER CHARACTER(20) 20
15 WORK_PHONE_NUMBER CHARACTER(20) 20
16 MOBILE_NUMBER CHARACTER(20) 20
17 EMAIL_ADDRESS CHARACTER VARYING(60) 60
18 TFN_STATUS CHARACTER VARYING(20) 20
19 OCCUPATION CHARACTER VARYING(40) 40
20 MAIL_RETURNED_DATE1 TIMESTAMP 8
21 MAIL_RETURNED_DATE2 TIMESTAMP 8
22 KYC_VERIFIED_FLAG CHARACTER(1) 1
23 PRODUCT_NAME CHARACTER VARYING(40) 40
24 INVESTMENT_MODEL CHARACTER VARYING(80) 80
25 ACCOUNT_GROUP CHARACTER VARYING(40) 40
26 FUND_START_DATE TIMESTAMP 8
27 ACCOUNT_CREATION_DATE TIMESTAMP 8
28 EARLIEST_FUND_START_DATE TIMESTAMP 8
29 EXCLUDE_INS_LAPSING_FLAG CHARACTER VARYING(1) 1
30 ACCOUNT_STOPPED_FLAG CHARACTER VARYING(1) 1
31 ADVISER_ACCOUNT_ID INTEGER 4
32 REVERSION_PERCENT NUMERIC(5,2) 19
33 REVERSIONARY_FLAG CHARACTER VARYING(14) 14
34 DEALER_ID INTEGER 4
35 DEALER_NAME CHARACTER VARYING(60) 60
36 DEALER_BRANCH_ID INTEGER 4
37 DEALER_BRANCH_NAME CHARACTER VARYING(60) 60
38 INS_LAPSE_STATUS CHARACTER VARYING(7) 7
39 INSURANCE_COVER_ID INTEGER 4
40 INS_LAPSING_EXPIRY_DATETIME TIMESTAMP 8
41 INS_LAPSING_WARNING_DATE TIMESTAMP 8
42 INS_LAPSING_WARNING_DATE2 DATE 4
43 LOST_MEMBER_FLAG CHARACTER VARYING(13) 13
44 LOSTMEM_TRANSFER_REPORTED TIMESTAMP 8
45 LOSTMEM_INACTIVE_REPORTED TIMESTAMP 8
46 LOSTMEM_ERROR_REPORTED TIMESTAMP 8
47 EMPLOYER_ID INTEGER 4
48 EMPLOYER_NAME CHARACTER VARYING(60) 60
49 EMPLOYER_GROUP_ID INTEGER 4
50 EMPLOYER_GROUP_NAME CHARACTER VARYING(40) 40
51 EMPLOYER_START_DATE TIMESTAMP 8
52 EMPLOYER_END_DATE TIMESTAMP 8
53 SALARY NUMERIC(18,2) 19
54 EMPLOYER_REFERENCE CHARACTER VARYING(16) 16
55 CTP_STATUS CHARACTER VARYING(9) 9
56 PORTFOLIO_NAME CHARACTER VARYING(40) 40
57 RECURRING_SWITCH_ID INTEGER 4
58 PORTFOLIO_START_DATE TIMESTAMP 8
59 PORTFOLIO_END_DATE TIMESTAMP 8
60 PORTFOLIO_STATUS CHARACTER VARYING(8) 8
61 PORTFOLIO_FREQUENCY CHARACTER VARYING(10) 10
62 INVESTMENT_PERCENT NUMERIC(9,6) 19
63 BENEFICIARY_NAME CHARACTER VARYING(80) 80
64 BENEFICIARY_GENDER CHARACTER(1) 1
65 BENEFICIARY_DOB TIMESTAMP 8
66 BENEFICIARY_PERCENT NUMERIC(5,2) 19
67 BINDING_NOMINATION_DATE TIMESTAMP 8
68 BINDING_NOMINATION_EXPIRY_DATE TIMESTAMP 8
69 BINDING_NOMINATION_REVOKE_DATE TIMESTAMP 8
70 BANK_ACCOUNT_TYPE CHARACTER VARYING(12) 12
71 BANK_NAME CHARACTER VARYING(60) 60
72 BRANCH_NAME CHARACTER VARYING(60) 60
73 BSB_NUMBER CHARACTER VARYING(10) 10
74 ACCOUNT_HOLDER_NAME CHARACTER VARYING(40) 40
75 ACCOUNT_NUMBER CHARACTER VARYING(10) 10
76 DEFAULT_FLAG CHARACTER VARYING(1) 1
77 PDC_STATUS CHARACTER VARYING(1) 1
78 PDC_FREQUENCY_FLAG CHARACTER VARYING(1) 1
79 PDC_START_DATE TIMESTAMP 8
80 PDC_END_DATE TIMESTAMP 8
81 PDC_AUTHORISED_AMOUNT NUMERIC(18,2) 19
82 PDC_LAST_USED_DATE TIMESTAMP 8
83 PDC_CONTRIBUTION_TYPE_DESCRIPTION CHARACTER VARYING(40) 40
84 ATTRIBUTE_DESCRIPTION CHARACTER VARYING(60) 60
85 ATTRIBUTE_VALUE CHARACTER VARYING(70) 70
86 ATTRIBUTE_PARTY_TYPE CHARACTER VARYING(40) 40
87 EXTERNAL_SYSTEM CHARACTER VARYING(10) 10
88 EXTERNAL_REFERENCE CHARACTER VARYING(40) 40
89 EXTERNAL_PARTY_TYPE CHARACTER VARYING(40) 40
90 FINANCIAL_YEAR_END TIMESTAMP 8
91 WORK_TEST_MET_FLAG CHARACTER VARYING(1) 1
92 SPOUSE_ENTITY_ID INTEGER 4
93 SPOUSE_GIVEN_NAME CHARACTER VARYING(121) 121
94 SPOUSE_BIRTH_DATE TIMESTAMP 8
95 SPOUSE_GENDER CHARACTER VARYING(1) 1
96 SPOUSE_DECEASED_DATE TIMESTAMP 8
97 ADVISOR_NAME CHARACTER VARYING(122) 122
98 DECEASED_ORIGINAL_MEMBER_NAME CHARACTER VARYING(122) 122
99 ORIGINAL_MEMBER_DECEASED_DATE TIMESTAMP 8