Settled Cash: Calculated IDs

Owned by Nancy Cohn (Deactivated)
Last updated: Apr 06, 2021
1 min read

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

 

Â