Note
When you load a schedule, scheduleType and scheduleSubType mappings to DB can be swapped by setting
- W_REFERENCE_SHEDULE_TYPE_REMAP – global flag or
- REMAP_SHEDULE_TYPE – processing option for a single load event.
Element | Optional/Required | Value Type | Star Tag | SP Parameter | Eagle DB | DB Table | DB Field | DB Field Type | Xpath |
---|---|---|---|---|---|---|---|---|---|
objectType | Optional | ObjectTypeEnum | not stored in DB | EagleML/referenceTransaction/schedule/objectType | |||||
objectId | Optional | ObjectId | not stored in DB | EagleML/referenceTransaction/schedule/objectId | |||||
objectDescription | Optional | FeedTypeEnum | not stored in DB | EagleML/referenceTransaction/schedule/objectDescription | |||||
updateTimestamp | Optional | dateTime | not stored in DB | DATE | EagleML/referenceTransaction/schedule/updateTimestamp | ||||
customElements | Not recommended | CustomElements - Complex type | reserved for customizations | EagleML/referenceTransaction/schedule/customElements | |||||
sourceName | Optional | string - needed for resolution logics | 1102 | in_short_desc | PACE_MASTERDBO | INTERFACES | SHORT_DESC | CHAR(15) | EagleML/referenceTransaction/schedule/sourceName |
updateSource | Optional | string | 944 | in_update_source | SECURITYDBO | SCHEDULE | UPDATE_SOURCE | VARCHAR2(255) | EagleML/referenceTransaction/schedule/updateSource |
effectiveDate | Optional | date | 1109 | in_effective_date | SECURITYDBO | SCHEDULE | EFFECTIVE_DATE | DATE | EagleML/referenceTransaction/schedule/effectiveDate |
languageId | Optional | integer | not stored in DB | EagleML/referenceTransaction/schedule/languageId | |||||
tagNochangecase | Optional | string | 4637 | not stored in DB | EagleML/referenceTransaction/schedule/tagNochangecase | ||||
preserveNull | Optional | string | 5284 | not stored in DB | EagleML/referenceTransaction/schedule/preserveNull | ||||
noLoadValidationFlag | Optional | YesNoOptionEnum | not stored in DB, used in load logics | EagleML/referenceTransaction/schedule/noLoadValidationFlag | |||||
accountingValidationFlag | Optional | YesNoOptionEnum | not stored in DB, used in load logics | EagleML/referenceTransaction/schedule/accountingValidationFlag | |||||
Asset Identifiers Model | EagleML/referenceTransaction/schedule/ | ||||||||
setEligibleFlag | Optional | YesNoOptionEnum | not stored in DB | EagleML/referenceTransaction/schedule/setEligibleFlag | |||||
securityMasterSource | Optional | string | PACE_MASTERDBO | INTERFACES | SHORT_DESC | EagleML/referenceTransaction/schedule/securityMasterSource | |||
scheduleId | Optional | string | 3664 | in_schedule_char1 | SECURITYDBO | SCHEDULE | SCHEDULE_CHAR1 | VARCHAR2(30) | EagleML/referenceTransaction/schedule/scheduleId |
scheduleType | Optional | ScheduleTypeEnum | 1250 | in_schedule_sub_type | SECURITYDBO | SCHEDULE | SCHEDULE_SUB_TYPE | CHAR(8) | EagleML/referenceTransaction/schedule/scheduleType |
scheduleSubType | Required | string | 3678 | in_schedule_type | SECURITYDBO | SCHEDULE | SCHEDULE_TYPE | CHAR(4) | EagleML/referenceTransaction/schedule/scheduleSubType |
scheduleStatus | Optional | ScheduleStatusEnum | 1670 | in_schedule_status | SECURITYDBO | SCHEDULE | SCHEDULE_STATUS | VARCHAR2(12) | EagleML/referenceTransaction/schedule/scheduleStatus |
price | Optional | decimal | 1249 | in_schedule_price | SECURITYDBO | SCHEDULE | SCHEDULE_PRICE | NUMBER(28,12) | EagleML/referenceTransaction/schedule/price |
rate | Optional | decimal | 1249 | in_schedule_price | SECURITYDBO | SCHEDULE | SCHEDULE_PRICE | NUMBER(28,12) | EagleML/referenceTransaction/schedule/rate |
scheduleAmount | Optional | decimal | 1669 | in_schedule_amount | SECURITYDBO | SCHEDULE | SCHEDULE_AMOUNT | NUMBER(28,12) | EagleML/referenceTransaction/schedule/scheduleAmount |
scheduleFloat1 | Optional | decimal | 5534 | in_schedule_float1 | SECURITYDBO | SCHEDULE | SCHEDULE_FLOAT1 | NUMBER(28,12) | EagleML/referenceTransaction/schedule/scheduleFloat1 |
endDate | Optional | date | 73 | in_end_date | SECURITYDBO | SCHEDULE | END_DATE | DATE | EagleML/referenceTransaction/schedule/endDate |
accrualDateCust | Optional | date | 8504 | in_accrual_date_cust | SECURITYDBO | SCHEDULE | ACCRUAL_DATE_CUST | DATE | EagleML/referenceTransaction/schedule/accrualDateCust |
determDate1 | Optional | date | not stored in DB | EagleML/referenceTransaction/schedule/determDate1 | |||||
determDate2 | Optional | date | not stored in DB | EagleML/referenceTransaction/schedule/determDate2 | |||||
nextAccrualDate | Optional | date | 8502 | in_next_accrual_date | SECURITYDBO | SCHEDULE | NEXT_ACCRUAL_DATE | DATE | EagleML/referenceTransaction/schedule/nextAccrualDate |
payDate | Optional | date | 8503 | in_pay_date | SECURITYDBO | SCHEDULE | PAY_DATE | DATE | EagleML/referenceTransaction/schedule/payDate |
nextCallDate | Optional | date | 1241 | in_next_call_date | SECURITYDBO | SCHEDULE | NEXT_CALL_DATE | DATE | EagleML/referenceTransaction/schedule/nextCallDate |
nextCallPrice | Optional | decimal | 1242 | in_next_call_price | SECURITYDBO | SCHEDULE | NEXT_CALL_PRICE | NUMBER(28,12) | EagleML/referenceTransaction/schedule/nextCallPrice |
nextPutDate | Optional | date | 1243 | in_next_put_date | SECURITYDBO | SCHEDULE | NEXT_PUT_DATE | DATE | EagleML/referenceTransaction/schedule/nextPutDate |
nextPutPrice | Optional | decimal | 1244 | in_next_put_price | SECURITYDBO | SCHEDULE | NEXT_PUT_PRICE | NUMBER(28,12) | EagleML/referenceTransaction/schedule/nextPutPrice |
parCallDate | Optional | date | 1245 | in_par_call_date | SECURITYDBO | SCHEDULE | PAR_CALL_DATE | DATE | EagleML/referenceTransaction/schedule/parCallDate |
parPutDate | Optional | date | 1246 | in_par_put_date | SECURITYDBO | SCHEDULE | PAR_PUT_DATE | DATE | EagleML/referenceTransaction/schedule/parPutDate |