Page Comparison

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