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 |
|
|
|
|
|
|
|
|
|
ESTAR_TRADED_CASH_ACTIVITY.ACCT_BASIS |
|
x |
x |
x |
|
|
ESTAR_TRADED_CASH_ACTIVITY.PORTFOLIO_ACCT |
|
x |
x |
x |
|
|
ESTAR_TRADED_CASH_ACTIVITY.ASSET_ID |
|
x |
x |
x |
|
|
ESTAR_TRADED_CASH_ACTIVITY.LNG_SHT_C |
|
x |
x |
x |
|
|
ESTAR_TRADED_CASH_ACTIVITY.LINK_EVENT_ID |
|
x |
x |
x |
|
|
ESTAR_TRADED_CASH_ACTIVITY.EVENT_SEQUENCE |
|
x |
x |
x |
|
|
ESTAR_TRADED_CASH_ACTIVITY.CANCEL_EVT_ID |
|
x |
x |
|
|
|
ESTAR_TRADED_CASH_ACTIVITY.EVENT_TYPE |
|
|
|
x |
|
|
SECURITY_MASTER.PROCESS_SEC_TYPE |
|
|
|
x |
|
|
ESTAR_TRADED_CASH_ACTIVITY.COUPON_DATE |
|
|
|
x |
|
|
ESTAR_TRADED_CASH_ACTIVITY.LINK_EVENT_ID |
|
|
|
x |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
IncludeExtendedDetails must equal Y or ALL |
|
calcTransactionId |
calcTransactionId |
|
|
|
Order of included elements in calcTransactionId |
Max Character Length |
EnhanceCalcTransactionId = N |
EnhanceCalcTransactionId = Y |
|
|
|
|
|
|
|
|
|
|
ESTAR_TRADED_CASH_ACTIVITY.ACCT_BASIS |
5 |
x |
x |
|
|
|
ESTAR_TRADED_CASH_ACTIVITY.PORTFOLIO_ACCT |
8 |
x |
x |
|
|
|
ESTAR_TRADED_CASH_ACTIVITY.ASSET_ID |
38 |
x |
x |
|
|
|
ESTAR_TRADED_CASH_ACTIVITY.LNG_SHT_C |
1 |
x |
x |
|
|
|
ESTAR_TRADED_CASH_ACTIVITY.LINK_EVENT_ID |
255 |
x |
x |
|
|
|
ESTAR_TRADED_CASH_ACTIVITY.EVENT_SEQUENCE |
38 |
x |
x |
|
|
|
'#C' |
2 |
x |
x |
|
|
|
|
|
347 |
347 |
|
|
|
ESTAR_TRADED_CASH_ACTIVITY.CANCEL_EVT_ID is not null |
|
calcCancelTransactionId |
calcCancelTransactionId |
|
|
|
Order of included elements in calcCancelTransactionId |
|
EnhanceCalcTransactionId = N |
EnhanceCalcTransactionId = Y |
|
|
|
|
|
|
|
|
|
|
ESTAR_TRADED_CASH_ACTIVITY.ACCT_BASIS |
5 |
x |
x |
|
|
|
ESTAR_TRADED_CASH_ACTIVITY.PORTFOLIO_ACCT |
8 |
x |
x |
|
|
|
ESTAR_TRADED_CASH_ACTIVITY.ASSET_ID |
38 |
x |
x |
|
|
|
ESTAR_TRADED_CASH_ACTIVITY.LNG_SHT_C |
1 |
x |
x |
|
|
|
ESTAR_TRADED_CASH_ACTIVITY.LINK_EVENT_ID |
255 |
x |
x |
|
|
|
ESTAR_TRADED_CASH_ACTIVITY.EVENT_SEQUENCE |
38 |
x |
x |
|
|
|
|
|
345 |
345 |
|
|
|
|
|
calcMasterTransactionId |
calcMasterTransactionId |
|
|
|
Order of included elements in calcMasterTransactionId |
|
EnhanceCalcTransactionId = N |
EnhanceCalcTransactionId = Y |
|
|
|
|
|
|
|
|
|
|
ESTAR_TRADED_CASH_ACTIVITY.ACCT_BASIS |
5 |
|
x |
|
|
|
ESTAR_TRADED_CASH_ACTIVITY.PORTFOLIO_ACCT |
8 |
|
x |
|
|
|
ESTAR_TRADED_CASH_ACTIVITY.ASSET_ID |
38 |
|
x |
|
|
|
ESTAR_TRADED_CASH_ACTIVITY.LNG_SHT_C |
1 |
|
x |
|
|
|
ESTAR_TRADED_CASH_ACTIVITY.LINK_EVENT_ID |
255 |
x |
x |
|
|
|
|
|
255 |
307 |
|
|
|
|
|
|
|
|
|
|
|
|
ESTAR_TRADED_CASH_ACTIVITY.EVENT_TYPE = 'COUPON' OR (ESTAR_TRADED_CASH_ACTIVITY.EVENT_TYPE = 'RECLAIM' AND SUBSTR(SECURITY_MASTER.PROCESS_SEC_TYPE,0,2)='DB') |
|
|
|
|
|
|
SECURITY_MASTER.PROCESS_SEC_TYPE =DBAMTL |
|
|
|
|
ESTAR_TRADED_CASH_ACTIVITY.ACCT_BASIS |
5 |
x |
x |
|
|
|
ESTAR_TRADED_CASH_ACTIVITY.PORTFOLIO_ACCT |
8 |
x |
x |
|
|
|
ESTAR_TRADED_CASH_ACTIVITY.ASSET_ID |
38 |
x |
x |
|
|
|
ESTAR_TRADED_CASH_ACTIVITY.LNG_SHT_C |
1 |
x |
x |
|
|
|
'19000101' |
8 |
x |
x |
|
|
|
|
|
60 |
60 |
|
|
|
|
|
|
|
|
|
|
|
|
ESTAR_TRADED_CASH_ACTIVITY.EVENT_TYPE = 'COUPON' OR (ESTAR_TRADED_CASH_ACTIVITY.EVENT_TYPE = 'RECLAIM' AND SUBSTR(SECURITY_MASTER.PROCESS_SEC_TYPE,0,2)='DB') |
|
|
|
|
|
|
SECURITY_MASTER.PROCESS_SEC_TYPE <>DBAMTL |
|
|
|
|
ESTAR_TRADED_CASH_ACTIVITY.ACCT_BASIS |
5 |
x |
x |
|
|
|
ESTAR_TRADED_CASH_ACTIVITY.PORTFOLIO_ACCT |
8 |
x |
x |
|
|
|
ESTAR_TRADED_CASH_ACTIVITY.ASSET_ID |
38 |
x |
x |
|
|
|
ESTAR_TRADED_CASH_ACTIVITY.LNG_SHT_C |
1 |
x |
x |
|
|
|
ESTAR_TRADED_CASH_ACTIVITY.COUPON_DATE |
8 |
x |
x |
|
|
|
|
|
60 |
60 |
|
|
|