Warehouse Trade Activity: Calculated IDs
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 |
Â