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