Warehouse Performance Data Map Table

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

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

Entity Common Id Model

EagleML/warehouseTransaction/warehousePerformance/

Entity Properties Model (extract only)

EagleML/warehouseTransaction/warehousePerformance/

accountingBasis

 

string

21

 

not stored in DB

 

F21

 

EagleML/warehouseTransaction/warehousePerformance/accountingBasis

Asset Identifiers Model

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

dictionaryName

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

dictionaryId

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/

Â