...
Element | Required Inbound Acct Validation | Required Inbound Data Mgt | Value Type | Star Tag | SP Parameter | SP Type | Eagle DB | DB Table | DB Field | DB Field Type | Xpath | |||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
objectType | Required | ObjectTypeEnum | - | not stored in DB | EagleML/referenceTransaction/multilegSMF/objectType | |||||||||||||||||||||||||
objectId | ObjectId | - | not stored in DB | EagleML/referenceTransaction/multilegSMF/objectId | ||||||||||||||||||||||||||
objectDescription | FeedTypeEnum | - | not stored in DB | EagleML/referenceTransaction/multilegSMF/objectDescription | ||||||||||||||||||||||||||
updateTimestamp | dateTime | - | not stored in DB | EagleML/referenceTransaction/multilegSMF/updateTimestamp | ||||||||||||||||||||||||||
customElements | Not recommended | CustomElements | CustomElements – reserved for customizations | EagleML/referenceTransaction/multilegSMF/customElements | ||||||||||||||||||||||||||
sourceName | Required | string | 1102 | in_short_desc | S | PACE_MASTERDBO | INTERFACES | SHORT_DESC | CHAR(15) | EagleML/referenceTransaction/multilegSMF/sourceName | ||||||||||||||||||||
updateSource | Required | string | 944 | in_update_source | S | SECURITYDBO | SECURITY_MASTER | UPDATE_SOURCE | CHAR(255) | EagleML/referenceTransaction/multilegSMF/updateSource | ||||||||||||||||||||
effectiveDate | Required | date | EagleML/referenceTransaction/multilegSMF/effectiveDate | |||||||||||||||||||||||||||
languageId | integer | - | not stored in DB | EagleML/referenceTransaction/multilegSMF/languageId | ||||||||||||||||||||||||||
tagNochangecase | string | 4637 | EagleML/referenceTransaction/multilegSMF/tagNochangecase | |||||||||||||||||||||||||||
preserveNull | string | 5284 | EagleML/referenceTransaction/multilegSMF/preserveNull | |||||||||||||||||||||||||||
noLoadValidationFlag | YesNoOptionEnum | not stored in DB, used to manage the download logic | EagleML/referenceTransaction/multilegSMF/noLoadValidationFlag | |||||||||||||||||||||||||||
accountingValidationFlag | Required | YesNoOptionEnum | not stored in DB, used to manage the download logic | EagleML/referenceTransaction/multilegSMF/accountingValidationFlagcontractLeg | ||||||||||||||||||||||||||
jounalizingFlag | SmfLegModel | EagleML/referenceTransaction/multilegSMF/contractLeg/ | payLeg | SmfLegModel | JournalizingFlagEnum | 1293 | in_journal_flag | not stored in DB, used to manage the download logic | EagleML/referenceTransaction/multilegSMF/ | payLeg/jounalizingFlag | ||||||||||||||||||||
asOfEffectiveDate | SmfLegModel | date | 4212 | not stored in DB, used for time sensitive securities load logic | EagleML/referenceTransaction/multilegSMF/asOfEffectiveDate | |||||||||||||||||||||||||
contractLeg | SmfLegModel | Repeated Group (see extra table below) | EagleML/referenceTransaction/multilegSMF/receiveLegcontractLeg/ | |||||||||||||||||||||||||||
payLeg | NoteModel | Note ModelSmfLegModel | Repeated Group (see extra table below) | EagleML/referenceTransaction/multilegSMF/ | NoteModelpayLeg/ | |||||||||||||||||||||||||
receiveLeg | issuerModel | Issuer Model | EagleML/SmfLegModel | Repeated Group (see extra table below) | EagleML/referenceTransaction/multilegSMF/receiveLeg/ | |||||||||||||||||||||||||
NoteModel | NoteModel | Note Model | EagleML/referenceTransaction/multilegSMF/NoteModel/ | |||||||||||||||||||||||||||
issuer | issuerModel | Issuer Model | EagleML/referenceTransaction/multilegSMF/issuer/ | |||||||||||||||||||||||||||
Data Map Table | ||||||||||||||||||||||||||||||
investmentType | Required | StringWithCodeScheme | 11 | in_investment_type | S | SECURITYDBO | SECURITY_MASTER | INVESTMENT_TYPE | CHAR(4) | .../investmentType | ||||||||||||||||||||
processingSecurityType | Required | StringWithCodeScheme | 3931 | in_process_sec_type | S | SECURITYDBO | SECURITY_MASTER | PROCESS_SEC_TYPE | VARCHAR2(15) | .../processingSecurityType | ||||||||||||||||||||
securityType | string | 82 | in_security_type | S | SECURITYDBO | SECURITY_MASTER | SECURITY_TYPE | CHAR(15) | .../securityType | |||||||||||||||||||||
securitySubType | string | 1464 | in_alt_security_type | S | SECURITYDBO | SECURITY_MASTER_DETAIL | ALT_SECURITY_TYPE | CHAR(15) | .../securitySubType | |||||||||||||||||||||
settlementCurrency | Required - Defaulted to "Asset Currency" by panel | CurrencyCode | 63 | in_settlement_currency | S | SECURITYDBO | SECURITY_MASTER | SETTLEMENT_CURRENCY | CHAR(3) | .../settlementCurrency | ||||||||||||||||||||
incomeCurrency | Required - Defaulted to "Asset Currency" by panel | CurrencyCode | 1186 | in_sm_income_currency | S | SECURITYDBO | SECURITY_MASTER | INCOME_CURRENCY | CHAR(3) | .../incomeCurrency | ||||||||||||||||||||
quantityType | Required - Defaulted to "PAR" by Panel | StringWithCodeScheme | 12 | in_quantity_type | S | SECURITYDBO | SECURITY_MASTER | QUANTITY_TYPE | CHAR(12) | .../quantityType | ||||||||||||||||||||
priceMultiplier | Required - Defaulted to "0.01" by Panel | decimal | 18 | in_price_multiplier | F | SECURITYDBO | SECURITY_MASTER | PRICE_MULTIPLIER | NUMBER(28,12) | .../priceMultiplier | ||||||||||||||||||||
quantityScale | Required - Defaulted to "1" by Panel | decimal | 19 | in_sm_trading_unit | F | SECURITYDBO | SECURITY_MASTER | TRADING_UNIT | NUMBER(28,12) | .../quantityScale | ||||||||||||||||||||
issueCountry | string | 2290 | S | not stored in DB [used for issueCountryCode calculation] | .../issueCountry | |||||||||||||||||||||||||
issueCountryCode | Required | CountryCode | 1418 | in_nra_tax_country | S | SECURITYDBO | SECURITY_MASTER | NRA_TAX_COUNTRY | CHAR(30) | .../issueCountryCode | ||||||||||||||||||||
countryOfRisk | string | 2288 | not stored in DB [used for countryOfRiskCode calculation] | .../countryOfRisk | ||||||||||||||||||||||||||
countryOfRiskCode | CountryCode | 10536 | in_country_of_risk | S | SECURITYDBO | SECURITY_MASTER_DETAIL | COUNTRY_OF_RISK | VARCHAR2(20) | .../countryOfRiskCode | |||||||||||||||||||||
issueTaxType | string | 668 | in_issue_tax_type | S | SECURITYDBO | SECURITY_MASTER_DETAIL | ISSUE_TAX_TYPE | VARCHAR2(30) | .../issueTaxType | |||||||||||||||||||||
region | string | 5423 | in_region | S | SECURITYDBO | SECURITY_MASTER_DETAIL | REGION | VARCHAR2(50) | .../region | |||||||||||||||||||||
lookThroughIndicator | StringWithCodeScheme | 1776 | in_look_thru_ind | S | SECURITYDBO | SECURITY_MASTER_DETAIL | LOOK_THRU_IND | CHAR(3) | .../lookThroughIndicator | |||||||||||||||||||||
lookThroughValue | string | 1808 | in_look_thru_value | S | SECURITYDBO | SECURITY_MASTER_DETAIL | LOOK_THRU_VALUE | VARCHAR2(15) | .../lookThroughValue | |||||||||||||||||||||
payLegCompoundingIndicator | string | 11875 | in_compounding_indicator | S | SECURITYDBO | FIXED_INCOME | COMPOUNDING_INDICATOR | VARCHAR2(1) | .../payLegCompoundingIndicator | |||||||||||||||||||||
tradingFlat | Required - Defaulted to "No" by panel See the note | YesNoOptionEnum | 3949 | in_trading_flat | S | SECURITYDBO | SECURITY_MASTER_DETAIL | TRADING_FLAT | VARCHAR2(10) | .../tradingFlat | ||||||||||||||||||||
offset | decimal | 215 | in_offset | N | SECURITYDBO | DERIVATIVES | OFFSET | NUMBER | .../offset | |||||||||||||||||||||
rCouponType | string | 1366 | in_r_coupon_type | S | SECURITYDBO | DERIVATIVES | R_COUPON_TYPE | VARCHAR2(30) | .../rCouponType | |||||||||||||||||||||
swapMaturity | date | 1369 | in_swap_maturity | S | SECURITYDBO | DERIVATIVES | SWAP_MATURITY | DATE | .../swapMaturity | |||||||||||||||||||||
underlyingCusip | string | 1348 | in_underlying_cusip | S | SECURITYDBO | DERIVATIVES | UNDERLYING_CUSIP | CHAR(100) | .../underlyingCusip | |||||||||||||||||||||
underlyingSecurity | Required | string | 1141 | in_underlying_security | S | SECURITYDBO | DERIVATIVES | UNDERLYING_SECURITY | VARCHAR2(255) | .../underlyingSecurity | ||||||||||||||||||||
underlyingSecAlias | integer | 1347 | in_underlying_sec_alias | N | SECURITYDBO | DERIVATIVES | UNDERLYING_SEC_ALIAS | NUMBER | .../underlyingSecAlias | |||||||||||||||||||||
derivChar1 | string | 3317 | in_derv_char1 | SECURITYDBO | DERIVATIVES | DERV_CHAR1 | VARCHAR2(30) | .../derivChar1 | ||||||||||||||||||||||
derivChar2 | string | 3318 | in_derv_char2 | SECURITYDBO | DERIVATIVES | DERV_CHAR2 | VARCHAR2(30) | .../derivChar2 | ||||||||||||||||||||||
derivChar3 | string | 3622 | in_derv_char3 | SECURITYDBO | DERIVATIVES | DERV_CHAR3 | VARCHAR2(30) | .../derivChar3 | ||||||||||||||||||||||
derivChar4 | string | 3319 | in_derv_char4 | SECURITYDBO | DERIVATIVES | DERV_CHAR4 | VARCHAR2(30) | .../derivChar4 | ||||||||||||||||||||||
derivChar5 | string | 3320 | in_derv_char5 | SECURITYDBO | DERIVATIVES | DERV_CHAR5 | VARCHAR2(30) | .../derivChar5 | ||||||||||||||||||||||
derivChar6 | string | 3605 | in_derv_char6 | SECURITYDBO | DERIVATIVES | DERV_CHAR6 | VARCHAR2(30) | .../derivChar6 | ||||||||||||||||||||||
derivChar7 | string | 3606 | in_derv_char7 | SECURITYDBO | DERIVATIVES | DERV_CHAR7 | VARCHAR2(30) | .../derivChar7 | ||||||||||||||||||||||
derivChar8 | string | 3607 | in_derv_char8 | SECURITYDBO | DERIVATIVES | DERV_CHAR8 | VARCHAR2(30) | .../derivChar8 | ||||||||||||||||||||||
derivChar9 | string | 3608 | in_derv_char9 | SECURITYDBO | DERIVATIVES | DERV_CHAR9 | VARCHAR2(30) | .../derivChar9 | ||||||||||||||||||||||
derivChar10 | string | 3609 | in_derv_char10 | SECURITYDBO | DERIVATIVES | DERV_CHAR10 | VARCHAR2(30) | .../derivChar10derivDate1 | ||||||||||||||||||||||
derivChar11 | datestring | 33218259 | in_derv_ | date1char11 | SECURITYDBO | DERIVATIVES | DERV_ | DATE1DATECHAR11 | VARCHAR2(30) | .../ | derivDate1derivChar11 | |||||||||||||||||||
derivChar12 | string | 33098260 | in_ | pderv_ | roll_conventionchar12 | SECURITYDBO | DERIVATIVES | PDERV_ | ROLL_CONVENTIONCHAR12 | CHARVARCHAR2( | 230) | .../ | pRollConventionderivChar12 | |||||||||||||||||
derivChar13 | string | 33108261 | in_ | rderv_ | roll_conventionchar13 | SECURITYDBO | DERIVATIVES | RDERV_ | ROLL_CONVENTIONCHAR13 | CHARVARCHAR2( | 230) | .../ | rRollConventionderivChar13 | |||||||||||||||||
derivChar14 | string | 33148262 | in_ | rderv_ | calc_methodchar14 | S | SECURITYDBO | DERIVATIVES | RDERV_ | CALC_METHODCHAR14 | CHARVARCHAR2( | 230) | .../ | rCalcMethodderivChar14 | ||||||||||||||||
derivChar15 | string | 50278263 | in_ | clearedderv_ | securitySchar15 | SECURITYDBO | DERIVATIVES | CLEAREDDERV_ | SECURITYCHAR15 | VARCHAR2( | 130) | .../ | clearedSecurityderivChar15 | |||||||||||||||||
derivChar16 | string | 85558264 | in_ | finalderv_ | exchg_princhar16 | S | SECURITYDBO | SWAPSDERIVATIVES | FINALDERV_ | EXCHG_PRINCHAR16 | VARCHAR2( | 130) | .../ | finalExchangeOfPrincipalderivChar16 | ||||||||||||||||
derivChar17 | Required | string | 85548265 | in_ | initderv_ | exchg_princhar17 | S | SECURITYDBO | SWAPSDERIVATIVES | INITDERV_ | EXCHG_PRINCHAR17 | VARCHAR2( | 130) | .../ | initialExchangeOfPrincipalderivChar17 | |||||||||||||||
derivChar18 | decimalstring | 45868566 | in_ | legderv_ | multiplierNchar18 | SECURITYDBO | SWAPSDERIVATIVES | LEGDERV_ | MULTIPLIERCHAR18 | NUMBERVARCHAR2( | 32,1230) | .../ | legMultiplierderivChar18 | |||||||||||||||||
derivChar19 | string | 44098567 | in_ | notionalderv_ | reset_typechar19 | S | SECURITYDBO | SWAPSDERIVATIVES | NOTIONALDERV_ | RESET_TYPECHAR19 | VARCHAR2( | 1030) | .../ | notionalResetTypederivChar19 | ||||||||||||||||
derivChar20 | string | 45848568 | in_ | rollderv_ | conventionchar20 | SECURITYDBO | SWAPSDERIVATIVES | ROLLDERV_ | CONVENTIONCHAR20 | VARCHAR2( | 1030) | .../ | rollConventionderivChar20 | |||||||||||||||||
derivChar21 | Requiredstring | date | 388774 | in_ | matderv_ | datechar21 | S | SECURITYDBO | SECURITY_MASTERDERIVATIVES | MATDERV_ | DATEDATE | CHAR21 | VARCHAR2(30) | .../ | maturityDatederivChar21 | |||||||||||||||
derivChar22 | string | 115848775 | in_ | risk_classification_typeS | SECURITYDBO | SECURITY_MASTER_DETAIL | RISK_CLASSIFICATION_TYPE | VARCHAR2(15) | .../riskClassificationType | delayDaysType | string | 5074 | in_sm_delay_days_type | S | SECURITYDBO | SECURITY_MASTER | DELAY_DAYS_TYPE | VARCHAR2(1) | .../delayDaysTypederv_char22 | SECURITYDBO | DERIVATIVES | DERV_CHAR22 | VARCHAR2(30) | .../derivChar22 | ||||||
derivChar23 | string | 8776 | in_derv_char23 | SECURITYDBO | DERIVATIVES | DERV_CHAR23 | VARCHAR2(30) | .../derivChar23 | ||||||||||||||||||||||
derivChar24 | string | 8777 | in_derv_char24 | SECURITYDBO | DERIVATIVES | DERV_CHAR24 | VARCHAR2(30) | .../derivChar24 | ||||||||||||||||||||||
derivChar25 | string | 8778 | in_derv_char25 | SECURITYDBO | DERIVATIVES | DERV_CHAR25 | VARCHAR2(30) | .../derivChar25 | ||||||||||||||||||||||
derivChar26 | string | 16660 | in_derv_char26 | SECURITYDBO | DERIVATIVES | DERV_CHAR26 | VARCHAR2(30) | .../derivChar26 | ||||||||||||||||||||||
derivFloat1 | decimal | 3326 | in_derv_float1 | SECURITYDBO | DERIVATIVES | DERV_FLOAT1 | .../derivFloat1 | |||||||||||||||||||||||
derivFloat2 | decimal | 3327 | in_derv_float2 | SECURITYDBO | DERIVATIVES | DERV_FLOAT2 | .../derivFloat2 | |||||||||||||||||||||||
derivFloat3 | decimal | 3328 | in_derv_float3 | SECURITYDBO | DERIVATIVES | DERV_FLOAT3 | .../derivFloat3 | |||||||||||||||||||||||
derivFloat4 | decimal | 3329 | in_derv_float4 | SECURITYDBO | DERIVATIVES | DERV_FLOAT4 | .../derivFloat4 | |||||||||||||||||||||||
derivFloat5 | decimal | 3330 | in_derv_float5 | SECURITYDBO | DERIVATIVES | DERV_FLOAT5 | .../derivFloat5 | |||||||||||||||||||||||
derivFloat6 | decimal | 8254 | in_derv_float6 | SECURITYDBO | DERIVATIVES | DERV_FLOAT6 | .../derivFloat6 | |||||||||||||||||||||||
derivFloat7 | decimal | 8255 | in_derv_float7 | SECURITYDBO | DERIVATIVES | DERV_FLOAT7 | .../derivFloat7 | |||||||||||||||||||||||
derivFloat8 | decimal | 8256 | in_derv_float8 | SECURITYDBO | DERIVATIVES | DERV_FLOAT8 | .../derivFloat8 | |||||||||||||||||||||||
derivFloat9 | decimal | 8257 | in_derv_float9 | SECURITYDBO | DERIVATIVES | DERV_FLOAT9 | .../derivFloat9 | |||||||||||||||||||||||
derivFloat10 | decimal | 8258 | in_derv_float10 | SECURITYDBO | DERIVATIVES | DERV_FLOAT10 | .../derivFloat10 | |||||||||||||||||||||||
derivFloat11 | decimal | 8769 | in_derv_float11 | SECURITYDBO | DERIVATIVES | DERV_FLOAT11 | .../derivFloat11 | |||||||||||||||||||||||
derivFloat12 | decimal | 8770 | in_derv_float12 | SECURITYDBO | DERIVATIVES | DERV_FLOAT12 | .../derivFloat12 | |||||||||||||||||||||||
derivFloat13 | decimal | 8771 | in_derv_float13 | SECURITYDBO | DERIVATIVES | DERV_FLOAT13 | .../derivFloat13 | |||||||||||||||||||||||
derivFloat14 | decimal | 8772 | in_derv_float14 | SECURITYDBO | DERIVATIVES | DERV_FLOAT14 | .../derivFloat14 | |||||||||||||||||||||||
derivFloat15 | decimal | 8773 | in_derv_float15 | SECURITYDBO | DERIVATIVES | DERV_FLOAT15 | .../derivFloat15 | |||||||||||||||||||||||
derivDate1 | date | 3321 | in_derv_date1 | SECURITYDBO | DERIVATIVES | DERV_DATE1 | DATE | .../derivDate1 | ||||||||||||||||||||||
derivDate2 | date | 3322 | in_derv_date2 | SECURITYDBO | DERIVATIVES | DERV_DATE2 | DATE | .../derivDate2 | ||||||||||||||||||||||
derivDate3 | date | 3323 | in_derv_date3 | SECURITYDBO | DERIVATIVES | DERV_DATE3 | DATE | .../derivDate3 | ||||||||||||||||||||||
derivDate4 | date | 3324 | in_derv_date4 | SECURITYDBO | DERIVATIVES | DERV_DATE4 | DATE | .../derivDate4 | ||||||||||||||||||||||
derivDate5 | date | 3325 | in_derv_date5 | SECURITYDBO | DERIVATIVES | DERV_DATE5 | DATE | .../derivDate5 | ||||||||||||||||||||||
pmtAtIndicator | string | 3604 | in_pmt_at_indicator | SECURITYDBO | DERIVATIVES | PMT_AT_INDICATOR | .../pmtAtIndicator | |||||||||||||||||||||||
pArrearsFlag | string | 3602 | in_p_arrears_flag | SECURITYDBO | DERIVATIVES | P_ARREARS_FLAG | .../pArrearsFlag | |||||||||||||||||||||||
pCalcMethod | string | 3313 | in_p_calc_method | SECURITYDBO | DERIVATIVES | P_CALC_METHOD | .../pCalcMethod | |||||||||||||||||||||||
pCompoundingInd | string | 3311 | in_p_compounding_ind | SECURITYDBO | DERIVATIVES | P_COMPOUNDING_IND | .../pCompoundingInd | |||||||||||||||||||||||
pDivdCarryFlag | string | 3305 | in_p_divd_carry_flag | SECURITYDBO | DERIVATIVES | P_DIVD_CARRY_FLAG | .../pDivdCarryFlag | |||||||||||||||||||||||
pDivdReinvFlag | string | 3303 | in_p_divd_reinv_flag | SECURITYDBO | DERIVATIVES | P_DIVD_REINV_FLAG | .../pDivdReinvFlag | |||||||||||||||||||||||
pLegType | string | 3307 | in_p_leg_type | SECURITYDBO | DERIVATIVES | P_LEG_TYPE | .../pLegType | |||||||||||||||||||||||
pMultiplier | string | 3600 | in_p_multiplier | SECURITYDBO | DERIVATIVES | P_MULTIPLIER | .../pMultiplier | |||||||||||||||||||||||
premiumType | string | 3302 | in_premium_type | SECURITYDBO | DERIVATIVES | PREMIUM_TYPE | .../premiumType | |||||||||||||||||||||||
pRollConvention | string | 3309 | in_p_roll_convention | SECURITYDBO | DERIVATIVES | P_ROLL_CONVENTION | CHAR(2) | .../pRollConvention | ||||||||||||||||||||||
pSpreadAmt | decimal | 3315 | in_p_spread_amt | SECURITYDBO | DERIVATIVES | P_SPREAD_AMT | .../pSpreadAmt | |||||||||||||||||||||||
returnType | string | 3598 | in_return_type | SECURITYDBO | DERIVATIVES | RETURN_TYPE | .../returnType | |||||||||||||||||||||||
rDivdCarryFlag | string | 3306 | in_r_divd_carry_flag | SECURITYDBO | DERIVATIVES | R_DIVD_CARRY_FLAG | .../rDivdCarryFlag | |||||||||||||||||||||||
rDivdReinvFlag | string | 3304 | in_r_divd_reinv_flag | SECURITYDBO | DERIVATIVES | R_DIVD_REINV_FLAG | .../rDivdReinvFlag | |||||||||||||||||||||||
rLegType | string | 3308 | in_r_leg_type | SECURITYDBO | DERIVATIVES | R_LEG_TYPE | .../rLegType | |||||||||||||||||||||||
rMultiplier | decimal | 3601 | in_r_multiplier | SECURITYDBO | DERIVATIVES | R_MULTIPLIER | .../rMultiplier | |||||||||||||||||||||||
rRollConvention | string | 3310 | in_r_roll_convention | SECURITYDBO | DERIVATIVES | R_ROLL_CONVENTION | CHAR(2) | .../rRollConvention | ||||||||||||||||||||||
rSpreadAmt | decimal | 3316 | in_r_spread_amt | SECURITYDBO | DERIVATIVES | R_SPREAD_AMT | .../rSpreadAmt | |||||||||||||||||||||||
rArrearsFlag | string | 3603 | in_r_arrears_flag | SECURITYDBO | DERIVATIVES | R_ARREARS_FLAG | .../rArrearsFlag | |||||||||||||||||||||||
rCalcMethod | string | 3314 | in_r_calc_method | S | SECURITYDBO | DERIVATIVES | R_CALC_METHOD | CHAR(2) | .../rCalcMethod | |||||||||||||||||||||
rCompoundingInd | string | 3312 | in_r_compounding_ind | SECURITYDBO | DERIVATIVES | R_COMPOUNDING_IND | .../rCompoundingInd | |||||||||||||||||||||||
underlyingCmpid | string | 12385 | in_underlying_cmpid | SECURITYDBO | DERIVATIVES | UNDERLYING_CMPID | .../underlyingCmpid | |||||||||||||||||||||||
underlyingSecid | string | 12386 | in_underlying_secid | SECURITYDBO | DERIVATIVES | UNDERLYING_SECID | .../underlyingSecid | |||||||||||||||||||||||
clearedSecurity | string | 5027 | in_cleared_security | S | SECURITYDBO | DERIVATIVES | CLEARED_SECURITY | VARCHAR2(1) | .../clearedSecurity | |||||||||||||||||||||
calcMethod | string | 4589 | in_calc_method | SECURITYDBO | SWAPS | CALC_METHOD | .../calcMethod | |||||||||||||||||||||||
compoundAccrMethod | string | 4590 | in_compound_accr_method | SECURITYDBO | SWAPS | COMPOUND_ACCR_METHOD | .../compoundAccrMethod | |||||||||||||||||||||||
compoundIndicator | string | 1364 | in_compound_flag | SECURITYDBO | SWAPS | COMPOUND_FLAG | .../compoundIndicator | |||||||||||||||||||||||
finalExchangeOfPrincipal | string | 8555 | in_final_exchg_prin | S | SECURITYDBO | SWAPS | FINAL_EXCHG_PRIN | VARCHAR2(1) | .../finalExchangeOfPrincipal | |||||||||||||||||||||
initialExchangeOfPrincipal | Required | string | 8554 | in_init_exchg_prin | S | SECURITYDBO | SWAPS | INIT_EXCHG_PRIN | VARCHAR2(1) | .../initialExchangeOfPrincipal | ||||||||||||||||||||
swapType | string | 4590,1364 | in_pay_receive_ind in_optiondescr | SECURITYDBO | SWAP | PAY_RECEIVE_IND | .../swapType | |||||||||||||||||||||||
payRecIndicator | string | 4590 | in_pay_receive_ind | SECURITYDBO | SWAPS | PAY_RECEIVE_IND | .../payRecIndicator | |||||||||||||||||||||||
basisOffset | decimal | 4585 | in_basis_offset | SECURITYDBO | SWAPS | BASIS_OFFSET | .../basisOffset | |||||||||||||||||||||||
financeLegSide | string | 4583 | in_finance_leg_side | SECURITYDBO | SWAPS | FINANCE_LEG_SIDE | .../financeLegSide | |||||||||||||||||||||||
initialFeeCurrency | string | 4580 | in_initial_fee_currency | SECURITYDBO | SWAPS | INITIAL_FEE_CURRENCY | .../initialFeeCurrency | |||||||||||||||||||||||
legMultiplier | decimal | 4586 | in_leg_multiplier | N | SECURITYDBO | SWAPS | LEG_MULTIPLIER | NUMBER(32,12) | .../legMultiplier | |||||||||||||||||||||
notionalResetType | string | 4409 | in_notional_reset_type | S | SECURITYDBO | SWAPS | NOTIONAL_RESET_TYPE | VARCHAR2(10) | .../notionalResetType | |||||||||||||||||||||
rollConvention | string | 4584 | in_roll_convention | SECURITYDBO | SWAPS | ROLL_CONVENTION | VARCHAR2(10) | .../rollConvention | ||||||||||||||||||||||
maturityDate | Required | date | 38 | in_mat_date | S | SECURITYDBO | SECURITY_MASTER | MAT_DATE | DATE | .../maturityDate | ||||||||||||||||||||
riskClassificationType | string | 11584 | in_risk_classification_type | S | SECURITYDBO | SECURITY_MASTER_DETAIL | RISK_CLASSIFICATION_TYPE | VARCHAR2(15) | .../riskClassificationType | |||||||||||||||||||||
delayDaysType | string | 5074 | in_sm_delay_days_type | S | SECURITYDBO | SECURITY_MASTER | DELAY_DAYS_TYPE | VARCHAR2(1) | .../delayDaysType | |||||||||||||||||||||
rateConversionRule | string | 12849 | in_rate_conversion_rule | S | SECURITYDBO | DERIVATIVES | RATE_CONVERSION_RULE | VARCHAR2(20) | .../rateConversionRule | |||||||||||||||||||||
convertInterestRate | YesNoOptionEnum | 9154 | not stored in DB, used to set rateConversionRule only for processingSecurityType = 'SWLEAC' | .../convertInterestRate | ||||||||||||||||||||||||||
generateSwapResetScheduleSwitch | YesNoOptionEnum | 2299 | not stored in DB, used to generate the Swap Reset Schedule during SMF creation | .../generateSwapResetScheduleSwitch | ||||||||||||||||||||||||||
armInitFixedPeriodMonths | integer | 18566 | in_arm_ini_fixed_period_months | S | SECURITYDBO | MBS_DETAIL_EXT | ARM_INIT_FIXED_PERIOD_MONTHS | NUMBER(38,0) | .../MBSExtension/armInitFixedPeriodMonths | |||||||||||||||||||||
EquityModel | EquityModel | .../EquityModel/ | ||||||||||||||||||||||||||||
FixedIncomeModel | FixedIncomeModel | .../FixedIncomeModel/ | ||||||||||||||||||||||||||||
FixedIncomeExtension | FixedIncomeExtensionModel | .../FixedIncomeExtension/ | ||||||||||||||||||||||||||||
SMExtension | SMExtensionModel | .../SMExtension/ | ||||||||||||||||||||||||||||
UnderlyingModel | UnderlyingModel | .../UnderlyingModel/ | ||||||||||||||||||||||||||||
MultipleLegSwapModel | MultipleLegSwapModel | .../MultipleLegSwapModel/ | ||||||||||||||||||||||||||||
CapsAndFloorsModel | CapsAndFloorsModel | Caps And Floors Model | .../CapsAndFloorsModel | |||||||||||||||||||||||||||
IndexModel | IndexModel | Index Model | .../IndexModel | |||||||||||||||||||||||||||
ScheduleModel | ScheduleModel | Schedule Model | .../ScheduleModel | |||||||||||||||||||||||||||
IssueVariableRateModel | IssueVariableRateModel | Issue Variable Rate Model | .../IssueVariableRateModel | |||||||||||||||||||||||||||
EarningsTimePeriodModel | EarningsTimePeriodModel | Earnings Time Period Model | .../EarningsTimePeriodModel | |||||||||||||||||||||||||||
FloaterModel | FloaterModel | Floater Model | .../FloaterModel |
...