...
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
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
X | X |
ESTAR_TRADED_CASH_ACTIVITY.CANCEL_EVT_ID |
|
X |
X |
|
ESTAR_TRADED_CASH_ACTIVITY.EVENT_TYPE |
|
|
|
X |
SECURITY_MASTER.PROCESS_SEC_TYPE |
|
|
|
x
X |
ESTAR_TRADED_CASH_ACTIVITY.COUPON_DATE |
|
|
|
x
X | |||
ESTAR_TRADED_CASH_ACTIVITY.LINK_EVENT_ID |
|
|
|
x
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
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
X |
|
ESTAR_TRADED_CASH_ACTIVITY.LINK_EVENT_ID | 255 |
X |
x
X |
|
ESTAR_TRADED_CASH_ACTIVITY.EVENT_SEQUENCE | 38 |
X |
X |
|
'#C' | 2 |
x
x
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
X |
|
ESTAR_TRADED_CASH_ACTIVITY.LNG_SHT_C | 1 |
X |
x
X |
|
ESTAR_TRADED_CASH_ACTIVITY.LINK_EVENT_ID | 255 |
X |
X |
|
ESTAR_TRADED_CASH_ACTIVITY.EVENT_SEQUENCE | 38 |
x
x
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
X |
| |
ESTAR_TRADED_CASH_ACTIVITY.LNG_SHT_C | 1 |
|
X |
|
ESTAR_TRADED_CASH_ACTIVITY.LINK_EVENT_ID | 255 |
X |
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
X | X |
|
ESTAR_TRADED_CASH_ACTIVITY.PORTFOLIO_ACCT | 8 |
x
x
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
X |
|
ESTAR_TRADED_CASH_ACTIVITY.PORTFOLIO_ACCT | 8 |
X |
x
X |
|
ESTAR_TRADED_CASH_ACTIVITY.ASSET_ID | 38 |
X |
X |
|
ESTAR_TRADED_CASH_ACTIVITY.LNG_SHT_C | 1 |
x
x
X | X |
|
ESTAR_TRADED_CASH_ACTIVITY.COUPON_DATE | 8 |
X |
X |
|
|
|
60 | 60 |
|
...