Long Term Fixed SMF Data Map Table

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

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

YesNoOptionEnum

not stored in DB, used to manage the download logic

EagleML/referenceTransaction/genericSMF/accountingValidationFlag

Asset Identifiers Model

EagleML/referenceTransaction/genericSMF/

historyOnlyFlag

YesNoOptionEnum

1257

in_trans_type

S

smfflags_model.inc

not stored in DB, used for resolution logic

EagleML/referenceTransaction/genericSMF/historyOnlyFlag

spokeCheckFlag

integer

7250

in_hub_tag

I

smfflags_model.inc

not stored in DB, used for resolution logic

EagleML/referenceTransaction/genericSMF/spokeCheckFlag

inactiveFlag

YesNoOptionEnum

11043

in_inactive_flag

S

smfflags_model.inc

SECURITYDBO

SECURITY_MASTER

INACTIVE_FLAG

VARCHAR2(3)

EagleML/referenceTransaction/genericSMF/inactiveFlag

vendorModeFlag

VendorModeFlagEnum

1085

smfflags_model.inc

not stored in DB, used for resolution logic

EagleML/referenceTransaction/genericSMF/vendorModeFlag

journalizingFlag

JournalizingFlagFlagEnum

1293

in_journal_flag

S

smfflags_model.inc

not stored in DB, used for resolution logic

EagleML/referenceTransaction/genericSMF/journalizingFlag

investmentType

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

securityType

string

82

in_security_type

S

generic_smf_base_model.inc

SECURITYDBO

SECURITY_MASTER

SECURITY_TYPE

CHAR(15)

EagleML/referenceTransaction/genericSMF/securityType

securitySubType

string

1464

in_alt_security_type

S

smfobject.inc

SECURITYDBO

SECURITY_MASTER_DETAIL

ALT_SECURITY_TYPE

CHAR(15)

EagleML/referenceTransaction/genericSMF/securitySubType

settlementCurrency

Required

CurrencyCode

63

in_settlement_currency

S

smfobject.inc

SECURITYDBO

SECURITY_MASTER

SETTLEMENT_CURRENCY

CHAR(3)

EagleML/referenceTransaction/genericSMF/settlementCurrency

incomeCurrency

Required

CurrencyCode

1186

in_sm_income_currency

S

smfobject.inc

SECURITYDBO

SECURITY_MASTER

INCOME_CURRENCY

CHAR(3)

EagleML/referenceTransaction/genericSMF/incomeCurrency

quantityType

Required - Defaulted to "PAR"

StringWithCodeScheme

12

in_quantity_type

S

generic_smf_base_model.inc

SECURITYDBO

SECURITY_MASTER

QUANTITY_TYPE

CHAR(12)

EagleML/referenceTransaction/genericSMF/quantityType

priceMultiplier

Required - Defaulted to "0.01" by Panel

decimal

18

in_price_multiplier

F

smfobject.inc

SECURITYDBO

SECURITY_MASTER

PRICE_MULTIPLIER

NUMBER(28,12)

EagleML/referenceTransaction/genericSMF/priceMultiplier

quantityScale

Required - Defaulted to "1" by Panel

decimal

19

in_sm_trading_unit

F

smfobject.inc

SECURITYDBO

SECURITY_MASTER

TRADING_UNIT

NUMBER(28,12)

EagleML/referenceTransaction/genericSMF/quantityScale

issueCountryCode

Required

CountryCode

1418

in_nra_tax_country

S

smfobject.inc

SECURITYDBO

SECURITY_MASTER

NRA_TAX_COUNTRY

CHAR(30)

EagleML/referenceTransaction/genericSMF/issueCountryCode

countryOfRiskCode

CountryCode

10536

in_country_of_risk

S

generic_smf_base_model.inc

SECURITYDBO

SECURITY_MASTER_DETAIL

COUNTRY_OF_RISK

VARCHAR2(20)

EagleML/referenceTransaction/genericSMF/countryOfRiskCode

issueTaxType

string

668

in_issue_tax_type

S

smfobject.inc

SECURITYDBO

SECURITY_MASTER_DETAIL

ISSUE_TAX_TYPE

VARCHAR2(30)

EagleML/referenceTransaction/genericSMF/issueTaxType

region

string

5423

in_region

S

generic_smf_base_model.inc

SECURITYDBO

SECURITY_MASTER_DETAIL

REGION

VARCHAR2(50)

EagleML/referenceTransaction/genericSMF/region

_144AEligibleIndicator

YesNoOptionEnum

1301

in_sec_144a_flag

S

smfobject.inc

SECURITYDBO

SECURITY_MASTER

SEC_144A_FLAG

CHAR(2)

EagleML/referenceTransaction/genericSMF/_144AEligibleIndicator

restrictedIndicator

string

1139

in_liquid_flag

S

smfobject.inc

SECURITYDBO

SECURITY_MASTER

LIQUID_FLAG

CHAR(2)

EagleML/referenceTransaction/genericSMF/restrictedIndicator

refundIndicator

YesNoOptionEnum

3132

in_muni_refund_stat

S

smfobject.inc

SECURITYDBO

MUNI

MUNI_REFUND_STAT

CHAR(2)

EagleML/referenceTransaction/genericSMF/refundIndicator

oIDIndicator

Required

YesNoOptionEnum

218

in_oid_bond

S

creditdefaultswapsmf_model.inc

SECURITYDBO

SECURITY_MASTER

OID_BOND

CHAR(2)

EagleML/referenceTransaction/genericSMF/oIDIndicator

payLegCompoundingIndicator

string

11875

in_compounding_indicator

S

generic_smf_base_model.inc

SECURITYDBO

FIXED_INCOME

COMPOUNDING_INDICATOR

VARCHAR2(1)

EagleML/referenceTransaction/genericSMF/payLegCompoundingIndicator

tradingFlat

Required

YesNoOptionEnum

3949

in_trading_flat

S

generic_smf_base_model.inc

SECURITYDBO

SECURITY_MASTER_DETAIL

TRADING_FLAT

VARCHAR2(10)

EagleML/referenceTransaction/genericSMF/tradingFlat

offset

decimal

215

in_offset

N

generic_smf_base_model.inc

SECURITYDBO

DERIVATIVES

OFFSET

NUMBER

EagleML/referenceTransaction/genericSMF/offset

underlyingCusip

string

1348

in_underlying_cusip

S

generic_smf_base_model.inc

SECURITYDBO

DERIVATIVES

UNDERLYING_CUSIP

CHAR(100)

EagleML/referenceTransaction/genericSMF/underlyingCusip

underlyingSecurity

string

1141

in_underlying_security

S

underlyingsmf_model.inc

SECURITYDBO

DERIVATIVES

UNDERLYING_SECURITY

VARCHAR2(255)

EagleML/referenceTransaction/genericSMF/underlyingSecurity

maturityDate

Required

decimal

38

in_mat_date

S

fixedincomesmf_model.inc

SECURITYDBO

SECURITY_MASTER

MAT_DATE

DATE

EagleML/referenceTransaction/genericSMF/maturityDate

callIndicator

string

1182

in_callable

S

generic_smf_base_model.inc

SECURITYDBO

FIXED_INCOME

CALLABLE

CHAR(2)

EagleML/referenceTransaction/genericSMF/callIndicator

putIndicator

string

1546

in_puttable

S

generic_smf_base_model.inc

SECURITYDBO

FIXED_INCOME

PUTTABLE

CHAR(2)

EagleML/referenceTransaction/genericSMF/putIndicator

smIssuerId

string

1413

in_sm_issuer_id

S

generic_smf_base_model.inc

SECURITYDBO

SECURITY_MASTER

ISSUER_ID

CHAR(20)

EagleML/referenceTransaction/genericSMF/smIssuerId

issuerInd

string

1417

in_issuer_ind

S

generic_smf_base_model.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

ISSUER_INDUSTRY

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/issuerInd

minorInd

string

1789

in_minor_ind

S

generic_smf_base_model.inc

SECURITYDBO

SECURITY_MASTER

MINOR_IND

CHAR(8)

EagleML/referenceTransaction/genericSMF/minorInd

userField1

string

2337

in_user_field1

S

sm_detail_model.inc

SECURITYDBO

COMMERCIAL_BANK

USER_FIELD1

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/userField1

FixedIncomeModel

FixedIncomeModel

Fixed Income Model (see extra table)

EagleML/referenceTransaction/genericSMF/FixedIncomeModel