Caps & Floors Data Map Table
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 | 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/ | ||||||||||||
investmentType | Required | 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 |
settlementCurrency | Required - Defaulted to "Asset Currency" by panel | Â | CurrencyCode | 63 | in_settlement_currency | S | smfobject.inc | SECURITYDBO | SECURITY_MASTER | SETTLEMENT_CURRENCY | CHAR(3) | EagleML/referenceTransaction/genericSMF/settlementCurrency |
incomeCurrency | Required - Defaulted to "Asset Currency" by panel | Â | CurrencyCode | 1186 | in_sm_income_currency | S | smfobject.inc | SECURITYDBO | SECURITY_MASTER | INCOME_CURRENCY | CHAR(3) | EagleML/referenceTransaction/genericSMF/incomeCurrency |
issueCountryCode | Required | Â | CountryCode | 1418 | in_nra_tax_country | S | smfobject.inc | SECURITYDBO | SECURITY_MASTER | NRA_TAX_COUNTRY | CHAR(30) | EagleML/referenceTransaction/genericSMF/issueCountryCode |
strikeRate | Required | Â | decimal | 11850 | in_strike_rate | N | generic_smf_base_model.inc | SECURITYDBO | DERIVATIVES | STRIKE_RATE | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/strikeRate |
maturityDate | Required | Â | date | 38 | in_mat_date | S | fixedincomesmf_model.inc | SECURITYDBO | SECURITY_MASTER | MAT_DATE | DATE | EagleML/referenceTransaction/genericSMF/maturityDate |
FixedIncomeModel | Â | Â | FixedIncomeModel | Â | EagleML/referenceTransaction/genericSMF/FixedIncomeModel |
Â