Yield Curve Data Map Table

Element

Optional/Required

Value Type

Star Tag

Eagle DB

DB Table

DB Field

DB Field Type

XPATH

Element

Optional/Required

Value Type

Star Tag

Eagle DB

DB Table

DB Field

DB Field Type

XPATH

objectType

Optional

ObjectTypeEnum

 

not stored in DB

 

EagleML/referenceTransaction/yieldCurve/objectType

objectId

Optional

ObjectId

 

not stored in DB

 

EagleML/referenceTransaction/yieldCurve/objectId

objectDescription

Optional

FeedTypeEnum

 

not stored in DB

 

EagleML/referenceTransaction/yieldCurve/objectDescription

updateTimestamp

Optional

dateTime

 

 

 

 

 

EagleML/referenceTransaction/yieldCurve/updateTimestamp

customElements

Not recommended

CustomElements -  ComplexType

 

 

 

 

 

EagleML/referenceTransaction/yieldCurve/customElements

sourceName

Required

string

1102

not stored in DB

 

EagleML/referenceTransaction/yieldCurve/sourceName

updateSource

Required

string

944

SECURITYDBO

YIELD_CURVE

UPDATE_SOURCE

 

EagleML/referenceTransaction/yieldCurve/updateSource

effectiveDate

Required

date

1109

SECURITYDBO

YIELD_CURVE

EFFECTIVE_DATE

DATE(7)

EagleML/referenceTransaction/yieldCurve/effectiveDate

languageId

Optional

integer

 

not stored in DB 

 

EagleML/referenceTransaction/yieldCurve/languageId

tagNochangecase

Optional

string

4637

not stored in DB

 

EagleML/referenceTransaction/yieldCurve/tagNochangecase

preserveNull

Optional

string

5284

not stored in DB

 

EagleML/referenceTransaction/yieldCurve/preserveNull

noLoadValidationFlag

Optional

YesNoOptionEnum

 

not stored in DB

 

EagleML/referenceTransaction/yieldCurve/noLoadValidationFlag

yieldCurveCode

Required

string

 

SECURITYDBO

YIELD_CURVE

YIELD_CURVE_CODE

VARCHAR2(20)

EagleML/referenceTransaction/yieldCurve/yieldCurveCode

duration

Required

decimal

 

SECURITYDBO

YIELD_CURVE_DETAIL

PAR_DURATION

NUMBER(28,16)

EagleML/referenceTransaction/yieldCurve/duration

parYield

Optional

decimal

 

SECURITYDBO

YIELD_CURVE_DETAIL

PAR_YIELD

NUMBER(28,16)

EagleML/referenceTransaction/yieldCurve/parYield

maturityDate

Optional

date

38

SECURITYDBO

YIELD_CURVE_DETAIL

MAT_DATE

DATE(7)

EagleML/referenceTransaction/yieldCurve/maturityDate

Â