About Bypassing Earnings Replay for TBA Allocations
Backdated trade processing, specifically with mortgage-backed type positions such as TBAs, , for example, When youSet the Bypass Earnings Replay Option to A
You can have the system set the Bypass Earnings Replay (tag 11793) option to a value of A on transactions if you want Eagle Accounting to bypass the Earnings replay during the rollback/replay process. The rollback still occurs, but no income or trades replay ensues, which significantly improves system performance while posting backdated transaction activity. This setting is often used during TBA allocation, because the trade activity involved many backdated trades which rolled back earnings and factors each time during every trade.
If you assign the Bypass Earnings Replay (tag 11793) option for a transaction to a value of A, during transaction processing the system bypasses Earnings processing along with the following accounting functions
:
OpenWashSaleAdj
CloseWashSaleAdj
accrueMaster
supplementEventWithEarnProperty
ledgerPeriodForwardBackward
calcVariationMargin
CalculateYield
CalcTradedInterest
setConvBond
supplementEventWithYieldProperty
LedgerPosting_Generate_DRCR_ByRow
CalcTipsIndexRatio
GetPaydownGainloss
SetIncomeRecognitionTag
Included in this list is the write cursor to the STAR to PACE Delta trigger log. The system
bypasses this log to increase processing speeds. After you run the REACCRUE event, the system populates the STAR to PACE Delta trigger log and subsequently updates the Eagle data warehouse.
Set Up Bypass Earnings Replay and Process Transactions
You can set theAssign Transactions a Value of A
The Bypass Earnings Replay field is not available in any accounting trade entry panels. Because each Eagle client that uses this option has their own criteria for assigning this tag to transactions, you can use the Force Add Tags option on the stream to assign this tag a value of A. The Force Add Tags option, available in Message Center Editor's ID RUNPANEL Editor, allows you to add tags on an ad hoc basis without modifying and customizing a panel. For audit purposes, the system adds this column to the ESTAR_FINANCIAL_EVENT table once the trades are processed.
The Bypass Earnings Replay field is available when you book an impairment for a fixed income security using the Book Impairment Adjustment panel.
Process Transactions Set to A
Once you book a trade on the position with Bypass Earnings Replay (tag 11793) option set to a value of A
, Eagle Accounting
locks it down. This means that you cannot run the normal Earnings process or attempt to process factors until you run the Reaccrue process. You can use the Reaccrue for Earnings Bypass panel to catch up earnings that the system previously bypassed.
During transaction processing, Eagle Accounting uses the
PLANSTEP_FUNC_
BYPASS_
DT column on the ESTAR_COST_POSITION table. It sets this column equal to Trade Date minus one of the earliest trade on a position that was booked with Bypass Earnings Replay (tag 11793) set to A. Eagle Accounting uses this date to determine how far it needs to roll back earnings. The system then replays earnings up through the previous EARN_THROUGH_DATE on the ESTAR_COST_POSITION table. You can view the
value in Position Viewer for the Cost position, where
the value is called PLANSTEP_
FUNC_BYPASS_DT (tag 12401). It represents the date in which earnings need to be caught up from. It is used only by the Earnings process run through the Reaccrue for Earnings Bypass panel.
The system only bypasses ledger activity for open transactions. It does this because if a backdated close occurred that rolled back several transactions, the ledger postings associated with those rolled back transactions will remain on the ledger. Therefore, the system does not bypass ledger activity for closes and cancels at this time.
Set the Bypass Earnings Replay
Option to Y
You can have the system set the Bypass Earnings Replay (tag 11793) option to a value of
Y on transactions
The eagle_wrf_tba_process workflow has the ability to first suppress the earnings catch-up process, and then (when transactions are successfully processed) to automatically trigger the accrual process through current process center date.
Highlight |
---|
WRITERS NOTE: can you set to R manually or not? add XREF to TBA Consolidation IWS workflow page? If you have R, do you have to use the panel below, or does the IWS workflow do it for you? |
Reaccrue after an Earnings Bypass
In the Reaccrue for Earnings Bypass panel, you can perform rollback and replay for earnings processing for transactions that you previously bypassed. When you bypass rollback and replay earnings and other accounting processing for TBA allocations, Eagle Accounting allows you to perform that rollback and replay a single time, after all activity is posted. After you process transactions using the Reaccrue for Earnings Bypass panel, all activity including, but not limited to, ledger postings, warehouse activity, earnings, wash sales, trades, and corporate actions should be the same as if you did not previously bypass accounting processing for those transactions.
To reaccrue after bypassing earnings processing:
- From any Eagle window, click the Eagle Navigator button to access the Eagle Navigator..
- Enter Global Process Center in the Start Search text box.
Click the Global Process Center link to access the Global Process Center.
You see the Global Process Center.- Open the Earnings folder in the left navigation pane and select Reaccrue for Earnings Bypass.
You see the Reaccrue for Earnings Bypass panel. - Complete the options on the Reaccrue for Earnings Bypass panel.
- Click Submit.
The Global Processing Results frame appears at the bottom of the panel. The Detail tab shows each entity/security that was accrued with a Status of Processed and Event Type of Earn. Otherwise, if the system finds no accruals to process, the system displays a message indicating it produced no loopbacks.
Reaccrue for Earnings Bypass Panel Options
In the Reaccrue for Earnings panel, you can manually rollback and replay the earning process after bypassing the earnings process, along with additional accounting functions. The options may vary according to your selections. The following are the options in the Reaccrue for Earnings panel.
Accrue
Determines how to apply the global processing, as follows:
- One Entity/One Security
- One Entity/All Securities
- All Entities/One Security
- All Entities/All Securities
– Yes. Default. Replays earnings up through, and including, the last earn through date on the position.
– No. Does not run earnings up through the last earn through date. The system sets the LAST_VAULT_DATE column to NULL. You have to manually catch up earnings. Choosing No most likely indicates that you expect the system to post more trade activity on the position. This creates less work on the engine overall.
. You can have the system place this value on any backdated event. For example, you can use this value with the event type of INCRFEE or DECRFEE,
Using a value of Y suppresses the replay of earnings through the last earn thru date during rollback replay. For example, if you have a buy which has earned through today, and then you post another backdated buy today with a trade date of yesterday, you do not earn again through today as you normally would.
Info |
---|
The position is not locked when you use this option. You can use the standard earnings process to catch up earnings. You do not have to use the Reaccrue for Earnings Bypass panel with this option. |