FCT_CMPS_PORTFOLIO_INSIGHT

Database

INSNZP01_WEALTH

Schema

WEALTHPADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PORTFOLIO_ID INTEGER 4
2 PRODUCT_TYPE_ID INTEGER 4
3 NAME CHARACTER VARYING(40) 40
4 STATUS CHARACTER VARYING(1) 1
5 OLD_SYSTEM_REFERENCE CHARACTER VARYING(20) 20
6 START_DATE TIMESTAMP 8
7 END_DATE TIMESTAMP 8
8 DEFAULT_FLAG CHARACTER VARYING(1) 1
9 UNITISED_FLAG CHARACTER VARYING(1) 1
10 PORTFOLIO_TYPE CHARACTER VARYING(1) 1
11 ASSET_ID INTEGER 4
12 DISTRIBUTION_METHOD_FLAG CHARACTER VARYING(1) 1
13 VALUATION NUMERIC(18,2) 19
14 VALUATION_DATETIME TIMESTAMP 8
15 BANK_BALANCE NUMERIC(18,2) 19
16 CREDITORS_BALANCE NUMERIC(18,2) 19
17 DEBTORS_BALANCE NUMERIC(18,2) 19
18 LIQUID_FLAG CHARACTER VARYING(1) 1
19 REQUIRES_LIQUID_FLAG CHARACTER VARYING(1) 1
20 YIELD NUMERIC(7,4) 19
21 UNITS_ON_ISSUE INTEGER 4
22 WORKING_BANK_ACCOUNT_ID INTEGER 4
23 PAYMENT_BANK_ACCOUNT_ID INTEGER 4
24 NOTATION CHARACTER VARYING(2000) 2000
25 INCOME_TAX_ACCRUAL_RATE NUMERIC(7,4) 19
26 APIR_CODE CHARACTER VARYING(10) 10
27 PERCENT_LIQUIDITY_REQUIRED NUMERIC(5,2) 19
28 ASSET_UNITPRICE_FLAG CHARACTER VARYING(1) 1
29 BANK_INTEREST_RATE NUMERIC(5,2) 19
30 GROUPING_CODE CHARACTER VARYING(10) 10
31 SHORT_CODE CHARACTER VARYING(20) 20
32 REIMB_EXP_ACCRUAL_RATE NUMERIC(5,2) 19
33 PORTFOLIO_CLASS_CODE CHARACTER VARYING(1) 1
34 INCLUDE_MISC_TRANS_DISTN_FLAG CHARACTER VARYING(1) 1
35 UPS_PROCESS_CODE CHARACTER VARYING(1) 1
36 UPS_FEEDER_TRUST_TYPE CHARACTER VARYING(1) 1
37 LAST_MODIFIED_DATE TIMESTAMP 8
38 OK_FOR_DISBURSEMENT_FLAG CHARACTER VARYING(1) 1
39 TRAIL_FLAG CHARACTER VARYING(1) 1
40 PORTFOLIO_BASED_FEE_FLAG CHARACTER VARYING(1) 1
41 CORRESPONDENCE_NAME CHARACTER VARYING(40) 40
42 PORTFOLIO_BASED_FEE_PERCENT NUMERIC(7,4) 19
43 TRUSTEE_LEVEL_PARTY_TYPE_ID INTEGER 4
44 TRUSTEE_ENTITY_ID INTEGER 4
45 CUSTODIAN_ENTITY_ID INTEGER 4
46 FUND_MANAGER_ENTITY_ID INTEGER 4
47 REDEMPTION_BANK_ACC_DIR_CREDIT INTEGER 4
48 BROKERAGE_BANK_ACCOUNT_ID INTEGER 4
49 CIV_FLAG CHARACTER VARYING(1) 1
50 TFN_REQUIRED_FLAG CHARACTER VARYING(1) 1
51 PORTFOLIO_DIST_PARMS_ID INTEGER 4
52 ENTRY_FEE_ALLOWED_FLAG CHARACTER VARYING(1) 1
53 TRAIL_FEE_ALLOWED_FLAG CHARACTER VARYING(1) 1
54 TRAIL_REBATE_ALLOWED_FLAG CHARACTER VARYING(1) 1
55 MIN_APPLICATION_AMOUNT NUMERIC(18,2) 19
56 MIN_ACCOUNT_BALANCE NUMERIC(18,2) 19
57 EXIT_FEE_ALLOWED_FLAG CHARACTER VARYING(1) 1
58 MIN_REDEMPTION_AMOUNT NUMERIC(18,2) 19
59 MIN_SWITCH_AMOUNT NUMERIC(18,2) 19
60 SWITCH_FEE_ALLOWED_FLAG CHARACTER VARYING(1) 1
61 REGULAR_DRAWDOWN_ALLOWED_FLAG CHARACTER VARYING(1) 1
62 SAVINGS_PLAN_ALLOWED_FLAG CHARACTER VARYING(1) 1
63 MIN_ADD_APPLICATION_AMOUNT NUMERIC(18,2) 19
64 DIST_IN_PROGRESS_FLAG CHARACTER VARYING(1) 1
65 ABN NUMERIC(11,0) 19
66 BROKERAGE_NAME CHARACTER VARYING(60) 60
67 DEFAULT_PRICING_METHOD CHARACTER VARYING(1) 1
68 PORTFOLIO_CLASSIFICATION CHARACTER VARYING(1) 1
69 INITIAL_PRICING_STATUS CHARACTER VARYING(1) 1
70 SUSPEND_EXIT_FEE_AGING_FLAG CHARACTER VARYING(1) 1
71 EXIT_FEE_NUMBER_PERIOD NUMERIC(6,0) 19
72 EXIT_FEE_PERIOD_FREQUENCY CHARACTER VARYING(1) 1
73 REDEMPTION_SEQUENCE_NUMBER NUMERIC(6,0) 19
74 VOLATILITY_RANKING NUMERIC(6,2) 19
75 PORTFOLIO_PRICING_TYPE CHARACTER VARYING(1) 1
76 APPLICATION_STATUS CHARACTER VARYING(1) 1
77 COMPOUND_INTEREST_FLAG CHARACTER VARYING(1) 1
78 REDEMPTION_STATUS CHARACTER VARYING(1) 1
79 ILINK_REPORTABLE_FLAG CHARACTER VARYING(1) 1
80 DEFAULT_PORTFOLIO_PARMS_FLAG CHARACTER VARYING(1) 1
81 NO_GROWTH_FLAG CHARACTER VARYING(1) 1
82 UPFRONT_OR_TRAIL_ONLY_FLAG CHARACTER VARYING(1) 1
83 UPFRONT_OR_TRAIL_DEFAULT CHARACTER VARYING(1) 1
84 PARCELISED_TRAIL_FLAG CHARACTER VARYING(1) 1
85 INCLUDE_CGT_REPORTING_FLAG CHARACTER VARYING(1) 1
86 EXIT_FEE_WAIVE_ALLOWED_FLAG CHARACTER VARYING(1) 1
87 CURRENCY_CODE CHARACTER VARYING(3) 3
88 MSG_IF_NO_LATEST_UNITPRICE CHARACTER VARYING(1) 1
89 EXCEED_STD_ENTRY_FEE_FLAG CHARACTER VARYING(1) 1
90 LOAN_PORT_UNDERLYING_PROD_ID INTEGER 4
91 UPS_TOLERANCE_APPLIES CHARACTER VARYING(1) 1
92 UPS_TOLERANCE_RANGE NUMERIC(5,2) 19
93 APP_UP_SPREAD_PC NUMERIC(9,6) 19
94 RED_UP_SPREAD_PC NUMERIC(9,6) 19
95 NEXT_UP_DATETIME TIMESTAMP 8
96 UNIT_PRICE_FREQUENCY CHARACTER VARYING(1) 1
97 UP_APPLIES_FLAG CHARACTER VARYING(1) 1
98 UP_PRECISION INTEGER 4
99 UP_ROUNDING_METHOD CHARACTER VARYING(1) 1
100 DEFAULT_APPS_TRADE_DAYS INTEGER 4
101 DEFAULT_REDS_TRADE_DAYS INTEGER 4
102 TAX_WRAPPER_STATUS CHARACTER VARYING(1) 1
103 TAX_WRAPPER_COMP_CODE CHARACTER VARYING(10) 10
104 APPLICATION_CUTOFF TIME 8
105 REDEMPTION_CUTOFF TIME 8
106 INSURANCE_BANK_ACCOUNT_ID INTEGER 4
107 INSURANCE_RECOVERY_PORT_FLAG CHARACTER VARYING(1) 1
108 APPLY_PAL CHARACTER VARYING(1) 1
109 PAL_AMOUNT NUMERIC(18,2) 19
110 UNIT_APPS_ALLOWED_FLAG CHARACTER VARYING(1) 1
111 ANNUALISE_IRR_CALC CHARACTER VARYING(1) 1
112 SORT_ORDER INTEGER 4
113 SWITCH_CODE CHARACTER VARYING(20) 20
114 TERM_DEPOSIT_FLAG CHARACTER VARYING(1) 1
115 DEPOSIT_TERM INTEGER 4
116 MYSUPER_FLAG CHARACTER VARYING(1) 1
117 ACCRUED_DEFAULT_AMOUNT_FLAG CHARACTER VARYING(1) 1
118 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
119 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
120 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
121 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
122 DOMICILE_COUNTRY_CODE CHARACTER VARYING(8) 8
123 FATCA_STATUS CHARACTER VARYING(1) 1
124 GIIN CHARACTER VARYING(19) 19
125 GIIN_FLAG CHARACTER VARYING(1) 1
126 GIIN_VERIFIED_FLAG CHARACTER VARYING(1) 1