ISSUE

Tradefwd (tradefwdcancel) transaction is used in 2 situations:

...

The issue is cashdbo.cash_activity.performance_flow_descr  gets populated based on the trans_type with either a value of “positive”, “negative” or “no flow”.  Currently, for trans_type tradefwd (tradefwdcancel) . the  performance_flow_descr is  set to “POSITIVE” .  This is appropriate for situation #1 when a forward is opened.  However,  if the tradefwd is posted to close the forward, the performance_flow_descr should be “NEGATIVE”.

SOLUTION

To identify or distinguish when a tradefwd (tradefwd cancel) is used to close a forward from when it is used to open, and then change the performance_flow_descr to “NEGATIVE”  value when it is used to close (situation #2).

...

This change affects cash activity records.  Performance Flow Desc Update exporter (Eagle Pace) seems to lend itself to this sort of logic.   In reviewing the procedure , it highlighted some other changes related to data logic, parameters, and when it should be run, that I will include here as well.

REQUEST

Modify the Performance Flow Desc Update Exporter (PFD)   (Eagle Pace)

...