...
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 |
|
...