Mortgage Backed SMF Data Map Table
- Natalie Gesin (Deactivated)
- Kinga Huszno
- Dmitry Donosiyan (Unlicensed)
The tradingFlat 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 | Â |
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 "PAR" 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 | Â |
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 | Required | Â | 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 | Â |
refundIndicator | Â | Â | YesNoOptionEnum | 3132 | in_muni_refund_stat | S | smfobject.inc | SECURITYDBO | MUNI | MUNI_REFUND_STAT | CHAR(2) | EagleML/referenceTransaction/genericSMF/refundIndicator | Â |
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 | Â |
poolNumber | Â | Â | string | 1439 | in_pool_number | S | generic_smf_base_model.inc | SECURITYDBO | SECURITY_MASTER | POOL_NUMBER | CHAR(12) | EagleML/referenceTransaction/genericSMF/poolNumber | Â |
tradingFlat | Required | Â | YesNoOptionEnum | 3949 | in_trading_flat | S | generic_smf_base_model.inc | SECURITYDBO | SECURITY_MASTER_DETAIL | TRADING_FLAT | VARCHAR2(10) | EagleML/referenceTransaction/genericSMF/tradingFlat | Â |
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 | Â |
underlyingSecurity | Â | Â | string | 1141 | in_underlying_security | S | underlyingsmf_model.inc | SECURITYDBO | DERIVATIVES | UNDERLYING_SECURITY | VARCHAR2(255) | EagleML/referenceTransaction/genericSMF/underlyingSecurity | Â |
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 | Â |
minorInd | Â | Â | string | 1789 | in_minor_ind | S | generic_smf_base_model.inc | SECURITYDBO | SECURITY_MASTER | MINOR_IND | CHAR(8) | EagleML/referenceTransaction/genericSMF/minorInd | Â |
userField1 | Â | Â | string | 2337 | in_user_field1 | S | sm_detail_model.inc | SECURITYDBO | COMMERCIAL_BANK | USER_FIELD1 | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/userField1 | Â |
FixedIncomeModel | Â | Â | FixedIncomeModel | EagleML/referenceTransaction/genericSMF/FixedIncomeModel | Â | ||||||||
MBSModel | Â | Â | MBSModel | EagleML/referenceTransaction/genericSMF/MBSModel | Â | ||||||||
Â