MultiLeg SMF - Data Map Table

The tradingFlat element is required, when accountingValidationFlag ='Y' and processingSecurityType = 'DBFLTP' OR 'DBIBFD' OR 'DBIBMU' OR 'DBIBPK' OR 'DBIVIV' OR 'DBMFDD' OR 'DBAMTL' OR 'DBIBTL' and FixedIncomeModel/fiDetChar25 = 'NONE'.

Element

Required Inbound Acct Validation

Required Inbound Data Mgt

Value Type

Star Tag

SP Parameter

SP Type

Eagle DB

DB Table

DB Field

DB Field Type

Xpath

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/

Repeated Group (contractLeg, payLeg, receiveLeg) Data Map Table

investmentType

Required

 

StringWithCodeScheme

11

in_investment_type

S

SECURITYDBO

SECURITY_MASTER

INVESTMENT_TYPE

CHAR(4)

.../investmentType

processingSecurityType

Required

 

StringWithCodeScheme

3931

in_process_sec_type

S

SECURITYDBO

SECURITY_MASTER

PROCESS_SEC_TYPE

VARCHAR2(15)

.../processingSecurityType

securityType

 

 

string

82

in_security_type

S

SECURITYDBO

SECURITY_MASTER

SECURITY_TYPE

CHAR(15)

.../securityType

securitySubType

 

 

string

1464

in_alt_security_type

S

SECURITYDBO

SECURITY_MASTER_DETAIL

ALT_SECURITY_TYPE

CHAR(15)

.../securitySubType

settlementCurrency

Required - Defaulted to "Asset Currency" by panel

 

CurrencyCode

63

in_settlement_currency

S

SECURITYDBO

SECURITY_MASTER

SETTLEMENT_CURRENCY

CHAR(3)

.../settlementCurrency

incomeCurrency

Required - Defaulted to "Asset Currency" by panel

 

CurrencyCode

1186

in_sm_income_currency

S

SECURITYDBO

SECURITY_MASTER

INCOME_CURRENCY

CHAR(3)

.../incomeCurrency

quantityType

Required - Defaulted to "PAR" by Panel

 

StringWithCodeScheme

12

in_quantity_type

S

SECURITYDBO

SECURITY_MASTER

QUANTITY_TYPE

CHAR(12)

.../quantityType

priceMultiplier

Required - Defaulted to "0.01" by Panel

 

decimal

18

in_price_multiplier

F

SECURITYDBO

SECURITY_MASTER

PRICE_MULTIPLIER

NUMBER(28,12)

.../priceMultiplier

quantityScale

Required - Defaulted to "1" by Panel

 

decimal

19

in_sm_trading_unit

F

SECURITYDBO

SECURITY_MASTER

TRADING_UNIT

NUMBER(28,12)

.../quantityScale

issueCountry

 

 

string

2290

 

S

not stored in DB [used for issueCountryCode calculation]

 

.../issueCountry

issueCountryCode

Required

 

CountryCode

1418

in_nra_tax_country

S

SECURITYDBO

SECURITY_MASTER

NRA_TAX_COUNTRY

CHAR(30)

.../issueCountryCode

countryOfRisk

 

 

string

2288

 

 

not stored in DB [used for countryOfRiskCode calculation] 

 

.../countryOfRisk

countryOfRiskCode

 

 

CountryCode

10536

in_country_of_risk

S

SECURITYDBO

SECURITY_MASTER_DETAIL

COUNTRY_OF_RISK

VARCHAR2(20)

.../countryOfRiskCode

issueTaxType

 

 

string

668

in_issue_tax_type

S

SECURITYDBO

SECURITY_MASTER_DETAIL

ISSUE_TAX_TYPE

VARCHAR2(30)

.../issueTaxType

region

 

 

string

5423

in_region

S

SECURITYDBO

SECURITY_MASTER_DETAIL

REGION

VARCHAR2(50)

.../region

lookThroughIndicator

 

 

StringWithCodeScheme

1776

in_look_thru_ind

S

SECURITYDBO

SECURITY_MASTER_DETAIL

LOOK_THRU_IND

CHAR(3)

.../lookThroughIndicator

lookThroughValue

 

 

string

1808

in_look_thru_value

S

SECURITYDBO

SECURITY_MASTER_DETAIL

LOOK_THRU_VALUE

VARCHAR2(15)

.../lookThroughValue

payLegCompoundingIndicator

 

 

string

11875

in_compounding_indicator

S

SECURITYDBO

FIXED_INCOME

COMPOUNDING_INDICATOR

VARCHAR2(1)

.../payLegCompoundingIndicator

tradingFlat

Required - Defaulted to "No" by panel See the note

 

YesNoOptionEnum

3949

in_trading_flat

S

SECURITYDBO

SECURITY_MASTER_DETAIL

TRADING_FLAT

VARCHAR2(10)

.../tradingFlat

offset

 

 

decimal

215

in_offset

N

SECURITYDBO

DERIVATIVES

OFFSET

NUMBER

.../offset

rCouponType

 

 

string

1366

in_r_coupon_type

S

SECURITYDBO

DERIVATIVES

R_COUPON_TYPE

VARCHAR2(30)

.../rCouponType

swapMaturity

 

 

date

1369

in_swap_maturity

S

SECURITYDBO

DERIVATIVES

SWAP_MATURITY

DATE

.../swapMaturity

underlyingCusip

 

 

string

1348

in_underlying_cusip

S

SECURITYDBO

DERIVATIVES

UNDERLYING_CUSIP

CHAR(100)

.../underlyingCusip

underlyingSecurity

Required

 

string

1141

in_underlying_security

S

SECURITYDBO

DERIVATIVES

UNDERLYING_SECURITY

VARCHAR2(255)

.../underlyingSecurity

underlyingSecAlias

 

 

integer

1347

in_underlying_sec_alias

N

SECURITYDBO

DERIVATIVES

UNDERLYING_SEC_ALIAS

NUMBER

.../underlyingSecAlias

derivChar1

 

 

string

3317

in_derv_char1

 

SECURITYDBO

DERIVATIVES

DERV_CHAR1

VARCHAR2(30)

.../derivChar1

derivChar2

 

 

string

3318

in_derv_char2

 

SECURITYDBO

DERIVATIVES

DERV_CHAR2

VARCHAR2(30)

.../derivChar2

derivChar3

 

 

string

3622

in_derv_char3

 

SECURITYDBO

DERIVATIVES

DERV_CHAR3

VARCHAR2(30)

.../derivChar3

derivChar4

 

 

string

3319

in_derv_char4

 

SECURITYDBO

DERIVATIVES

DERV_CHAR4

VARCHAR2(30)

.../derivChar4

derivChar5

 

 

string

3320

in_derv_char5

 

SECURITYDBO

DERIVATIVES

DERV_CHAR5

VARCHAR2(30)

.../derivChar5

derivChar6

 

 

string

3605

in_derv_char6

 

SECURITYDBO

DERIVATIVES

DERV_CHAR6

VARCHAR2(30)

.../derivChar6

derivChar7

 

 

string

3606

in_derv_char7

 

SECURITYDBO

DERIVATIVES

DERV_CHAR7

VARCHAR2(30)

.../derivChar7

derivChar8

 

 

string

3607

in_derv_char8

 

SECURITYDBO

DERIVATIVES

DERV_CHAR8

VARCHAR2(30)

.../derivChar8

derivChar9

 

 

string

3608

in_derv_char9

 

SECURITYDBO

DERIVATIVES

DERV_CHAR9

VARCHAR2(30)

.../derivChar9

derivChar10

 

 

string

3609

in_derv_char10

 

SECURITYDBO

DERIVATIVES

DERV_CHAR10

VARCHAR2(30)

.../derivChar10

derivChar11

 

 

string

8259

in_derv_char11

 

SECURITYDBO

DERIVATIVES

DERV_CHAR11

VARCHAR2(30)

.../derivChar11

derivChar12

 

 

string

8260

in_derv_char12

 

SECURITYDBO

DERIVATIVES

DERV_CHAR12

VARCHAR2(30)

.../derivChar12

derivChar13

 

 

string

8261

in_derv_char13

 

SECURITYDBO

DERIVATIVES

DERV_CHAR13

VARCHAR2(30)

.../derivChar13

derivChar14

 

 

string

8262

in_derv_char14

 

SECURITYDBO

DERIVATIVES

DERV_CHAR14

VARCHAR2(30)

.../derivChar14

derivChar15

 

 

string

8263

in_derv_char15

 

SECURITYDBO

DERIVATIVES

DERV_CHAR15

VARCHAR2(30)

.../derivChar15

derivChar16

 

 

string

8264

in_derv_char16

 

SECURITYDBO

DERIVATIVES

DERV_CHAR16

VARCHAR2(30)

.../derivChar16

derivChar17

 

 

string

8265

in_derv_char17

 

SECURITYDBO

DERIVATIVES

DERV_CHAR17

VARCHAR2(30)

.../derivChar17

derivChar18

 

 

string

8566

in_derv_char18

 

SECURITYDBO

DERIVATIVES

DERV_CHAR18

VARCHAR2(30)

.../derivChar18

derivChar19

 

 

string

8567

in_derv_char19

 

SECURITYDBO

DERIVATIVES

DERV_CHAR19

VARCHAR2(30)

.../derivChar19

derivChar20

 

 

string

8568

in_derv_char20

 

SECURITYDBO

DERIVATIVES

DERV_CHAR20

VARCHAR2(30)

.../derivChar20

derivChar21

 

 

string

8774

in_derv_char21

 

SECURITYDBO

DERIVATIVES

DERV_CHAR21

VARCHAR2(30)

.../derivChar21

derivChar22

 

 

string

8775

in_derv_char22

 

SECURITYDBO

DERIVATIVES

DERV_CHAR22

VARCHAR2(30)

.../derivChar22

derivChar23

 

 

string

8776

in_derv_char23

 

SECURITYDBO

DERIVATIVES

DERV_CHAR23

VARCHAR2(30)

.../derivChar23

derivChar24

 

 

string

8777

in_derv_char24

 

SECURITYDBO

DERIVATIVES

DERV_CHAR24

VARCHAR2(30)

.../derivChar24

derivChar25

 

 

string

8778

in_derv_char25

 

SECURITYDBO

DERIVATIVES

DERV_CHAR25

VARCHAR2(30)

.../derivChar25

derivChar26

 

 

string

16660

in_derv_char26

 

SECURITYDBO

DERIVATIVES

DERV_CHAR26

VARCHAR2(30)

.../derivChar26

derivFloat1

 

 

decimal

3326

in_derv_float1

 

SECURITYDBO

DERIVATIVES

DERV_FLOAT1

 

.../derivFloat1

derivFloat2

 

 

decimal

3327

in_derv_float2

 

SECURITYDBO

DERIVATIVES

DERV_FLOAT2

 

.../derivFloat2

derivFloat3

 

 

decimal

3328

in_derv_float3

 

SECURITYDBO

DERIVATIVES

DERV_FLOAT3

 

.../derivFloat3

derivFloat4

 

 

decimal

3329

in_derv_float4

 

SECURITYDBO

DERIVATIVES

DERV_FLOAT4

 

.../derivFloat4

derivFloat5

 

 

decimal

3330

in_derv_float5

 

SECURITYDBO

DERIVATIVES

DERV_FLOAT5

 

.../derivFloat5

derivFloat6

 

 

decimal

8254

in_derv_float6

 

SECURITYDBO

DERIVATIVES

DERV_FLOAT6

 

.../derivFloat6

derivFloat7

 

 

decimal

8255

in_derv_float7

 

SECURITYDBO

DERIVATIVES

DERV_FLOAT7

 

.../derivFloat7

derivFloat8

 

 

decimal

8256

in_derv_float8

 

SECURITYDBO

DERIVATIVES

DERV_FLOAT8

 

.../derivFloat8

derivFloat9

 

 

decimal

8257

in_derv_float9

 

SECURITYDBO

DERIVATIVES

DERV_FLOAT9

 

.../derivFloat9

derivFloat10

 

 

decimal

8258

in_derv_float10

 

SECURITYDBO

DERIVATIVES

DERV_FLOAT10

 

.../derivFloat10

derivFloat11

 

 

decimal

8769

in_derv_float11

 

SECURITYDBO

DERIVATIVES

DERV_FLOAT11

 

.../derivFloat11

derivFloat12

 

 

decimal

8770

in_derv_float12

 

SECURITYDBO

DERIVATIVES

DERV_FLOAT12

 

.../derivFloat12

derivFloat13

 

 

decimal

8771

in_derv_float13

 

SECURITYDBO

DERIVATIVES

DERV_FLOAT13

 

.../derivFloat13

derivFloat14

 

 

decimal

8772

in_derv_float14

 

SECURITYDBO

DERIVATIVES

DERV_FLOAT14

 

.../derivFloat14

derivFloat15

 

 

decimal

8773

in_derv_float15

 

SECURITYDBO

DERIVATIVES

DERV_FLOAT15

 

.../derivFloat15

derivDate1

 

 

date

3321

in_derv_date1

 

SECURITYDBO

DERIVATIVES

DERV_DATE1

DATE

.../derivDate1

derivDate2

 

 

date

3322

in_derv_date2

 

SECURITYDBO

DERIVATIVES

DERV_DATE2

DATE

.../derivDate2

derivDate3

 

 

date

3323

in_derv_date3

 

SECURITYDBO

DERIVATIVES

DERV_DATE3

DATE

.../derivDate3

derivDate4

 

 

date

3324

in_derv_date4

 

SECURITYDBO

DERIVATIVES

DERV_DATE4

DATE

.../derivDate4

derivDate5

 

 

date

3325

in_derv_date5

 

SECURITYDBO

DERIVATIVES

DERV_DATE5

DATE

.../derivDate5

pmtAtIndicator

 

 

string

3604

in_pmt_at_indicator

 

SECURITYDBO

DERIVATIVES

PMT_AT_INDICATOR

 

.../pmtAtIndicator

pArrearsFlag

 

 

string

3602

in_p_arrears_flag

 

SECURITYDBO

DERIVATIVES

P_ARREARS_FLAG

 

.../pArrearsFlag

pCalcMethod

 

 

string

3313

in_p_calc_method

 

SECURITYDBO

DERIVATIVES

P_CALC_METHOD

 

.../pCalcMethod

pCompoundingInd

 

 

string

3311

in_p_compounding_ind

 

SECURITYDBO

DERIVATIVES

P_COMPOUNDING_IND

 

.../pCompoundingInd

pDivdCarryFlag

 

 

string

3305

in_p_divd_carry_flag

 

SECURITYDBO

DERIVATIVES

P_DIVD_CARRY_FLAG

 

.../pDivdCarryFlag

pDivdReinvFlag

 

 

string

3303

in_p_divd_reinv_flag

 

SECURITYDBO

DERIVATIVES

P_DIVD_REINV_FLAG

 

.../pDivdReinvFlag

pLegType

 

 

string

3307

in_p_leg_type

 

SECURITYDBO

DERIVATIVES

P_LEG_TYPE

 

.../pLegType

pMultiplier

 

 

string

3600

in_p_multiplier

 

SECURITYDBO

DERIVATIVES

P_MULTIPLIER

 

.../pMultiplier

premiumType

 

 

string

3302

in_premium_type

 

SECURITYDBO

DERIVATIVES

PREMIUM_TYPE

 

.../premiumType

pRollConvention

 

 

string

3309

in_p_roll_convention

 

SECURITYDBO

DERIVATIVES

P_ROLL_CONVENTION

CHAR(2)

.../pRollConvention

pSpreadAmt

 

 

decimal

3315

in_p_spread_amt

 

SECURITYDBO

DERIVATIVES

P_SPREAD_AMT

 

.../pSpreadAmt

returnType

 

 

string

3598

in_return_type

 

SECURITYDBO

DERIVATIVES

RETURN_TYPE

 

.../returnType

rDivdCarryFlag

 

 

string

3306

in_r_divd_carry_flag

 

SECURITYDBO

DERIVATIVES

R_DIVD_CARRY_FLAG

 

.../rDivdCarryFlag

rDivdReinvFlag

 

 

string

3304

in_r_divd_reinv_flag

 

SECURITYDBO

DERIVATIVES

R_DIVD_REINV_FLAG

 

.../rDivdReinvFlag

rLegType

 

 

string

3308

in_r_leg_type

 

SECURITYDBO

DERIVATIVES

R_LEG_TYPE

 

.../rLegType

rMultiplier

 

 

decimal

3601

in_r_multiplier

 

SECURITYDBO

DERIVATIVES

R_MULTIPLIER

 

.../rMultiplier

rRollConvention

 

 

string

3310

in_r_roll_convention

 

SECURITYDBO

DERIVATIVES

R_ROLL_CONVENTION

CHAR(2)

.../rRollConvention

rSpreadAmt

 

 

decimal

3316

in_r_spread_amt

 

SECURITYDBO

DERIVATIVES

R_SPREAD_AMT

 

.../rSpreadAmt

rArrearsFlag

 

 

string

3603

in_r_arrears_flag

 

SECURITYDBO

DERIVATIVES

R_ARREARS_FLAG

 

.../rArrearsFlag

rCalcMethod

 

 

string

3314

in_r_calc_method

S

SECURITYDBO

DERIVATIVES

R_CALC_METHOD

CHAR(2)

.../rCalcMethod

rCompoundingInd

 

 

string

3312

in_r_compounding_ind

 

SECURITYDBO

DERIVATIVES

R_COMPOUNDING_IND

 

.../rCompoundingInd

underlyingCmpid

 

 

string

12385

in_underlying_cmpid

 

SECURITYDBO

DERIVATIVES

UNDERLYING_CMPID

 

.../underlyingCmpid

underlyingSecid

 

 

string

12386

in_underlying_secid

 

SECURITYDBO

DERIVATIVES

UNDERLYING_SECID

 

.../underlyingSecid

clearedSecurity

 

 

string

5027

in_cleared_security

S

SECURITYDBO

DERIVATIVES

CLEARED_SECURITY

VARCHAR2(1)

.../clearedSecurity

calcMethod

 

 

string

4589

in_calc_method

 

SECURITYDBO

SWAPS

CALC_METHOD

 

.../calcMethod

compoundAccrMethod

 

 

string

4590

in_compound_accr_method

 

SECURITYDBO

SWAPS

COMPOUND_ACCR_METHOD

 

.../compoundAccrMethod

compoundIndicator

 

 

string

1364

in_compound_flag

 

SECURITYDBO

SWAPS

COMPOUND_FLAG

 

.../compoundIndicator

finalExchangeOfPrincipal

 

 

string

8555

in_final_exchg_prin

S

SECURITYDBO

SWAPS

FINAL_EXCHG_PRIN

VARCHAR2(1)

.../finalExchangeOfPrincipal

initialExchangeOfPrincipal

Required

 

string

8554

in_init_exchg_prin

S

SECURITYDBO

SWAPS

INIT_EXCHG_PRIN

VARCHAR2(1)

.../initialExchangeOfPrincipal

swapType

 

 

string

4590,1364

in_pay_receive_ind
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

overrideSecurityMasterDates

 

 

YesNoOptionEnum

7171

 

 

not stored in DB, used only when processingSecurityType = 'SWLEDB'

.../overrideSecurityMasterDates

schedulePaymentFrequency

 

 

string

7164

 

 

not stored in DB, used only when processingSecurityType = 'SWLEDB'

.../schedulePaymentFrequency

schedulePaymentFrequencyCode

 

 

string

7165

 

 

not stored in DB, used only when processingSecurityType = 'SWLEDB'

.../schedulePaymentFrequencyCode

scheduleFirstValuationDate

 

 

date

7562

 

 

not stored in DB, used only when processingSecurityType = 'SWLEDB'

.../scheduleFirstValuationDate

scheduleLastValuationDate

 

 

date

7561

 

 

not stored in DB, used only when processingSecurityType = 'SWLEDB'

.../scheduleLastValuationDate

scheduleBusinessDayConvention

 

 

string

7166

 

 

not stored in DB, used only when processingSecurityType = 'SWLEDB'

.../scheduleBusinessDayConvention

scheduleCouponDayOfMonth

 

 

decimal

7320

 

 

not stored in DB, used only when processingSecurityType = 'SWLEDB'

.../scheduleCouponDayOfMonth

scheduleBusinessCalendarName

 

 

string

7167

 

 

not stored in DB, used only when processingSecurityType = 'SWLEDB'

.../scheduleBusinessCalendarName

scheduleDayOfMonthOverride

 

 

string

7168

 

 

not stored in DB, used only when processingSecurityType = 'SWLEDB'

.../scheduleDayOfMonthOverride

scheduleCouponDelayDays

 

 

decimal

7321

 

 

not stored in DB, used only when processingSecurityType = 'SWLEDB'

.../scheduleCouponDelayDays

scheduleCouponDelayDaysType

 

 

string

7169

 

 

not stored in DB, used only when processingSecurityType = 'SWLEDB'

.../scheduleCouponDelayDaysType

scheduleDelayDays

 

 

decimal

7322

 

 

not stored in DB, used only when processingSecurityType = 'SWLEDB'

.../scheduleDelayDays

scheduleDelayDaysType

 

 

string

7170

 

 

not stored in DB, used only when processingSecurityType = 'SWLEDB'

.../scheduleDelayDaysType

EquityModel

 

 

EquityModel

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/

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