Warehouse Performance Data Map Table
- Natalie Gesin (Deactivated)
- Kinga Huszno
- Dmitry Donosiyan (Unlicensed)
Either Warehouse Performance Data Map Table#dictionaryName or Warehouse Performance Data Map Table#dictionaryId must be set in your data message. dictionaryId has a higher priority for the load. If you pass only one of them, another field will be extracted with the same value
Element | Optional/ Required | Value Type | Star Tag | SP Parameter | Eagle DB | DB Table | DB Field | DB Data Type | GIS CSV Names | PIPE Numbers | Xpath |
|---|---|---|---|---|---|---|---|---|---|---|---|
objectType |
| ObjectTypeEnum |
|
| not stored in DB |
|
|
| EagleML/warehouseTransaction/warehousePerformance/objectType | ||
objectId |
| ObjectId |
|
| not stored in DB |
|
|
| EagleML/warehouseTransaction/warehousePerformance/objectId | ||
objectDescription |
| FeedTypeEnum |
|
| not stored in DB |
|
|
| EagleML/warehouseTransaction/warehousePerformance/objectDescription | ||
updateTimestamp |
| dateTime |
|
| PERFORMDBO | PERF_SUMMARY | UPDATE_DATE | DATE |
|
| EagleML/warehouseTransaction/warehousePerformance/updateTimestamp |
customElements | Not recommended | CustomElements - Complex Type |
|
| reserved for customization |
|
|
| EagleML/warehouseTransaction/warehousePerformance/customElements | ||
sourceName |
| string | 1102 | in_short_desc | PACE_MASTERDBO | INTERFACES | SHORT_DESC | CHAR(15) | F1102 |
| EagleML/warehouseTransaction/warehousePerformance/sourceName |
updateSource |
| string | 944 | in_update_source | PERFORMDBO | PERF_SEC_RETURNS | UPDATE_SOURCE | CHAR(8) | F944 | 3 | EagleML/warehouseTransaction/warehousePerformance/updateSource |
batchCollectErrorsFlag |
| YesNoOptionEnum |
|
| not stored in DB |
|
|
| EagleML/warehouseTransaction/warehousePerformance/batchCollectErrorsFlag | ||
singleRowCommitFlag |
| YesNoOptionEnum |
|
| not stored in DB |
|
|
| EagleML/warehouseTransaction/warehousePerformance/singleRowCommitFlag | ||
reportType |
| string |
|
| not stored in DB |
|
|
| EagleML/warehouseTransaction/warehousePerformance/reportType | ||
effectiveDate |
| date |
|
| not stored in DB |
|
|
| EagleML/warehouseTransaction/warehousePerformance/effectiveDate | ||
EagleML/warehouseTransaction/warehousePerformance/ | |||||||||||
Entity Properties Model (extract only) | EagleML/warehouseTransaction/warehousePerformance/ | ||||||||||
accountingBasis |
| string | 21 |
| not stored in DB |
| F21 |
| EagleML/warehouseTransaction/warehousePerformance/accountingBasis | ||
EagleML/warehouseTransaction/warehousePerformance/ | |||||||||||
Extended Asset Properties Model (extract only) | EagleML/warehouseTransaction/warehousePerformance/ | ||||||||||
maturityDate |
| date |
|
| not stored in DB |
|
|
| EagleML/warehouseTransaction/warehousePerformance/maturityDate | ||
abal |
| decimal | 9826 | in_abal | PERFORMDBO | PERF_SEC_RETURNS | ABAL | NUMBER(28,12) | F9826 | 98 | EagleML/warehouseTransaction/warehousePerformance/abal |
afterTaxReturn |
| decimal | 2544 | in_after_tax_return | PERFORMDBO | PERF_SEC_RETURNS | AFTER_TAX_RETURN | NUMBER(28,12) | F2544 | 100 | EagleML/warehouseTransaction/warehousePerformance/afterTaxReturn |
accruedIncome |
| decimal | 2542 | in_accrued_income | PERFORMDBO | PERF_SEC_RETURNS | ACCRUED_INCOME | NUMBER(28,12) | F2542 | 99 | EagleML/warehouseTransaction/warehousePerformance/accruedIncome |
beforeTaxReturn |
| decimal | 2545 | in_before_tax_return | PERFORMDBO | PERF_SEC_RETURNS | BEFORE_TAX_RETURN | NUMBER(28,12) | F2545 | 101 | EagleML/warehouseTransaction/warehousePerformance/beforeTaxReturn |
currency |
| decimal | 2546 | in_currency | PERFORMDBO | PERF_SEC_RETURNS | CURRENCY | NUMBER(28,12) | F2546 | 102 | EagleML/warehouseTransaction/warehousePerformance/currency |
currencyCode |
| string | 85 | in_currency_code | PERFORMDBO | PERF_SEC_RETURNS | CURRENCY_CODE | CHAR(4) | F85 | 103 | EagleML/warehouseTransaction/warehousePerformance/currencyCode |
dailyWtdAdj |
| decimal | 2547 | in_daily_wtd_adj | PERFORMDBO | PERF_SEC_RETURNS | DAILY_WTD_ADJ | NUMBER(28,12) | F2547 | 104 | EagleML/warehouseTransaction/warehousePerformance/dailyWtdAdj |
dVA |
| decimal | 2548 | in_dva | PERFORMDBO | PERF_SEC_RETURNS | DVA | NUMBER(28,12) | F2548 | 105 | EagleML/warehouseTransaction/warehousePerformance/dVA |
returnLevel |
| PerformanceReturnLevelEnum | 1256 | in_switch | not stored in DB |
| F1256 |
| EagleML/warehouseTransaction/warehousePerformance/returnLevel | ||
Required - either dictionaryName or dictionaryId must be set | string - used in resolution logics | 1156 | in_dictionary_name | RULESDBO | DICTIONARIES | DICTIONARY_NAME | CHAR(50) | F11567 |
| EagleML/warehouseTransaction/warehousePerformance/dictionaryName | |
decimal | 9753 | in_dictionary_id | PERFORMDBO | PERF_SUMMARY | DICTIONARY_ID | NUMBER(38) | F9753 |
| EagleML/warehouseTransaction/warehousePerformance/dictionaryId | ||
endDate |
| date | 221 | in_end_effective_date | PERFORMDBO | PERF_SUMMARY | END_EFFECTIVE_DATE | DATE | F221 |
| EagleML/warehouseTransaction/warehousePerformance/endDate |
earnedIncome |
| decimal | 9775 | in_earned_income | PERFORMDBO | PERF_SEC_RETURNS | EARNED_INCOME | NUMBER(28,12) | F9775 | 106 | EagleML/warehouseTransaction/warehousePerformance/earnedIncome |
flowWeighting |
| string | 9799 | in_flow_weighting | PERFORMDBO | PERF_SEC_RETURNS | FLOW_WEIGHTING | CHAR(8) | F9799 | 111 | EagleML/warehouseTransaction/warehousePerformance/flowWeighting |
feeHandling |
| string | 2000 | in_fee_handling | PERFORMDBO | PERF_SEC_RETURNS | FEE_HANDLING | CHAR(8) | F2000 | 107 | EagleML/warehouseTransaction/warehousePerformance/feeHandling |
feeStatus |
| decimal | 2549 | in_fee_status | PERFORMDBO | PERF_SEC_RETURNS | FEE_STATUS | NUMBER(28,12) | F2549 | 108 | EagleML/warehouseTransaction/warehousePerformance/feeStatus |
fees |
| decimal | 9777 | in_fees | PERFORMDBO | PERF_SEC_RETURNS | FEES | NUMBER(28,12) | F9777 | 109 | EagleML/warehouseTransaction/warehousePerformance/fees |
fieldAttributeId |
| decimal | 2550 | in_field_attribute_id | PERFORMDBO | PERF_SEC_RETURNS | FIELD_ATTRIBUTE_ID | NUMBER | F2550 | 110 | EagleML/warehouseTransaction/warehousePerformance/fieldAttributeId |
inactiveFlag |
| YesNoOptionEnum - used in resolution logics | 1104 | in_inactive_flag | RULESDBO | ENTITY | INACTIVE_FLAG | CHAR(20) | F11043 |
| EagleML/warehouseTransaction/warehousePerformance/inactiveFlag |
levelCount |
| decimal | 3037 | in_level_count | PERFORMDBO | PERF_SUMMARY | LEVEL_COUNT | NUMBER | F3037 |
| EagleML/warehouseTransaction/warehousePerformance/levelCount |
matDate |
| date - used in resolution logics | 38 | in_mat_date | not stored in DB |
| F38 |
| EagleML/warehouseTransaction/warehousePerformance/matDate | ||
marketValue |
| decimal | 9773 | in_market_value | PERFORMDBO | PERF_SEC_RETURNS | MARKET_VALUE | NUMBER(28,12) | F9773 | 125 | EagleML/warehouseTransaction/warehousePerformance/marketValue |
mpcLockInd |
| string | 9760 | in_mpc_lock_ind | PERFORMDBO | PERF_SUMMARY | MPC_LOCK_IND | VARCHAR2(20) | F9760 |
| EagleML/warehouseTransaction/warehousePerformance/mpcLockInd |
mpcUpdDate |
| date | 9759 | in_mpc_update_date | PERFORMDBO | PERF_SUMMARY | MPC_UPD_DATE | DATE | F9759 |
| EagleML/warehouseTransaction/warehousePerformance/mpcUpdDate |
netAdjAmt |
| decimal | 9859 | in_net_adj_amt | PERFORMDBO | PERF_SEC_RETURNS | NET_ADJ_AMT | NUMBER(28,12) | F9859 | 137 | EagleML/warehouseTransaction/warehousePerformance/netAdjAmt |
perfFreqCode |
| PerfFreqCodeEnum | 9751 | in_perf_freq_code | PERFORMDBO | PERF_SUMMARY | PERF_FREQ_CODE | CHAR(8) | F9751 |
| EagleML/warehouseTransaction/warehousePerformance/perfFreqCode |
perfRollupReturnsId |
| decimal | 9763 | in_perf_roll_return_id | PERFORMDBO | PERF_SEC_RETURNS | PERF_ROLLUP_RETURNS_ID | NUMBER | F9763 |
| EagleML/warehouseTransaction/warehousePerformance/perfRollupReturnsId |
prinReturn |
| decimal | 9767 | in_prin_return | PERFORMDBO | PERF_SEC_RETURNS | PRIN_RETURN | NUMBER(28,12) | F9767 | 138 | EagleML/warehouseTransaction/warehousePerformance/prinReturn |
recordType |
| string | 2008 | in_record_type | PERFORMDBO | PERF_SEC_RETURNS | RECORD_TYPE | CHAR(8) | F2008 | 148 | EagleML/warehouseTransaction/warehousePerformance/recordType |
returnType |
| integer | 2865 | in_return_type | PERFORMDBO | PERF_SEC_RETURNS | RETURN_TYPE | NUMBER(28,12) | F2865 | 149 | EagleML/warehouseTransaction/warehousePerformance/returnType |
statusFlag |
| string | 9757 | in_status_flag | PERFORMDBO | PERF_SUMMARY | STATUS_FLAG | CHAR(2) | F9757 | 2 | EagleML/warehouseTransaction/warehousePerformance/statusFlag |
startDate |
| date | 220 | in_begin_effective_date | PERFORMDBO | PERF_SUMMARY | BEGIN_EFFECTIVE_DATE | DATE | F220 | 4 | EagleML/warehouseTransaction/warehousePerformance/startDate |
srcIntfcInst |
| decimal | 1168 | in_src_intfc_inst | not stored in DB |
| F1168 |
| EagleML/warehouseTransaction/warehousePerformance/srcIntfcInst | ||
taxStatus |
| decimal | 2866 | in_tax_status | PERFORMDBO | PERF_SEC_RETURNS | TAX_STATUS | NUMBER(28,12) | F2866 | 150 | EagleML/warehouseTransaction/warehousePerformance/taxStatus |
totalReturn |
| decimal | 9764 | in_tot_return | PERFORMDBO | PERF_SEC_RETURNS | TOT_RETURN | NUMBER(28,12) | F9764 | 151 | EagleML/warehouseTransaction/warehousePerformance/totalReturn |
totalReturnNet |
| decimal | 4597 | in_tot_return_net | PERFORMDBO | PERF_SEC_RETURNS | TOT_RETURN_NET | NUMBER(28,12) | F4597 | 152 | EagleML/warehouseTransaction/warehousePerformance/totalReturnNet |
totalFlows |
| decimal | 9774 | in_total_flows | PERFORMDBO | PERF_SEC_RETURNS | TOTAL_FLOWS | NUMBER(28,12) | F9774 | 153 | EagleML/warehouseTransaction/warehousePerformance/totalFlows |
pSperformanceFlag |
| YesNoOptionEnum | 3065 | in_ps_perform_flag | PERFORMDBO | PERF_SUMMARY | PS_PERFORM_FLAG | VARCHAR2(2) | F3065 |
| EagleML/warehouseTransaction/warehousePerformance/pSperformanceFlag |
incAdjNet |
| decimal | 2551 | in_inc_adj_net | PERFORMDBO | PERF_SEC_RETURNS | INC_ADJ_NET | NUMBER(28,12) | F2551 | 112 | EagleML/warehouseTransaction/warehousePerformance/incAdjNet |
incAdjWtd |
| decimal | 2552 | in_inc_adj_wtd | PERFORMDBO | PERF_SEC_RETURNS | INC_ADJ_WTD | NUMBER(28,12) | F2552 | 113 | EagleML/warehouseTransaction/warehousePerformance/incAdjWtd |
iRRReturn |
| decimal | 2557 | in_irr_return | PERFORMDBO | PERF_SEC_RETURNS | IRR_RETURN | NUMBER(28,12) | F2557 | 114 | EagleML/warehouseTransaction/warehousePerformance/iRRReturn |
iRRReturnNet |
| decimal | 2558 | in_irr_return_net | PERFORMDBO | PERF_SEC_RETURNS | IRR_RETURN_NET | NUMBER(28,12) | F2558 | 115 | EagleML/warehouseTransaction/warehousePerformance/iRRReturnNet |
iTDAfterTaxReturn |
| decimal | 2559 | in_itd_after_tax_return | PERFORMDBO | PERF_SEC_RETURNS | ITD_AFTER_TAX_RETURN | NUMBER(28,12) | F2559 | 116 | EagleML/warehouseTransaction/warehousePerformance/iTDAfterTaxReturn |
iTDBeforeTaxReturn |
| decimal | 2564 | in_itd_before_tax_return | PERFORMDBO | PERF_SEC_RETURNS | ITD_BEFORE_TAX_RETURN | NUMBER(28,12) | F2564 | 117 | EagleML/warehouseTransaction/warehousePerformance/iTDBeforeTaxReturn |
iTDiRRReturn |
| decimal | 2565 | in_itd_irr_return | PERFORMDBO | PERF_SEC_RETURNS | ITD_IRR_RETURN | NUMBER(28,12) | F2565 | 118 | EagleML/warehouseTransaction/warehousePerformance/iTDiRRReturn |
iTDiRRReturnNet |
| decimal | 2566 | in_itd_irr_return_net | PERFORMDBO | PERF_SEC_RETURNS | ITD_IRR_RETURN_NET | NUMBER(28,12) | F2566 | 119 | EagleML/warehouseTransaction/warehousePerformance/iTDiRRReturnNet |
iTDModDietzReturn |
| decimal | 2571 | in_itd_mod_dietz_return | PERFORMDBO | PERF_SEC_RETURNS | ITD_MOD_DIETZ_RETURN | NUMBER(28,12) | F2571 | 120 | EagleML/warehouseTransaction/warehousePerformance/iTDModDietzReturn |
iTDModDietzReturnNet |
| decimal | 2572 | in_itd_mod_dietz_return_net | PERFORMDBO | PERF_SEC_RETURNS | ITD_MOD_DIETZ_RETURN_NET | NUMBER(28,12) | F2572 | 121 | EagleML/warehouseTransaction/warehousePerformance/iTDModDietzReturnNet |
iTDPrincipalReturn |
| decimal | 2573 | in_itd_prin_return | PERFORMDBO | PERF_SEC_RETURNS | ITD_PRIN_RETURN | NUMBER(28,12) | F2573 | 122 | EagleML/warehouseTransaction/warehousePerformance/iTDPrincipalReturn |
iTDTotalReturn |
| decimal | 2578 | in_itd_tot_return | PERFORMDBO | PERF_SEC_RETURNS | ITD_TOT_RETURN | NUMBER(28,12) | F2578 | 123 | EagleML/warehouseTransaction/warehousePerformance/iTDTotalReturn |
iTDTotalReturnNet |
| decimal | 2579 | in_itd_tot_return_net | PERFORMDBO | PERF_SEC_RETURNS | ITD_TOT_RETURN_NET | NUMBER(28,12) | F2579 | 124 | EagleML/warehouseTransaction/warehousePerformance/iTDTotalReturnNet |
modDietzReturn |
| decimal | 2580 | in_mod_dietz_return | PERFORMDBO | PERF_SEC_RETURNS | MOD_DIETZ_RETURN | NUMBER(28,12) | F2580 | 126 | EagleML/warehouseTransaction/warehousePerformance/modDietzReturn |
modDietzReturnNet |
| decimal | 2585 | in_mod_dietz_return_net | PERFORMDBO | PERF_SEC_RETURNS | MOD_DIETZ_RETURN_NET | NUMBER(28,12) | F2585 | 127 | EagleML/warehouseTransaction/warehousePerformance/modDietzReturnNet |
mTDAfterTaxReturn |
| decimal | 2586 | in_mtd_after_tax_return | PERFORMDBO | PERF_SEC_RETURNS | MTD_AFTER_TAX_RETURN | NUMBER(28,12) | F2586 | 128 | EagleML/warehouseTransaction/warehousePerformance/mTDAfterTaxReturn |
mTDBeforeTaxReturn |
| decimal | 2587 | in_mtd_before_tax_return | PERFORMDBO | PERF_SEC_RETURNS | MTD_BEFORE_TAX_RETURN | NUMBER(28,12) | F2587 | 129 | EagleML/warehouseTransaction/warehousePerformance/mTDBeforeTaxReturn |
mTDiRRReturn |
| decimal | 2592 | in_mtd_irr_return | PERFORMDBO | PERF_SEC_RETURNS | MTD_IRR_RETURN | NUMBER(28,12) | F2592 | 130 | EagleML/warehouseTransaction/warehousePerformance/mTDiRRReturn |
mTDiRRReturnNet |
| decimal | 2593 | in_mtd_irr_return_net | PERFORMDBO | PERF_SEC_RETURNS | MTD_IRR_RETURN_NET | NUMBER(28,12) | F2593 | 131 | EagleML/warehouseTransaction/warehousePerformance/mTDiRRReturnNet |
mTDModDietzReturn |
| decimal | 2594 | in_mtd_mod_dietz_return | PERFORMDBO | PERF_SEC_RETURNS | MTD_MOD_DIETZ_RETURN | NUMBER(28,12) | F2594 | 132 | EagleML/warehouseTransaction/warehousePerformance/mTDModDietzReturn |
mTDModDietzReturnNet |
| decimal | 2599 | in_mtd_mod_dietz_return_net | PERFORMDBO | PERF_SEC_RETURNS | MTD_MOD_DIETZ_RETURN_NET | NUMBER(28,12) | F2599 | 133 | EagleML/warehouseTransaction/warehousePerformance/mTDModDietzReturnNet |
mTDPrincipalReturn |
| decimal | 2600 | in_mtd_prin_return | PERFORMDBO | PERF_SEC_RETURNS | MTD_PRIN_RETURN | NUMBER(28,12) | F2600 | 134 | EagleML/warehouseTransaction/warehousePerformance/mTDPrincipalReturn |
mTDTotalReturn |
| decimal | 2602 | in_mtd_tot_return | PERFORMDBO | PERF_SEC_RETURNS | MTD_TOT_RETURN | NUMBER(28,12) | F2602 | 135 | EagleML/warehouseTransaction/warehousePerformance/mTDTotalReturn |
mTDTotalReturnNet |
| decimal | 2603 | in_mtd_tot_return_net | PERFORMDBO | PERF_SEC_RETURNS | MTD_TOT_RETURN_NET | NUMBER(28,12) | F2603 | 136 | EagleML/warehouseTransaction/warehousePerformance/mTDTotalReturnNet |
qTDAfterTaxReturn |
| decimal | 2822 | in_qtd_after_tax_return | PERFORMDBO | PERF_SEC_RETURNS | QTD_AFTER_TAX_RETURN | NUMBER(28,12) | F2822 | 139 | EagleML/warehouseTransaction/warehousePerformance/qTDAfterTaxReturn |
qTDBeforeTaxReturn |
| decimal | 2823 | in_qtd_before_tax_return | PERFORMDBO | PERF_SEC_RETURNS | QTD_BEFORE_TAX_RETURN | NUMBER(28,12) | F2823 | 140 | EagleML/warehouseTransaction/warehousePerformance/qTDBeforeTaxReturn |
qTDiRRReturn |
| decimal | 2824 | in_qtd_irr_return | PERFORMDBO | PERF_SEC_RETURNS | QTD_IRR_RETURN | NUMBER(28,12) | F2824 | 141 | EagleML/warehouseTransaction/warehousePerformance/qTDiRRReturn |
qTDiRRReturnNet |
| decimal | 2825 | in_qtd_irr_return_net | PERFORMDBO | PERF_SEC_RETURNS | QTD_IRR_RETURN_NET | NUMBER(28,12) | F2825 | 142 | EagleML/warehouseTransaction/warehousePerformance/qTDiRRReturnNet |
qTDModDietzReturn |
| decimal | 2830 | in_qtd_mod_dietz_return | PERFORMDBO | PERF_SEC_RETURNS | QTD_MOD_DIETZ_RETURN | NUMBER(28,12) | F2830 | 143 | EagleML/warehouseTransaction/warehousePerformance/qTDModDietzReturn |
qTDModDietzReturnNet |
| decimal | 2831 | in_qtd_mod_dietz_return_net | PERFORMDBO | PERF_SEC_RETURNS | QTD_MOD_DIETZ_RETURN_NET | NUMBER(28,12) | F2831 | 144 | EagleML/warehouseTransaction/warehousePerformance/qTDModDietzReturnNet |
qTDPrincipalReturn |
| decimal | 2877 | in_qtd_prin_return | PERFORMDBO | PERF_SEC_RETURNS | QTD_PRIN_RETURN | NUMBER(28,12) | F2877 | 145 | EagleML/warehouseTransaction/warehousePerformance/qTDPrincipalReturn |
qTDTotalReturn |
| decimal | 2878 | in_qtd_tot_return | PERFORMDBO | PERF_SEC_RETURNS | QTD_TOT_RETURN | NUMBER(28,12) | F2878 | 146 | EagleML/warehouseTransaction/warehousePerformance/qTDTotalReturn |
qTDTotalReturnNet |
| decimal | 2876 | in_qtd_tot_return_net | PERFORMDBO | PERF_SEC_RETURNS | QTD_TOT_RETURN_NET | NUMBER(28,12) | F2876 | 147 | EagleML/warehouseTransaction/warehousePerformance/qTDTotalReturnNet |
unitValueLiqPrincipal |
| decimal | 2867 | in_unit_value_liq_prin | PERFORMDBO | PERF_SEC_RETURNS | UNIT_VALUE_LIQ_PRIN | NUMBER(28,12) | F2867 | 154 | EagleML/warehouseTransaction/warehousePerformance/unitValueLiqPrincipal |
unitValueLiqTotal |
| decimal | 2868 | in_unit_value_liq_tot | PERFORMDBO | PERF_SEC_RETURNS | UNIT_VALUE_LIQ_TOT | NUMBER(28,12) | F2868 | 155 | EagleML/warehouseTransaction/warehousePerformance/unitValueLiqTotal |
unitValuePrincipal |
| decimal | 2869 | in_unit_value_prin | PERFORMDBO | PERF_SEC_RETURNS | UNIT_VALUE_PRIN | NUMBER(28,12) | F2869 | 156 | EagleML/warehouseTransaction/warehousePerformance/unitValuePrincipal |
unitValueRealPrincipal |
| decimal | 2870 | in_unit_value_real_prin | PERFORMDBO | PERF_SEC_RETURNS | UNIT_VALUE_REAL_PRIN | NUMBER(28,12) | F2870 | 157 | EagleML/warehouseTransaction/warehousePerformance/unitValueRealPrincipal |
unitValueRealTotal |
| decimal | 2911 | in_unit_value_real_tot | PERFORMDBO | PERF_SEC_RETURNS | UNIT_VALUE_REAL_TOT | NUMBER(28,12) | F2911 | 158 | EagleML/warehouseTransaction/warehousePerformance/unitValueRealTotal |
unitValueTotal |
| decimal | 9766 | in_unit_value_tot | PERFORMDBO | PERF_SEC_RETURNS | UNIT_VALUE_TOT | NUMBER(28,12) | F9766 | 159 | EagleML/warehouseTransaction/warehousePerformance/unitValueTotal |
yTDAfterTaxReturn |
| decimal | 2912 | in_ytd_after_tax_return | PERFORMDBO | PERF_SEC_RETURNS | YTD_AFTER_TAX_RETURN | NUMBER(28,12) | F2912 | 160 | EagleML/warehouseTransaction/warehousePerformance/yTDAfterTaxReturn |
yTDBeforeTaxReturn |
| decimal | 2913 | in_ytd_before_tax_return | PERFORMDBO | PERF_SEC_RETURNS | YTD_BEFORE_TAX_RETURN | NUMBER(28,12) | F2913 | 161 | EagleML/warehouseTransaction/warehousePerformance/yTDBeforeTaxReturn |
yTDiRRReturn |
| decimal | 2914 | in_ytd_irr_return | PERFORMDBO | PERF_SEC_RETURNS | YTD_IRR_RETURN | NUMBER(28,12) | F2914 | 162 | EagleML/warehouseTransaction/warehousePerformance/yTDiRRReturn |
yTDiRRReturnNet |
| decimal | 2915 | in_ytd_irr_return_net | PERFORMDBO | PERF_SEC_RETURNS | YTD_IRR_RETURN_NET | NUMBER(28,12) | F2915 | 163 | EagleML/warehouseTransaction/warehousePerformance/yTDiRRReturnNet |
yTDModDietzReturn |
| decimal | 2916 | in_ytd_mod_dietz_return | PERFORMDBO | PERF_SEC_RETURNS | YTD_MOD_DIETZ_RETURN | NUMBER(28,12) | F2916 | 164 | EagleML/warehouseTransaction/warehousePerformance/yTDModDietzReturn |
yTDModDietzReturnNet |
| decimal | 2917 | in_ytd_mod_dietz_return_net | PERFORMDBO | PERF_SEC_RETURNS | YTD_MOD_DIETZ_RETURN_NET | NUMBER(28,12) | F2917 | 165 | EagleML/warehouseTransaction/warehousePerformance/yTDModDietzReturnNet |
yTDPrincipalReturn |
| decimal | 2898 | in_ytd_prin_return | PERFORMDBO | PERF_SEC_RETURNS | YTD_PRIN_RETURN | NUMBER(28,12) | F2898 | 166 | EagleML/warehouseTransaction/warehousePerformance/yTDPrincipalReturn |
yTDTotalReturn |
| decimal | 2899 | in_ytd_tot_return | PERFORMDBO | PERF_SEC_RETURNS | YTD_TOT_RETURN | NUMBER(28,12) | F2899 | 167 | EagleML/warehouseTransaction/warehousePerformance/yTDTotalReturn |
yTDTotalReturnNet |
| decimal | 2900 | in_ytd_tot_return_net | PERFORMDBO | PERF_SEC_RETURNS | YTD_TOT_RETURN_NET | NUMBER(28,12) | F2900 | 168 | EagleML/warehouseTransaction/warehousePerformance/yTDTotalReturnNet |
pSUserFloat1 |
| decimal | 3040 | in_ps_user_float1 | PERFORMDBO | PERF_SUMMARY | PS_USER_FLOAT1 | NUMBER(28,12) | F3040 |
| EagleML/warehouseTransaction/warehousePerformance/pSUserFloat1 |
pSRUserInt1 |
| decimal | 2799 | in_psr_user_int1 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_INT1 | NUMBER | F2799 | 97 | EagleML/warehouseTransaction/warehousePerformance/pSRUserInt1 |
psrUserChar1 |
| string | 9834 | in_psr_user_char1 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_CHAR1 | VARCHAR2(8) | F9834 | 89 | EagleML/warehouseTransaction/warehousePerformance/psrUserChar1 |
psrUserChar2 |
| string | 9835 | in_psr_user_char2 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_CHAR2 | VARCHAR2(8) | F9835 | 90 | EagleML/warehouseTransaction/warehousePerformance/psrUserChar2 |
pSRUserChar3 |
| string | 2001 | in_psr_user_char3 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_CHAR3 | VARCHAR2(8) | F2001 | 91 | EagleML/warehouseTransaction/warehousePerformance/pSRUserChar3 |
pSRUserChar4 |
| string | 2002 | in_psr_user_char4 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_CHAR4 | VARCHAR2(8) | F2002 | 92 | EagleML/warehouseTransaction/warehousePerformance/pSRUserChar4 |
pSRUserChar5 |
| string | 2003 | in_psr_user_char5 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_CHAR5 | VARCHAR2(8) | F2003 | 93 | EagleML/warehouseTransaction/warehousePerformance/pSRUserChar5 |
psrUserDate1 |
| date | 9863 | in_psr_user_date1 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_DATE1 | DATE | F9863 | 94 | EagleML/warehouseTransaction/warehousePerformance/psrUserDate1 |
psrUserDate2 |
| date | 9864 | in_psr_user_date2 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_DATE2 | DATE | F9864 | 95 | EagleML/warehouseTransaction/warehousePerformance/psrUserDate2 |
pSRUserDate3 |
| date | 3088 | in_psr_user_date3 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_DATE3 | DATE | F3088 | 96 | EagleML/warehouseTransaction/warehousePerformance/pSRUserDate3 |
psrUserFloat1 |
| decimal | 9828 | in_psr_user_float1 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT1 | NUMBER(28,12) | F9828 | 23 | EagleML/warehouseTransaction/warehousePerformance/psrUserFloat1 |
psrUserFloat2 |
| decimal | 9829 | in_psr_user_float2 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT2 | NUMBER(28,12) | F9829 | 24 | EagleML/warehouseTransaction/warehousePerformance/psrUserFloat2 |
psrUserFloat3 |
| decimal | 9830 | in_psr_user_float3 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT3 | NUMBER(28,12) | F9830 | 25 | EagleML/warehouseTransaction/warehousePerformance/psrUserFloat3 |
psrUserFloat4 |
| decimal | 9831 | in_psr_user_float4 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT4 | NUMBER(28,12) | F9831 | 26 | EagleML/warehouseTransaction/warehousePerformance/psrUserFloat4 |
psrUserFloat5 |
| decimal | 9832 | in_psr_user_float5 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT5 | NUMBER(28,12) | F9832 | 27 | EagleML/warehouseTransaction/warehousePerformance/psrUserFloat5 |
psrUserFloat6 |
| decimal | 9838 | in_psr_user_float6 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT6 | NUMBER(28,12) | F9838 | 28 | EagleML/warehouseTransaction/warehousePerformance/psrUserFloat6 |
psrUserFloat7 |
| decimal | 9839 | in_psr_user_float7 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT7 | NUMBER(28,12) | F9839 | 29 | EagleML/warehouseTransaction/warehousePerformance/psrUserFloat7 |
psrUserFloat8 |
| decimal | 9840 | in_psr_user_float8 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT8 | NUMBER(28,12) | F9840 | 30 | EagleML/warehouseTransaction/warehousePerformance/psrUserFloat8 |
psrUserFloat9 |
| decimal | 9841 | in_psr_user_float9 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT9 | NUMBER(28,12) | F9841 | 31 | EagleML/warehouseTransaction/warehousePerformance/psrUserFloat9 |
psrUserFloat10 |
| decimal | 9842 | in_psr_user_float10 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT10 | NUMBER(28,12) | F9842 | 32 | EagleML/warehouseTransaction/warehousePerformance/psrUserFloat10 |
pSRUserFloat11 |
| decimal | 2605 | in_psr_user_float11 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT11 | NUMBER(28,12) | F2605 | 33 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat11 |
pSRUserFloat12 |
| decimal | 2606 | in_psr_user_float12 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT12 | NUMBER(28,12) | F2606 | 34 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat12 |
pSRUserFloat13 |
| decimal | 2608 | in_psr_user_float13 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT13 | NUMBER(28,12) | F2608 | 35 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat13 |
pSRUserFloat14 |
| decimal | 2609 | in_psr_user_float14 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT14 | NUMBER(28,12) | F2609 | 36 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat14 |
pSRUserFloat15 |
| decimal | 2611 | in_psr_user_float15 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT15 | NUMBER(28,12) | F2611 | 37 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat15 |
pSRUserFloat16 |
| decimal | 2612 | in_psr_user_float16 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT16 | NUMBER(28,12) | F2612 | 38 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat16 |
pSRUserFloat17 |
| decimal | 2614 | in_psr_user_float17 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT17 | NUMBER(28,12) | F2614 | 39 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat17 |
pSRUserFloat18 |
| decimal | 2615 | in_psr_user_float18 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT18 | NUMBER(28,12) | F2615 | 40 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat18 |
pSRUserFloat19 |
| decimal | 2616 | in_psr_user_float19 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT19 | NUMBER(28,12) | F2616 | 41 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat19 |
pSRUserFloat20 |
| decimal | 2617 | in_psr_user_float20 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT20 | NUMBER(28,12) | F2617 | 42 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat20 |
pSRUserFloat21 |
| decimal | 2618 | in_psr_user_float21 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT21 | NUMBER(28,12) | F2618 | 43 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat21 |
pSRUserFloat22 |
| decimal | 2619 | in_psr_user_float22 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT22 | NUMBER(28,12) | F2619 | 44 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat22 |
pSRUserFloat23 |
| decimal | 2620 | in_psr_user_float23 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT23 | NUMBER(28,12) | F2620 | 45 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat23 |
pSRUserFloat24 |
| decimal | 2621 | in_psr_user_float24 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT24 | NUMBER(28,12) | F2621 | 46 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat24 |
pSRUserFloat25 |
| decimal | 2622 | in_psr_user_float25 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT25 | NUMBER(28,12) | F2622 | 47 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat25 |
pSRUserFloat26 |
| decimal | 2623 | in_psr_user_float26 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT26 | NUMBER(28,12) | F2623 | 48 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat26 |
pSRUserFloat27 |
| decimal | 2624 | in_psr_user_float27 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT27 | NUMBER(28,12) | F2624 | 49 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat27 |
pSRUserFloat28 |
| decimal | 2625 | in_psr_user_float28 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT28 | NUMBER(28,12) | F2625 | 50 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat28 |
pSRUserFloat29 |
| decimal | 2626 | in_psr_user_float29 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT29 | NUMBER(28,12) | F2626 | 51 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat29 |
pSRUserFloat30 |
| decimal | 2627 | in_psr_user_float30 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT30 | NUMBER(28,12) | F2627 | 52 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat30 |
pSRUserFloat31 |
| decimal | 2628 | in_psr_user_float31 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT31 | NUMBER(28,12) | F2628 | 53 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat31 |
pSRUserFloat32 |
| decimal | 2629 | in_psr_user_float32 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT32 | NUMBER(28,12) | F2629 | 54 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat32 |
pSRUserFloat33 |
| decimal | 2630 | in_psr_user_float33 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT33 | NUMBER(28,12) | F2630 | 55 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat33 |
pSRUserFloat34 |
| decimal | 2631 | in_psr_user_float34 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT34 | NUMBER(28,12) | F2631 | 56 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat34 |
pSRUserFloat35 |
| decimal | 2632 | in_psr_user_float35 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT35 | NUMBER(28,12) | F2632 | 57 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat35 |
pSRUserFloat36 |
| decimal | 2633 | in_psr_user_float36 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT36 | NUMBER(28,12) | F2633 | 58 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat36 |
pSRUserFloat37 |
| decimal | 2634 | in_psr_user_float37 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT37 | NUMBER(28,12) | F2634 | 59 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat37 |
pSRUserFloat38 |
| decimal | 2635 | in_psr_user_float38 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT38 | NUMBER(28,12) | F2635 | 60 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat38 |
pSRUserFloat39 |
| decimal | 2636 | in_psr_user_float39 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT39 | NUMBER(28,12) | F2636 | 61 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat39 |
pSRUserFloat40 |
| decimal | 2637 | in_psr_user_float40 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT40 | NUMBER(28,12) | F2637 | 62 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat40 |
pSRUserFloat41 |
| decimal | 2638 | in_psr_user_float41 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT41 | NUMBER(28,12) | F2638 | 63 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat41 |
pSRUserFloat42 |
| decimal | 2639 | in_psr_user_float42 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT42 | NUMBER(28,12) | F2639 | 64 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat42 |
pSRUserFloat43 |
| decimal | 2640 | in_psr_user_float43 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT43 | NUMBER(28,12) | F2640 | 65 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat43 |
pSRUserFloat44 |
| decimal | 2641 | in_psr_user_float44 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT44 | NUMBER(28,12) | F2641 | 66 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat44 |
pSRUserFloat45 |
| decimal | 2642 | in_psr_user_float45 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT45 | NUMBER(28,12) | F2642 | 67 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat45 |
pSRUserFloat46 |
| decimal | 2643 | in_psr_user_float46 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT46 | NUMBER(28,12) | F2643 | 68 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat46 |
pSRUserFloat47 |
| decimal | 2661 | in_psr_user_float47 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT47 | NUMBER(28,12) | F2661 | 69 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat47 |
pSRUserFloat48 |
| decimal | 2662 | in_psr_user_float48 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT48 | NUMBER(28,12) | F2662 | 70 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat48 |
pSRUserFloat49 |
| decimal | 2663 | in_psr_user_float49 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT49 | NUMBER(28,12) | F2663 | 71 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat49 |
pSRUserFloat50 |
| decimal | 2664 | in_psr_user_float50 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT50 | NUMBER(28,12) | F2664 | 72 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat50 |
pSRUserFloat51 |
| decimal | 2665 | in_psr_user_float51 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT51 | NUMBER(28,12) | F2665 | 73 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat51 |
pSRUserFloat52 |
| decimal | 2666 | in_psr_user_float52 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT52 | NUMBER(28,12) | F2666 | 74 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat52 |
pSRUserFloat53 |
| decimal | 2667 | in_psr_user_float53 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT53 | NUMBER(28,12) | F2667 | 75 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat53 |
pSRUserFloat54 |
| decimal | 2674 | in_psr_user_float54 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT54 | NUMBER(28,12) | F2674 | 76 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat54 |
pSRUserFloat55 |
| decimal | 2675 | in_psr_user_float55 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT55 | NUMBER(28,12) | F2675 | 77 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat55 |
pSRUserFloat56 |
| decimal | 2676 | in_psr_user_float56 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT56 | NUMBER(28,12) | F2676 | 78 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat56 |
pSRUserFloat57 |
| decimal | 2677 | in_psr_user_float57 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT57 | NUMBER(28,12) | F2677 | 79 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat57 |
pSRUserFloat58 |
| decimal | 2678 | in_psr_user_float58 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT58 | NUMBER(28,12) | F2678 | 80 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat58 |
pSRUserFloat59 |
| decimal | 2679 | in_psr_user_float59 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT59 | NUMBER(28,12) | F2679 | 81 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat59 |
pSRUserFloat60 |
| decimal | 2792 | in_psr_user_float60 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT60 | NUMBER(28,12) | F2792 | 82 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat60 |
pSRUserFloat61 |
| decimal | 2793 | in_psr_user_float61 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT61 | NUMBER(28,12) | F2793 | 83 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat61 |
pSRUserFloat62 |
| decimal | 2794 | in_psr_user_float62 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT62 | NUMBER(28,12) | F2794 | 84 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat62 |
pSRUserFloat63 |
| decimal | 2795 | in_psr_user_float63 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT63 | NUMBER(28,12) | F2795 | 85 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat63 |
pSRUserFloat64 |
| decimal | 2796 | in_psr_user_float64 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT64 | NUMBER(28,12) | F2796 | 86 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat64 |
pSRUserFloat65 |
| decimal | 2797 | in_psr_user_float65 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT65 | NUMBER(28,12) | F2797 | 87 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat65 |
pSRUserFloat66 |
| decimal | 2798 | in_psr_user_float66 | PERFORMDBO | PERF_SEC_RETURNS | PSR_USER_FLOAT66 | NUMBER(28,12) | F2798 | 88 | EagleML/warehouseTransaction/warehousePerformance/pSRUserFloat66 |
levelType |
| normalizedString |
|
| PERFORMDBO | PERF_SUMMARY | LEVEL_TYPE | CHAR(8) |
|
| EagleML/warehouseTransaction/warehousePerformance/levelType |
perfSummaryType |
| normalizedString |
|
| PERFORMDBO | PERF_SUMMARY | PERF_SUMMARY_TYPE | CHAR(2) |
|
| EagleML/warehouseTransaction/warehousePerformance/perfSummaryType |
perfSummaryId |
| integer |
|
| PERFORMDBO | PERF_SUMMARY | PERF_SUM_INST | NUMBER |
|
| EagleML/warehouseTransaction/warehousePerformance/perfSummaryId |
dictLevel2 |
| string |
| in_dl2_code | RULESDBO | DICTIONARY_DETAIL | DICT_L2_CODE_VALUE | CHAR(30) |
| 5 | EagleML/warehouseTransaction/warehousePerformance/dictLevel2 |
dictLevel3 |
| string |
| in_dl3_code | RULESDBO | DICTIONARY_DETAIL | DICT_L3_CODE_VALUE | CHAR(30) |
| 6 | EagleML/warehouseTransaction/warehousePerformance/dictLevel3 |
dictLevel4 |
| string |
| in_dl4_code | RULESDBO | DICTIONARY_DETAIL | DICT_L4_CODE_VALUE | CHAR(30) |
| 7 | EagleML/warehouseTransaction/warehousePerformance/dictLevel4 |
dictLevel5 |
| string |
| in_dl5_code | RULESDBO | DICTIONARY_DETAIL | DICT_L5_CODE_VALUE | CHAR(30) |
| 8 | EagleML/warehouseTransaction/warehousePerformance/dictLevel5 |
dictLevel6 |
| string |
| in_dl6_code | RULESDBO | DICTIONARY_DETAIL | DICT_L6_CODE_VALUE | CHAR(30) |
| 9 | EagleML/warehouseTransaction/warehousePerformance/dictLevel6 |
dictLevel7 |
| string |
| in_dl7_code | RULESDBO | DICTIONARY_DETAIL | DICT_L7_CODE_VALUE | CHAR(30) |
| 10 | EagleML/warehouseTransaction/warehousePerformance/dictLevel7 |
dictLevel8 |
| string |
| in_dl8_code | RULESDBO | DICTIONARY_DETAIL | DICT_L8_CODE_VALUE | CHAR(30) |
| 11 | EagleML/warehouseTransaction/warehousePerformance/dictLevel8 |
reloadFinalFlag |
| YesNoOptionEnum |
|
| not stored in DB |
|
|
| EagleML/warehouseTransaction/warehousePerformance/reloadFinalFlag | ||
psreUserFloat1 |
| decimal |
|
| PERFORMDBO | PERF_SEC_RETURNS_EXT | PSRE_USER_FLOAT1 |
|
|
| EagleML/warehouseTransaction/warehousePerformance/psreUserFloat1 |
psreUserFloat2 |
| decimal |
|
| PERFORMDBO | PERF_SEC_RETURNS_EXT | PSRE_USER_FLOAT2 |
|
|
| EagleML/warehouseTransaction/warehousePerformance/psreUserFloat2 |
psreUserFloat3 |
| decimal |
|
| PERFORMDBO | PERF_SEC_RETURNS_EXT | PSRE_USER_FLOAT3 |
|
|
| EagleML/warehouseTransaction/warehousePerformance/psreUserFloat3 |
psreUserFloat4 |
| decimal |
|
| PERFORMDBO | PERF_SEC_RETURNS_EXT | PSRE_USER_FLOAT4 |
|
|
| EagleML/warehouseTransaction/warehousePerformance/psreUserFloat4 |
psreUserFloat5 |
| decimal |
|
| PERFORMDBO | PERF_SEC_RETURNS_EXT | PSRE_USER_FLOAT5 |
|
|
| EagleML/warehouseTransaction/warehousePerformance/psreUserFloat5 |
netAssetValue |
| decimal |
|
| PERFORMDBO | PERF_SEC_RETURNS_EXT | NET_ASSET_VALUE |
|
|
| EagleML/warehouseTransaction/warehousePerformance/netAssetValue |
notionalMarketValue |
| decimal |
|
| PERFORMDBO | PERF_SEC_RETURNS_EXT | NOTIONAL_MARKET_VALUE |
|
|
| EagleML/warehouseTransaction/warehousePerformance/notionalMarketValue |
curveAnalytics | Curve Analytics Model - see extra data map table Please note, that to extract this model you need IncludeCurveAnalytics task parameter set to Y in your RTR for extract
| EagleML/warehouseTransaction/warehousePerformance/curveAnalytics/ | |||||||||
liquidity | Liquidity Model - see extra data map table | EagleML/warehouseTransaction/warehousePerformance/liquidity/ | |||||||||
sectorAnalytics | Sector Analytics Model - see extra data map table | EagleML/warehouseTransaction/warehousePerformance/sectorAnalytics/ | |||||||||