Versions Compared

Key

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

Element

Value Type

Star Tag

Eagle DB

DB Table

DB Field

Data Type

XPath

objectType

objectType

not stored in DB

EagleML/s2pReportingTransaction/spdDeltaTriggerLog/objectType

objectId

objectId

not stored in DB

EagleML/s2pReportingTransaction/spdDeltaTriggerLog/objectId

objectDescription

objectDescription

not stored in DB

EagleML/s2pReportingTransaction/spdDeltaTriggerLog/objectDescription

updateTimestamp

dateTime

ESTAR

SPD_DELTA_TRIGGER_LOG_HIST

UPDATE_DATE

DATE

EagleML/s2pReportingTransaction/spdDeltaTriggerLog/updateTimestamp

updateSource

string

ESTAR

SPD_DELTA_TRIGGER_LOG_HIST

UPDATE_USER

VARCHAR2(32)

EagleML/s2pReportingTransaction/spdDeltaTriggerLog/updateSource

sourceName

not stored in DB

EagleML/s2pReportingTransaction/spdDeltaTriggerLog/sourceName

localCurrency

CurrencyCode

ESTAR

SPD_DELTA_TRIGGER_LOG_HIST

LOCAL_CURRENCY

VARCHAR2(3)

EagleML/s2pReportingTransaction/spdDeltaTriggerLog/localCurrency

longShortIndicator

LongShortIndicatorEnum

ESTAR

SPD_DELTA_TRIGGER_LOG_HIST

LONG_SHORT_IND

CHAR(1)

EagleML/s2pReportingTransaction/spdDeltaTriggerLog/longShortIndicator

entityId

string

RULESDBO

ENTITY

ENTITY_ID

CHAR(8)

EagleML/s2pReportingTransaction/spdDeltaTriggerLog/entityId

entityName

string

RULESDBO

ENTITY

ENTITY_NAME

CHAR(30)

EagleML/s2pReportingTransaction/spdDeltaTriggerLog/entityName

entityType

normalizedString

RULESDBO

ENTITY

ENTITY_TYPE

CHAR(4)

EagleML/s2pReportingTransaction/spdDeltaTriggerLog/entityType

accountingBasis

string

ESTAR

SPD_DELTA_TRIGGER_LOG_HIST

ACCT_BASIS

VARCHAR2(5)

EagleML/s2pReportingTransaction/spdDeltaTriggerLog/accountingBasis

internalId

InstrumentId

EagleML/s2pReportingTransaction/spdDeltaTriggerLog/internalId

historyType

string

ESTAR

SPD_DELTA_TRIGGER_LOG_HIST

HISTORY_TYPE

CHAR(1)

EagleML/s2pReportingTransaction/spdDeltaTriggerLog/historyType

originalHistoryType

string

ESTAR

SPD_DELTA_TRIGGER_LOG_HIST

ORIG_HISTORY_TYPE

CHAR(1)

EagleML/s2pReportingTransaction/spdDeltaTriggerLog/originalHistoryType

accountingDate

date

ESTAR

SPD_DELTA_TRIGGER_LOG_HIST

ACCTG_DATE

DATE

EagleML/s2pReportingTransaction/spdDeltaTriggerLog/accountingDate

postDate

date

ESTAR

SPD_DELTA_TRIGGER_LOG_HIST

POST_DATE

DATE

EagleML/s2pReportingTransaction/spdDeltaTriggerLog/postDate

tradeDate

date

ESTAR

SPD_DELTA_TRIGGER_LOG_HIST

TRADE_DATE

DATE

EagleML/s2pReportingTransaction/spdDeltaTriggerLog/tradeDate

settlementDate

date

ESTAR

SPD_DELTA_TRIGGER_LOG_HIST

SETTLE_DATE

DATE

EagleML/s2pReportingTransaction/spdDeltaTriggerLog/settlementDate

monthEndDate

date

ESTAR

SPD_DELTA_TRIGGER_LOG_HIST

MONTH_END_DATE

DATE

EagleML/s2pReportingTransaction/spdDeltaTriggerLog/monthEndDate

eventId

string

ESTAR

SPD_DELTA_TRIGGER_LOG_HIST

EVENT_ID

VARCHAR2(55)

EagleML/s2pReportingTransaction/spdDeltaTriggerLog/eventId

batchEventId

string

ESTAR

SPD_DELTA_TRIGGER_LOG_HIST

BATCH_EVENT_ID

VARCHAR2(55)

EagleML/s2pReportingTransaction/spdDeltaTriggerLog/batchEventId

targetEventId

string

ESTAR

SPD_DELTA_TRIGGER_LOG_HIST

TARGET_EVENT_ID

VARCHAR2(55)

EagleML/s2pReportingTransaction/spdDeltaTriggerLog/targetEventId

linkEventId

TransactionId

ESTAR

SPD_DELTA_TRIGGER_LOG_HIST

LINK_EVENT_ID

VARCHAR2(55)

EagleML/s2pReportingTransaction/spdDeltaTriggerLog/linkEventId

messageType

string

ESTAR

SPD_DELTA_TRIGGER_LOG_HIST

MESSAGE_TYPE

VARCHAR2(25)

EagleML/s2pReportingTransaction/spdDeltaTriggerLog/messageType

messageSubType

string

ESTAR

SPD_DELTA_TRIGGER_LOG_HIST

MESSAGE_SUBTYPE

VARCHAR2(25)

EagleML/s2pReportingTransaction/spdDeltaTriggerLog/messageSubType

cashCategory

string

ESTAR

SPD_DELTA_TRIGGER_LOG_HIST

CASH_CATEGORY

VARCHAR2(10)

EagleML/s2pReportingTransaction/spdDeltaTriggerLog/cashCategory

cashStatus

string

ESTAR

SPD_DELTA_TRIGGER_LOG_HIST

CASH_STATUS

VARCHAR2(10)

EagleML/s2pReportingTransaction/spdDeltaTriggerLog/cashStatus

ccFlag

integer

ESTAR

SPD_DELTA_TRIGGER_LOG_HIST

CC_FLAG

NUMBER(38)

EagleML/s2pReportingTransaction/spdDeltaTriggerLog/ccFlag

srcIntfcInst

decimal

ESTAR

SPD_DELTA_TRIGGER_LOG_HIST

SPD_DATE_TYPE

VARCHAR2(2)

EagleML/s2pReportingTransaction/spdDeltaTriggerLog/srcIntfcInst

spdDeltaInst

integer

ESTAR

SPD_DELTA_TRIGGER_LOG_HIST

SPD_DELTA_INST

NUMBER(38)

EagleML/s2pReportingTransaction/spdDeltaTriggerLog/spdDeltaInst

instance

integer

ESTAR

SPD_DELTA_TRIGGER_LOG_HIST

INSTANCE

NUMBER(38)

EagleML/s2pReportingTransaction/spdDeltaTriggerLog/instance

srcSysC

string

ESTAR

SPD_DELTA_TRIGGER_LOG_HIST

SRC_SYS_C

VARCHAR2(25)

EagleML/s2pReportingTransaction/spdDeltaTriggerLog/srcSysC