Panels, Binds, and Stored Procedures for Cash

The Cash default message stream has several incoming message types for which corresponding rules, panels, binds, and stored procedures are as follows:

  • Conversion Trades Only

  • Miscellaneous Cash Transactions

  • Miscellaneous Income/Expense – Asset Specific

  • Cancel Cash Entitlements

Conversion Trades Only

Cash Dividends

The following table lists the rules, panels, binds, and stored procedures used for processing the Open Cash Dividend transactions in the Cash default message stream.

CSV/STAR Rule

Panel

Bind

Procedure

CSV/STAR Rule

Panel

Bind

Procedure

csv- /or/ star-
cashdiv.xml
 

 

 

 

 

 

 

 

 

eagle/star/cash/pan-dividendconv.htm

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

CASHDIV

 

 

 

 

 

 

 

 

QUERY_NET_AMOUNT

INSERT_UPDATE_CASH_POSITION

INSERT_CASH_ACTIVITY

INSERT_CASH_ALLOCATION_LOG

INSERT_CASH_FIN_LOG

INS_SUB_RED_TRANSACTION

INS_UPD_CASH_COMMENTS

POP_DELTA_TRIG_LOG_CASH

Q_HISTORY_CASH

Coupons

The following table lists the rules, panels, binds, and stored procedures used for processing the unsettled Coupon transactions and traded rows in the message streams.

CSV/STAR Rule

Panel

Bind

Procedure

CSV/STAR Rule

Panel

Bind

Procedure

csv- /or/ star-
coupon.xml
 

 

 

 

 

 

 

 

 

eagle/star/cash/pan-pastdueintandreclaim_conv.htm
 

 

 

 

 

 

 

 

 

COUPON
 

 

 

 

 

 

 

 

 

QUERY_NET_AMOUNT

INSERT_UPDATE_CASH_POSITION

INSERT_CASH_ACTIVITY

INSERT_CASH_ALLOCATION_LOG

INSERT_CASH_FIN_LOG

INS_SUB_RED_TRANSACTION

INS_UPD_CASH_COMMENTS

POP_DELTA_TRIG_LOG_CASH

Q_HISTORY_CASH

Reclaims

The following table lists the rules, panels, binds, and stored procedures used for processing the unsettled Reclaim transactions and traded rows in the message streams.

CSV/STAR Rule

Panel

Bind

Procedure

CSV/STAR Rule

Panel

Bind

Procedure

csv- /or/ star-
reclaim.xml
 

 

 

 

 

 

 

 

 

eagle/star/cash/pan-divreclaimconv.htm
 

 

 

 

 

 

 

 

 

RECLAIM
 

 

 

 

 

 

 

 

 

QUERY_NET_AMOUNT

INSERT_UPDATE_CASH_POSITION

INSERT_CASH_ACTIVITY

INSERT_CASH_ALLOCATION_LOG

INSERT_CASH_FIN_LOG

INS_SUB_RED_TRANSACTION

INS_UPD_CASH_COMMENTS

POP_DELTA_TRIG_LOG_CASH

Q_HISTORY_CASH

Miscellaneous Cash Transactions

The following table lists the rules, panels, binds, and stored procedures used for processing the Miscellaneous Cash transactions in the message streams.

CSV/STAR Rule

Panel

Bind

Procedure

CSV/STAR Rule

Panel

Bind

Procedure

csv- /or/ star-
cash.xml
 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

eagle/star/cash/pan-cashcontribution.htm

 

 

 

 

 

 

 

 

CONTRIBUTION
 

 

 

 

 

 

 

 

 

Q_HISTORY_CASH

INSERT_UPDATE_CASH_POSITION

INSERT_CASH_ACTIVITY

POP_DELTA_TRIG_LOG_CASH

INSERT_CASH_FIN_LOG

INS_SUB_RED_TRANSACTION

INS_UPD_CASH_COMMENTS

INSERT_CASH_ALLOCATION_LOG

QUERY_NET_AMOUNT

eagle/star/cash/pan-miscincome.htm

MISCINC

Same as above.

eagle/star/cash/pan-cashwithdrawal.htm

 

 

 

 

 

 

 

 

WITHDRAWAL

 

 

 

 

 

 

 

 

 

Q_HISTORY_CASH

INSERT_UPDATE_CASH_POSITION

INSERT_CASH_ACTIVITY

POP_DELTA_TRIG_LOG_CASH

INSERT_CASH_FIN_LOG

INS_SUB_RED_TRANSACTION

INS_UPD_CASH_COMMENTS

INSERT_CASH_ALLOCATION_LOG

QUERY_NET_AMOUNT

eagle/star/cash/pan-miscexpense.htm 

MISCEXP

 

 

 

 

 

 

 

 

 

 

 

INSERT_UPDATE_CASH_POSITION

INSERT_CASH_ACTIVITY

INSERT_CASH_ALLOCATION_LOG

INSERT_CASH_FIN_LOG

INS_SUB_RED_TRANSACTION

INS_UPD_CASH_COMMENTS

POP_DELTA_TRIG_LOG_CASH

Q_HISTORY_CASH

QUERY_NET_AMOUNT

TRIGGER_POST_1DAY_ACCRUAL

UPD_FEE_PAYMENT_RELEASE_FLAG

eagle/star/cash/pan-miscincomeadj.htm

MISCINCADJ

 

eagle/star/cash/pan-miscexpenseadj.htm

MISCEXPADJ

 

Miscellaneous Income/Expense – Asset Specific

The following table lists the rules, panels, binds, and stored procedures used for processing the Miscellaneous Income/Expense – Asset Specific transactions in the message streams.

CSV/STAR Rule

Panel

Bind

Procedure

CSV/STAR Rule

Panel

Bind

Procedure

csv- /or/ star-
asset_specific_misc_inc_exp.xml

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

eagle/star/cash/pan-miscincome-issue-specific.htm

 

 

 

 

 

MISCINC

 

 

 

 

 

 

 

 

QUERY_NET_AMOUNT

INSERT_UPDATE_CASH_POSITION

INSERT_CASH_ACTIVITY

INSERT_CASH_ALLOCATION_LOG

INSERT_CASH_FIN_LOG

INS_SUB_RED_TRANSACTION

INS_UPD_CASH_COMMENTS

POP_DELTA_TRIG_LOG_CASH

Q_HISTORY_CASH

eagle/star/cash/pan-miscexpense-issue-specific.htm
 

 

 

 

 

 

 

 

 

 

 

MISCEXP

 

 

 

 

 

 

 

 

 

 

INSERT_UPDATE_CASH_POSITION

INSERT_CASH_ACTIVITY

INSERT_CASH_ALLOCATION_LOG

INSERT_CASH_FIN_LOG

INS_SUB_RED_TRANSACTION

INS_UPD_CASH_COMMENTS

POP_DELTA_TRIG_LOG_CASH

Q_HISTORY_CASH

QUERY_NET_AMOUNT

TRIGGER_POST_1DAY_ACCRUAL

UPD_FEE_PAYMENT_RELEASE_FLAG

Cancel Cash Entitlements

The following table lists the rules, panels, binds, and stored procedures used for processing the Cancel Cash Entitlements transactions in the message streams.

CSV/STAR Rule

Panel

Bind

Procedure

CSV/STAR Rule

Panel

Bind

Procedure

csv- /or/ star-
cancelcash.xml

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

eagle/star/cash/pan-cancelentitlements.htm

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

CANCELCASH

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

CANCEL_SUB_RED_TRANSACTION

INSERT_UPDATE_CASH_POSITION

INSERT_UPDATE_COST_POSITION

CUSTODY_CHECK

INSERT_CASH_ACTIVITY

INSERT_CASH_ALLOCATION_LOG

INSERT_CASH_FIN_LOG

INSERT_ESTAR_VARMGN_LOG

INSERT_FINANCIAL_EVT

INSERT_INC_FIN_LOG

INS_UPD_CASH_COMMENTS

POPULATE_DELTA_TRIGGER_LOG

POP_DELTA_TRIG_LOG_CASH

PPA_LOG_MANUAL_SWEEP

Q_HISTORY

Q_HISTORY_CASH

TRIGGER_FEE_SETT_REVERSAL

TRIG_AUTO_FEE_CANCEL

UPDATE_FEE_TRIGGER_STATUS

eagle/star/cash/pan-canrecpayconv1.htm

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

CANCELCASH

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

CANCEL_SUB_RED_TRANSACTION

INSERT_UPDATE_CASH_POSITION

INSERT_UPDATE_COST_POSITION

CUSTODY_CHECK

INSERT_CASH_ACTIVITY

INSERT_CASH_ALLOCATION_LOG

INSERT_CASH_FIN_LOG

INSERT_ESTAR_VARMGN_LOG

INSERT_FINANCIAL_EVT

INS_UPD_CASH_COMMENTS

POPULATE_DELTA_TRIGGER_LOG

POP_DELTA_TRIG_LOG_CASH

PPA_LOG_MANUAL_SWEEP

Q_HISTORY

Q_HISTORY_CASH

TRIGGER_FEE_SETT_REVERSAL

TRIG_AUTO_FEE_CANCEL

UPDATE_FEE_TRIGGER_STATUS