Credit Default Swap SMF Data Map Table
- Natalie Gesin (Deactivated)
- Kinga Huszno
- Dmitry Donosiyan (Unlicensed)
The 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 | ||
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 | EagleML/referenceTransaction/genericSMF/EquityModel | ||||||||
FixedIncomeModel |
|
| FixedIncomeModel | EagleML/referenceTransaction/genericSMF/FixedIncomeModel | ||||||||
FixedIncomeExtension |
|
| FixedIncomeExtensionModel | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension | ||||||||