Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 7 Next »

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

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)

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


  • No labels