IssuePrice Data Map Table

Element

Optional/Required

Value Type

Star Tag

SP Parameter

SP Type

Eagle DB

DB Table

DB Field

DB Field Type

XPath

Element

Optional/Required

Value Type

Star Tag

SP Parameter

SP Type

Eagle DB

DB Table

DB Field

DB Field Type

XPath

objectType

Optional

ObjectTypeEnum

 

 

 

not stored in DB

 

EagleML/referenceTransaction/issuePrice/objectType

objectId

Optional

ObjectId

 

 

 

not stored in DB

 

EagleML/referenceTransaction/issuePrice/objectId

objectDescription

Optional

FeedTypeEnum

 

 

 

not stored in DB

 

EagleML/referenceTransaction/issuePrice/objectDescription

updateTimestamp

Optional

dateTime

 

 

 

SECURITYDBO

PRICE

UPDATE_DATE

DATE

EagleML/referenceTransaction/issuePrice/updateTimestamp

customElements

Not recommended

CustomElements

 

 

 

CustomElements reserved for customizations

EagleML/referenceTransaction/issuePrice/customElements

sourceName

Optional

string

1102

in_short_desc

S

PACE_MASTERDBO

INTERFACES

SHORT_DESC

CHAR(15)

EagleML/referenceTransaction/issuePrice/sourceName

updateSource

Optional

string

944

in_upd_src

S

SECURITYDBO

PRICE

UPDATE_SOURCE

VARCHAR2(255)

EagleML/referenceTransaction/issuePrice/updateSource

effectiveDate

Optional

date

1109

in_eff_dt

S

SECURITYDBO

PRICE

EFFECTIVE_DATE

DATE

EagleML/referenceTransaction/issuePrice/effectiveDate

languageId

Optional

integer

 

 

 

not stored in DB

 

EagleML/referenceTransaction/issuePrice/languageId

tagNochangecase

Optional

string

 

 

 

not stored in DB

 

EagleML/referenceTransaction/issuePrice/tagNochangecase

preserveNull

Optional

string

 

 

 

not stored in DB

 

EagleML/referenceTransaction/issuePrice/preserveNull

noLoadValidationFlag

Optional

YesNoOptionEnum

 

 

 

not stored in DB

 

EagleML/referenceTransaction/issuePrice/noLoadValidationFlag

accountingValidationFlag

Optional

YesNoOptionEnum

 

 

 

not stored in DB

 

EagleML/referenceTransaction/issuePrice/accountingValidationFlag

Asset Identifiers Model

EagleML/referenceTransaction/issuePrice/

exceptionProcessingSwitch

Optional

YesNoOptionEnum

 

 

 

not stored in DB

 

EagleML/referenceTransaction/issuePrice/exceptionProcessingSwitch

valuePositionsAtCostSwitch

Optional

YesNoOptionEnum

 

 

 

not stored in DB

 

EagleML/referenceTransaction/issuePrice/valuePositionsAtCostSwitch

closingPrice

Optional

decimal

481

in_price

I

SECURITYDBO

PRICE

PRICE

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/closingPrice

oidYield

Optional

decimal

39

in_yld

I

SECURITYDBO

PRICE

YIELD

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/oidYield

yieldType

Optional

string

1113

in_yld_type

S

SECURITYDBO

PRICE

YIELD_TYPE_CODE

CHAR(8)

EagleML/referenceTransaction/issuePrice/yieldType

priceTypeCode

Optional

normalizedString

1843

in_price_type_code

S

SECURITYDBO

PRICE

PRICE_TYPE_CODE

VARCHAR2(15)

EagleML/referenceTransaction/issuePrice/priceTypeCode

priceFlag

Optional

string

1844

in_price_flag

S

SECURITYDBO

PRICE

PRICING_FLAG

CHAR(2)

EagleML/referenceTransaction/issuePrice/priceFlag

lastTradedPrice

Optional

decimal

1845

in_px_last

I

SECURITYDBO

PRICE

PX_LAST

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/lastTradedPrice

bidPrice

Optional

decimal

1846

in_px_bid

I

SECURITYDBO

PRICE

PX_BID

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/bidPrice

askPrice

Optional

decimal

1847

in_px_ask

I

SECURITYDBO

PRICE

PX_ASK

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/askPrice

highPrice

Optional

decimal

1848

in_px_high

I

SECURITYDBO

PRICE

PX_HIGH

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/highPrice

lowPrice

Optional

decimal

1849

in_px_low

I

SECURITYDBO

PRICE

PX_LOW

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/lowPrice

midPrice

Optional

decimal

1850

in_px_mid

I

SECURITYDBO

PRICE

PX_MID

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/midPrice

priceVolume

Optional

decimal

1851

in_px_volume

I

SECURITYDBO

PRICE

PX_VOLUME

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/priceVolume

priceLevel

Optional

integer

12007

in_price_level

I

SECURITYDBO

PRICE

PRICE_LEVEL

NUMBER(38)

EagleML/referenceTransaction/issuePrice/priceLevel

priceCondition

Optional

string

4849

in_price_condition

S

SECURITYDBO

PRICE

PRICE_CONDITION

VARCHAR2(20)

EagleML/referenceTransaction/issuePrice/priceCondition

originalPrice

Optional

decimal

893

in_original_price

I

SECURITYDBO

PRICE

ORIGINAL_PRICE

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/originalPrice

units

Optional

decimal

40

in_units

I

SECURITYDBO

PRICE

UNITS

NUMBER(38,12)

EagleML/referenceTransaction/issuePrice/units

referencePrice

Optional

decimal

1852

in_px_reference

I

SECURITYDBO

PRICE

PX_REFERENCE

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/referencePrice

priceSource

Optional

string

513

in_src

S

SECURITYDBO

PRICE

PX_SOURCE

CHAR(8)

EagleML/referenceTransaction/issuePrice/priceSource

priceTolerance

Optional

decimal

 

 

 

not stored in DB 

 

EagleML/referenceTransaction/issuePrice/priceTolerance

calculatedMean

Optional

decimal

11847

in_calculated_mean

I

SECURITYDBO

PRICE

CALCULATED_MEAN

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/calculatedMean

fairValueFactor

Optional

decimal

10813

in_fair_value_factor

I

SECURITYDBO

PRICE

FAIR_VALUE_FACTOR

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/fairValueFactor

dirtyPrice

Optional

decimal

2895

in_px_dirty

I

SECURITYDBO

PRICE

PX_DIRTY

NUMBER(38,12)

EagleML/referenceTransaction/issuePrice/dirtyPrice

cleanPriceInclOption

Optional

decimal

 

 

 

not stored in DB

 

EagleML/referenceTransaction/issuePrice/cleanPriceInclOption

nominalDirtyPrice

Optional

decimal

2896

in_px_nominal_dirty

I

SECURITYDBO

PRICE

PX_NOMINAL_DIRTY

NUMBER(38,12)

EagleML/referenceTransaction/issuePrice/nominalDirtyPrice

cleanInclOptionPrice

Optional

decimal

2897

in_px_clean_incl_option

I

SECURITYDBO

PRICE

PX_CLEAN_INCL_OPTION

NUMBER(38,12)

EagleML/referenceTransaction/issuePrice/cleanInclOptionPrice

dirtyInclOptionPrice

Optional

decimal

2898

in_px_dirty_incl_option

I

SECURITYDBO

PRICE

PX_DIRTY_INCL_OPTION

NUMBER(38,12)

EagleML/referenceTransaction/issuePrice/dirtyInclOptionPrice

cleanExclOptionPrice

Optional

decimal

2899

in_px_clean_excl_option

I

SECURITYDBO

PRICE

PX_CLEAN_EXCL_OPTION

NUMBER(38,12)

EagleML/referenceTransaction/issuePrice/cleanExclOptionPrice

dirtyExclOptionPrice

Optional

decimal

2900

in_px_dirty_excl_option

I

SECURITYDBO

PRICE

PX_DIRTY_EXCL_OPTION

NUMBER(38,12)

EagleML/referenceTransaction/issuePrice/dirtyExclOptionPrice

callOptionPrice

Optional

decimal

2901

in_px_call_option

I

SECURITYDBO

PRICE

PX_CALL_OPTION

NUMBER(38,12)

EagleML/referenceTransaction/issuePrice/callOptionPrice

putOptionPrice

Optional

decimal

8548

in_px_put_option

I

SECURITYDBO

PRICE

PX_PUT_OPTION (DB v13.1 or newer)

NUMBER(38,12)

EagleML/referenceTransaction/issuePrice/putOptionPrice

fairValuePrice

Optional

decimal

2902

in_fair_value_price

I

SECURITYDBO

PRICE

FAIR_VALUE_PRICE

NUMBER(38,12)

EagleML/referenceTransaction/issuePrice/fairValuePrice

fairValueInclAccrued

Optional

decimal

2903

in_fair_value_incl_accrued

I

SECURITYDBO

PRICE

FAIR_VALUE_INCL_ACCRUED

NUMBER(38,12)

EagleML/referenceTransaction/issuePrice/fairValueInclAccrued

averagePrice

Optional

decimal

5595

in_px_average

I

SECURITYDBO

PRICE

PX_AVERAGE

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/averagePrice

fixingPrice

Optional

decimal

5596

in_px_fixing

I

SECURITYDBO

PRICE

PX_FIXING

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/fixingPrice

grossAskPrice

Optional

decimal

5597

in_px_gross_ask

I

SECURITYDBO

PRICE

PX_GROSS_ASK

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/grossAskPrice

grossBidPrice

Optional

decimal

5598

in_px_gross_bid

I

SECURITYDBO

PRICE

PX_GROSS_BID

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/grossBidPrice

grossMidPrice

Optional

decimal

5599

in_px_gross_mid

I

SECURITYDBO

PRICE

PX_GROSS_MID

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/grossMidPrice

histClosePrice

Optional

decimal

5600

in_px_hist_close

I

SECURITYDBO

PRICE

PX_HIST_CLOSE

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/histClosePrice

midClosePrice

Optional

decimal

5602

in_px_mid_close

I

SECURITYDBO

PRICE

PX_MID_CLOSE

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/midClosePrice

meanPrice

Optional

decimal

10427

in_px_mean

I

SECURITYDBO

PRICE

PX_MEAN

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/meanPrice

nominalPrice

Optional

decimal

5603

in_px_nominal

I

SECURITYDBO

PRICE

PX_NOMINAL

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/nominalPrice

officialClosePrice

Optional

decimal

5604

in_px_official_close

I

SECURITYDBO

PRICE

PX_OFFICIAL_CLOSE

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/officialClosePrice

openPrice

Optional

decimal

5605

in_px_open

I

SECURITYDBO

PRICE

PX_OPEN

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/openPrice

sarulePrice

Optional

decimal

5606

in_px_sarule

I

SECURITYDBO

PRICE

PX_SARULE

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/sarulePrice

vwapClosePrice

Optional

decimal

5607

in_px_vwap_close

I

SECURITYDBO

PRICE

PX_VWAP_CLOSE

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/vwapClosePrice

reinvestDate

Optional

date

5608

in_reinvest_date

S

SECURITYDBO

PRICE

REINVEST_DATE

DATE

EagleML/referenceTransaction/issuePrice/reinvestDate

shsUsedForEarningsComp

Optional

decimal

5609

in_shs_used_for_earnings_comp

I

SECURITYDBO

PRICE

SHS_USED_FOR_EARNINGS_COMP

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/shsUsedForEarningsComp

shsUsedForOwnershipComp

Optional

decimal

5610

in_shs_used_for_ownership_comp

I

SECURITYDBO

PRICE

SHS_USED_FOR_OWNERSHIP_COMP

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/shsUsedForOwnershipComp

status

Optional

string

5614

in_status

S

SECURITYDBO

PRICE

STATUS

VARCHAR2(25)

EagleML/referenceTransaction/issuePrice/status

stcgDist

Optional

decimal

5615

in_stcg_dist

I

SECURITYDBO

PRICE

STCG_DIST

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/stcgDist

subsidyRatio

Optional

decimal

5616

in_subsidy_ratio

I

SECURITYDBO

PRICE

SUBSIDY_RATIO

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/subsidyRatio

totalDist

Optional

decimal

5617

in_total_dist

I

SECURITYDBO

PRICE

TOTAL_DIST

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/totalDist

askAdrPrice

Optional

decimal

10424

in_px_ask_adr

I

SECURITYDBO

PRICE

PX_ASK_ADR

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/askAdrPrice

bidAdrPrice

Optional

decimal

10425

in_px_bid_adr

I

SECURITYDBO

PRICE

PX_BID_ADR

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/bidAdrPrice

lastAdrPrice

Optional

decimal

10426

in_px_last_adr

I

SECURITYDBO

PRICE

PX_LAST_ADR

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/lastAdrPrice

priceLastUpdateDate

Optional

date

5601

in_px_last_update_date

S

SECURITYDBO

PRICE

PX_LAST_UPDATE_DATE

DATE

EagleML/referenceTransaction/issuePrice/priceLastUpdateDate

basis

Optional

decimal

5581

in_basis

I

SECURITYDBO

PRICE

BASIS

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/basis

bestRuleName

Optional

string

5582

in_best_rule_name

S

SECURITYDBO

PRICE

BEST_RULE_NAME

VARCHAR2(15)

EagleML/referenceTransaction/issuePrice/bestRuleName

expenseRatio

Optional

decimal

5583

in_expense_ratio

I

SECURITYDBO

PRICE

EXPENSE_RATIO

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/expenseRatio

incomeDist

Optional

decimal

5584

in_income_dist

I

SECURITYDBO

PRICE

INCOME_DIST

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/incomeDist

lastUpdateDate

Optional

date

5585

in_last_update_date

S

SECURITYDBO

PRICE

LAST_UPDATE_DATE

DATE

EagleML/referenceTransaction/issuePrice/lastUpdateDate

lastUpdatePrice

Optional

decimal

5586

in_last_update_price

I

SECURITYDBO

PRICE

LAST_UPDATE_PRICE

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/lastUpdatePrice

lastUpdateSource

Optional

string

5587

in_last_update_source

S

SECURITYDBO

PRICE

LAST_UPDATE_SOURCE

VARCHAR2(20)

EagleML/referenceTransaction/issuePrice/lastUpdateSource

lastUpdateTime

Optional

string

5588

in_last_update_time

S

SECURITYDBO

PRICE

LAST_UPDATE_TIME

CHAR(8)

EagleML/referenceTransaction/issuePrice/lastUpdateTime

ltcgDist

Optional

decimal

5589

in_ltcg_dist

I

SECURITYDBO

PRICE

LTCG_DIST

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/ltcgDist

mtcgDist

Optional

decimal

5590

in_mtcg_dist

I

SECURITYDBO

PRICE

MTCG_DIST

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/mtcgDist

naicPrice

Optional

decimal

5591

in_naic_price

I

SECURITYDBO

PRICE

NAIC_PRICE

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/naicPrice

navCurrent

Optional

decimal

5592

in_nav_current

I

SECURITYDBO

PRICE

NAV_CURRENT

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/navCurrent

navReinvest

Optional

decimal

5593

in_nav_reinvest

I

SECURITYDBO

PRICE

NAV_REINVEST

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/navReinvest

otherDist

Optional

decimal

5594

in_other_dist

I

SECURITYDBO

PRICE

OTHER_DIST

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/otherDist

stkdivFlag

Optional

string

10428

in_stkdiv_flag

S

SECURITYDBO

PRICE

STKDIV_FLAG

VARCHAR2(8)

EagleML/referenceTransaction/issuePrice/stkdivFlag

stkspltFlag

Optional

string

10429

in_stksplt_flag

S

SECURITYDBO

PRICE

STKSPLT_FLAG

VARCHAR2(8)

EagleML/referenceTransaction/issuePrice/stkspltFlag

preFvPrice

Optional

decimal

2502

in_pre_fv_price

I

SECURITYDBO

PRICE

PRE_FV_PRICE

NUMBER(38,12)

EagleML/referenceTransaction/issuePrice/preFvPrice

marketDate

Optional

string

2410

in_market_date

S

SECURITYDBO

PRICE

MARKET_DATE

DATE

EagleML/referenceTransaction/issuePrice/marketDate

userDate1

Optional

date

5618

in_user_date1

S

SECURITYDBO

PRICE

USER_DATE1

DATE

EagleML/referenceTransaction/issuePrice/userDate1

userDate2

Optional

date

5619

in_user_date2

S

SECURITYDBO

PRICE

USER_DATE2

DATE

EagleML/referenceTransaction/issuePrice/userDate2

userDate3

Optional

date

5620

in_user_date3

S

SECURITYDBO

PRICE

USER_DATE3

DATE

EagleML/referenceTransaction/issuePrice/userDate3

userFee1

Optional

decimal

5621

in_user_fee1

I

SECURITYDBO

PRICE

USER_FEE1

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/userFee1

userFee2

Optional

decimal

5622

in_user_fee2

I

SECURITYDBO

PRICE

USER_FEE2

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/userFee2

userFee3

Optional

decimal

5623

in_user_fee3

I

SECURITYDBO

PRICE

USER_FEE3

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/userFee3

userNav1

Optional

decimal

5624

in_user_nav1

I

SECURITYDBO

PRICE

USER_NAV1

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/userNav1

userNav2

Optional

decimal

5625

in_user_nav2

I

SECURITYDBO

PRICE

USER_NAV2

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/userNav2

userNav3

Optional

decimal

5626

in_user_nav3

I

SECURITYDBO

PRICE

USER_NAV3

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/userNav3

userNav4

Optional

decimal

5627

in_user_nav4

I

SECURITYDBO

PRICE

USER_NAV4

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/userNav4

userNav5

Optional

decimal

5628

in_user_nav5

I

SECURITYDBO

PRICE

USER_NAV5

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/userNav5

sourceDetail

Optional

string

2503

in_source_detail

S

SECURITYDBO

PRICE

SOURCE_DETAIL

VARCHAR2(255)

EagleML/referenceTransaction/issuePrice/sourceDetail

sourceFieldName

Optional

string

5611

in_source_field_name

S

SECURITYDBO

PRICE

SOURCE_FIELD_NAME

CHAR(30)

EagleML/referenceTransaction/issuePrice/sourceFieldName

sourceLevel

Optional

decimal

5612

in_source_level

I

SECURITYDBO

PRICE

SOURCE_LEVEL

NUMBER

EagleML/referenceTransaction/issuePrice/sourceLevel

sourceSrcIntfcName

Optional

string

5613

in_source_src_intfc_name

S

SECURITYDBO

PRICE

SOURCE_SRC_INTFC_NAME

CHAR(15)

EagleML/referenceTransaction/issuePrice/sourceSrcIntfcName

sourceSrcIntfcInst

Optional

integer

4855

in_source_src_intfc_inst

I

SECURITYDBO

PRICE

SOURCE_SRC_INTFC_INST

NUMBER(38)

EagleML/referenceTransaction/issuePrice/sourceSrcIntfcInst

priceCurrency

Optional

string

85

in_curr

S

SECURITYDBO

PRICE

PRICE_CURRENCY

CHAR(8)

EagleML/referenceTransaction/issuePrice/priceCurrency

percentChange1m

Optional

decimal

18434

in_percent_change_1m

I

SECURITYDBO

PRICE

PERCENT_CHANGE_1M

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/percentChange1m

percentChange3m

Optional

decimal

18435

in_percent_change_3m

I

SECURITYDBO

PRICE

PERCENT_CHANGE_3M

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/percentChange3m

percentChange6m

Optional

decimal

18436

in_percent_change_6m

I

SECURITYDBO

PRICE

PERCENT_CHANGE_6M

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/percentChange6m

percentChange1yr

Optional

decimal

18437

in_percent_change_1yr

I

SECURITYDBO

PRICE

PERCENT_CHANGE_1YR

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/percentChange1yr

percentChangeWtd

Optional

decimal

18438

in_percent_change_wtd

I

SECURITYDBO

PRICE

PERCENT_CHANGE_WTD

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/percentChangeWtd

percentChangeMtd

Optional

decimal

18439

in_percent_change_mtd

I

SECURITYDBO

PRICE

PERCENT_CHANGE_MTD

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/percentChangeMtd

percentChangeQtd

Optional

decimal

18440

in_percent_change_qtd

I

SECURITYDBO

PRICE

PERCENT_CHANGE_QTD

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/percentChangeQtd

percentChangeYtd

Optional

decimal

18441

in_percent_change_ytd

I

SECURITYDBO

PRICE

PERCENT_CHANGE_YTD

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/percentChangeYtd

pxDirtyClean

Optional

string

18442

in_px_dirty_clean

S

SECURITYDBO

PRICE

PX_DIRTY_CLEAN

VARCHAR2(255)

EagleML/referenceTransaction/issuePrice/pxDirtyClean

pxSettle

Optional

decimal

18443

in_px_settle

I

SECURITYDBO

PRICE

PX_SETTLE

NUMBER(28,12)

EagleML/referenceTransaction/issuePrice/pxSettle

pxSettleLastDate

Optional

date

18444

in_px_settle_last_date

S

SECURITYDBO

PRICE

PX_SETTLE_LAST_DATE

DATE

EagleML/referenceTransaction/issuePrice/pxSettleLastDate

quotedSpec

Optional

string

18445

in_quoted_spec

S

SECURITYDBO

PRICE

QUOTED_SPEC

VARCHAR2(255)

EagleML/referenceTransaction/issuePrice/quotedSpec

settlementType

Optional

string

18446

in_settlement_type

S

SECURITYDBO

PRICE

SETTLEMENT_TYPE

VARCHAR2(255)

EagleML/referenceTransaction/issuePrice/settlementType

confidenceInterval

Optional

decimal

10957

in_confidence_interval

I

SECURITYDBO

PRICE

CONFIDENCE_INTERVAL

NUMBER(38,12)

EagleML/referenceTransaction/issuePrice/confidenceInterval

bloombergAskPriceScore

Optional

decimal

18348

in_ask_score

I

SECURITYDBO

PRICE

ASK_SCORE

NUMBER(38,12)

EagleML/referenceTransaction/issuePrice/bloombergAskPriceScore

bloombergBidPriceScore

Optional

decimal

18349

in_bid_score

I

SECURITYDBO

PRICE

BID_SCORE

NUMBER(38,12)

EagleML/referenceTransaction/issuePrice/bloombergBidPriceScore

bloombergMidPriceScore

Optional

decimal

18350

in_mid_score

I

SECURITYDBO

PRICE

MID_SCORE

NUMBER(38,12)

EagleML/referenceTransaction/issuePrice/bloombergMidPriceScore

bloombergQuoteCode

Optional

decimal

10381

in_quote_type

I

SECURITYDBO

PRICE

QUOTE_TYPE

NUMBER(38,12)

EagleML/referenceTransaction/issuePrice/bloombergQuoteCode

pricingEntityId

Optional

string

7107

in_entity_id

S

SECURITYDBO

PRICE

ENTITY_ID

CHAR(8)

EagleML/referenceTransaction/issuePrice/pricingEntityId

priceConversionFxRate

Optional

decimal

7682

in_price_conversion_fx_rate

I

SECURITYDBO

PRICE

PRICE_CONVERSION_FX_RATE

NUMBER(38,12)

EagleML/referenceTransaction/issuePrice/priceConversionFxRate

priceConversionFxSource

Optional

string

7108

in_price_conv_fx_source

S

SECURITYDBO

PRICE

PRICE_CONV_FX_SOURCE

VARCHAR2(15)

EagleML/referenceTransaction/issuePrice/priceConversionFxSource

pxYest

Optional

decimal

7728

in_px_yest

I

SECURITYDBO

PRICE

PX_YEST

NUMBER(38,12)

EagleML/referenceTransaction/issuePrice/pxYest

payRecIndicator

Optional

string

4590

 

S

SECURITYDBO

SWAPS

PAY_RECEIVE_IND

VARCHAR2(10)

EagleML/referenceTransaction/issuePrice/payRecIndicator

payPriceLeg

Pay Price Leg Model

EagleML/referenceTransaction/issuePrice/payPriceLeg

receivePriceLeg

Receive Price Leg Model

EagleML/referenceTransaction/issuePrice/receivePriceLeg

Pay Price Leg Model

notionalAmount

Optional

decimal

7683

in_pay_leg_notional

I

SECURITYDBO

PRICE

PAY_LEG_NOTIONAL

NUMBER(38,12)

../notionalAmount

price

Optional

decimal

7680

in_pay_leg_price_or_mv

I

SECURITYDBO

PRICE

PAY_LEG_PRICE_OR_MV

NUMBER(38,12)

../price

marketValue

Optional

decimal

7680

in_pay_leg_price_or_mv

I

SECURITYDBO

PRICE

PAY_LEG_PRICE_OR_MV

NUMBER(38,12)

../marketValue

Receive Price Leg Model

notionalAmount

Optional

decimal

7684

in_rec_leg_notional

I

SECURITYDBO

PRICE

REC_LEG_NOTIONAL

NUMBER(38,12)

../notionalAmount

price

Optional

decimal

7681

in_rec_leg_price_or_mv

I

SECURITYDBO

PRICE

REC_LEG_PRICE_OR_MV

NUMBER(38,12)

../price

marketValue

Optional

decimal

7681

in_rec_leg_price_or_mv

I

SECURITYDBO

PRICE

REC_LEG_PRICE_OR_MV

NUMBER(38,12)

../marketValue