...
...
- 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
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/objectTypeeffectiveDate | |||||||||||||||
objectIdlanguageId | ObjectIdinteger | not stored in DB | EagleML/referenceTransaction/schedule/objectIdlanguageId | |||||||||||||||||||||
tagNochangecase | objectDescriptionstring | FeedTypeEnum4637 | not stored in DB | EagleML/referenceTransaction/schedule/objectDescriptiontagNochangecase | ||||||||||||||||||||
preserveNull | updateTimestampstring | dateTime | DATE5284 | not stored in DB | EagleML/referenceTransaction/schedule/updateTimestamppreserveNull | |||||||||||||||||||
customElementsnoLoadValidationFlag | Not recommended | CustomElements - Complex type | reserved for customizationsYesNoOptionEnum | not stored in DB, used in load logics | EagleML/referenceTransaction/schedule/customElementsnoLoadValidationFlag | |||||||||||||||||||
sourceNameaccountingValidationFlag | Required | string - needed for resolution logics | 1102 | in_short_desc | PACE_MASTERDBO | INTERFACES | SHORT_DESC | CHAR(15)YesNoOptionEnum | not stored in DB, used in load logics | EagleML/referenceTransaction/schedule/sourceNameaccountingValidationFlag | ||||||||||||||
updateSourceskipIfExistFlag | stringYesNoOptionEnum | 944 | in_update_source | SECURITYDBO | SCHEDULE | UPDATE_SOURCE | VARCHAR2(255)not stored in DB, used in load logics | EagleML/referenceTransaction/schedule/updateSource | effectiveDate | Required | date | 1109 | in_effective_date | SECURITYDBO | SCHEDULE | EFFECTIVE_DATE | DATEskipIfExistFlag | |||||||
Asset Identifiers Model | EagleML/referenceTransaction/schedule/effectiveDate | |||||||||||||||||||||||
languageIdsetEligibleFlag | integerYesNoOptionEnum | not stored in DB | EagleML/referenceTransaction/schedule/languageIdsetEligibleFlag | |||||||||||||||||||||
tagNochangecasesecurityMasterSource | string | 4637 | not stored in DBPACE_MASTERDBO | INTERFACES | SHORT_DESC | EagleML/referenceTransaction/schedule/tagNochangecasesecurityMasterSource | ||||||||||||||||||
preserveNullscheduleId | string | 52843251 | not stored in DB | EagleML/referenceTransaction/schedule/preserveNull | noLoadValidationFlag | YesNoOptionEnum | not stored in DB, used in load logicsin_schedule_char1 | SECURITYDBO | SCHEDULE | SCHEDULE_CHAR1 | VARCHAR2(30) | 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 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/skipIfExistFlag | |||||||||||||||
Asset Identifiers Model | EagleML/referenceTransaction/schedule/ | |||||||||||||||||||||||
setEligibleFlag | YesNoOptionEnum | not stored in DBscheduleType | ||||||||||||||||||||||
scheduleSubType | Required | string | 3678 | in_schedule_type | SECURITYDBO | SCHEDULE | SCHEDULE_TYPE | CHAR(4) | EagleML/referenceTransaction/schedule/setEligibleFlagscheduleSubType | |||||||||||||||
scheduleStatus | securityMasterSourceScheduleStatusEnum | string1670 | PACE_MASTERDBO | INTERFACES | SHORT_DESCin_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 | ||||||||||||
scheduleType | see the note above about reversed mapping | ScheduleTypeEnum | 1250 | rate | decimal | 1249 | in_schedule_ | sub_typeprice | SECURITYDBO | SCHEDULE | SCHEDULE_ | SUB_TYPEPRICE | CHARNUMBER( | 828,12) | EagleML/referenceTransaction/schedule/ | scheduleTyperate | ||||||||
scheduleSubTypescheduleAmount | Requireddecimal | string | 36781669 | 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_ | scheduleaccrual_date_ | pricecust | SECURITYDBO | SCHEDULE | SCHEDULEACCRUAL_DATE_ | PRICENUMBER(28,12)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_schedulenext_accrual_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_accrualnext_call_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_nextschedule_put_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 | PARSCHEDULE_CALL_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_schedulepre_refunded_float2date | SECURITYDBO | SCHEDULE | SCHEDULE_FLOAT2 | NUMBER(28,12)PRE_REFUNDED_DATE | DATE | EagleML/referenceTransaction/schedule/scheduleFloat2preRefundedDate | |||||||||||||||
scheduleFloat3preRefundedPrice | decimal | 52361248 | in_schedulepre_refunded_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_workout_seriesprice | 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 | WORKOUTEXERCISE_DATEDATEPRICE | 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_discreteschedule_frequency | SECURITYDBO | SCHEDULEDISCRETE | SCHEDULE_FREQUENCY | CHAR(412) | EagleML/referenceTransaction/schedule/discretescheduleFrequency | ||||||||||||||||
exerciseDatescheduleLocalCurrency | dateCurrencyCode | 36593674 | in_sch_exerciselocal_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_fixing_sharesdate | SECURITYDBO | SCHEDULE | SHARES | NUMBER(28,12)FIXING_DATE | DATE | EagleML/referenceTransaction/schedule/sharesfixingDate | |||||||||||||||
valuationDatecashPaymentDate | date | 1640916411 | in_cash_valuationpayment_date | SECURITYDBO | SCHEDULE | VALUATIONCASH_PAYMENT_DATE | DATE | EagleML/referenceTransaction/schedule/valuationDatecashPaymentDatebypassSinkCheckSwitch | ||||||||||||||||
putNotificationMaxDays | YesNoOptionEnuminteger | 174791657 | in_put_ | bypassnotification_ | 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 |