Utilized Fields for EML Calculated ID Logic |
|
|
|
|
|
|
|
|
Universal ID for transaction record |
ID on a cancel trade that will link back to the calcTransactionId |
ID that links the transaction record together including during rollback and replay |
|
|
|
|
Occurs once in a database |
Occurs once in a database |
Can occur many times in database |
|
|
|
|
calcTransactionId |
calcCancelTransactionId |
calcMasterTransactionId |
|
|
|
|
|
|
|
|
|
TRADE.ACCT_BASIS |
|
x |
x |
x |
|
|
TRADE.ENTITY_ID |
|
x |
x |
x |
|
|
TRADE.EVENT_SEQUENCE |
|
x |
x |
|
|
|
TRADE.RECORD_TYPE |
|
x |
x |
|
|
|
TRADE.SECURITY_ALIAS |
|
x |
x |
x |
|
|
TRADE.STAR_TAG25 |
|
x |
x |
x |
|
|
TRADE.STAR_TAG26 |
|
x |
x |
|
|
|
TRADE.TO_ACCOUNT |
|
x |
x |
|
|
|
TRADE.TO_LONG_SHORT_INDICATOR |
|
x |
x |
x |
|
|
TRADE.TO_SECURITY_ALIAS |
|
x |
x |
|
|
|
TRADE.TRANS_CODE |
|
x |
x |
|
|
|
TRADE_DETAIL.LONG_SHORT_INDICATOR |
|
x |
x |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
IncludeExtendedDetails must equal Y or ALL to get |
|
|
|
|
|
|
record_type 350 and 450 indicate open and close adjustments for corporate actions |
|
|
|
|
|
|
Order of included elements in calcTransactionId |
Max Character Length |
calcTransactionId |
calcTransactionId |
calcTransactionId |
|
|
|
|
EnhanceCalcTransactionId = N |
EnhanceCalcTransactionId = Y, record_type = 350 or 450 |
EnhanceCalcTransactionId = Y, record_type != 350 or 450 |
|
|
TRADE.ACCT_BASIS |
5 |
x |
x |
x |
|
|
TRADE.ENTITY_ID |
8 |
x |
x |
x |
|
|
TRADE.SECURITY_ALIAS |
38 |
x |
x |
x |
|
|
TRADE_DETAIL.LONG_SHORT_INDICATOR |
1 |
x |
x |
x |
|
|
TRADE.STAR_TAG25 |
255 |
x |
x |
x |
|
|
TRADE.STAR_TAG26 |
255 |
|
x |
|
|
|
TRADE.EVENT_SEQUENCE |
38 |
x |
x |
x |
|
|
TRADE.TO_ACCOUNT |
8 |
x |
x |
x |
|
|
TRADE.TO_SECURITY_ALIAS |
38 |
x |
x |
x |
|
|
TRADE.TO_LONG_SHORT_INDICATOR |
1 |
x |
x |
x |
|
|
Static Value - #C |
2 |
x |
x |
x |
|
|
|
|
394 |
649 |
394 |
|
|
Order of included elements in calcCancelTransactionId |
|
calcCancelTransactionId |
calcCancelTransactionId |
calcCancelTransactionId |
|
|
|
|
EnhanceCalcTransactionId = N |
EnhanceCalcTransactionId = Y, record_type = 350 or 450 |
EnhanceCalcTransactionId = Y, record_type != 350 or 450 |
|
|
TRADE.ACCT_BASIS |
5 |
x |
x |
x |
|
|
TRADE.ENTITY_ID |
8 |
x |
x |
x |
|
|
TRADE.SECURITY_ALIAS |
38 |
x |
x |
x |
|
|
TRADE_DETAIL.LONG_SHORT_INDICATOR |
1 |
x |
x |
x |
|
|
TRADE.STAR_TAG25 |
255 |
x |
x |
x |
|
|
TRADE.STAR_TAG26 |
255 |
|
x |
|
|
|
TRADE.EVENT_SEQUENCE |
38 |
x |
x |
x |
|
|
TRADE.TO_ACCOUNT |
8 |
x |
x |
x |
|
|
TRADE.TO_SECURITY_ALIAS |
38 |
x |
x |
x |
|
|
TRADE.TO_LONG_SHORT_INDICATOR |
1 |
x |
x |
x |
|
|
|
|
392 |
647 |
392 |
|
|
Order of included elements in calcMasterTransactionId |
|
calcMasterTransactionId |
calcMasterTransactionId |
calcMasterTransactionId |
|
|
|
|
EnhanceCalcTransactionId = N |
EnhanceCalcTransactionId = Y, record_type = 350 or 450 |
EnhanceCalcTransactionId = Y, record_type != 350 or 450 |
|
|
TRADE.ACCT_BASIS |
5 |
|
x |
x |
|
|
TRADE.ENTITY_ID |
8 |
|
x |
x |
|
|
TRADE.SECURITY_ALIAS |
38 |
|
x |
x |
|
|
TRADE_DETAIL.LONG_SHORT_INDICATOR |
1 |
|
x |
x |
|
|
TRADE.STAR_TAG25 |
255 |
x |
x |
x |
|
|
|
|
255 |
307 |
307 |
|
|