Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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 version 13v13.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

percentChange1mOptionaldecimal

ISECURITYDBOPRICEPERCENT_CHANGE_1M
EagleML/referenceTransaction/issuePrice/percentChange1m
percentChange3mOptionaldecimal

ISECURITYDBOPRICEPERCENT_CHANGE_3M
EagleML/referenceTransaction/issuePrice/percentChange3m
percentChange6mOptionaldecimal

ISECURITYDBOPRICEPERCENT_CHANGE_6M
EagleML/referenceTransaction/issuePrice/percentChange6m
percentChange1yrOptionaldecimal

ISECURITYDBOPRICEPERCENT_CHANGE_1YR
EagleML/referenceTransaction/issuePrice/percentChange1yr
percentChangeWtdOptionaldecimal

ISECURITYDBOPRICEPERCENT_CHANGE_WTD
EagleML/referenceTransaction/issuePrice/percentChangeWtd
percentChangeMtdOptionaldecimal

ISECURITYDBOPRICEPERCENT_CHANGE_MTD
EagleML/referenceTransaction/issuePrice/percentChangeMtd
percentChangeQtdOptionaldecimal

ISECURITYDBOPRICEPERCENT_CHANGE_QTD
EagleML/referenceTransaction/issuePrice/percentChangeQtd
percentChangeYtdOptionaldecimal

ISECURITYDBOPRICEPERCENT_CHANGE_YTD
EagleML/referenceTransaction/issuePrice/percentChangeYtd
pxDirtyCleanOptionalstring

SSECURITYDBOPRICEPX_DIRTY_CLEANVARCHAR2(255)EagleML/referenceTransaction/issuePrice/pxDirtyClean
pxSettleOptionaldecimal

ISECURITYDBOPRICEPX_SETTLE
EagleML/referenceTransaction/issuePrice/pxSettle
pxSettleLastDateOptionaldate

SSECURITYDBOPRICEPX_SETTLE_LAST_DATEDATEEagleML/referenceTransaction/issuePrice/pxSettleLastDate
quotedSpecOptionalstring

SSECURITYDBOPRICEQUOTED_SPECVARCHAR2(255)EagleML/referenceTransaction/issuePrice/quotedSpec
settlementTypeOptionalstring

SSECURITYDBOPRICESETTLEMENT_TYPE
EagleML/referenceTransaction/issuePrice/settlementType

...