Generic SMF - Underlying Model Data Map 

Element

Required Inbound Acct Validation

Required Inbound Data Mgt

Value Type

Star Tag

SP Parameter

SP Type

Include File Name

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

Include File Name

Eagle DB

DB Table

DB Field

DB Field Type

Xpath

Asset Identifiers Model

EagleML/referenceTransaction/genericSMF/UnderlyingModel/

investmentType

 

 

StringWithCodeScheme

11

in_investment_type

S

 

 

 

 

 

EagleML/referenceTransaction/genericSMF/investmentType

processingSecurityType

 

 

StringWithCodeScheme

3931

in_process_sec_type

S

 

 

 

 

 

EagleML/referenceTransaction/genericSMF/processingSecurityType

underlyingRate

 

 

decimal

3611

in_underlying_rate

F

underlyingsmf_model.inc

SECURITYDBO

UNDERLYING_SECURITY

UNDERLYING_RATE

NUMBER(28,12)

EagleML/referenceTransaction/genericSMF/UnderlyingModel/underlyingRate

underlyingPrice

 

 

decimal

3612

 in_underlying_price

F

underlyingsmf_model.inc

SECURITYDBO

UNDERLYING_SECURITY

UNDERLYING_PRICE

NUMBER(28,12)

EagleML/referenceTransaction/genericSMF/UnderlyingModel/underlyingPrice

underlyingSecurityIncomeProcessingFlag

 

 

string

9712

 in_stream_flag

S

underlyingsmf_model.inc

SECURITYDBO

UNDERLYING_SECURITY

STREAM_FLAG

VARCHAR2(1)

EagleML/referenceTransaction/genericSMF/UnderlyingModel/underlyingSecurityIncomeProcessingFlag

baseContractXreferenceIdAndType

 

 

AssetIdAndAssetIdType

EagleML/referenceTransaction/genericSMF/UnderlyingModel/baseContractXreferenceIdAndType/

nonFundedIndicator

 

 

string

905

in_non_fund_flag

S

underlyingsmf_model.inc

SECURITYDBO

UNDERLYING_SECURITY

NON_FUND_FLAG

VARCHAR2(1)

EagleML/referenceTransaction/genericSMF/UnderlyingModel/nonFundedIndicator

securityGlobalAmount

 

 

decimal

909

in_security_amount

I

underlyingsmf_model.inc

SECURITYDBO

UNDERLYING_SECURITY

SECURITY_AMOUNT

NUMBER(38,12)

EagleML/referenceTransaction/genericSMF/UnderlyingModel/securityGlobalAmount

underlyingSecurityAmount

 

 

decimal

911

in_underlying_amount

I

underlyingsmf_model.inc

SECURITYDBO

UNDERLYING_SECURITY

UNDERLYING_AMOUNT

NUMBER(38,12)

EagleML/referenceTransaction/genericSMF/UnderlyingModel/underlyingSecurityAmount

underlyingPercentage

 

 

decimal

912

in_underlying_pct

I

underlyingsmf_model.inc

SECURITYDBO

UNDERLYING_SECURITY

UNDERLYING_PCT

NUMBER(38,12)

EagleML/referenceTransaction/genericSMF/UnderlyingModel/underlyingPercentage

underlyingType

 

 

string

916

in_underlying_type

S

underlyingsmf_model.inc

SECURITYDBO

UNDERLYING_SECURITY

UNDERLYING_TYPE

VARCHAR2(100)

EagleML/referenceTransaction/genericSMF/UnderlyingModel/underlyingType

reasonDescription

 

 

string

56

in_reason

S

 

SECURITYDBO

UNDERLYING_SECURITY

REASON

 

EagleML/referenceTransaction/genericSMF/UnderlyingModel/reasonDescription

underlyingChar1

 

 

string

3613

in_underlying_char1

S

underlyingsmf_model.inc

SECURITYDBO

UNDERLYING_SECURITY

UNDERLYING_CHAR1

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/UnderlyingModel/underlyingChar1

underlyingChar2

 

 

string

3614

in_underlying_char2

S

underlyingsmf_model.inc

SECURITYDBO

UNDERLYING_SECURITY

UNDERLYING_CHAR2

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/UnderlyingModel/underlyingChar2

underlyingChar3

 

 

string

3615

in_underlying_char3

S

underlyingsmf_model.inc

SECURITYDBO

UNDERLYING_SECURITY

UNDERLYING_CHAR3

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/UnderlyingModel/underlyingChar3

underlyingFloat1

 

 

decimal

3616

in_underlying_float1

F

underlyingsmf_model.inc

SECURITYDBO

UNDERLYING_SECURITY

UNDERLYING_FLOAT1

NUMBER(28,12)

EagleML/referenceTransaction/genericSMF/UnderlyingModel/underlyingFloat1

underlyingFloat2

 

 

decimal

3617

in_underlying_float2

F

underlyingsmf_model.inc

SECURITYDBO

UNDERLYING_SECURITY

UNDERLYING_FLOAT2

NUMBER(28,12)

EagleML/referenceTransaction/genericSMF/UnderlyingModel/underlyingFloat2

underlyingFloat3

 

 

decimal

3618

in_underlying_float3

F

underlyingsmf_model.inc

SECURITYDBO

UNDERLYING_SECURITY

UNDERLYING_FLOAT3

NUMBER(28,12)

EagleML/referenceTransaction/genericSMF/UnderlyingModel/underlyingFloat3

underlyingDate1

 

 

date

3619

in_underlying_date1

S

underlyingsmf_model.inc

SECURITYDBO

UNDERLYING_SECURITY

UNDERLYING_DATE1

DATE

EagleML/referenceTransaction/genericSMF/UnderlyingModel/underlyingDate1

underlyingDate2

 

 

date

3620

in_underlying_date2

S

underlyingsmf_model.inc

SECURITYDBO

UNDERLYING_SECURITY

UNDERLYING_DATE2

DATE

EagleML/referenceTransaction/genericSMF/UnderlyingModel/underlyingDate2

underlyingDate3

 

 

date

3621

in_underlying_date3

S

underlyingsmf_model.inc

SECURITYDBO

UNDERLYING_SECURITY

UNDERLYING_DATE3

DATE

EagleML/referenceTransaction/genericSMF/UnderlyingModel/underlyingDate3

beginDate

Required

 

date

71

in_begin_date

S

underlyingsmf_model.inc

SECURITYDBO

UNDERLYING_SECURITY

BEGIN_DATE

DATE

EagleML/referenceTransaction/genericSMF/UnderlyingModel/beginDate

endDate

 

 

date

73

in_end_date

S

underlyingsmf_model.inc

SECURITYDBO

UNDERLYING_SECURITY

END_DATE

DATE

EagleML/referenceTransaction/genericSMF/UnderlyingModel/endDate