...
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 | JournalizingFlagEnum |
| SmfLegModel | Repeated Group1293 | in_journal_flag | not stored in DB, used to manage the download logic | EagleML/referenceTransaction/multilegSMF/ | contractLegpayLeg |
| 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 | receiveLeg |
|
| SmfLegModel | Repeated Group (see extra table below) | EagleML/referenceTransaction/multilegSMF/payLeg/ | |||||||||||||||||||||||||||||
receiveLeg | anchorSmfLegModel | Repeated | _GroupGroup (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 |
| 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 |
|
| date | 3321string | 8259 | in_derv_ | date1char11 |
| SECURITYDBO | DERIVATIVES | DERV_ | DATE1DATECHAR11 | VARCHAR2(30) | .../ | derivDate1derivChar11 | pRollConvention | |||||||||||||||||||
| derivChar12 |
| string | 33098260 | in_ | pderv_ | roll_conventionchar12 |
| SECURITYDBO | DERIVATIVES | PDERV_ | ROLL_CONVENTIONCHAR12 | CHARVARCHAR2( | 230) | .../ | pRollConventionderivChar12 | ||||||||||||||||||||
| derivChar13 |
|
| string | 33108261 | in_ | r_roll_conventionderv_char13 | 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_ | securitychar15 | S | 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_ | init_exchg_prinSderv_char17 | SECURITYDBO | SWAPSDERIVATIVES | INITDERV_ | EXCHG_PRINCHAR17 | VARCHAR2( | 130) | .../ | initialExchangeOfPrincipalderivChar17 | |||||||||||||||||||||
| derivChar18 | string |
| decimal8566 | 4586 | in_ | legderv_ | multiplierNchar18 | SECURITYDBO | SWAPSDERIVATIVES | LEGDERV_ | MULTIPLIERCHAR18 | NUMBERVARCHAR2( | 32,1230) | .../ | legMultipliernotionalResetType |
| derivChar18 | ||||||||||||||||||
| derivChar19 | string | 44098567 | in_ | notionalderv_ | reset_typechar19 | S | SECURITYDBO | SWAPSDERIVATIVES | NOTIONALDERV_ | RESET_TYPECHAR19 | VARCHAR2( | 1030) | .../ | notionalResetTypederivChar19 | rollConvention | ||||||||||||||||||||
| derivChar20 |
| string | 45848568 | in_ | rollderv_ | conventionchar20 |
| SECURITYDBO | SWAPSDERIVATIVES | ROLLDERV_ | CONVENTIONCHAR20 | VARCHAR2( | 1030) | .../ | rollConventionderivChar20 | ||||||||||||||||||||
| derivChar21 | Required |
| date | 38string | 8774 | in_ | matderv_ | datechar21 | S | SECURITYDBO | SECURITY_MASTERDERIVATIVES | MATDERV_ | DATEDATECHAR21 | VARCHAR2(30) | .../ | maturityDatederivChar21 | |||||||||||||||||||
| derivChar22 |
|
| string | 115848775 | in_ | risk_classification_typeSderv_char22 | SECURITYDBO | SECURITY_MASTER_DETAIL | RISK_CLASSIFICATION_TYPEDERIVATIVES | DERV_CHAR22 | VARCHAR2( | 1530) | .../ | riskClassificationTypederivChar22 | |||||||||||||||||||||
| derivChar23 |
|
| string | 50748776 | in_ | sm_delay_days_typeSderv_char23 | SECURITYDBO | SECURITY_MASTERDERIVATIVES | DELAYDERV_ | DAYS_TYPECHAR23 | VARCHAR2( | 130) | .../ | delayDaysTypeEquityModel |
|
| EquityModel | Equity Model derivChar23 | |||||||||||||||||
| derivChar24 | string | 8777 | in_derv_char24 | SECURITYDBO | DERIVATIVES | DERV_CHAR24 | VARCHAR2(30) | .../ | EquityModel/FixedIncomeModel |
|
| FixedIncomeModel | Fixed Income ModelderivChar24 | ||||||||||||||||||||||
| derivChar25 | string | 8778 | in_derv_char25 | SECURITYDBO | DERIVATIVES | DERV_CHAR25 | VARCHAR2(30) | .../ | FixedIncomeModel/FixedIncomeExtension |
|
| FixedIncomeExtensionModel | Fixed Income Extension ModelderivChar25 | ||||||||||||||||||||||
| derivChar26 | string | 16660 | in_derv_char26 | SECURITYDBO | DERIVATIVES | DERV_CHAR26 | VARCHAR2(30) | .../ | FixedIncomeExtension/SMExtension |
|
| SMExtensionModel | SM Extension ModelderivChar26 | ||||||||||||||||||||||
| derivFloat1 | decimal | 3326 | in_derv_float1 | SECURITYDBO | DERIVATIVES | DERV_FLOAT1 | .../ | SMExtension/derivFloat1 | |||||||||||||||||||||||||||
| derivFloat2 | decimal |
| UnderlyingModel | Underlying Model3327 | in_derv_float2 | SECURITYDBO | DERIVATIVES | DERV_FLOAT2 | .../ | UnderlyingModel/MultipleLegSwapModel |
|
| MultipleLegSwapModel | Multiple Leg Swap ModelderivFloat2 | |||||||||||||||||||||
| derivFloat3 | decimal | 3328 | in_derv_float3 | SECURITYDBO | DERIVATIVES | DERV_FLOAT3 | .../ | MultipleLegSwapModel/derivFloat3 | |||||||||||||||||||||||||||
| Anchor | Equity_Model | Equity_Model | Equity Model Data Map Table|||||||||||||||||||||||||||||||||
costBasisRuleType |
|
| string | 2817 | in_cost_basis_rule_type | S | SECURITYDBO | SECURITY_MASTER_DETAIL | COST_BASIS_RULE_TYPE | VARCHAR2(20) | .../EquityModel/costBasisRuleType | ||||||||||||||||||||||||
| Anchor | Fixed_Income | Fixed_Income | Fixed Income Model Data Map|||||||||||||||||||||||||||||||||
coupon | Required |
| decimal | 70 | in_coupon | F | SECURITYDBO | SECURITY_MASTER | COUPON | NUMBER(28,12) | .../FixedIncomeModel/coupon | ||||||||||||||||||||||||
couponTypeCode | Required |
| StringWithCodeScheme | 97 | in_coupon_type_code | S | SECURITYDBO | SECURITY_MASTER | COUPON_TYPE_CODE | CHAR(8) | .../FixedIncomeModel/couponTypeCode | ||||||||||||||||||||||||
dayCountBasis
| Required
|
| DayCountFraction
| 471
| in_day_cnt
| S
| SECURITYDBO | SECURITY_MASTER | DAY_CNT | CHAR(20) | .../FixedIncomeModel/dayCountBasis
| ||||||||||||||||||||||||
SECURITYDBO | SMF_EARNINGS_TIME_PERIOD | DAY_CNT | CHAR(20) | ||||||||||||||||||||||||||||||||
paymentFrequency |
|
| string | 2287 |
|
| not stored in DB [used for paymentFrequencyCode calculation] |
| .../FixedIncomeModel/paymentFrequency | ||||||||||||||||||||||||||
paymentFrequencyCode | Required |
| StringWithCodeScheme | 472 | in_coupon_freq_code | S | SECURITYDBO | SECURITY_MASTER | COUPON_FREQ_CODE | CHAR(8) | .../FixedIncomeModel/paymentFrequencyCode | ||||||||||||||||||||||||
issueDate | Required |
| date | 68 | in_issue_date | S | SECURITYDBO | FIXED_INCOME | ISSUE_DATE | DATE | .../FixedIncomeModel/issueDate | ||||||||||||||||||||||||
datedDate | Required |
| date | 1183 | in_dated_date | S | SECURITYDBO | FIXED_INCOME | DATED_DATE | DATE | .../FixedIncomeModel/datedDate | ||||||||||||||||||||||||
firstCouponDate | Required |
| date | 473 | in_first_income_date | S | SECURITYDBO | FIXED_INCOME | FIRST_INCOME_DATE | DATE | .../FixedIncomeModel/firstCouponDate | ||||||||||||||||||||||||
lastCouponDate | Required |
| date | 474 | in_last_income_date | S | SECURITYDBO | FIXED_INCOME | LAST_INCOME_DATE | DATE | .../FixedIncomeModel/lastCouponDate | ||||||||||||||||||||||||
defaultIndicator |
|
| YesNoOptionEnum | 1551 | in_default_flag | S | SECURITYDBO | SECURITY_MASTER | DEFAULT_FLAG | CHAR(2) | .../FixedIncomeModel/defaultIndicator | ||||||||||||||||||||||||
defaultDate |
|
| date | 10142 | in_default_date | S | SECURITYDBO | FIXED_INCOME | DEFAULT_DATE | DATE | .../FixedIncomeModel/defaultDate | ||||||||||||||||||||||||
firstRateResetDate | Required |
| date | 10911 | in_first_rate_reset_date | S | SECURITYDBO | FIXED_INCOME | FIRST_RATE_RESET_DATE | DATE | .../FixedIncomeModel/firstRateResetDate | ||||||||||||||||||||||||
resetFrequency | Required |
| string | 476 |
|
| not stored in DB [used for varRateFreqCode calculation] |
| .../FixedIncomeModel/resetFrequency | ||||||||||||||||||||||||||
resetLookBackDaysType |
|
| string | 5075 | in_reset_lag_days_type | S | SECURITYDBO | FIXED_INCOME | RESET_LAG_DAYS_TYPE | VARCHAR2(1) | .../FixedIncomeModel/resetLookBackDaysType | ||||||||||||||||||||||||
periodicCap |
|
| decimal | 10907 | in_periodic_cap | N | SECURITYDBO | FIXED_INCOME | PERIODIC_CAP | NUMBER(28,12) | .../FixedIncomeModel/periodicCap | ||||||||||||||||||||||||
periodicFloor |
|
| decimal | 10908 | in_periodic_floor | N | SECURITYDBO | FIXED_INCOME | PERIODIC_FLOOR | NUMBER(28,12) | .../FixedIncomeModel/periodicFloor | ||||||||||||||||||||||||
lifetimeCap |
|
| decimal | 10909 | in_lifetime_cap | N | SECURITYDBO | FIXED_INCOME | LIFETIME_CAP | NUMBER(28,12) | .../FixedIncomeModel/lifetimeCap | ||||||||||||||||||||||||
lifetimeFloor |
|
| decimal | 10910 | in_lifetime_floor | N | SECURITYDBO | FIXED_INCOME | LIFETIME_FLOOR | NUMBER(28,12) | .../FixedIncomeModel/lifetimeFloor | ||||||||||||||||||||||||
datedDateCPI |
|
| decimal | 1550 | in_govt_idx_ratio | F | SECURITYDBO | FIXED_INCOME | GOVT_IDX_RATIO | NUMBER(28,12) | .../FixedIncomeModel/datedDateCPI | ||||||||||||||||||||||||
iLBCalculationType |
|
| string | 11808 | in_inflation_calc_method | S | SECURITYDBO | FIXED_INCOME | INFLATION_CALCULATION_METHOD | VARCHAR2(10) | .../FixedIncomeModel/iLBCalculationType | ||||||||||||||||||||||||
iLBIndexPrecision |
|
| integer | 11017 | in_ilb_index_precision | N | SECURITYDBO | FIXED_INCOME | ILB_INDEX_PRECISION | NUMBER(38) | .../FixedIncomeModel/iLBIndexPrecision | ||||||||||||||||||||||||
iLBDeflationProtectedMaturity |
|
| YesNoOptionEnum | 11809 | in_deflation_protect_maturity | S | SECURITYDBO | FIXED_INCOME | DEFLATION_PROTECTED_MATURITY | VARCHAR2(1) | .../FixedIncomeModel/iLBDeflationProtectedMaturity | ||||||||||||||||||||||||
compoundingMethod |
|
| string | 11876 | in_compounding_method | S | SECURITYDBO | FIXED_INCOME | COMPOUNDING_METHOD | VARCHAR2(15) | .../FixedIncomeModel/compoundingMethod | ||||||||||||||||||||||||
compoundingFrequency |
|
| StringWithCodeScheme | 11877 | in_compounding_frequency | S | SECURITYDBO | FIXED_INCOME | COMPOUNDING_FREQUENCY | VARCHAR2(15) | .../FixedIncomeModel/compoundingFrequency | ||||||||||||||||||||||||
firstCompoundingDate |
|
| date | 11878 | in_first_compounding_date | S | SECURITYDBO | FIXED_INCOME | FIRST_COMPOUNDING_DATE | DATE | .../FixedIncomeModel/firstCompoundingDate | ||||||||||||||||||||||||
lastCompoundingDate |
|
| date | 11879 | in_last_compounding_date | S | SECURITYDBO | FIXED_INCOME | LAST_COMPOUNDING_DATE | DATE | .../FixedIncomeModel/lastCompoundingDate | ||||||||||||||||||||||||
delayDays |
|
| integer | 1799 | in_coupon_day_of_month | I | SECURITYDBO | SECURITY_MASTER | COUPON_DAY_OF_MONTH | NUMBER | .../FixedIncomeModel/delayDays | ||||||||||||||||||||||||
couponDayOfMonth | Required |
| integer | 10551 | in_fi_coupon_day_of_month | I | SECURITYDBO | FIXED_INCOME | COUPON_DAY_OF_MONTH | NUMBER(38) | .../FixedIncomeModel/couponDayOfMonth | ||||||||||||||||||||||||
businessDayConvention | Required |
| StringWithCodeScheme | 1536 | in_interest_method_code | S | SECURITYDBO | FIXED_INCOME | INTEREST_METHOD_CODE | CHAR(10) | .../FixedIncomeModel/businessDayConvention | ||||||||||||||||||||||||
businessCalendarName | Required |
| string | 1480 | in_businessday | S | SECURITYDBO | SECURITY_MASTER_DETAIL | BUSINESSDAY | VARCHAR2(10) | .../FixedIncomeModel/businessCalendarName | ||||||||||||||||||||||||
dayOfMonthOverride |
|
| integer | 1533 | in_day_type | S | SECURITYDBO | FIXED_INCOME | DAY_TYPE | CHAR(10) | .../FixedIncomeModel/dayOfMonthOverride | ||||||||||||||||||||||||
interestPaymentTiming |
|
| StringWithCodeScheme | 1523 | in_accrual_method | S | SECURITYDBO | FIXED_INCOME | ACCRUAL_METHOD | CHAR(4) | .../FixedIncomeModel/interestPaymentTiming | ||||||||||||||||||||||||
resetLagDays |
|
| integer | 10547 | in_reset_lag_days | N | SECURITYDBO | FIXED_INCOME | RESET_LAG_DAYS | NUMBER(38) | .../FixedIncomeModel/resetLagDays | ||||||||||||||||||||||||
variableRateAdj |
|
| decimal | 1553 | in_variable_rate_adj | F | SECURITYDBO | FIXED_INCOME | VARIABLE_RATE_ADJ | NUMBER(28,12) | .../FixedIncomeModel/variableRateAdj | ||||||||||||||||||||||||
varRateFreqCode |
|
| string | 1788 | in_var_rate_freq_code | S | SECURITYDBO | FIXED_INCOME | VAR_RATE_FREQ_CODE | CHAR(4) | .../FixedIncomeModel/varRateFreqCode | ||||||||||||||||||||||||
floaterMultiple |
|
| integer | 4532 | in_floater_multiple | I | SECURITYDBO | FIXED_INCOME | FLOATER_MULTIPLE | NUMBER | .../FixedIncomeModel/floaterMultiple | ||||||||||||||||||||||||
resetLagBusinessDays |
|
| string | 10548 | in_reset_lag_business_days | S | SECURITYDBO | FIXED_INCOME | RESET_LAG_BUSINESS_DAYS | VARCHAR2(20) | .../FixedIncomeModel/resetLagBusinessDays | ||||||||||||||||||||||||
maturityDelayDays |
|
| integer | 3997 | in_maturity_delay_days | N | SECURITYDBO | FIXED_INCOME | MATURITY_DELAY_DAYS | NUMBER(38) | .../FixedIncomeModel/maturityDelayDays | ||||||||||||||||||||||||
maturityDelayDaysType |
|
| string | 3998 | in_maturity_delay_days_type | S | SECURITYDBO | FIXED_INCOME | MATURITY_DELAY_DAYS_TYPEderivFloat4 | 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) | .../FixedIncomeModel/maturityDelayDaysTypefinalExchangeOfPrincipal | ||||||||||||||||||||||||||
dualCurrencyIndicatorinitialExchangeOfPrincipal |
| Required | string | 118028554 | in_dualinit_currencyexchg_indicatorprin | S | SECURITYDBO | FIXED_INCOMESWAPS | DUALINIT_CURRENCYEXCHG_INDICATORPRIN | VARCHAR2(21) | .../FixedIncomeModel/dualCurrencyIndicatorinitialExchangeOfPrincipaldualCurConvFactor | ||||||||||||||||||||||||
| swapType | string |
| decimal | 11803 | in_dual_cur_conv_factor | F | SECURITYDBO | FIXED_INCOME | DUAL_CUR_CONV_FACTOR | NUMBER(38,12)4590,1364 | in_pay_receive_ind in_optiondescr | SECURITYDBO | SWAP | PAY_RECEIVE_IND | .../ | FixedIncomeModel/dualCurConvFactorprincipalCurrencyDc |
| swapType | |||||||||||||||||
| payRecIndicator | string | 118134590 | in_ | principalpay_ | currencyreceive_ | dcind | S | SECURITYDBO | FIXED_INCOMESWAPS | PRINCIPALPAY_ | CURRENCYRECEIVE_ | DCVARCHAR2(3) | .../FixedIncomeModel/principalCurrencyDc | ||||||||||||||||||||||
settlementRateOption |
|
| string | 11816 | in_settlement_rate_option | S | SECURITYDBO | FIXED_INCOME | SETTLEMENT_RATE_OPTION | VARCHAR2(55) | .../FixedIncomeModel/settlementRateOption | ||||||||||||||||||||||||
fxRateType |
|
| string | 11817 | in_fx_rate_type | S | SECURITYDBO | FIXED_INCOME | FX_RATE_TYPE | VARCHAR2(2) | .../FixedIncomeModel/fxRateType | ||||||||||||||||||||||||
fxFixingPeriod |
|
| string | 11818 | in_fx_fixing_period | S | SECURITYDBO | FIXED_INCOME | FX_FIXING_PERIOD | VARCHAR2(2) | .../FixedIncomeModel/fxFixingPeriod | ||||||||||||||||||||||||
fxFixingPeriodMultiplier |
|
| decimal | 12027 | in_fx_fixing_period_multipl | F | SECURITYDBO | FIXED_INCOME | FX_FIXING_PERIOD_MULTIPL | NUMBER(38IND | .../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) | .../FixedIncomeModel/fxFixingPeriodMultiplier | fxFixingPeriodDateType |
|
| legMultiplier | ||||||||||||||||||||||
notionalResetType | string | 120284409 | in_fxnotional_fixingreset_period_dt_type | S | SECURITYDBO | FIXED_INCOMESWAPS | FXNOTIONAL_FIXINGRESET_PERIOD_DT_TYPE | VARCHAR2(210) | .../FixedIncomeModel/fxFixingPeriodDateType | fxFixingBusDayConvention |
|
| notionalResetType | ||||||||||||||||||||||
rollConvention | string | 120294584 | in_fx_fixing_bus_day_convSroll_convention | SECURITYDBO | FIXED_INCOMESWAPS | FX_FIXING_BUS_DAY_CONVROLL_CONVENTION | VARCHAR2(210) | .../FixedIncomeModel/fxFixingBusDayConventionrollConvention | |||||||||||||||||||||||||||
fxFixingBusinessCentermaturityDate | Required | date | string38 | 12340 | in_fx_fixing_business_centermat_date | S | SECURITYDBO | FIXEDSECURITY_INCOMEMASTER | FX_FIXING_BUSINESS_CENTER | VARCHAR2(50)MAT_DATE | DATE | .../FixedIncomeModel/fxFixingBusinessCenter | fxFixingDtRelativeTo |
|
| maturityDate | |||||||||||||||||||
riskClassificationType | string | 1234111584 | in_fxrisk_fixing_dt_relative_toclassification_type | S | SECURITYDBO | FIXEDSECURITY_MASTER_INCOMEDETAIL | FXRISK_FIXING_DT_RELATIVE_TOCLASSIFICATION_TYPE | VARCHAR2(215) | .../FixedIncomeModel/fxFixingDtRelativeTo | fixingDtBusinessCenter |
| riskClassificationType | |||||||||||||||||||||||
delayDaysType | string | 164075074 | in_fixingsm_dtdelay_businessdays_centertype | S | SECURITYDBO | FIXEDSECURITY_INCOMEMASTER | FIXINGDELAY_DTDAYS_BUSINESS_CENTERTYPE | VARCHAR2(501) | .../FixedIncomeModel/fixingDtBusinessCenterdelayDaysTypeigFlag | ||||||||||||||||||||||||||
| rateConversionRule | string |
| YesNoOptionEnum | 16834 | in_ig_flag12849 | in_rate_conversion_rule | S | SECURITYDBO | DERIVATIVES | FIXEDRATE_ | INCOMEIGCONVERSION_ | FLAGRULE | VARCHAR2( | 120) | .../ | FixedIncomeModel/igFlagrateConversionRule | |||||||||||||||||||
| Anchor | Fixed_Income_Extension | Fixed_Income_Extension | Fixed Income Extension Model Data MapcpnDelayDays |
|
| integer | 4909 | in_cpn_delay_days | N | SECURITYDBO | FIXED_INCOME | CPN_DELAY_DAYS | NUMBER(38|||||||||||||||||||||||
| 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) | .../ | FixedIncomeExtensionMBSExtension/ | cpnDelayDaysarmInitFixedPeriodMonths | ||||||||||||||||||||||||
cpnDelayDaysTypeEquityModel | EquityModel | string | 3999 | in_CPN_DELAY_DAYS_TYPE | S | SECURITYDBO | FIXED_INCOME | CPN_DELAY_DAYS_TYPE | VARCHAR2(1).../EquityModel/ | ||||||||||||||||||||||||||
FixedIncomeModel | FixedIncomeModel | .../FixedIncomeModel/ | |||||||||||||||||||||||||||||||||
FixedIncomeExtension | FixedIncomeExtensionModel | .../FixedIncomeExtension/cpnDelayDaysType | |||||||||||||||||||||||||||||||||
SMExtension | SM_ExtensionSMExtensionModel | _ | SM Extension Data Map | prvtPlace |
|
| string | 1421 | in_prvt_place |
| SECURITYDBO | SECURITY_MASTER | PRVT_PLACE | CHAR(2).../SMExtension/ | |||||||||||||||||||||
UnderlyingModel | UnderlyingModel | .../UnderlyingModel/ | |||||||||||||||||||||||||||||||||
MultipleLegSwapModel | MultipleLegSwapModel | .../MultipleLegSwapModel/ | |||||||||||||||||||||||||||||||||
| CapsAndFloorsModel | CapsAndFloorsModel | Caps And Floors Model | .../ | SMExtension/prvtPlaceCapsAndFloorsModel | |||||||||||||||||||||||||||||||
| IndexModel | IndexModel |
| string | 11476 | in_sec_ext_granularity_cat | S | SECURITYDBO | SECURITY_MASTER_EXT | GRANULARITY_CATEGORY | CHAR(20) | .../SMExtension/granularityCategory | ||||||||||||||||||||||||
| Anchor | Underlying_Model | Underlying_Model | Underlying Model Data Map|||||||||||||||||||||||||||||||||
underlyingType |
|
| string | 916 | in_underlying_type | S | SECURITYDBO | UNDERLYING_SECURITY | UNDERLYING_TYPE | VARCHAR2(100) | .../UnderlyingModel/underlyingType | ||||||||||||||||||||||||
| Anchor | Multiple_Leg_Swap | Multiple_Leg_Swap | Multiple Leg Swap Model Data Map|||||||||||||||||||||||||||||||||
calculateFirstLastCouponDate |
|
| date | 2301 | This feature should NOT be used. Should be handled in RDC instead. Please consult with Eagle. | .../MultipleLegSwapModel/calculateFirstLastCouponDate | calculateValidateLastPaymentDate |
|
| StringWithCodeScheme | 2337 |
| not stored in DB |
| .../MultipleLegSwapModel/couponType | ||||||||||||||||||||
...
| 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 | ||||||||