/
MultiLeg SMF - Data Map Table

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

Ā