Versions Compared

Key

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


Warning

Please note, that 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


Info

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


ElementCommentsValue TypeStar TagSP ParameterEagle DBDB TableDB FieldDB Field TypeXpath
scheduleId
string3251in_schedule_char1SECURITYDBOSCHEDULESCHEDULE_CHAR1VARCHAR2(30)EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleId
scheduleType
ScheduleTypeEnum1250in_schedule_sub_typeSECURITYDBOSCHEDULESCHEDULE_SUB_TYPECHAR(8)EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleType
scheduleSubTypeRequiredstring3678in_schedule_typeSECURITYDBOSCHEDULESCHEDULE_TYPECHAR(4)EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleSubType
scheduleStatus
ScheduleStatusEnum1670in_schedule_statusSECURITYDBOSCHEDULESCHEDULE_STATUSVARCHAR2(12)EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleStatus
price
decimal1249in_schedule_priceSECURITYDBOSCHEDULESCHEDULE_PRICENUMBER(28,12)EagleML/referenceTransaction/genericSMF/ScheduleModel/price
rate
decimal1249in_schedule_priceSECURITYDBOSCHEDULESCHEDULE_PRICENUMBER(28,12)EagleML/referenceTransaction/genericSMF/ScheduleModel/rate
scheduleAmount
decimal1669in_schedule_amountSECURITYDBOSCHEDULESCHEDULE_AMOUNTNUMBER(28,12)EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleAmount
scheduleFloat1
decimal5534in_schedule_float1SECURITYDBOSCHEDULESCHEDULE_FLOAT1NUMBER(28,12)EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleFloat1
endDate
date73in_end_dateSECURITYDBOSCHEDULEEND_DATEDATEEagleML/referenceTransaction/genericSMF/ScheduleModel/endDate
accrualDateCust
date8504in_accrual_date_custSECURITYDBOSCHEDULEACCRUAL_DATE_CUSTDATEEagleML/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
date8502in_next_accrual_dateSECURITYDBOSCHEDULENEXT_ACCRUAL_DATEDATEEagleML/referenceTransaction/genericSMF/ScheduleModel/nextAccrualDate
payDate
date8503in_pay_dateSECURITYDBOSCHEDULEPAY_DATEDATEEagleML/referenceTransaction/genericSMF/ScheduleModel/payDate
nextCallDate
date1241in_next_call_dateSECURITYDBOSCHEDULENEXT_CALL_DATEDATEEagleML/referenceTransaction/genericSMF/ScheduleModel/nextCallDate
nextCallPrice
decimal1242in_next_call_priceSECURITYDBOSCHEDULENEXT_CALL_PRICENUMBER(28,12)EagleML/referenceTransaction/genericSMF/ScheduleModel/nextCallPrice
nextPutDate
date1243in_next_put_dateSECURITYDBOSCHEDULENEXT_PUT_DATEDATEEagleML/referenceTransaction/genericSMF/ScheduleModel/nextPutDate
nextPutPrice
decimal1244in_next_put_priceSECURITYDBOSCHEDULENEXT_PUT_PRICENUMBER(28,12)EagleML/referenceTransaction/genericSMF/ScheduleModel/nextPutPrice
parCallDate
date1245in_par_call_dateSECURITYDBOSCHEDULEPAR_CALL_DATEDATEEagleML/referenceTransaction/genericSMF/ScheduleModel/parCallDate
parPutDate
date1246in_par_put_dateSECURITYDBOSCHEDULEPAR_PUT_DATEDATEEagleML/referenceTransaction/genericSMF/ScheduleModel/parPutDate
scheduleChar1
string3664in_schedule_char1SECURITYDBOSCHEDULESCHEDULE_CHAR1VARCHAR2(30)EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleChar1
scheduleChar2
string3665in_schedule_char2SECURITYDBOSCHEDULESCHEDULE_CHAR2VARCHAR2(30)EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleChar2
scheduleChar3
string3666in_schedule_char3SECURITYDBOSCHEDULESCHEDULE_CHAR3VARCHAR2(30)EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleChar3
scheduleChar4
string3667in_schedule_char4SECURITYDBOSCHEDULESCHEDULE_CHAR4VARCHAR2(30)EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleChar4
scheduleChar5
string3668in_schedule_char5SECURITYDBOSCHEDULESCHEDULE_CHAR5VARCHAR2(30)EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleChar5
scheduleDate1
date3669in_schedule_date1SECURITYDBOSCHEDULESCHEDULE_DATE1DATEEagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleDate1
scheduleDate2
date3670in_schedule_date2SECURITYDBOSCHEDULESCHEDULE_DATE2DATEEagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleDate2
scheduleDate3
date3671in_schedule_date3SECURITYDBOSCHEDULESCHEDULE_DATE3DATEEagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleDate3
scheduleDate4
date3672in_schedule_date4SECURITYDBOSCHEDULESCHEDULE_DATE4DATEEagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleDate4
scheduleDate5
date3673in_schedule_date5SECURITYDBOSCHEDULESCHEDULE_DATE5DATEEagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleDate5
scheduleDate6
date8279in_schedule_date6SECURITYDBOSCHEDULESCHEDULE_DATE6DATEEagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleDate6
scheduleDate7
date8280in_schedule_date7SECURITYDBOSCHEDULESCHEDULE_DATE7DATEEagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleDate7
scheduleDate8
date8281in_schedule_date8SECURITYDBOSCHEDULESCHEDULE_DATE8DATEEagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleDate8
scheduleDate9
date8282in_schedule_date9SECURITYDBOSCHEDULESCHEDULE_DATE9DATEEagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleDate9
scheduleDate10
date8283in_schedule_date10SECURITYDBOSCHEDULESCHEDULE_DATE10DATEEagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleDate10
scheduleFloat2
decimal5235in_schedule_float2SECURITYDBOSCHEDULESCHEDULE_FLOAT2NUMBER(28,12)EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleFloat2
scheduleFloat3
decimal5236in_schedule_float3SECURITYDBOSCHEDULESCHEDULE_FLOAT3NUMBER(28,12)EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleFloat3
scheduleFloat4
decimal8284in_schedule_float4SECURITYDBOSCHEDULESCHEDULE_FLOAT4NUMBER(28,12)EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleFloat4
scheduleFloat5
decimal8285in_schedule_float5SECURITYDBOSCHEDULESCHEDULE_FLOAT5NUMBER(28,12)EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleFloat5
preRefundedDate
date1247in_pre_refunded_dateSECURITYDBOSCHEDULEPRE_REFUNDED_DATEDATEEagleML/referenceTransaction/genericSMF/ScheduleModel/preRefundedDate
preRefundedPrice
decimal1248in_pre_refunded_priceSECURITYDBOSCHEDULEPRE_REFUNDED_PRICENUMBER(28,12)EagleML/referenceTransaction/genericSMF/ScheduleModel/preRefundedPrice
series
string1251in_seriesSECURITYDBOSCHEDULESERIESCHAR(12)EagleML/referenceTransaction/genericSMF/ScheduleModel/series
stepUpCoupon
decimal1252in_step_up_couponSECURITYDBOSCHEDULESTEP_UP_COUPONNUMBER(28,12)EagleML/referenceTransaction/genericSMF/ScheduleModel/stepUpCoupon
stepUpDate
date1253in_step_up_dateSECURITYDBOSCHEDULESTEP_UP_DATEDATEEagleML/referenceTransaction/genericSMF/ScheduleModel/stepUpDate
workoutDate
date1254in_workout_dateSECURITYDBOSCHEDULEWORKOUT_DATEDATEEagleML/referenceTransaction/genericSMF/ScheduleModel/workoutDate
workoutPrice
decimal1255in_workout_priceSECURITYDBOSCHEDULEWORKOUT_PRICENUMBER(28,12)EagleML/referenceTransaction/genericSMF/ScheduleModel/workoutPrice
discrete
string3663in_discreteSECURITYDBOSCHEDULEDISCRETECHAR(4)EagleML/referenceTransaction/genericSMF/ScheduleModel/discrete
exerciseDate
date3659in_exercise_dateSECURITYDBOSCHEDULEEXERCISE_DATEDATEEagleML/referenceTransaction/genericSMF/ScheduleModel/exerciseDate
exercisePrice
decimal3661in_exercise_priceSECURITYDBOSCHEDULEEXERCISE_PRICENUMBER(28,12)EagleML/referenceTransaction/genericSMF/ScheduleModel/exercisePrice
localCurrencySchedule
CurrencyCode3677in_local_curr_schSECURITYDBOSCHEDULELOCAL_CURR_SCHCHAR(3)EagleML/referenceTransaction/genericSMF/ScheduleModel/localCurrencySchedule
scheduleFrequency
string3662in_schedule_frequencySECURITYDBOSCHEDULESCHEDULE_FREQUENCYCHAR(12)EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleFrequency
scheduleLocalCurrency
CurrencyCode3674in_sch_local_currencySECURITYDBOSCHEDULESCH_LOCAL_CURRENCYVARCHAR2(3)EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleLocalCurrency
scheduleBaseCurrency
CurrencyCode3675in_sch_base_currencySECURITYDBOSCHEDULESCH_BASE_CURRENCYVARCHAR2(3)EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleBaseCurrency
shares
decimal3660in_sharesSECURITYDBOSCHEDULESHARESNUMBER(28,12)EagleML/referenceTransaction/genericSMF/ScheduleModel/shares
valuationDate
date16409in_valuation_dateSECURITYDBOSCHEDULEVALUATION_DATEDATEEagleML/referenceTransaction/genericSMF/ScheduleModel/valuationDate
bypassSinkCheckSwitch
YesNoOptionEnum17479in_bypass_sink_checkSECURITYDBOSCHEDULEBYPASS_SINK_CHECKVARCHAR2(1)EagleML/referenceTransaction/genericSMF/ScheduleModel/bypassSinkCheckSwitch
fixingDate
date16410in_fixing_dateSECURITYDBOSCHEDULEFIXING_DATEDATEEagleML/referenceTransaction/genericSMF/ScheduleModel/fixingDate
cashPaymentDate
date16411in_cash_payment_dateSECURITYDBOSCHEDULECASH_PAYMENT_DATEDATEEagleML/referenceTransaction/genericSMF/ScheduleModel/cashPaymentDate
resetDate
date16408in_reset_dateSECURITYDBOSCHEDULERESET_DATEDATEEagleML/referenceTransaction/genericSMF/ScheduleModel/resetDate
effectiveDateRequireddate1109in_effective_dateSECURITYDBOSCHEDULEEFFECTIVE_DATEDATEEagleML/referenceTransaction/genericSMF/ScheduleModel/effectiveDate

...