Credit Default Swap 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

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

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

issueTaxType

string

668

in_issue_tax_type

S

smfobject.inc

SECURITYDBO

SECURITY_MASTER_DETAIL

ISSUE_TAX_TYPE

VARCHAR2(30)

EagleML/referenceTransaction/genericSMF/issueTaxType

oIDIndicator

Required - Defaulted to "No" by panel

YesNoOptionEnum

218

in_oid_bond

S

creditdefaultswapsmf_model.inc

SECURITYDBO

SECURITY_MASTER

OID_BOND

CHAR(2)

EagleML/referenceTransaction/genericSMF/oIDIndicator

tradingFlat

Required - Defaulted to "No" by panel         See the note 

YesNoOptionEnum

3949

in_trading_flat

S

generic_smf_base_model.inc

SECURITYDBO

SECURITY_MASTER_DETAIL

TRADING_FLAT

VARCHAR2(10)

EagleML/referenceTransaction/genericSMF/tradingFlat

optiondescr

Required

string

1364

in_optiondescr

S

generic_smf_base_model.inc

SECURITYDBO

DERIVATIVES

OPTIONDESCR

VARCHAR2(10)

EagleML/referenceTransaction/genericSMF/optiondescr

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

premiumType

string

3302

in_premium_type

S

creditdefaultswapsmf_model.inc

SECURITYDBO

DERIVATIVES

PREMIUM_TYPE

CHAR(2)

EagleML/referenceTransaction/genericSMF/premiumType

clearedSecurity

string

5027

in_cleared_security

S

generic_smf_base_model.inc

SECURITYDBO

DERIVATIVES

CLEARED_SECURITY

VARCHAR2(1)

EagleML/referenceTransaction/genericSMF/clearedSecurity

notionalResetType

string

4409

in_notional_reset_type

S

multiplelegswapsmf_model.inc

SECURITYDBO

SWAPS

NOTIONAL_RESET_TYPE

varchar2(10)

EagleML/referenceTransaction/genericSMF/notionalResetType

maturityDate

Required

decimal

38

in_mat_date

S

fixedincomesmf_model.inc

SECURITYDBO

SECURITY_MASTER

MAT_DATE

DATE

EagleML/referenceTransaction/genericSMF/maturityDate

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

EquityModel

EquityModel

Equity Model (see extra table)

EagleML/referenceTransaction/genericSMF/EquityModel

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