Info |
---|
Please note that 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) |
...
Info | ||||||
---|---|---|---|---|---|---|
|
Element | Comments | Value Type | Star Tag | SP Parameter | Eagle DB | DB Table | DB Field | DB Field Type | Xpath | |||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
objectType | ObjectTypeEnum | not stored in DB | EagleML/referenceTransaction/schedule/objectType | |||||||||||||||||||||||
objectId | ObjectId | not stored in DB | EagleML/referenceTransaction/schedule/objectId | |||||||||||||||||||||||
objectDescription | FeedTypeEnum | not stored in DB | EagleML/referenceTransaction/schedule/objectDescription | |||||||||||||||||||||||
updateTimestamp | dateTime | DATE | EagleML/referenceTransaction/schedule/updateTimestamp | |||||||||||||||||||||||
customElements | Not recommended | CustomElements - Complex type | reserved for customizations | EagleML/referenceTransaction/schedule/customElements | ||||||||||||||||||||||
sourceName | Required | string - needed for resolution logics | 1102 | in_short_desc | PACE_MASTERDBO | INTERFACES | SHORT_DESC | CHAR(15) | EagleML/referenceTransaction/schedule/sourceName | |||||||||||||||||
updateSource | string | 944 | in_update_source | SECURITYDBO | SCHEDULE | UPDATE_SOURCE | VARCHAR2(255) | EagleML/referenceTransaction/schedule/updateSource | ||||||||||||||||||
effectiveDate | Required | date | 1109 | in_effective_date | SECURITYDBO | SCHEDULE | EFFECTIVE_DATE | DATE | EagleML/referenceTransaction/schedule/effectiveDate | |||||||||||||||||
languageId | integer | not stored in DB | EagleML/referenceTransaction/schedule/languageId | |||||||||||||||||||||||
tagNochangecase | string | 4637 | not stored in DB | EagleML/referenceTransaction/schedule/objectTypetagNochangecase | ||||||||||||||||||||||
preserveNull | objectIdstring | ObjectId5284 | not stored in DB | EagleML/referenceTransaction/schedule/objectIdpreserveNull | ||||||||||||||||||||||
objectDescriptionnoLoadValidationFlag | FeedTypeEnumYesNoOptionEnum | not stored in DB, used in load logics | EagleML/referenceTransaction/schedule/objectDescriptionnoLoadValidationFlag | |||||||||||||||||||||||
updateTimestampaccountingValidationFlag | dateTime | DATEYesNoOptionEnum | not stored in DB, used in load logics | EagleML/referenceTransaction/schedule/updateTimestampaccountingValidationFlag | ||||||||||||||||||||||
customElementsskipIfExistFlag | Not recommended | CustomElements - Complex type | reserved for customizationsYesNoOptionEnum | not stored in DB, used in load logics | EagleML/referenceTransaction/schedule/customElementsskipIfExistFlag | |||||||||||||||||||||
sourceName | Required | string - needed for resolution logics | 1102 | in_short_desc | PACE_MASTERDBO | INTERFACES | SHORT_DESC | CHAR(15) | Asset Identifiers Model | EagleML/referenceTransaction/schedule/sourceName | updateSource | string | 944 | in_update_source | SECURITYDBO | SCHEDULE | UPDATE_SOURCE | VARCHAR2(255) | ||||||||
setEligibleFlag | YesNoOptionEnum | not stored in DB | EagleML/referenceTransaction/schedule/updateSourcesetEligibleFlag | |||||||||||||||||||||||
effectiveDatesecurityMasterSource | Required | date | 1109 | in_effective_date | SECURITYDBO | SCHEDULE | EFFECTIVE_DATE | DATEstring | PACE_MASTERDBO | INTERFACES | SHORT_DESC | EagleML/referenceTransaction/schedule/effectiveDatesecurityMasterSource | ||||||||||||||
scheduleId | languageIdstring | integer3251 | not stored in DB | EagleML/referenceTransaction/schedule/languageId | tagNochangecase | string | 4637 | not stored in DBin_schedule_char1 | SECURITYDBO | SCHEDULE | SCHEDULE_CHAR1 | VARCHAR2(30) | EagleML/referenceTransaction/schedule/tagNochangecase | preserveNull | string | 5284 | not stored in DB | EagleML/referenceTransaction/schedule/preserveNull | noLoadValidationFlag | YesNoOptionEnum | not stored in DB, used in load logicsscheduleId | |||||
scheduleType | see the note above about reversed mapping | ScheduleTypeEnum | 1250 | in_schedule_sub_type | SECURITYDBO | SCHEDULE | SCHEDULE_SUB_TYPE | CHAR(8) | EagleML/referenceTransaction/schedule/noLoadValidationFlag | accountingValidationFlag | YesNoOptionEnum | not stored in DB, used in load logics | EagleML/referenceTransaction/schedule/accountingValidationFlag | skipIfExistFlag | YesNoOptionEnum | not stored in DB, used in load logics | EagleML/referenceTransaction/schedule/skipIfExistFlag | Asset Identifiers ModelscheduleType | ||||||||
scheduleSubType | Required | string | 3678 | in_schedule_type | SECURITYDBO | SCHEDULE | SCHEDULE_TYPE | CHAR(4) | EagleML/referenceTransaction/schedule/scheduleSubType | |||||||||||||||||
setEligibleFlagscheduleStatus | ScheduleStatusEnum | YesNoOptionEnum1670 | not stored in DB | EagleML/referenceTransaction/schedule/setEligibleFlag | securityMasterSource | string | PACE_MASTERDBO | INTERFACES | SHORT_DESC | in_schedule_status | SECURITYDBO | SCHEDULE | SCHEDULE_STATUS | VARCHAR2(12) | EagleML/referenceTransaction/schedule/securityMasterSourcescheduleStatusscheduleId | |||||||||||
price | stringdecimal | 32511249 | in_schedule_ | char1price | SECURITYDBO | SCHEDULE | SCHEDULE_ | CHAR1PRICE | VARCHAR2NUMBER( | 3028,12) | EagleML/referenceTransaction/schedule/ | scheduleIdprice | ||||||||||||||
rate | ScheduleTypeEnumdecimal | 12501249 | in_schedule_ | sub_typeprice | SECURITYDBO | SCHEDULE | SCHEDULE_ | SUB_TYPEPRICE | CHARNUMBER( | 828,12) | EagleML/referenceTransaction/schedule/ | scheduleTyperate | ||||||||||||||
scheduleSubTypescheduleAmount | Requireddecimal | string1669 | 3678 | in_schedule_typeamount | SECURITYDBO | SCHEDULE | SCHEDULE_TYPEAMOUNT | CHARNUMBER(428,12) | EagleML/referenceTransaction/schedule/scheduleSubTypescheduleAmount | |||||||||||||||||
scheduleStatusscheduleFloat1 | ScheduleStatusEnumdecimal | 16705534 | in_schedule_statusfloat1 | SECURITYDBO | SCHEDULE | SCHEDULE_STATUSFLOAT1 | VARCHAR2NUMBER(28,12) | EagleML/referenceTransaction/schedule/scheduleStatusscheduleFloat1 | ||||||||||||||||||
endDate | decimaldate | 124973 | in_ | scheduleend_ | pricedate | SECURITYDBO | SCHEDULE | SCHEDULEEND_ | PRICENUMBER(28,12)DATE | DATE | EagleML/referenceTransaction/schedule/ | priceendDate | ||||||||||||||
accrualDateCust | decimaldate | 12498504 | in_accrual_ | scheduledate_ | pricecust | SECURITYDBO | SCHEDULE | SCHEDULE_PRICE | NUMBER(28,12)ACCRUAL_DATE_CUST | DATE | EagleML/referenceTransaction/schedule/ | rateaccrualDateCust | ||||||||||||||
scheduleAmountdetermDate1 | decimal | 1669 | in_schedule_amount | SECURITYDBO | SCHEDULE | SCHEDULE_AMOUNT | NUMBER(28,12)date | not stored in DB | EagleML/referenceTransaction/schedule/determDate1 | |||||||||||||||||
determDate2 | date | not stored in DB | EagleML/referenceTransaction/schedule/scheduleAmountdetermDate2 | |||||||||||||||||||||||
scheduleFloat1nextAccrualDate | decimaldate | 55348502 | in_next_scheduleaccrual_float1date | SECURITYDBO | SCHEDULESCHEDULE | NEXT_ACCRUAL_FLOAT1NUMBER(28,12)DATE | DATE | EagleML/referenceTransaction/schedule/scheduleFloat1nextAccrualDate | ||||||||||||||||||
endDatepayDate | date | 738503 | in_endpay_date | SECURITYDBO | SCHEDULE | ENDPAY_DATE | DATE | EagleML/referenceTransaction/schedule/endDatepayDate | ||||||||||||||||||
accrualDateCustnextCallDate | date | 85041241 | in_next_accrualcall_date_cust | SECURITYDBO | SCHEDULE | ACCRUALNEXT_CALL_DATE_CUST | DATE | EagleML/referenceTransaction/schedule/accrualDateCustnextCallDate | ||||||||||||||||||
nextCallPrice | determDate1decimal | date1242 | not stored in DB | EagleML/referenceTransaction/schedule/determDate1 | determDate2 | date | not stored in DBin_next_call_price | SECURITYDBO | SCHEDULE | NEXT_CALL_PRICE | NUMBER(28,12) | EagleML/referenceTransaction/schedule/determDate2nextCallPrice | ||||||||||||||
nextAccrualDatenextPutDate | date | 85021243 | in_next_accrualput_date | SECURITYDBO | SCHEDULE | NEXT_ACCRUALPUT_DATE | DATE | EagleML/referenceTransaction/schedule/nextAccrualDatenextPutDate | ||||||||||||||||||
payDatenextPutPrice | datedecimal | 85031244 | in_paynext_put_dateprice | SECURITYDBO | SCHEDULE | PAYNEXT_PUT_DATEDATEPRICE | NUMBER(28,12) | EagleML/referenceTransaction/schedule/payDatenextPutPrice | ||||||||||||||||||
nextCallDateparCallDate | date | 12411245 | in_nextpar_call_date | SECURITYDBO | SCHEDULE | NEXTPAR_CALL_DATE | DATE | EagleML/referenceTransaction/schedule/nextCallDateparCallDate | ||||||||||||||||||
nextCallPriceparPutDate | decimaldate | 12421246 | in_nextpar_callput_pricedate | SECURITYDBO | SCHEDULE | NEXTPAR_CALLPUT_PRICENUMBER(28,12)DATE | DATE | EagleML/referenceTransaction/schedule/nextCallPriceparPutDate | ||||||||||||||||||
nextPutDatescheduleChar1 | datestring | 12433664 | in_next_putschedule_datechar1 | SECURITYDBO | SCHEDULE | NEXTSCHEDULE_PUT_DATEDATECHAR1 | VARCHAR2(30) | EagleML/referenceTransaction/schedule/nextPutDatescheduleChar1 | ||||||||||||||||||
nextPutPricescheduleChar2 | decimalstring | 12443665 | in_nextschedule_put_pricechar2 | SECURITYDBO | SCHEDULE | NEXTSCHEDULE_PUT_PRICECHAR2 | NUMBERVARCHAR2(28,1230) | EagleML/referenceTransaction/schedule/nextPutPricescheduleChar2 | ||||||||||||||||||
parCallDatescheduleChar3 | datestring | 12453666 | in_parschedule_call_datechar3 | SECURITYDBO | SCHEDULE | PAR_CALLSCHEDULE_DATEDATECHAR3 | VARCHAR2(30) | EagleML/referenceTransaction/schedule/parCallDatescheduleChar3 | ||||||||||||||||||
parPutDatescheduleChar4 | datestring | 12463667 | in_parschedule_put_datechar4 | SECURITYDBO | SCHEDULE | PARSCHEDULE_PUT_DATEDATECHAR4 | VARCHAR2(30) | EagleML/referenceTransaction/schedule/parPutDatescheduleChar4 | ||||||||||||||||||
scheduleChar1scheduleChar5 | string | 36643668 | in_schedule_char1char5 | SECURITYDBO | SCHEDULE | SCHEDULE_CHAR1CHAR5 | VARCHAR2(30) | EagleML/referenceTransaction/schedule/scheduleChar1scheduleChar5 | ||||||||||||||||||
scheduleChar2scheduleDate1 | stringdate | 36653669 | in_schedule_char2date1 | SECURITYDBO | SCHEDULE | SCHEDULE_CHAR2VARCHAR2(30)DATE1 | DATE | EagleML/referenceTransaction/schedule/scheduleChar2scheduleDate1 | ||||||||||||||||||
scheduleChar3scheduleDate2 | stringdate | 36663670 | in_schedule_char3date2 | SECURITYDBO | SCHEDULE | SCHEDULE_CHAR3VARCHAR2(30)DATE2 | DATE | EagleML/referenceTransaction/schedule/scheduleChar3scheduleDate2 | ||||||||||||||||||
scheduleChar4scheduleDate3 | stringdate | 36673671 | in_schedule_char4date3 | SECURITYDBO | SCHEDULE | SCHEDULE_CHAR4VARCHAR2(30)DATE3 | DATE | EagleML/referenceTransaction/schedule/scheduleChar4scheduleDate3 | ||||||||||||||||||
scheduleChar5scheduleDate4 | stringdate | 36683672 | in_schedule_char5date4 | SECURITYDBO | SCHEDULE | SCHEDULE_CHAR5VARCHAR2(30)DATE4 | DATE | EagleML/referenceTransaction/schedule/scheduleChar5scheduleDate4 | ||||||||||||||||||
scheduleDate1scheduleDate5 | date | 36693673 | in_schedule_date1date5 | SECURITYDBO | SCHEDULE | SCHEDULE_DATE1DATE5 | DATE | EagleML/referenceTransaction/schedule/scheduleDate1scheduleDate5 | ||||||||||||||||||
scheduleDate2scheduleDate6 | date | 36708279 | in_schedule_date2date6 | SECURITYDBO | SCHEDULE | SCHEDULE_DATE2DATE6 | DATE | EagleML/referenceTransaction/schedule/scheduleDate2scheduleDate6 | ||||||||||||||||||
scheduleDate3scheduleDate7 | date | 36718280 | in_schedule_date3date7 | SECURITYDBO | SCHEDULE | SCHEDULE_DATE3DATE7 | DATE | EagleML/referenceTransaction/schedule/scheduleDate3scheduleDate7 | ||||||||||||||||||
scheduleDate4scheduleDate8 | date | 36728281 | in_schedule_date4date8 | SECURITYDBO | SCHEDULE | SCHEDULE_DATE4DATE8 | DATE | EagleML/referenceTransaction/schedule/scheduleDate4scheduleDate8 | ||||||||||||||||||
scheduleDate5scheduleDate9 | date | 36738282 | in_schedule_date5date9 | SECURITYDBO | SCHEDULE | SCHEDULE_DATE5DATE9 | DATE | EagleML/referenceTransaction/schedule/scheduleDate5scheduleDate9 | ||||||||||||||||||
scheduleDate6scheduleDate10 | date | 82798283 | in_schedule_date6date10 | SECURITYDBO | SCHEDULE | SCHEDULE_DATE6DATE10 | DATE | EagleML/referenceTransaction/schedule/scheduleDate6scheduleDate10 | ||||||||||||||||||
scheduleDate7scheduleFloat2 | datedecimal | 82805235 | in_schedule_date7float2 | SECURITYDBO | SCHEDULE | SCHEDULE_DATE7DATEFLOAT2 | NUMBER(28,12) | EagleML/referenceTransaction/schedule/scheduleDate7scheduleFloat2 | ||||||||||||||||||
scheduleDate8scheduleFloat3 | datedecimal | 82815236 | in_schedule_date8float3 | SECURITYDBO | SCHEDULE | SCHEDULE_DATE8DATEFLOAT3 | NUMBER(28,12) | EagleML/referenceTransaction/schedule/scheduleDate8scheduleFloat3 | ||||||||||||||||||
scheduleDate9scheduleFloat4 | datedecimal | 82828284 | in_schedule_date9float4 | SECURITYDBO | SCHEDULE | SCHEDULE_DATE9DATEFLOAT4 | NUMBER(28,12) | EagleML/referenceTransaction/schedule/scheduleDate9scheduleFloat4 | ||||||||||||||||||
scheduleDate10scheduleFloat5 | datedecimal | 82838285 | in_schedule_date10float5 | SECURITYDBO | SCHEDULE | SCHEDULE_DATE10DATEFLOAT5 | NUMBER(28,12) | EagleML/referenceTransaction/schedule/scheduleDate10scheduleFloat5 | ||||||||||||||||||
scheduleFloat2preRefundedDate | decimaldate | 52351247 | in_pre_schedulerefunded_float2date | SECURITYDBO | SCHEDULESCHEDULE | PRE_REFUNDED_FLOAT2NUMBER(28,12)DATE | DATE | EagleML/referenceTransaction/schedule/scheduleFloat2preRefundedDate | ||||||||||||||||||
scheduleFloat3preRefundedPrice | decimal | 52361248 | in_pre_schedulerefunded_float3price | SECURITYDBO | SCHEDULESCHEDULE | PRE_REFUNDED_FLOAT3PRICE | NUMBER(28,12) | EagleML/referenceTransaction/schedule/scheduleFloat3preRefundedPrice | ||||||||||||||||||
scheduleFloat4series | decimalstring | 82841251 | in_schedule_float4series | SECURITYDBO | SCHEDULESCHEDULE_FLOAT4 | SERIES | NUMBERCHAR(28,12) | EagleML/referenceTransaction/schedule/scheduleFloat4series | ||||||||||||||||||
scheduleFloat5stepUpCoupon | decimal | 82851252 | in_step_scheduleup_float5coupon | SECURITYDBO | SCHEDULESCHEDULE | STEP_UP_FLOAT5COUPON | NUMBER(28,12) | EagleML/referenceTransaction/schedule/scheduleFloat5stepUpCoupon | ||||||||||||||||||
preRefundedDatestepUpDate | date | 12471253 | in_prestep_refundedup_date | SECURITYDBO | SCHEDULE | PRESTEP_REFUNDEDUP_DATE | DATE | EagleML/referenceTransaction/schedule/preRefundedDatestepUpDate | ||||||||||||||||||
preRefundedPriceworkoutDate | decimaldate | 12481254 | in_preworkout_refunded_pricedate | SECURITYDBO | SCHEDULE | PREWORKOUT_REFUNDED_PRICENUMBER(28,12)DATE | DATE | EagleML/referenceTransaction/schedule/preRefundedPriceworkoutDate | ||||||||||||||||||
seriesworkoutPrice | stringdecimal | 12511255 | in_seriesworkout_price | SECURITYDBO | SCHEDULESERIES | WORKOUT_PRICE | CHARNUMBER(28,12) | EagleML/referenceTransaction/schedule/seriesworkoutPrice | ||||||||||||||||||
stepUpCoupondiscrete | decimalstring | 12523663 | in_step_up_coupondiscrete | SECURITYDBO | SCHEDULE | STEP_UP_COUPON | NUMBER(28,12DISCRETE | CHAR(4) | EagleML/referenceTransaction/schedule/stepUpCoupondiscrete | |||||||||||||||||
stepUpDateexerciseDate | date | 12533659 | in_stepexercise_up_date | SECURITYDBO | SCHEDULE | STEPEXERCISE_UP_DATE | DATE | EagleML/referenceTransaction/schedule/stepUpDateexerciseDate | ||||||||||||||||||
workoutDateexercisePrice | datedecimal | 12543661 | in_workoutexercise_dateprice | SECURITYDBO | SCHEDULE | WORKOUT_DATE | DATEEXERCISE_PRICE | NUMBER(28,12) | EagleML/referenceTransaction/schedule/workoutDateexercisePrice | |||||||||||||||||
workoutPricelocalCurrencySchedule | decimalCurrencyCode | 12553677 | in_workoutlocal_curr_pricesch | SECURITYDBO | SCHEDULE | WORKOUTLOCAL_CURR_PRICESCH | NUMBERCHAR(28,123) | EagleML/referenceTransaction/schedule/workoutPricelocalCurrencySchedule | ||||||||||||||||||
discretescheduleFrequency | string | 36633662 | in_schedule_discretefrequency | SECURITYDBO | SCHEDULEDISCRETE | SCHEDULE_FREQUENCY | CHAR(412) | EagleML/referenceTransaction/schedule/discretescheduleFrequency | ||||||||||||||||||
exerciseDatescheduleLocalCurrency | dateCurrencyCode | 36593674 | in_exercisesch_local_datecurrency | SECURITYDBO | SCHEDULE | EXERCISESCH_LOCAL_DATEDATECURRENCY | VARCHAR2(3) | EagleML/referenceTransaction/schedule/exerciseDatescheduleLocalCurrency | ||||||||||||||||||
exercisePricescheduleBaseCurrency | decimalCurrencyCode | 36613675 | in_sch_exercisebase_pricecurrency | SECURITYDBO | SCHEDULE | EXERCISESCH_BASE_PRICECURRENCY | NUMBERVARCHAR2(28,123) | EagleML/referenceTransaction/schedule/exercisePricescheduleBaseCurrency | ||||||||||||||||||
localCurrencyScheduleshares | CurrencyCodedecimal | 36773660 | in_local_curr_schshares | SECURITYDBO | SCHEDULE | LOCAL_CURR_SCH | CHAR(3SHARES | NUMBER(28,12) | EagleML/referenceTransaction/schedule/localCurrencyScheduleshares | |||||||||||||||||
scheduleFrequencybypassSinkCheckSwitch | stringYesNoOptionEnum | 366217479 | in_bypass_schedulesink_frequencycheck | SECURITYDBO | SCHEDULESCHEDULE | BYPASS_SINK_FREQUENCYCHECK | CHARVARCHAR2(121) | EagleML/referenceTransaction/schedule/scheduleFrequencybypassSinkCheckSwitch | ||||||||||||||||||
scheduleLocalCurrencyresetDate | CurrencyCodedate | 367416408 | in_schreset_local_currencydate | SECURITYDBO | SCHEDULE | SCHRESET_LOCAL_CURRENCYVARCHAR2(3)DATE | DATE | EagleML/referenceTransaction/schedule/scheduleLocalCurrencyresetDate | ||||||||||||||||||
scheduleBaseCurrencyvaluationDate | CurrencyCodedate | 367516409 | in_schvaluation_base_currencydate | SECURITYDBO | SCHEDULE | SCHVALUATION_BASE_CURRENCYVARCHAR2(3)DATE | DATE | EagleML/referenceTransaction/schedule/scheduleBaseCurrencyvaluationDate | ||||||||||||||||||
sharesfixingDate | decimaldate | 366016410 | in_sharesfixing_date | SECURITYDBO | SCHEDULE | SHARES | NUMBER(28,12)FIXING_DATE | DATE | EagleML/referenceTransaction/schedule/sharesfixingDate | |||||||||||||||||
valuationDatecashPaymentDate | date | 1640916411 | inin_cash_valuationpayment_date | SECURITYDBO | SCHEDULE | VALUATIONCASH_PAYMENT_DATE | DATE | EagleML/referenceTransaction/schedule/valuationDatecashPaymentDatebypassSinkCheckSwitch | ||||||||||||||||||
putNotificationMaxDays | YesNoOptionEnuminteger | 174791657 | in_ | bypassput_notification_ | sinkmax_ | checkdays | SECURITYDBO | SCHEDULE | BYPASSPUT_NOTIFICATION_ | SINKMAX_ | CHECKVARCHAR2(1)DAYS | NUMBER | EagleML/referenceTransaction/schedule/ | bypassSinkCheckSwitchputNotificationMaxDays | ||||||||||||
putNotificationMinDays | dateinteger | 164101658 | in_put_ | fixingnotification_min_ | datedays | SECURITYDBO | SCHEDULE | FIXING_DATE | DATEPUT_NOTIFICATION_MIN_DAYS | NUMBER | EagleML/referenceTransaction/schedule/ | fixingDateputNotificationMinDays | ||||||||||||||
baseCurrSch | datestring | 164113676 | in_ | cashbase_ | paymentcurr_ | datesch | SECURITYDBO | SCHEDULE | CASHBASE_ | PAYMENTCURR_ | DATEDATESCH | CHAR(3) | EagleML/referenceTransaction/schedule/ | cashPaymentDatebaseCurrSch | ||||||||||||
journalizingFlag | dateJournalizingFlagEnum | 164081293 | in_ | resetjournal_ | dateSECURITYDBO | SCHEDULE | RESET_DATE | DATE | flag | not stored in DB | EagleML/referenceTransaction/schedule/ | resetDatejournalizingFlag |