MultiLeg SMF - Data Map Table
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 | 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/accountingValidationFlag | ||
jounalizingFlag |
|
| JournalizingFlagEnum | 1293 | in_journal_flag |
| not stored in DB, used to manage the download logic |
| EagleML/referenceTransaction/multilegSMF/jounalizingFlag | ||
asOfEffectiveDate |
|
| 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/contractLeg/ | ||||||
payLeg |
|
| SmfLegModel | Repeated Group (see extra table below) | EagleML/referenceTransaction/multilegSMF/payLeg/ | ||||||
receiveLeg |
|
| SmfLegModel | Repeated Group (see extra table below) | EagleML/referenceTransaction/multilegSMF/receiveLeg/ | ||||||
NoteModel |
|
| NoteModel | EagleML/referenceTransaction/multilegSMF/NoteModel/ | |||||||
issuer |
|
| issuerModel | EagleML/referenceTransaction/multilegSMF/issuer/ | |||||||
Repeated Group (contractLeg, payLeg, receiveLeg) 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) | .../derivChar10 |
derivChar11 |
|
| string | 8259 | in_derv_char11 |
| SECURITYDBO | DERIVATIVES | DERV_CHAR11 | VARCHAR2(30) | .../derivChar11 |
derivChar12 |
|
| string | 8260 | in_derv_char12 |
| SECURITYDBO | DERIVATIVES | DERV_CHAR12 | VARCHAR2(30) | .../derivChar12 |
derivChar13 |
|
| string | 8261 | in_derv_char13 |
| SECURITYDBO | DERIVATIVES | DERV_CHAR13 | VARCHAR2(30) | .../derivChar13 |
derivChar14 |
|
| string | 8262 | in_derv_char14 |
| SECURITYDBO | DERIVATIVES | DERV_CHAR14 | VARCHAR2(30) | .../derivChar14 |
derivChar15 |
|
| string | 8263 | in_derv_char15 |
| SECURITYDBO | DERIVATIVES | DERV_CHAR15 | VARCHAR2(30) | .../derivChar15 |
derivChar16 |
|
| string | 8264 | in_derv_char16 |
| SECURITYDBO | DERIVATIVES | DERV_CHAR16 | VARCHAR2(30) | .../derivChar16 |
derivChar17 |
|
| string | 8265 | in_derv_char17 |
| SECURITYDBO | DERIVATIVES | DERV_CHAR17 | VARCHAR2(30) | .../derivChar17 |
derivChar18 |
|
| string | 8566 | in_derv_char18 |
| SECURITYDBO | DERIVATIVES | DERV_CHAR18 | VARCHAR2(30) | .../derivChar18 |
derivChar19 |
|
| string | 8567 | in_derv_char19 |
| SECURITYDBO | DERIVATIVES | DERV_CHAR19 | VARCHAR2(30) | .../derivChar19 |
derivChar20 |
|
| string | 8568 | in_derv_char20 |
| SECURITYDBO | DERIVATIVES | DERV_CHAR20 | VARCHAR2(30) | .../derivChar20 |
derivChar21 |
|
| string | 8774 | in_derv_char21 |
| SECURITYDBO | DERIVATIVES | DERV_CHAR21 | VARCHAR2(30) | .../derivChar21 |
derivChar22 |
|
| string | 8775 | in_derv_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 |
| 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 |
overrideSecurityMasterDates |
|
| YesNoOptionEnum | 7171 |
|
| not stored in DB, used only when processingSecurityType = 'SWLEDB' | .../overrideSecurityMasterDates | |||
schedulePaymentFrequency |
|
| string | 7164 |
|
| not stored in DB, used only when processingSecurityType = 'SWLEDB' | .../schedulePaymentFrequency | |||
schedulePaymentFrequencyCode |
|
| string | 7165 |
|
| not stored in DB, used only when processingSecurityType = 'SWLEDB' | .../schedulePaymentFrequencyCode | |||
scheduleFirstValuationDate |
|
| date | 7562 |
|
| not stored in DB, used only when processingSecurityType = 'SWLEDB' | .../scheduleFirstValuationDate | |||
scheduleLastValuationDate |
|
| date | 7561 |
|
| not stored in DB, used only when processingSecurityType = 'SWLEDB' | .../scheduleLastValuationDate | |||
scheduleBusinessDayConvention |
|
| string | 7166 |
|
| not stored in DB, used only when processingSecurityType = 'SWLEDB' | .../scheduleBusinessDayConvention | |||
scheduleCouponDayOfMonth |
|
| decimal | 7320 |
|
| not stored in DB, used only when processingSecurityType = 'SWLEDB' | .../scheduleCouponDayOfMonth | |||
scheduleBusinessCalendarName |
|
| string | 7167 |
|
| not stored in DB, used only when processingSecurityType = 'SWLEDB' | .../scheduleBusinessCalendarName | |||
scheduleDayOfMonthOverride |
|
| string | 7168 |
|
| not stored in DB, used only when processingSecurityType = 'SWLEDB' | .../scheduleDayOfMonthOverride | |||
scheduleCouponDelayDays |
|
| decimal | 7321 |
|
| not stored in DB, used only when processingSecurityType = 'SWLEDB' | .../scheduleCouponDelayDays | |||
scheduleCouponDelayDaysType |
|
| string | 7169 |
|
| not stored in DB, used only when processingSecurityType = 'SWLEDB' | .../scheduleCouponDelayDaysType | |||
scheduleDelayDays |
|
| decimal | 7322 |
|
| not stored in DB, used only when processingSecurityType = 'SWLEDB' | .../scheduleDelayDays | |||
scheduleDelayDaysType |
|
| string | 7170 |
|
| not stored in DB, used only when processingSecurityType = 'SWLEDB' | .../scheduleDelayDaysType | |||
EquityModel |
|
| EquityModel | .../EquityModel/ | |||||||
FixedIncomeModel |
|
| FixedIncomeModel | .../FixedIncomeModel/ | |||||||
FixedIncomeExtension |
|
| FixedIncomeExtensionModel | .../FixedIncomeExtension/ | |||||||
SMExtension |
|
| SMExtensionModel | .../SMExtension/ | |||||||
UnderlyingModel |
|
| UnderlyingModel | .../UnderlyingModel/ | |||||||
MultipleLegSwapModel |
|
| MultipleLegSwapModel | .../MultipleLegSwapModel/ | |||||||
CapsAndFloorsModel |
|
| CapsAndFloorsModel | .../CapsAndFloorsModel | |||||||
IndexModel |
|
| IndexModel | .../IndexModel | |||||||
ScheduleModel |
|
| ScheduleModel | .../ScheduleModel | |||||||
IssueVariableRateModel |
|
| IssueVariableRateModel | .../IssueVariableRateModel | |||||||
EarningsTimePeriodModel |
|
| EarningsTimePeriodModel | .../EarningsTimePeriodModel | |||||||
FloaterModel |
|
| FloaterModel | .../FloaterModel |