Equity, Mutual Fund 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

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"

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

restrictedIndicator

string

1139

in_liquid_flag

S

smfobject.inc

SECURITYDBO

SECURITY_MASTER

LIQUID_FLAG

CHAR(2)

EagleML/referenceTransaction/genericSMF/restrictedIndicator

multiListedIndicator

YesNoOptionEnum

4565

in_multi_listed_flag

S

smfobject.inc

SECURITYDBO

EQUITY

MULTI_LISTED_FLAG

CHAR(2)

EagleML/referenceTransaction/genericSMF/multiListedIndicator

refundIndicator

YesNoOptionEnum

3132

in_muni_refund_stat

S

smfobject.inc

SECURITYDBO

MUNI

MUNI_REFUND_STAT

CHAR(2)

EagleML/referenceTransaction/genericSMF/refundIndicator

gicsSector

string

10181

in_gics_sector

S

gics_model.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

GICS_SECTOR

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/gicsSector

gicsSectorName

string

10182

in_gics_name

S

gics_model.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

GICS_NAME

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/gicsSectorName

gicsIndustryGroup

string

10183

in_gics_industry_group

S

gics_model.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

GICS_INDUSTRY_GROUP

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/gicsIndustryGroup

gicsIndustryGroupName

string

10184

in_gics_industry_group_name

S

gics_model.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

GICS_INDUSTRY_GROUP_NAME

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/gicsIndustryGroupName

gicsIndustry

string

10185

in_gics_industry

S

gics_model.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

GICS_INDUSTRY

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/gicsIndustry

gicsIndustryName

string

10186

in_gics_industry_name

S

gics_model.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

GICS_INDUSTRY_NAME

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/gicsIndustryName

gicsSubIndustry

string

10187

in_gics_sub_industry

S

gics_model.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

GICS_SUB_INDUSTRY

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/gicsSubIndustry

gicsSubIndustryName

string

10188

in_gics_sub_industry_name

S

gics_model.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

GICS_SUB_INDUSTRY_NAME

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/gicsSubIndustryName

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

decimal

38

in_mat_date

S

fixedincomesmf_model.inc

SECURITYDBO

SECURITY_MASTER

MAT_DATE

DATE

EagleML/referenceTransaction/genericSMF/maturityDate

closedEndFundFlag

string

1792

in_closed_end_fund_flag

S

generic_smf_base_model.inc

SECURITYDBO

SECURITY_MASTER

CLOSED_END_FUND_FLAG

CHAR(2)

EagleML/referenceTransaction/genericSMF/closedEndFundFlag

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

registeredFlag

string

1445

in_registered_flag

S

generic_smf_base_model.inc

SECURITYDBO

SECURITY_MASTER

REGISTERED_FLAG

CHAR(2)

EagleML/referenceTransaction/genericSMF/registeredFlag

pficFlag

string

2906

in_pfic_flag

S

generic_smf_base_model.inc

SECURITYDBO

SECURITY_MASTER

PFIC_FLAG

VARCHAR2(1)

EagleML/referenceTransaction/genericSMF/pficFlag

EquityModel

EquityModel

Equity Model (see extra table)

EagleML/referenceTransaction/genericSMF/EquityModel

FixedIncomeModel

FixedIncomeModel

Fixed Income Model (see extra table)

EagleML/referenceTransaction/genericSMF/FixedIncomeModel