Warning |
---|
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:
|
...
Element
|
Element | Comments | Value Type | Star Tag | SP Parameter | SP TypeEagle DB | DB Table | DB Field | DB Field Type | XPathXpath |
| ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
scheduleId | Optionalstring | integer3251 | 3664 | in_schedule_char1S | SECURITYDBO | SCHEDULE | SCHEDULE_CHAR1 | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleId |
| ||||||||||
scheduleTypeOptional | ScheduleTypeEnum | 36781250 | in_schedule_sub_type | S | SECURITYDBO | SCHEDULE | SCHEDULE_SUB_TYPE | CHAR(48) | EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleType | |||||||||||
scheduleSubType | Required | string | 12503678 | in_schedule_sub_typeS | SECURITYDBO | SCHEDULE | SCHEDULE_SUB_TYPE | CHAR(84) | EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleSubType |
| ||||||||||
scheduleStatus | Optional | ScheduleStatusEnum | 1670 | in_schedule_statusS | SECURITYDBO | SCHEDULE | SCHEDULE_STATUS | VARCHAR2(12) | EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleStatus |
| ||||||||||
priceOptional | decimal | 1249 | in_schedule_priceF | SECURITYDBO | SCHEDULE | SCHEDULE_PRICE | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/ScheduleModel/price | ||||||||||||
rate | Optional | decimal | 1249 | in_schedule_priceF | SECURITYDBO | SCHEDULE | SCHEDULE_PRICE | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/ScheduleModel/rate | |||||||||||
scheduleAmountOptional | decimal | 1669 | in_schedule_amountF | SECURITYDBO | SCHEDULE | SCHEDULE_AMOUNT | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleAmount | ||||||||||||
scheduleFloat1Optional | decimal | 5534 | in_schedule_float1I | SECURITYDBO | SCHEDULE | SCHEDULE_FLOAT1 | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleFloat1 | ||||||||||||
endDate | Optional | date | 73 | in_end_date | S | SECURITYDBO | SCHEDULE | END_DATE | DATE | EagleML/referenceTransaction/genericSMF/ScheduleModel/endDate |
| |||||||||
accrualDateCustOptional | date | 71578504 | in_accrual_date_custS | SECURITYDBO | SCHEDULE | ACCRUAL_DATE_CUST | DATE | EagleML/referenceTransaction/genericSMF/ScheduleModel/accrualDateCust |
| determDate1 | Optional | date | 7113 |
|
| not stored in DB | ||||
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/determDate1nextAccrualDate | ||||||||||||
payDate | determDate2date | Optional8503 | in_pay_date | 7114 |
|
| not stored in DB | 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/determDate2 | nextAccrualDate | OptionalnextCallDate | ||||||||||
nextCallPrice | decimal | 1242 | in_next_call_price | SECURITYDBO | SCHEDULE | NEXT_CALL_PRICE | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/ScheduleModel/nextCallPrice | ||||||||||||
nextPutDate | date | 71631243 | in_next_accrualput_dateS | SECURITYDBO | SCHEDULE | NEXT_PUT_DATE | DATE | EagleML/referenceTransaction/genericSMF/ScheduleModel/nextPutDate | ||||||||||||
nextPutPrice | decimal | 1244 | in_next_put_price | SECURITYDBO | SCHEDULE | NEXT_ACCRUAL_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/nextAccrualDate |
| payDate | Optional | date | 7164 | in_pay_date | SvaluationDate | |||||
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 | PAYCASH_PAYMENT_DATE | DATE | EagleML/referenceTransaction/genericSMF/ScheduleModel/payDate cashPaymentDate | ||||||||||||
resetDate | date | 16408 | in_reset_date | SECURITYDBO | SCHEDULE | RESET_DATE | DATE | EagleML/referenceTransaction/genericSMF/ScheduleModel/resetDate | ||||||||||||
effectiveDate | Required | date | 1109 | in_effective_dateS | SECURITYDBO | SCHEDULE | EFFECTIVE_DATE | DATE | EagleML/referenceTransaction/genericSMF/ScheduleModel/effectiveDate |