Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

     anchorRepeated Group (contractLeg, payLeg,  

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

Equity Model Data Map TableFixed Income Model Data MapFixed Income Extension Model Data MapSM Extension Data MapUnderlying Model Data Map Multiple Leg Swap Model Data Map

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

 

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 (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/

NoteModelRepeated_Group

Repeated_GroupNoteModelNote ModelEagleML/referenceTransaction/multilegSMF/NoteModel/
issuer

issuerModelIssuer ModelEagleML/referenceTransaction/multilegSMF/issuer/

Anchor
Repeated_Group
Repeated_Group
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

 


SS

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

 

 



integerinteger

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



3609string

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



5074string

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/

Anchor
Equity_ModelEquity_Model

costBasisRuleType

 

 

string

2817

in_cost_basis_rule_type

S

SECURITYDBO

SECURITY_MASTER_DETAIL

COST_BASIS_RULE_TYPE

VARCHAR2(20)

.../EquityModel/costBasisRuleType

Anchor
Fixed_IncomeFixed_Income

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

Anchor
Fixed_Income_ExtensionFixed_Income_Extension

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

Anchor
SM_ExtensionSM_Extension

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

Anchor
Underlying_ModelUnderlying_Model

underlyingType

 

 

string

916

in_underlying_type

S

SECURITYDBO

UNDERLYING_SECURITY

UNDERLYING_TYPE

VARCHAR2(100)

.../UnderlyingModel/underlyingType

Anchor
Multiple_Leg_SwapMultiple_Leg_Swap

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

...

CapsAndFloorsModel

CapsAndFloorsModelCaps And Floors Model.../CapsAndFloorsModel
IndexModel

IndexModelIndex Model.../IndexModel
ScheduleModel

ScheduleModelSchedule Model.../ScheduleModel
IssueVariableRateModel

IssueVariableRateModelIssue Variable Rate Model.../IssueVariableRateModel
EarningsTimePeriodModel

EarningsTimePeriodModelEarnings Time Period Model.../EarningsTimePeriodModel
FloaterModel

FloaterModelFloater Model.../FloaterModel