Caps & Floors Data Map Table

Element

Required Inbound Acct Validation

Required Inbound Data Mgt

Value Type

Star Tag

SP Parameter

SP Type

Include File Name

Eagle DB

DB Table

DB Field

DB Field Type

Xpath

Element

Required Inbound Acct Validation

Required Inbound Data Mgt

Value Type

Star Tag

SP Parameter

SP Type

Include File Name

Eagle DB

DB Table

DB Field

DB Field Type

Xpath

objectType

Required

 

ObjectTypeEnum

-

 

 

 

not stored in DB

 

EagleML/referenceTransaction/genericSMF/objectType

objectId

 

 

ObjectId

-

 

 

 

not stored in DB

 

EagleML/referenceTransaction/genericSMF/objectId

objectDescription

 

 

FeedTypeEnum

-

 

 

 

not stored in DB

 

EagleML/referenceTransaction/genericSMF/objectDescription

updateTimestamp

 

 

dateTime

-

 

 

 

not stored in DB

 

EagleML/referenceTransaction/genericSMF/updateTimestamp

sourceName

Required

Required

string

1102

in_short_desc

S

referenceobject.inc

PACE_MASTERDBO

INTERFACES

SHORT_DESC

CHAR(15)

EagleML/referenceTransaction/genericSMF/sourceName

updateSource

Required

Required

string

944

in_update_source

S

referenceobject.inc

SECURITYDBO

SECURITY_MASTER

UPDATE_SOURCE

CHAR(255)

EagleML/referenceTransaction/genericSMF/updateSource

effectiveDate

Required

Required

date

1109

in_effective_date

S

referenceobject.inc

SECURITYDBO

All history (_HIST) tables

EFFECTIVE_DATE

DATE

EagleML/referenceTransaction/genericSMF/effectiveDate

accountingValidationFlag

Required

 

YesNoOptionEnum

 

 

 

 

not stored in DB, used to manage the download logic

 

EagleML/referenceTransaction/genericSMF/accountingValidationFlag

Asset Identifiers Model

EagleML/referenceTransaction/genericSMF/

investmentType

Required

Required

StringWithCodeScheme

11

in_investment_type

S

smfobject.inc

SECURITYDBO

SECURITY_MASTER

INVESTMENT_TYPE

CHAR(4)

EagleML/referenceTransaction/genericSMF/investmentType

processingSecurityType

Required

Required

StringWithCodeScheme

3931

in_process_sec_type

S

smfobject.inc

SECURITYDBO

SECURITY_MASTER

PROCESS_SEC_TYPE

VARCHAR2(15)

EagleML/referenceTransaction/genericSMF/processingSecurityType

settlementCurrency

Required - Defaulted to "Asset Currency" by panel

 

CurrencyCode

63

in_settlement_currency

S

smfobject.inc

SECURITYDBO

SECURITY_MASTER

SETTLEMENT_CURRENCY

CHAR(3)

EagleML/referenceTransaction/genericSMF/settlementCurrency

incomeCurrency

Required - Defaulted to "Asset Currency" by panel

 

CurrencyCode

1186

in_sm_income_currency

S

smfobject.inc

SECURITYDBO

SECURITY_MASTER

INCOME_CURRENCY

CHAR(3)

EagleML/referenceTransaction/genericSMF/incomeCurrency

issueCountryCode

Required

 

CountryCode

1418

in_nra_tax_country

S

smfobject.inc

SECURITYDBO

SECURITY_MASTER

NRA_TAX_COUNTRY

CHAR(30)

EagleML/referenceTransaction/genericSMF/issueCountryCode

strikeRate

Required

 

decimal

11850

in_strike_rate

N

generic_smf_base_model.inc

SECURITYDBO

DERIVATIVES

STRIKE_RATE

NUMBER(28,12)

EagleML/referenceTransaction/genericSMF/strikeRate

maturityDate

Required

 

date

38

in_mat_date

S

fixedincomesmf_model.inc

SECURITYDBO

SECURITY_MASTER

MAT_DATE

DATE

EagleML/referenceTransaction/genericSMF/maturityDate

FixedIncomeModel

 

 

FixedIncomeModel

Fixed Income Model

 

EagleML/referenceTransaction/genericSMF/FixedIncomeModel

Â