Spd Delta Trigger Log Data Map Table

Owned by Dmitry Donosiyan (Unlicensed)
Last updated: Oct 31, 2024 by Kinga Huszno
1 min read

Element

Value Type

Star Tag

Eagle DB

DB Table

DB Field

Data Type

XPath

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

Â