Versions Compared

Key

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


Info
titleNote
  • Signage Logic can be applied only to extracts
  • Currently available for Warehouse Trade, Traded Cash Activity, and Settled Cash Activity feeds

Signage logic allows to change the algorithm for certain numeric field values extracted. This includes changes applied on the step of calculation of their value:

Expand
titleClick to expand an example of alternative calculation

AMOUNT field in Traded CA (if 'IncludeCurveAnalyticsEnableSignageLogic' = 'Y'):

Code Block
languagesql
CASE WHEN ESTAR_TRADED_CASH_ACTIVITY.CASH_EVT_TYP <> 'RECPT'
THEN NVL(ESTAR_TRADED_CASH_ACTIVITY.AMOUNT,0) * -1
ELSE NVL(ESTAR_TRADED_CASH_ACTIVITY.AMOUNT,0)
END AMOUNT


Signage logic is enabled with parameter 'EnableSignageLogic' set to 'Y' or by its global analog W_ENABLE_SIGNAGE_LOGIC in w_config_custom.inc (if the value is 'N' or not specified (default), numeric fields are presented as stored in database).
Signage logic for Trade SETTLEMENT_AMOUT and SETTLE_AMOUNT_BASE is enabled with the additional parameter 'SettlementSignageFlag' set to Y.

Field Group NumberWarehouse Trade FieldsTraded CA FieldsSettled CA Fields
1NET_CASH 
EagleML/WarehouseTransaction/warehouseTrade/netAmountLocal
AMOUNTAMOUNT

TRADE_BASE_AMOUNT
EagleML/WarehouseTransaction/warehouseTrade/netAmountBase

NET_AMOUNT_BASENET_AMOUNT_BASE
SETTLEMENT_AMOUNT
EagleML/WarehouseTransaction/warehouseTrade/settlementAmount
SETTLE_AMOUNT_LOCALSETTLE_AMOUNT_LOCAL
REC_PAY_AMT_BREC_PAY_AMT_B
REC_PAY_AMT_LREC_PAY_AMT_L
2COST_BASE
EagleML/WarehouseTransaction/warehouseTrade/costBase
(no fields)(no fields)
COST_LOCAL
EagleML/WarehouseTransaction/warehouseTrade/costLocal

ORIG_ACQ_COST_BASE
EagleML/WarehouseTransaction/warehouseTrade/originalAcquisitionCostBase

ORIG_ACQ_COST_LOCAL
EagleML/WarehouseTransaction/warehouseTrade/originalAcquisitionCostLocal
PAR_OR_SHARES
EagleML/WarehouseTransaction/warehouseTrade/originalQuantity
3PRINCIPAL
EagleML/WarehouseTransaction/warehouseTrade/principal
PRINCIPALPRINCIPAL
PRINCIPAL_BASE
EagleML/WarehouseTransaction/warehouseTrade/principalB
PRINCIPAL_AMOUNT_BASEPRINCIPAL_AMOUNT_BASE
DIRTY_PRINCIPAL
EagleML/WarehouseTransaction/warehouseTrade/dirtyPrincipalLocal


DIRTY_PRINCIPAL_BASE
EagleML/WarehouseTransaction/warehouseTrade/dirtyPrincipalBase



4BASE COMMISSION AMOUNT
EagleML/WarehouseTransaction/warehouseTrade/baseCommissionAmount
COMM_AMT_BCOMM_AMT_B
LOCAL_COMMISSION_AMOUNT
EagleML/WarehouseTransaction/warehouseTrade/localCommissionAmount
COMM_AMT_LCOMM_AMT_L
EXCHANGE_FEE
EagleML/WarehouseTransaction/warehouseTrade/exchangeFee
OTHER_FEE_BOTHER_FEE_B
EXCHANGE_FEE_BASE
EagleML/WarehouseTransaction/warehouseTrade/exchangeFeeBase
OTHER_FEE_LOCALOTHER_FEE_LOCAL
OTHER_FEE
EagleML/WarehouseTransaction/warehouseTrade/otherFee
RECLAIM_AMOUNT_BASERECLAIM_AMOUNT_BASE
OTHER_FEE_BASE
EagleML/WarehouseTransaction/warehouseTrade/otherFeeBase
RECLAIM_LRECLAIM_L
SEC_FEES
EagleML/WarehouseTransaction/warehouseTrade/secFee
SEC_FEESEC_FEE
SEC_FEES_BASE
EagleML/WarehouseTransaction/warehouseTrade/secFeesBase
SEC_FEE_BSEC_FEE_B
TAXES
EagleML/WarehouseTransaction/warehouseTrade/taxAmountLocal
STAMP_DUTY_TAX_BSTAMP_DUTY_TAX_B
TAXES_BASE
EagleML/WarehouseTransaction/warehouseTrade/taxesBase
STAMP_DUTY_TAX_LSTAMP_DUTY_TAX_L
TAX_AMT_BTAX_AMT_B
TAX_AMT_LTAX_AMT_L
TAX_EXPENSE_BASETAX_EXPENSE_BASE
WITHHOLDING_LWITHHOLDING_L
5

CURRENCY_GAIN
EagleML/WarehouseTransaction/warehouseTrade/gainCurrency

GAIN_CURRENCYGAIN_CURRENCY

SECURITY_GAIN
EagleML/WarehouseTransaction/warehouseTrade/gainSecurityLocal

GAIN_SWAP_BGAIN_SWAP_B
TOTAL_GAIN_LOCAL
EagleML/WarehouseTransaction/warehouseTrade/totalGainLocal
GAIN_SWAP_LGAIN_SWAP_L
TOTAL_GAIN
EagleML/WarehouseTransaction/warehouseTrade/totalGain
(no fields)(no fields)

ST_GAIN_SEC_L
EagleML/WarehouseTransaction/warehouseTrade/stGainSecLocal

ST_GAIN_SEC_B
EagleML/WarehouseTransaction/warehouseTrade/stGainSecBase

ST_GAIN
EagleML/WarehouseTransaction/warehouseTrade/stGain
ST_GAIN_CRRCY
EagleML/WarehouseTransaction/warehouseTrade/stGainCurrency
LT_GAIN_SEC_L
EagleML/WarehouseTransaction/warehouseTrade/ltLossSecLocal
LT_GAIN_SEC_B
EagleML/WarehouseTransaction/warehouseTrade/ltLossSecBase
LT_GAIN
EagleML/WarehouseTransaction/warehouseTrade/ltGain
LT_GAIN_CRRCY
EagleML/WarehouseTransaction/warehouseTrade/ltGainCurrency
GAIN_CRRCY_988
EagleML/WarehouseTransaction/warehouseTrade/gainCurrency988
6CURRENCY_LOSS
EagleML/WarehouseTransaction/warehouseTrade/lossCurrency
LOSS_CURRENCYLOSS_CURRENCY

SECURITY_LOSS
EagleML/WarehouseTransaction/warehouseTrade/lossSecurityLocal

LOSS_SWAP_BLOSS_SWAP_B
TOTAL_LOSS
EagleML/WarehouseTransaction/warehouseTrade/totalLoss
LOSS_SWAP_LLOSS_SWAP_L
TOTAL_LOSS_LOCAL
EagleML/WarehouseTransaction/warehouseTrade/totalLossLocal
(no fields)(no fields)
ST_LOSS_SEC_L
EagleML/WarehouseTransaction/warehouseTrade/stLossSecLocal
ST_LOSS_SEC_B
EagleML/WarehouseTransaction/warehouseTrade/stLossSecBase
ST_LOSS
EagleML/WarehouseTransaction/warehouseTrade/stLoss
ST_LOSS_CRRCY
EagleML/WarehouseTransaction/warehouseTrade/stLossCurrency
LT_LOSS_SEC_L
EagleML/WarehouseTransaction/warehouseTrade/ltLossSecLocal
LT_LOSS_SEC_B
EagleML/WarehouseTransaction/warehouseTrade/ltLossSecBase
LT_LOSS
EagleML/WarehouseTransaction/warehouseTrade/ltLoss
LT_LOSS_CRRCY (no signage logic currently)
EagleML/WarehouseTransaction/warehouseTrade/ltLossCurrency

LOSS_CRRCY_988 (no signage logic currently)
EagleML/WarehouseTransaction/warehouseTrade/lossCurrency988

7ACCRUED_INTEREST
EagleML/WarehouseTransaction/warehouseTrade/accruedInterest
INCOMEINCOME
BASEINTERESTADJ
EagleML/WarehouseTransaction/warehouseTrade/interestAdjBase
INCOME_AMOUNT_BASEINCOME_AMOUNT_BASE
CLS_AMORT_LOCAL
EagleML/WarehouseTransaction/warehouseTrade/clsAmortLocal
(no fields)(no fields)
CLS_AMORT_BASE
EagleML/WarehouseTransaction/warehouseTrade/clsAmortBase
CLS_OID_L
EagleML/WarehouseTransaction/warehouseTrade/clsOidLoca
CLS_OID_B
EagleML/WarehouseTransaction/warehouseTrade/clsOidBase

CLS_ILB_INC_LTD_LOCAL
EagleML/WarehouseTransaction/warehouseTrade/clsIlbIncLtdLocal

CLS_ILB_INC_LTD_BASE
EagleML/WarehouseTransaction/warehouseTrade/clsIlbIncLtdBase
8(no fields)UNITSUNITS
9TRADE_AMOUNT
EagleML/WarehouseTransaction/warehouseTrade/tradeAmount
(no fields)(no fields)
NETSETTLEAMT
EagleML/WarehouseTransaction/warehouseTrade/netsettleamt
TOTAL_AMORT_LOCAL,
EagleML/WarehouseTransaction/warehouseTrade/totalAmortLocal
TOTAL_AMORT_BASE
EagleML/WarehouseTransaction/warehouseTrade/totalAmortBase

...