Generic SMF - Schedule Model Data Map 

Schedule Model is separated by the smf_mi stream and loaded as a Schedule EagleML object - so you should use SCHEDULEEXTRACT feedtype to extract it.

Please note:

  • price and rate are being loaded into the same DB field via the same tag. In case both elements are specified, price has a higher priority than rate (if price is empty or missing, rate value is used).

  • scheduleSubType and scheduleType have their mappings reversed - no mistake here, this is how core fields are mapped in the SP and cannot be changed.

Element

Comments

Value Type

Star Tag

SP Parameter

Eagle DB

DB Table

DB Field

DB Field Type

Xpath

Element

Comments

Value Type

Star Tag

SP Parameter

Eagle DB

DB Table

DB Field

DB Field Type

Xpath

scheduleId

 

string

3251

in_schedule_char1

SECURITYDBO

SCHEDULE

SCHEDULE_CHAR1

VARCHAR2(30)

EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleId

scheduleType

 

ScheduleTypeEnum

1250

in_schedule_sub_type

SECURITYDBO

SCHEDULE

SCHEDULE_SUB_TYPE

CHAR(8)

EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleType

scheduleSubType

Required

string

3678

in_schedule_type

SECURITYDBO

SCHEDULE

SCHEDULE_TYPE

CHAR(4)

EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleSubType

scheduleStatus

 

ScheduleStatusEnum

1670

in_schedule_status

SECURITYDBO

SCHEDULE

SCHEDULE_STATUS

VARCHAR2(12)

EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleStatus

price

 

decimal

1249

in_schedule_price

SECURITYDBO

SCHEDULE

SCHEDULE_PRICE

NUMBER(28,12)

EagleML/referenceTransaction/genericSMF/ScheduleModel/price

rate

 

decimal

1249

in_schedule_price

SECURITYDBO

SCHEDULE

SCHEDULE_PRICE

NUMBER(28,12)

EagleML/referenceTransaction/genericSMF/ScheduleModel/rate

scheduleAmount

 

decimal

1669

in_schedule_amount

SECURITYDBO

SCHEDULE

SCHEDULE_AMOUNT

NUMBER(28,12)

EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleAmount

scheduleFloat1

 

decimal

5534

in_schedule_float1

SECURITYDBO

SCHEDULE

SCHEDULE_FLOAT1

NUMBER(28,12)

EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleFloat1

endDate

 

date

73

in_end_date

SECURITYDBO

SCHEDULE

END_DATE

DATE

EagleML/referenceTransaction/genericSMF/ScheduleModel/endDate

accrualDateCust

 

date

8504

in_accrual_date_cust

SECURITYDBO

SCHEDULE

ACCRUAL_DATE_CUST

DATE

EagleML/referenceTransaction/genericSMF/ScheduleModel/accrualDateCust

determDate1

 

date

 

 

not stored in DB

 

EagleML/referenceTransaction/genericSMF/ScheduleModel/determDate1

determDate2

 

date

 

 

not stored in DB

 

EagleML/referenceTransaction/genericSMF/ScheduleModel/determDate2

nextAccrualDate

 

date

8502

in_next_accrual_date

SECURITYDBO

SCHEDULE

NEXT_ACCRUAL_DATE

DATE

EagleML/referenceTransaction/genericSMF/ScheduleModel/nextAccrualDate

payDate

 

date

8503

in_pay_date

SECURITYDBO

SCHEDULE

PAY_DATE

DATE

EagleML/referenceTransaction/genericSMF/ScheduleModel/payDate

nextCallDate

 

date

1241

in_next_call_date

SECURITYDBO

SCHEDULE

NEXT_CALL_DATE

DATE

EagleML/referenceTransaction/genericSMF/ScheduleModel/nextCallDate

nextCallPrice

 

decimal

1242

in_next_call_price

SECURITYDBO

SCHEDULE

NEXT_CALL_PRICE

NUMBER(28,12)

EagleML/referenceTransaction/genericSMF/ScheduleModel/nextCallPrice

nextPutDate

 

date

1243

in_next_put_date

SECURITYDBO

SCHEDULE

NEXT_PUT_DATE

DATE

EagleML/referenceTransaction/genericSMF/ScheduleModel/nextPutDate

nextPutPrice

 

decimal

1244

in_next_put_price

SECURITYDBO

SCHEDULE

NEXT_PUT_PRICE

NUMBER(28,12)

EagleML/referenceTransaction/genericSMF/ScheduleModel/nextPutPrice

parCallDate

 

date

1245

in_par_call_date

SECURITYDBO

SCHEDULE

PAR_CALL_DATE

DATE

EagleML/referenceTransaction/genericSMF/ScheduleModel/parCallDate

parPutDate

 

date

1246

in_par_put_date

SECURITYDBO

SCHEDULE

PAR_PUT_DATE

DATE

EagleML/referenceTransaction/genericSMF/ScheduleModel/parPutDate

scheduleChar1

 

string

3664

in_schedule_char1

SECURITYDBO

SCHEDULE

SCHEDULE_CHAR1

VARCHAR2(30)

EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleChar1

scheduleChar2

 

string

3665

in_schedule_char2

SECURITYDBO

SCHEDULE

SCHEDULE_CHAR2

VARCHAR2(30)

EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleChar2

scheduleChar3

 

string

3666

in_schedule_char3

SECURITYDBO

SCHEDULE

SCHEDULE_CHAR3

VARCHAR2(30)

EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleChar3

scheduleChar4

 

string

3667

in_schedule_char4

SECURITYDBO

SCHEDULE

SCHEDULE_CHAR4

VARCHAR2(30)

EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleChar4

scheduleChar5

 

string

3668

in_schedule_char5

SECURITYDBO

SCHEDULE

SCHEDULE_CHAR5

VARCHAR2(30)

EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleChar5

scheduleDate1

 

date

3669

in_schedule_date1

SECURITYDBO

SCHEDULE

SCHEDULE_DATE1

DATE

EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleDate1

scheduleDate2

 

date

3670

in_schedule_date2

SECURITYDBO

SCHEDULE

SCHEDULE_DATE2

DATE

EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleDate2

scheduleDate3

 

date

3671

in_schedule_date3

SECURITYDBO

SCHEDULE

SCHEDULE_DATE3

DATE

EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleDate3

scheduleDate4

 

date

3672

in_schedule_date4

SECURITYDBO

SCHEDULE

SCHEDULE_DATE4

DATE

EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleDate4

scheduleDate5

 

date

3673

in_schedule_date5

SECURITYDBO

SCHEDULE

SCHEDULE_DATE5

DATE

EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleDate5

scheduleDate6

 

date

8279

in_schedule_date6

SECURITYDBO

SCHEDULE

SCHEDULE_DATE6

DATE

EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleDate6

scheduleDate7

 

date

8280

in_schedule_date7

SECURITYDBO

SCHEDULE

SCHEDULE_DATE7

DATE

EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleDate7

scheduleDate8

 

date

8281

in_schedule_date8

SECURITYDBO

SCHEDULE

SCHEDULE_DATE8

DATE

EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleDate8

scheduleDate9

 

date

8282

in_schedule_date9

SECURITYDBO

SCHEDULE

SCHEDULE_DATE9

DATE

EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleDate9

scheduleDate10

 

date

8283

in_schedule_date10

SECURITYDBO

SCHEDULE

SCHEDULE_DATE10

DATE

EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleDate10

scheduleFloat2

 

decimal

5235

in_schedule_float2

SECURITYDBO

SCHEDULE

SCHEDULE_FLOAT2

NUMBER(28,12)

EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleFloat2

scheduleFloat3

 

decimal

5236

in_schedule_float3

SECURITYDBO

SCHEDULE

SCHEDULE_FLOAT3

NUMBER(28,12)

EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleFloat3

scheduleFloat4

 

decimal

8284

in_schedule_float4

SECURITYDBO

SCHEDULE

SCHEDULE_FLOAT4

NUMBER(28,12)

EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleFloat4

scheduleFloat5

 

decimal

8285

in_schedule_float5

SECURITYDBO

SCHEDULE

SCHEDULE_FLOAT5

NUMBER(28,12)

EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleFloat5

preRefundedDate

 

date

1247

in_pre_refunded_date

SECURITYDBO

SCHEDULE

PRE_REFUNDED_DATE

DATE

EagleML/referenceTransaction/genericSMF/ScheduleModel/preRefundedDate

preRefundedPrice

 

decimal

1248

in_pre_refunded_price

SECURITYDBO

SCHEDULE

PRE_REFUNDED_PRICE

NUMBER(28,12)

EagleML/referenceTransaction/genericSMF/ScheduleModel/preRefundedPrice

series

 

string

1251

in_series

SECURITYDBO

SCHEDULE

SERIES

CHAR(12)

EagleML/referenceTransaction/genericSMF/ScheduleModel/series

stepUpCoupon

 

decimal

1252

in_step_up_coupon

SECURITYDBO

SCHEDULE

STEP_UP_COUPON

NUMBER(28,12)

EagleML/referenceTransaction/genericSMF/ScheduleModel/stepUpCoupon

stepUpDate

 

date

1253

in_step_up_date

SECURITYDBO

SCHEDULE

STEP_UP_DATE

DATE

EagleML/referenceTransaction/genericSMF/ScheduleModel/stepUpDate

workoutDate

 

date

1254

in_workout_date

SECURITYDBO

SCHEDULE

WORKOUT_DATE

DATE

EagleML/referenceTransaction/genericSMF/ScheduleModel/workoutDate

workoutPrice

 

decimal

1255

in_workout_price

SECURITYDBO

SCHEDULE

WORKOUT_PRICE

NUMBER(28,12)

EagleML/referenceTransaction/genericSMF/ScheduleModel/workoutPrice

discrete

 

string

3663

in_discrete

SECURITYDBO

SCHEDULE

DISCRETE

CHAR(4)

EagleML/referenceTransaction/genericSMF/ScheduleModel/discrete

exerciseDate

 

date

3659

in_exercise_date

SECURITYDBO

SCHEDULE

EXERCISE_DATE

DATE

EagleML/referenceTransaction/genericSMF/ScheduleModel/exerciseDate

exercisePrice

 

decimal

3661

in_exercise_price

SECURITYDBO

SCHEDULE

EXERCISE_PRICE

NUMBER(28,12)

EagleML/referenceTransaction/genericSMF/ScheduleModel/exercisePrice

localCurrencySchedule

 

CurrencyCode

3677

in_local_curr_sch

SECURITYDBO

SCHEDULE

LOCAL_CURR_SCH

CHAR(3)

EagleML/referenceTransaction/genericSMF/ScheduleModel/localCurrencySchedule

scheduleFrequency

 

string

3662

in_schedule_frequency

SECURITYDBO

SCHEDULE

SCHEDULE_FREQUENCY

CHAR(12)

EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleFrequency

scheduleLocalCurrency

 

CurrencyCode

3674

in_sch_local_currency

SECURITYDBO

SCHEDULE

SCH_LOCAL_CURRENCY

VARCHAR2(3)

EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleLocalCurrency

scheduleBaseCurrency

 

CurrencyCode

3675

in_sch_base_currency

SECURITYDBO

SCHEDULE

SCH_BASE_CURRENCY

VARCHAR2(3)

EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleBaseCurrency

shares

 

decimal

3660

in_shares

SECURITYDBO

SCHEDULE

SHARES

NUMBER(28,12)

EagleML/referenceTransaction/genericSMF/ScheduleModel/shares

valuationDate

 

date

16409

in_valuation_date

SECURITYDBO

SCHEDULE

VALUATION_DATE

DATE

EagleML/referenceTransaction/genericSMF/ScheduleModel/valuationDate

bypassSinkCheckSwitch

 

YesNoOptionEnum

17479

in_bypass_sink_check

SECURITYDBO

SCHEDULE

BYPASS_SINK_CHECK

VARCHAR2(1)

EagleML/referenceTransaction/genericSMF/ScheduleModel/bypassSinkCheckSwitch

fixingDate

 

date

16410

in_fixing_date

SECURITYDBO

SCHEDULE

FIXING_DATE

DATE

EagleML/referenceTransaction/genericSMF/ScheduleModel/fixingDate

cashPaymentDate

 

date

16411

in_cash_payment_date

SECURITYDBO

SCHEDULE

CASH_PAYMENT_DATE

DATE

EagleML/referenceTransaction/genericSMF/ScheduleModel/cashPaymentDate

resetDate

 

date

16408

in_reset_date

SECURITYDBO

SCHEDULE

RESET_DATE

DATE

EagleML/referenceTransaction/genericSMF/ScheduleModel/resetDate

effectiveDate

Required

date

1109

in_effective_date

SECURITYDBO

SCHEDULE

EFFECTIVE_DATE

DATE

EagleML/referenceTransaction/genericSMF/ScheduleModel/effectiveDate