Right, Warrant 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

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 "SHARES" 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 "1.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

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

amereuro

Required

string

1142

in_amereuro

S

generic_smf_base_model.inc

SECURITYDBO

DERIVATIVES

AMEREURO

VARCHAR2(10)

EagleML/referenceTransaction/genericSMF/amereuro

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

maturityDate

Required

decimal

38

in_mat_date

S

fixedincomesmf_model.inc

SECURITYDBO

SECURITY_MASTER

MAT_DATE

DATE

EagleML/referenceTransaction/genericSMF/maturityDate

strikePrice

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

minorInd

string

1789

in_minor_ind

S

generic_smf_base_model.inc

SECURITYDBO

SECURITY_MASTER

MINOR_IND

CHAR(8)

EagleML/referenceTransaction/genericSMF/minorInd

EquityModel

EquityModel

Equity Model (see extra table)

EagleML/referenceTransaction/genericSMF/EquityModel