Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The following table lists the fields, STAR tag number, and descriptions of the fields affected by the S2P derivation logic for forward contracts.

Option

Tag

Description

MTTYPE

1

TRADEFWD transactions are split into a closing transaction and an opening transaction. This can be unrelated to the business purpose of the transaction. A closing/ opening transaction can initiate a position or close an existing position. Options include:

  • MTCLOSE. Close side of the contract
  • MTOPEN. Open side of the contract

Long Short Indicator

15

Specifies the long short indicator for the leg of the forward contract, as derived below:

  • Set to L for both sides of the forward contract when the entity election specifies to net forward contracts (see tag 3924)
  • Set to S for the sell side of the forward contract when the entity election is NOT specified to net forward contracts (see tag 3924).
  • Set to L for the buy side of the forward contract.

Event Type

55

Specifies the event type for the leg, as derived below:

  • Set to TRADEFWD in STAR for both legs of the forward contract.
  • Set to SETTLEFWD for the maturity of the forward contract.
  • Set to TRADEFWDCANCEL or SETTLEFWDCANCEL when the record corresponds to the cancel event to a forward contract.

Reason Code

56

Specifies the client intent for the contract. A client may initiate a forward contract or close an existing contract position. For example:

  • Contact is an opening (OP) transaction
  • Contact is a closing (CL) transaction

The field is optional. When the client does not value this field, STAR to PACE logic defaults to standard values.

Buy/Sell Indicator

1364

STAR populates the Buy/Sell Indicator on the position level of the object for both the legs of the forward contract. The value is established for the lifecycle of the position when STAR initially creates the new forward position (leg).

The field is reset when a new transaction arrives that predates the existing processed contract. The STAR AS OF processing supports the submission of transactions out of order, that is, the STAR roll back and replay reprocesses the transactions in the true order.

Note: When the value is set incorrectly, you must cancel the transaction and create a new forward contract security master record.

Forward Close Eligible Indicator

3924

Specifies the entity option created during the Create Entity function to control forward close eligibility. Options include:

  • Y. The user intends to process the impact of multiple forward contracts as one position (each leg).
  • N. The user intends to process the impact of multiple forward contracts as individual positions (each leg).

Note: A position holds only one transaction until maturity.

Cancel Flag

10045

Indicates whether a record in the warehouse is a cancel record. The field is not available or stored in the STAR core object. Options include:

  • Y. Cancel record
  • N. Not a cancel record

Record Type

5525

Specifies the actual ESTAR cost object level where the forward trade is stored. Options include:

  • 150 – Open Lots (Level 150)
  • 180 – Close Lots (Level 180)
  • 250 – Cancel Open (Level 250)
  • 280 – Cancel Close (Level 280)

TRADES Database Fields Derived for Forwards

The following table lists the TRADES database fields established by S2P processing for forward contracts.

Event Type

Cash Category

Fields Used

TRADES

TRADE

COST_BASE
COST_LOCAL
NET_CASH
ORIG_ACQ_COST_BASE
ORIG_ACQ_COST_LOCAL
PAR_OR_SHARES
TRADE_AMOUNT
TRADE_BASE_AMOUNT

TRADES

TRADE_DETAIL

DISP_BOOK_VALUE_GAAP
DISP_BOOK_VALUE_STAT
NETSETTLEAMT