...
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 | Note Model | EagleML/referenceTransaction/multilegSMF/NoteModel/ | ||||||||||||||
| issuer | issuerModel | Issuer Model | EagleML/referenceTransaction/multilegSMF/issuer/ | ||||||||||||||
| |||||||||||||||||
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 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 | ||||||||||||||
...