Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 4 Next »

 

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

contractLeg

 

 

SmfLegModel

Repeated Group

EagleML/referenceTransaction/multilegSMF/contractLeg

payLeg

 

 

SmfLegModel

Repeated Group 

EagleML/referenceTransaction/multilegSMF/payLeg

receiveLeg

 

 

SmfLegModel

Repeated Group

EagleML/referenceTransaction/multilegSMF/receiveLeg

Repeated Group (contractLeg, payLeg, receiveLeg) 

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

derivDate1

 

 

date

3321

in_derv_date1

 

SECURITYDBO

DERIVATIVES

DERV_DATE1

DATE

.../derivDate1

pRollConvention

 

 

string

3309

in_p_roll_convention

 

SECURITYDBO

DERIVATIVES

P_ROLL_CONVENTION

CHAR(2)

.../pRollConvention

rRollConvention

 

 

string

3310

in_r_roll_convention

 

SECURITYDBO

DERIVATIVES

R_ROLL_CONVENTION

CHAR(2)

.../rRollConvention

rCalcMethod

 

 

string

3314

in_r_calc_method

S

SECURITYDBO

DERIVATIVES

R_CALC_METHOD

CHAR(2)

.../rCalcMethod

clearedSecurity

 

 

string

5027

in_cleared_security

S

SECURITYDBO

DERIVATIVES

CLEARED_SECURITY

VARCHAR2(1)

.../clearedSecurity

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

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

EquityModel

 

 

EquityModel

Equity Model 

.../EquityModel/

FixedIncomeModel

 

 

FixedIncomeModel

Fixed Income Model

.../FixedIncomeModel/

FixedIncomeExtension

 

 

FixedIncomeExtensionModel

Fixed Income Extension Model

.../FixedIncomeExtension/

SMExtension

 

 

SMExtensionModel

SM Extension Model

.../SMExtension/

UnderlyingModel

 

 

UnderlyingModel

Underlying Model

.../UnderlyingModel/

MultipleLegSwapModel

 

 

MultipleLegSwapModel

Multiple Leg Swap Model

.../MultipleLegSwapModel/

 
The models below are similar to Generic SMF models, but unnecessary elements have been brushed out.
 

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

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_TYPE

VARCHAR2(1)

.../FixedIncomeModel/maturityDelayDaysType

dualCurrencyIndicator

 

 

string

11802

in_dual_currency_indicator

S

SECURITYDBO

FIXED_INCOME

DUAL_CURRENCY_INDICATOR

VARCHAR2(2)

.../FixedIncomeModel/dualCurrencyIndicator

dualCurConvFactor

 

 

decimal

11803

in_dual_cur_conv_factor

F

SECURITYDBO

FIXED_INCOME

DUAL_CUR_CONV_FACTOR

NUMBER(38,12)

.../FixedIncomeModel/dualCurConvFactor

principalCurrencyDc

 

 

string

11813

in_principal_currency_dc

S

SECURITYDBO

FIXED_INCOME

PRINCIPAL_CURRENCY_DC

VARCHAR2(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(38,12)

.../FixedIncomeModel/fxFixingPeriodMultiplier

fxFixingPeriodDateType

 

 

string

12028

in_fx_fixing_period_dt_type

S

SECURITYDBO

FIXED_INCOME

FX_FIXING_PERIOD_DT_TYPE

VARCHAR2(2)

.../FixedIncomeModel/fxFixingPeriodDateType

fxFixingBusDayConvention

 

 

string

12029

in_fx_fixing_bus_day_conv

S

SECURITYDBO

FIXED_INCOME

FX_FIXING_BUS_DAY_CONV

VARCHAR2(2)

.../FixedIncomeModel/fxFixingBusDayConvention

fxFixingBusinessCenter

 

 

string

12340

in_fx_fixing_business_center

S

SECURITYDBO

FIXED_INCOME

FX_FIXING_BUSINESS_CENTER

VARCHAR2(50)

.../FixedIncomeModel/fxFixingBusinessCenter

fxFixingDtRelativeTo

 

 

string

12341

in_fx_fixing_dt_relative_to

S

SECURITYDBO

FIXED_INCOME

FX_FIXING_DT_RELATIVE_TO

VARCHAR2(2)

.../FixedIncomeModel/fxFixingDtRelativeTo

fixingDtBusinessCenter

 

 

string

16407

in_fixing_dt_business_center

S

SECURITYDBO

FIXED_INCOME

FIXING_DT_BUSINESS_CENTER

VARCHAR2(50)

.../FixedIncomeModel/fixingDtBusinessCenter

igFlag

 

 

YesNoOptionEnum

16834

in_ig_flag

S

SECURITYDBO

FIXED_INCOME

IG_FLAG

VARCHAR2(1)

.../FixedIncomeModel/igFlag

Fixed Income Extension Model Data Map

cpnDelayDays

 

 

integer

4909

in_cpn_delay_days

N

SECURITYDBO

FIXED_INCOME

CPN_DELAY_DAYS

NUMBER(38)

.../FixedIncomeExtension/cpnDelayDays

cpnDelayDaysType

 

 

string

3999

in_CPN_DELAY_DAYS_TYPE

S

SECURITYDBO

FIXED_INCOME

CPN_DELAY_DAYS_TYPE

VARCHAR2(1)

.../FixedIncomeExtension/cpnDelayDaysType

SM Extension Data Map

prvtPlace

 

 

string

1421

in_prvt_place

 

SECURITYDBO

SECURITY_MASTER

PRVT_PLACE

CHAR(2)

.../SMExtension/prvtPlace

granularityCategory

 

 

string

11476

in_sec_ext_granularity_cat

S

SECURITYDBO

SECURITY_MASTER_EXT

GRANULARITY_CATEGORY

CHAR(20)

.../SMExtension/granularityCategory

Underlying Model Data Map 

underlyingType

 

 

string

916

in_underlying_type

S

SECURITYDBO

UNDERLYING_SECURITY

UNDERLYING_TYPE

VARCHAR2(100)

.../UnderlyingModel/underlyingType

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

  • No labels