Option Contract 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

Required

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

updateMasterTablesFlag

string

990

in_tag_list

S

smfflags_model.inc

not stored in DB, used for resolution logic

EagleML/referenceTransaction/genericSMF/updateMasterTablesFlag

journalizingFlag

JournalizingFlagFlagEnum

1293

in_journal_flag

S

smfflags_model.inc

not stored in DB, used for resolution logic

EagleML/referenceTransaction/genericSMF/journalizingFlag

fieldCompareFlag

YesNoOptionEnum

989

in_989_flag

S

smfflags_model.inc

not stored in DB, used for resolution logic

EagleML/referenceTransaction/genericSMF/fieldCompareFlag

investmentType

Required

StringWithCodeScheme

11

in_investment_type

S

smfobject.inc

SECURITYDBO

SECURITY_MASTER

INVESTMENT_TYPE

CHAR(4)

EagleML/referenceTransaction/genericSMF/investmentType

processingSecurityType

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

quantityType

Required - Defaulted to "CONTRACTS" by panel

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 "1.00" 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 "100.00" 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

region

string

5423

in_region

S

generic_smf_base_model.inc

SECURITYDBO

SECURITY_MASTER_DETAIL

REGION

VARCHAR2(50)

EagleML/referenceTransaction/genericSMF/region

putCallIndicator

Required

StringWithCodeScheme

1350

in_call_put_flag

S

optioncontractsmf_model.inc

SECURITYDBO

EQUITY

CALL_PUT_FLAG

CHAR(4)

EagleML/referenceTransaction/genericSMF/putCallIndicator

variationMarginFlag

YesNoOptionEnum

4533

in_var_margin

S

futurecontractsmf_model.inc

SECURITYDBO

DERIVATIVES

VAR_MARGIN

VARCHAR2(3)

EagleML/referenceTransaction/genericSMF/variationMarginFlag

variationMarginRule

integer

4350

in_var_margin_rule

N

generic_smf_base_model.inc

SECURITYDBO

DERIVATIVES

VAR_MARGIN_RULE

NUMBER

EagleML/referenceTransaction/genericSMF/variationMarginRule

amereuro

Required

string

1142

in_amereuro

S

generic_smf_base_model.inc

SECURITYDBO

DERIVATIVES

AMEREURO

VARCHAR2(10)

EagleML/referenceTransaction/genericSMF/amereuro

curr0

string

1356

in_curr0

S

generic_smf_base_model.inc

SECURITYDBO

DERIVATIVES

CURR0

VARCHAR2(3)

EagleML/referenceTransaction/genericSMF/curr0

curr1

string

1357

in_curr1

S

generic_smf_base_model.inc

SECURITYDBO

DERIVATIVES

CURR1

VARCHAR2(3)

EagleML/referenceTransaction/genericSMF/curr1

underlyingCusip

Required

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

strikePrice

Required

decimal

67

in_strike_price

F

optioncontractsmf_model.inc

SECURITYDBO

DERIVATIVES

STRIKE_PRICE

NUMBER(28,12)

EagleML/referenceTransaction/genericSMF/strikePrice

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

FixedIncomeModel

FixedIncomeModel

Fixed Income Model (see extra table)

EagleML/referenceTransaction/genericSMF/FixedIncomeModel

FixedIncomeExtension

FixedIncomeExtensionModel

Fixed Income Extension Model (see extra table)

EagleML/referenceTransaction/genericSMF/FixedIncomeExtension