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

Â