FCT_CMPS_MEMBER_ACCOUNT_INSIGHT

Database

INSNZP01_WEALTH

Schema

WEALTHPADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 MEMBER_ACCOUNT_ID INTEGER 4
2 ENTITY_ID INTEGER 4
3 ADVISER_ACCOUNT_ID INTEGER 4
4 CORR_ADVISER_ACCOUNT_ID INTEGER 4
5 PRODUCT_TYPE_ID INTEGER 4
6 OLD_SYSTEM_REFERENCE CHARACTER VARYING(20) 20
7 STATUS CHARACTER VARYING(1) 1
8 REVERSIONARY_FLAG CHARACTER VARYING(1) 1
9 REVERSIONARY_ENTITY_ID INTEGER 4
10 REVERSION_DATETIME TIMESTAMP 8
11 COMPLYING_FUND_ID INTEGER 4
12 TRUSTEE_ENTITY_ID INTEGER 4
13 DISABLE_PAYMENTS_FLAG CHARACTER VARYING(1) 1
14 CORRESPONDENCE_FLAG CHARACTER VARYING(1) 1
15 FUND_START_DATE TIMESTAMP 8
16 FUND_END_DATE TIMESTAMP 8
17 SOLE_PARENT_REBATE NUMERIC(18,2) 19
18 SPECIAL_REBATES NUMERIC(18,2) 19
19 ZONE_REBATE NUMERIC(18,2) 19
20 AMOUNT_CLAIMED_AS_TAX_DEDUCT NUMERIC(18,2) 19
21 PENSION_TERM_YEARS INTEGER 4
22 PENSION_TERM_MONTHS INTEGER 4
23 PAYMENT_FREQUENCY_FLAG CHARACTER VARYING(1) 1
24 FIRST_PAYMENT_DATE TIMESTAMP 8
25 REPORTING_FREQUENCY_FLAG CHARACTER VARYING(1) 1
26 RETIREMENT_AGE INTEGER 4
27 PENSION_TYPE CHARACTER VARYING(1) 1
28 ACCOUNT_CREATION_DATE TIMESTAMP 8
29 PENSION_START_DATE TIMESTAMP 8
30 PENSION_ESCALATION_TYPE CHARACTER VARYING(1) 1
31 PENSION_ESCALATION_PERCENT NUMERIC(5,2) 19
32 NEXTYEAR_ESCALATION_TYPE CHARACTER VARYING(1) 1
33 NEXTYEAR_ESCALATION_PERCENT NUMERIC(5,2) 19
34 EARLIEST_FUND_START_DATE TIMESTAMP 8
35 NEXTYEAR_PENSION_AMOUNT NUMERIC(18,2) 19
36 LOST_MEMBER_FLAG CHARACTER VARYING(1) 1
37 CFORWARD_DED_AMOUNT NUMERIC(18,2) 19
38 OTHER_REBATE NUMERIC(18,2) 19
39 EXTRA_TAX NUMERIC(18,2) 19
40 INVALIDITY_FLAG CHARACTER VARYING(1) 1
41 REBATE_PERCENT NUMERIC(7,4) 19
42 APPLY_REBATE_FLAG CHARACTER VARYING(1) 1
43 PREFERRED_PAYMENT_TYPE CHARACTER VARYING(1) 1
44 PAYEE_NAME CHARACTER VARYING(60) 60
45 BANK_ACCOUNT_ID INTEGER 4
46 EXIT_REASON_CODE CHARACTER VARYING(1) 1
47 EMPLOYER_ADDRESS_FLAG CHARACTER VARYING(1) 1
48 NOTATION CHARACTER VARYING(2000) 2000
49 TAX_CATEGORY CHARACTER VARYING(1) 1
50 DEPENDANT_SPOUSE_REBATE NUMERIC(18,2) 19
51 REQUESTED_DEDUCTION_AMOUNT NUMERIC(18,2) 19
52 CALCULATED_DEDUCTION_AMOUNT NUMERIC(18,2) 19
53 PENSION_ANNUAL_AMOUNT NUMERIC(18,2) 19
54 PENSION_AMOUNT NUMERIC(18,2) 19
55 PENSION_PAYMENT_TYPE CHARACTER VARYING(1) 1
56 PENSION_PAYEE_NAME CHARACTER VARYING(60) 60
57 PENSION_BANK_ACCOUNT_ID INTEGER 4
58 DEFAULT_STATEMENT_FLAG CHARACTER VARYING(1) 1
59 PENSION_NEXTDUE_DATE TIMESTAMP 8
60 PENSION_AMOUNT_INC_FEES NUMERIC(18,2) 19
61 REVERSION_PERCENT NUMERIC(5,2) 19
62 ADVISER_EFFECTIVE_DATETIME TIMESTAMP 8
63 CLAIM_DEDUCTION_FLAG CHARACTER VARYING(1) 1
64 PHONE_REDEMPTION_OK_FLAG CHARACTER VARYING(1) 1
65 ACCOUNT_STOPPED_FLAG CHARACTER VARYING(1) 1
66 CLIENT_TYPE CHARACTER VARYING(1) 1
67 FID_APPLIES_FLAG CHARACTER VARYING(1) 1
68 BAD_APPLIES_FLAG CHARACTER VARYING(1) 1
69 GC_LAST_PRINTED_YEAR INTEGER 4
70 LAST_MODIFIED_DATE TIMESTAMP 8
71 FEEDER_MASTER_PORTFOLIO_ID INTEGER 4
72 COMPLYING_PENSION_FLAG CHARACTER VARYING(1) 1
73 FINAL_ANNUITY_PAYMENT_DATE TIMESTAMP 8
74 SURCHG_INTEREST_PENDING NUMERIC(13,2) 19
75 SURCHG_AMOUNT_PENDING NUMERIC(13,2) 19
76 SURCHG_ADV_INSTAL_PENDING NUMERIC(13,2) 19
77 SURCHG_INT_ATO_FILE CHARACTER VARYING(10) 10
78 SURCHG_AMT_ATO_FILE CHARACTER VARYING(10) 10
79 SURCHG_ADV_INSTAL_ATO_FILE CHARACTER VARYING(10) 10
80 PORTFOLIO_BASED_FEE_AMOUNT NUMERIC(18,2) 19
81 ACCOUNT_STOPPED_DATETIME TIMESTAMP 8
82 STATEMENT_NUMBER_COPIES INTEGER 4
83 DATE_LOSTMEMBER_REPORTED TIMESTAMP 8
84 DATE_FOUNDMEMBER_REPORTED TIMESTAMP 8
85 MAIL_EXCLUSION CHARACTER VARYING(1) 1
86 PENSION_NEXTRUN_DATE TIMESTAMP 8
87 PENSION_STATUS CHARACTER VARYING(1) 1
88 CAP_FLAG CHARACTER VARYING(1) 1
89 CAP_ACCESS_AGE INTEGER 4
90 CAP_INDEX_AGE INTEGER 4
91 CAP_NON_COMMUTABLE_AMOUNT NUMERIC(18,2) 19
92 CAP_NON_COMMUTABLE_PERCENT NUMERIC(5,2) 19
93 ACCOUNT_OPERATION_IDENTIFIER CHARACTER VARYING(1) 1
94 INVESTMENT_MODEL_ID INTEGER 4
95 DIVORCE_PROCEEDINGS_FLAG CHARACTER VARYING(1) 1
96 EXCLUDE_INS_LAPSING_FLAG CHARACTER VARYING(1) 1
97 TFN_SUPPLIED_FLAG CHARACTER VARYING(1) 1
98 TAX_WRAPPER_TYPE_CODE CHARACTER VARYING(10) 10
99 ASSET_TEST_EXEMPT_FUNDED CHARACTER VARYING(1) 1
100 TERM_PENSION_END_DATE TIMESTAMP 8
101 TAP_ANNUAL_PAYMENT_METHOD CHARACTER VARYING(1) 1
102 TERM_RELATED_TO CHARACTER VARYING(1) 1
103 TERM_LIFE_EXP_TABLE CHARACTER VARYING(8) 8
104 ISA_REPAIR_DATE TIMESTAMP 8
105 ISA_VOID_DATE TIMESTAMP 8
106 CONCURRENT_INDICATOR CHARACTER VARYING(1) 1
107 CATEGORY_STATUS CHARACTER VARYING(20) 20
108 RETIREMENT_DATE TIMESTAMP 8
109 CONTRACTED_OUT_FLAG CHARACTER VARYING(1) 1
110 CONTRACT_OUT_ACKNOWLEDGE_FLAG CHARACTER VARYING(1) 1
111 PENSION_RETAIN_100PERC_ATE CHARACTER VARYING(1) 1
112 MARITAL_STATUS CHARACTER VARYING(1) 1
113 IDD_CEASE_DATE TIMESTAMP 8
114 SURVIVOR_IDD_FLAG CHARACTER VARYING(1) 1
115 DECEASED_MACC_ID INTEGER 4
116 TRANSITION_TO_RETIREMENT_FLAG CHARACTER VARYING(1) 1
117 EXCLUDE_FROM_TOPUP_SWEEP_FLAG CHARACTER VARYING(1) 1
118 PENSION_AMOUNT_CALCULATED NUMERIC(18,2) 19
119 PENS_APPLY_POST07_RULE CHARACTER VARYING(1) 1
120 REVERSIONARY_AGE INTEGER 4
121 PENSION_FACTORS_RULE_FLAG CHARACTER VARYING(1) 1
122 INVALIDITY_PENSION_FLAG CHARACTER VARYING(1) 1
123 DEATH_PENSION_FLAG CHARACTER VARYING(1) 1
124 PENSION_ORIGINAL_START_DATE TIMESTAMP 8
125 LOSTMEM_TRANSFER_REPORTED TIMESTAMP 8
126 LOSTMEM_INACTIVE_REPORTED TIMESTAMP 8
127 LOSTMEM_ERROR_REPORTED TIMESTAMP 8
128 LMR_TRANSFER_REASON_ID INTEGER 4
129 DEFAULT_DEFERRED_ENTRY_FEES CHARACTER VARYING(1) 1
130 TRN_NUMBER CHARACTER VARYING(15) 15
131 USM_REPORT_DATE TIMESTAMP 8
132 USM_REPORT_ERROR_FLAG CHARACTER VARYING(1) 1
133 LOST_MEMBER_REPORTED_BALANCE NUMERIC(18,2) 19
134 CTAX_REBATE_ALLOW_EXPENSE CHARACTER VARYING(1) 1
135 USM_STATUS CHARACTER VARYING(1) 1
136 INSOLUBLE_LOST_ACCOUNT_FLAG CHARACTER VARYING(1) 1
137 TRAIL_WITHHOLD_FLAG CHARACTER VARYING(1) 1
138 WITHHELD_TRAIL_PAYFORFEIT_FLAG CHARACTER VARYING(1) 1
139 TRN_MODIFIED_DATE TIMESTAMP 8
140 SPOUSE_OF_PRIMARY_ENTITY_FLAG CHARACTER VARYING(1) 1
141 NONREV_PRIMARY_ENTITY_ID INTEGER 4
142 INVESTMENT_CHOICE_FLAG CHARACTER VARYING(1) 1
143 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
144 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
145 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
146 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8