Credit Default Swap SMF Data Map Table

Owned by Natalie Gesin (Deactivated)
Last updated: Oct 18, 2017 by Dmitry Donosiyan (Unlicensed)
1 min read

tradingFlat element is required, when accountingValidationFlag ='Y' and processingSecurityType = 'DBFLTP' OR 'DBIBFD' OR 'DBIBMU' OR 'DBIBPK' OR 'DBIVIV' OR 'DBMFDD' OR 'DBAMTL' OR 'DBIBTL' and FixedIncomeModel/fiDetChar25 = 'NONE'

Element

Required Inbound Acct Validation

Required Inbound Data Mgt

Value Type

Star Tag

SP Parameter

SP Type

Include File Name

Eagle DB

DB Table

DB Field

DB Field Type

Xpath

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

Â