Versions Compared

Key

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

...


...

  • 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

Anchor
top
top
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


reserved for customizationsVARCHAR2(255)not stored in DBnot stored in DB, used in load logicsnot stored in DB, used in load logicsnot stored in DBstring3251char1CHAR1VARCHAR230scheduleIdsub_typeSUB_TYPECHAR8scheduleTypepricedecimal1249schedulepriceSCHEDULEPRICENUMBER(28,12)priceratedecimal1249schedulepriceSCHEDULEPRICENUMBER(28,12)ratenot stored in DBYesNoOptionEnum17479bypasssinkcheckBYPASSSINKCHECKVARCHAR2(1)bypassSinkCheckSwitchfixingDatedate16410fixingdateDATEfixingDatecashPaymentDatedate16411cashpaymentdateCASHPAYMENTDATEDATEcashPaymentDateresetDatedate16408resetdateresetDate
ElementCommentsValue TypeStar TagSP ParameterEagle DBDB TableDB FieldDB Field TypeXpath
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




DATEEagleML/referenceTransaction/schedule/updateTimestamp
customElementsNot recommendedCustomElements - Complex type

reserved for customizations
EagleML/referenceTransaction/schedule/customElements
sourceNameRequiredstring - needed for resolution logics1102in_short_descPACE_MASTERDBOINTERFACESSHORT_DESCCHAR(15)EagleML/referenceTransaction/schedule/sourceName
updateSource
string944in_update_sourceSECURITYDBOSCHEDULEUPDATE_SOURCEVARCHAR2(255)EagleML/referenceTransaction/schedule/updateSource
effectiveDateRequireddate1109in_effective_dateSECURITYDBOSCHEDULEEFFECTIVE_DATEDATEEagleML/referenceTransaction/schedule/objectTypeeffectiveDate
objectIdlanguageId
ObjectIdinteger

not stored in DB
EagleML/referenceTransaction/schedule/objectIdlanguageId
tagNochangecase
objectDescriptionstringFeedTypeEnum4637
not stored in DB
EagleML/referenceTransaction/schedule/objectDescriptiontagNochangecase
preserveNull
updateTimestampstringdateTimeDATE5284
not stored in DB
EagleML/referenceTransaction/schedule/updateTimestamppreserveNull
customElementsnoLoadValidationFlagNot recommendedCustomElements - Complex type
YesNoOptionEnum

not stored in DB, used in load logics
EagleML/referenceTransaction/schedule/customElementsnoLoadValidationFlag
sourceNameaccountingValidationFlagRequiredstring - needed for resolution logics1102in_short_descPACE_MASTERDBOINTERFACESSHORT_DESC
CHAR(15)YesNoOptionEnum

not stored in DB, used in load logics
EagleML/referenceTransaction/schedule/sourceNameaccountingValidationFlag
updateSourceskipIfExistFlag
stringYesNoOptionEnum944in_update_sourceSECURITYDBOSCHEDULEUPDATE_SOURCE

not stored in DB, used in load logics
EagleML/referenceTransaction/schedule/updateSourceeffectiveDateRequireddate1109in_effective_dateSECURITYDBOSCHEDULEEFFECTIVE_DATEDATEskipIfExistFlag
Asset Identifiers ModelEagleML/referenceTransaction/schedule/effectiveDate
languageIdsetEligibleFlag
integerYesNoOptionEnum

not stored in DB
EagleML/referenceTransaction/schedule/languageIdsetEligibleFlag
tagNochangecasesecurityMasterSource
string4637

PACE_MASTERDBOINTERFACESSHORT_DESC
EagleML/referenceTransaction/schedule/tagNochangecasesecurityMasterSource
preserveNullscheduleId
string52843251not stored in DBEagleML/referenceTransaction/schedule/preserveNullnoLoadValidationFlagYesNoOptionEnumin_schedule_char1SECURITYDBOSCHEDULESCHEDULE_CHAR1VARCHAR2(30)EagleML/referenceTransaction/schedule/noLoadValidationFlagaccountingValidationFlagYesNoOptionEnumnot stored in DB, used in load logicsEagleML/referenceTransaction/schedule/accountingValidationFlagskipIfExistFlagYesNoOptionEnumscheduleId
scheduleTypesee the note above about reversed mappingScheduleTypeEnum1250in_schedule_sub_typeSECURITYDBOSCHEDULESCHEDULE_SUB_TYPECHAR(8)EagleML/referenceTransaction/schedule/skipIfExistFlag
Asset Identifiers ModelEagleML/referenceTransaction/schedule/
setEligibleFlagYesNoOptionEnumscheduleType
scheduleSubTypeRequiredstring3678in_schedule_typeSECURITYDBOSCHEDULESCHEDULE_TYPECHAR(4)EagleML/referenceTransaction/schedule/setEligibleFlagscheduleSubType
scheduleStatus
securityMasterSourceScheduleStatusEnumstring1670PACE_MASTERDBOINTERFACESSHORT_DESCin_schedule_statusSECURITYDBOSCHEDULESCHEDULE_STATUSVARCHAR2(12)EagleML/referenceTransaction/schedule/securityMasterSourcescheduleStatusscheduleId
price
decimal1249in_schedule_priceSECURITYDBOSCHEDULESCHEDULE_PRICENUMBER(28,12)EagleML/referenceTransaction/schedule/price
scheduleTypesee the note above about reversed mappingScheduleTypeEnum1250rate
decimal1249in_schedule_priceSECURITYDBOSCHEDULESCHEDULE_PRICENUMBER(28,12)EagleML/referenceTransaction/schedule/rate
scheduleSubTypescheduleAmount
Requireddecimalstring36781669in_schedule_typeamountSECURITYDBOSCHEDULESCHEDULE_TYPEAMOUNTCHARNUMBER(428,12)EagleML/referenceTransaction/schedule/scheduleSubTypescheduleAmount
scheduleStatusscheduleFloat1
ScheduleStatusEnumdecimal16705534in_schedule_statusfloat1SECURITYDBOSCHEDULESCHEDULE_STATUSFLOAT1VARCHAR2NUMBER(28,12)EagleML/referenceTransaction/schedule/scheduleStatusscheduleFloat1
endDate
date73in_end_dateSECURITYDBOSCHEDULEEND_DATEDATEEagleML/referenceTransaction/schedule/endDate
accrualDateCust
date8504in_accrual_date_custSECURITYDBOSCHEDULEACCRUAL_DATE_CUSTDATEEagleML/referenceTransaction/schedule/accrualDateCust
scheduleAmountdetermDate1decimal1669in_schedule_amountSECURITYDBOSCHEDULESCHEDULE_AMOUNT
NUMBER(28,12)date

not stored in DB
EagleML/referenceTransaction/schedule/determDate1
determDate2
date

not stored in DB
EagleML/referenceTransaction/schedule/scheduleAmountdetermDate2
scheduleFloat1nextAccrualDate
decimaldate55348502in_schedulenext_accrual_float1dateSECURITYDBOSCHEDULESCHEDULENEXT_ACCRUAL_FLOAT1NUMBER(28,12)DATEDATEEagleML/referenceTransaction/schedule/scheduleFloat1nextAccrualDate
endDatepayDate
date738503in_endpay_dateSECURITYDBOSCHEDULEENDPAY_DATEDATEEagleML/referenceTransaction/schedule/endDatepayDate
accrualDateCustnextCallDate
date85041241in_accrualnext_call_date_custSECURITYDBOSCHEDULEACCRUALNEXT_CALL_DATE_CUSTDATEEagleML/referenceTransaction/schedule/accrualDateCustnextCallDate
nextCallPrice
determDate1decimaldate1242not stored in DBEagleML/referenceTransaction/schedule/determDate1determDate2datein_next_call_priceSECURITYDBOSCHEDULENEXT_CALL_PRICENUMBER(28,12)EagleML/referenceTransaction/schedule/determDate2nextCallPrice
nextAccrualDatenextPutDate
date85021243in_next_accrualput_dateSECURITYDBOSCHEDULENEXT_ACCRUALPUT_DATEDATEEagleML/referenceTransaction/schedule/nextAccrualDatenextPutDate
payDatenextPutPrice
datedecimal85031244in_paynext_put_datepriceSECURITYDBOSCHEDULEPAYNEXT_PUT_DATEDATEPRICENUMBER(28,12)EagleML/referenceTransaction/schedule/payDatenextPutPrice
nextCallDateparCallDate
date12411245in_nextpar_call_dateSECURITYDBOSCHEDULENEXTPAR_CALL_DATEDATEEagleML/referenceTransaction/schedule/nextCallDateparCallDate
nextCallPriceparPutDate
decimaldate12421246in_nextpar_callput_pricedateSECURITYDBOSCHEDULENEXTPAR_CALLPUT_PRICENUMBER(28,12)DATEDATEEagleML/referenceTransaction/schedule/nextCallPriceparPutDate
nextPutDatescheduleChar1
datestring12433664in_nextschedule_put_datechar1SECURITYDBOSCHEDULENEXTSCHEDULE_PUT_DATEDATECHAR1VARCHAR2(30)EagleML/referenceTransaction/schedule/nextPutDatescheduleChar1
nextPutPricescheduleChar2
decimalstring12443665in_nextschedule_put_pricechar2SECURITYDBOSCHEDULENEXTSCHEDULE_PUT_PRICECHAR2NUMBERVARCHAR2(28,1230)EagleML/referenceTransaction/schedule/nextPutPricescheduleChar2
parCallDatescheduleChar3
datestring12453666in_parschedule_call_datechar3SECURITYDBOSCHEDULEPARSCHEDULE_CALL_DATEDATECHAR3VARCHAR2(30)EagleML/referenceTransaction/schedule/parCallDatescheduleChar3
parPutDatescheduleChar4
datestring12463667in_parschedule_put_datechar4SECURITYDBOSCHEDULEPARSCHEDULE_PUT_DATEDATECHAR4VARCHAR2(30)EagleML/referenceTransaction/schedule/parPutDatescheduleChar4
scheduleChar1scheduleChar5
string36643668in_schedule_char1char5SECURITYDBOSCHEDULESCHEDULE_CHAR1CHAR5VARCHAR2(30)EagleML/referenceTransaction/schedule/scheduleChar1scheduleChar5
scheduleChar2scheduleDate1
stringdate36653669in_schedule_char2date1SECURITYDBOSCHEDULESCHEDULE_CHAR2VARCHAR2(30)DATE1DATEEagleML/referenceTransaction/schedule/scheduleChar2scheduleDate1
scheduleChar3scheduleDate2
stringdate36663670in_schedule_char3date2SECURITYDBOSCHEDULESCHEDULE_CHAR3VARCHAR2(30)DATE2DATEEagleML/referenceTransaction/schedule/scheduleChar3scheduleDate2
scheduleChar4scheduleDate3
stringdate36673671in_schedule_char4date3SECURITYDBOSCHEDULESCHEDULE_CHAR4VARCHAR2(30)DATE3DATEEagleML/referenceTransaction/schedule/scheduleChar4scheduleDate3
scheduleChar5scheduleDate4
stringdate36683672in_schedule_char5date4SECURITYDBOSCHEDULESCHEDULE_CHAR5VARCHAR2(30)DATE4DATEEagleML/referenceTransaction/schedule/scheduleChar5scheduleDate4
scheduleDate1scheduleDate5
date36693673in_schedule_date1date5SECURITYDBOSCHEDULESCHEDULE_DATE1DATE5DATEEagleML/referenceTransaction/schedule/scheduleDate1scheduleDate5
scheduleDate2scheduleDate6
date36708279in_schedule_date2date6SECURITYDBOSCHEDULESCHEDULE_DATE2DATE6DATEEagleML/referenceTransaction/schedule/scheduleDate2scheduleDate6
scheduleDate3scheduleDate7
date36718280in_schedule_date3date7SECURITYDBOSCHEDULESCHEDULE_DATE3DATE7DATEEagleML/referenceTransaction/schedule/scheduleDate3scheduleDate7
scheduleDate4scheduleDate8
date36728281in_schedule_date4date8SECURITYDBOSCHEDULESCHEDULE_DATE4DATE8DATEEagleML/referenceTransaction/schedule/scheduleDate4scheduleDate8
scheduleDate5scheduleDate9
date36738282in_schedule_date5date9SECURITYDBOSCHEDULESCHEDULE_DATE5DATE9DATEEagleML/referenceTransaction/schedule/scheduleDate5scheduleDate9
scheduleDate6scheduleDate10
date82798283in_schedule_date6date10SECURITYDBOSCHEDULESCHEDULE_DATE6DATE10DATEEagleML/referenceTransaction/schedule/scheduleDate6scheduleDate10
scheduleDate7scheduleFloat2
datedecimal82805235in_schedule_date7float2SECURITYDBOSCHEDULESCHEDULE_DATE7DATEFLOAT2NUMBER(28,12)EagleML/referenceTransaction/schedule/scheduleDate7scheduleFloat2
scheduleDate8scheduleFloat3
datedecimal82815236in_schedule_date8float3SECURITYDBOSCHEDULESCHEDULE_DATE8DATEFLOAT3NUMBER(28,12)EagleML/referenceTransaction/schedule/scheduleDate8scheduleFloat3
scheduleDate9scheduleFloat4
datedecimal82828284in_schedule_date9float4SECURITYDBOSCHEDULESCHEDULE_DATE9DATEFLOAT4NUMBER(28,12)EagleML/referenceTransaction/schedule/scheduleDate9scheduleFloat4
scheduleDate10scheduleFloat5
datedecimal82838285in_schedule_date10float5SECURITYDBOSCHEDULESCHEDULE_DATE10DATEFLOAT5NUMBER(28,12)EagleML/referenceTransaction/schedule/scheduleDate10scheduleFloat5
scheduleFloat2preRefundedDate
decimaldate52351247in_schedulepre_refunded_float2dateSECURITYDBOSCHEDULESCHEDULE_FLOAT2NUMBER(28,12)PRE_REFUNDED_DATEDATEEagleML/referenceTransaction/schedule/scheduleFloat2preRefundedDate
scheduleFloat3preRefundedPrice
decimal52361248in_schedulepre_refunded_float3priceSECURITYDBOSCHEDULESCHEDULEPRE_REFUNDED_FLOAT3PRICENUMBER(28,12)EagleML/referenceTransaction/schedule/scheduleFloat3preRefundedPrice
scheduleFloat4series
decimalstring82841251in_schedule_float4seriesSECURITYDBOSCHEDULESCHEDULE_FLOAT4SERIESNUMBERCHAR(28,12)EagleML/referenceTransaction/schedule/scheduleFloat4series
scheduleFloat5stepUpCoupon
decimal82851252in_step_scheduleup_float5couponSECURITYDBOSCHEDULESCHEDULESTEP_UP_FLOAT5COUPONNUMBER(28,12)EagleML/referenceTransaction/schedule/scheduleFloat5stepUpCoupon
preRefundedDatestepUpDate
date12471253in_prestep_refundedup_dateSECURITYDBOSCHEDULEPRESTEP_REFUNDEDUP_DATEDATEEagleML/referenceTransaction/schedule/preRefundedDatestepUpDate
preRefundedPriceworkoutDate
decimaldate12481254in_preworkout_refunded_pricedateSECURITYDBOSCHEDULEPREWORKOUT_REFUNDED_PRICENUMBER(28,12)DATEDATEEagleML/referenceTransaction/schedule/preRefundedPriceworkoutDate
seriesworkoutPrice
stringdecimal12511255in_workout_seriespriceSECURITYDBOSCHEDULESERIESWORKOUT_PRICECHARNUMBER(28,12)EagleML/referenceTransaction/schedule/seriesworkoutPrice
stepUpCoupondiscrete
decimalstring12523663in_step_up_coupondiscreteSECURITYDBOSCHEDULESTEP_UP_COUPONNUMBER(28,12DISCRETECHAR(4)EagleML/referenceTransaction/schedule/stepUpCoupondiscrete
stepUpDateexerciseDate
date12533659in_stepexercise_up_dateSECURITYDBOSCHEDULESTEPEXERCISE_UP_DATEDATEEagleML/referenceTransaction/schedule/stepUpDateexerciseDate
workoutDateexercisePrice
datedecimal12543661in_workoutexercise_datepriceSECURITYDBOSCHEDULEWORKOUTEXERCISE_DATEDATEPRICENUMBER(28,12)EagleML/referenceTransaction/schedule/workoutDateexercisePrice
workoutPricelocalCurrencySchedule
decimalCurrencyCode12553677in_workoutlocal_curr_priceschSECURITYDBOSCHEDULEWORKOUTLOCAL_CURR_PRICESCHNUMBERCHAR(28,123)EagleML/referenceTransaction/schedule/workoutPricelocalCurrencySchedule
discretescheduleFrequency
string36633662in_discreteschedule_frequencySECURITYDBOSCHEDULEDISCRETESCHEDULE_FREQUENCYCHAR(412)EagleML/referenceTransaction/schedule/discretescheduleFrequency
exerciseDatescheduleLocalCurrency
dateCurrencyCode36593674in_sch_exerciselocal_datecurrencySECURITYDBOSCHEDULEEXERCISESCH_LOCAL_DATEDATECURRENCYVARCHAR2(3)EagleML/referenceTransaction/schedule/exerciseDatescheduleLocalCurrency
exercisePricescheduleBaseCurrency
decimalCurrencyCode36613675in_sch_exercisebase_pricecurrencySECURITYDBOSCHEDULEEXERCISESCH_BASE_PRICECURRENCYNUMBERVARCHAR2(28,123)EagleML/referenceTransaction/schedule/exercisePricescheduleBaseCurrency
localCurrencyScheduleshares
CurrencyCodedecimal36773660in_local_curr_schsharesSECURITYDBOSCHEDULELOCAL_CURR_SCHCHAR(3SHARESNUMBER(28,12)EagleML/referenceTransaction/schedule/localCurrencyScheduleshares
scheduleFrequencybypassSinkCheckSwitch
stringYesNoOptionEnum366217479in_bypass_schedulesink_frequencycheckSECURITYDBOSCHEDULESCHEDULEBYPASS_SINK_FREQUENCYCHECKCHARVARCHAR2(121)EagleML/referenceTransaction/schedule/scheduleFrequencybypassSinkCheckSwitch
scheduleLocalCurrencyresetDate
CurrencyCodedate367416408in_schreset_local_currencydateSECURITYDBOSCHEDULESCHRESET_LOCAL_CURRENCYVARCHAR2(3)DATEDATEEagleML/referenceTransaction/schedule/scheduleLocalCurrencyresetDate
scheduleBaseCurrencyvaluationDate
CurrencyCodedate367516409in_schvaluation_base_currencydateSECURITYDBOSCHEDULESCHVALUATION_BASE_CURRENCYVARCHAR2(3)DATEDATEEagleML/referenceTransaction/schedule/scheduleBaseCurrencyvaluationDate
sharesfixingDate
decimaldate366016410in_fixing_sharesdateSECURITYDBOSCHEDULESHARESNUMBER(28,12)FIXING_DATEDATEEagleML/referenceTransaction/schedule/sharesfixingDate
valuationDatecashPaymentDate
date1640916411in_cash_valuationpayment_dateSECURITYDBOSCHEDULEVALUATIONCASH_PAYMENT_DATEDATEEagleML/referenceTransaction/schedule/valuationDatecashPaymentDatebypassSinkCheckSwitch
putNotificationMaxDays
integer1657in_put_notification_max_daysSECURITYDBOSCHEDULEPUT_NOTIFICATION_MAX_DAYSNUMBEREagleML/referenceTransaction/schedule/putNotificationMaxDays
putNotificationMinDays
integer1658in_put_notification_min_daysSECURITYDBOSCHEDULEFIXING_DATEPUT_NOTIFICATION_MIN_DAYSNUMBEREagleML/referenceTransaction/schedule/putNotificationMinDays
baseCurrSch
string3676in_base_curr_schSECURITYDBOSCHEDULEBASE_CURR_SCHCHAR(3)EagleML/referenceTransaction/schedule/baseCurrSch
journalizingFlag
JournalizingFlagEnum1293in_journal_SECURITYDBOSCHEDULERESET_DATEDATEflagnot stored in DBEagleML/referenceTransaction/schedule/journalizingFlag