Profit & Loss with Product Control fields

Download sample file: PLPCActuals.csv This Profit & Loss with Product Control fields file type is identified using the pattern: **PLPCActuals*.csv (as specified by mr.pnl.file-patterns.pnl). This file is loaded using the PnL topic. See the Topic Aliases table for an understanding of the topic aliases associated with each topic. For information on the glob patterns used and how to customize them, see note on File name patterns

Field	Key	Null	FieldType	Description	Example
AsOfDate	Y	N	String with format ‘YYYY-MM-DD’	Indicates value date.	2019-01-01
TradeID	Y	N	String	If TradeId comes from multiple systems you may need to prepend source system to the ID for uniqueness. Note that in certain cases, the TradeId could be for adjustment purposes. In such cases we might only have one PnL vector per Book or desk. The TradeId should contain this information clearly (ADDON or ADJ).	“IR_IRSWAP_LIBOR3M”, “EQ_12345677”, etc.
Daily	N	N	Double	P&L
Monthly	N	N	Double	Monthly (MTD) P&L
Yearly	N	N	Double	Yearly (YTD) P&L
Lifetime	N	N	Double	Lifetime (LTD) P&L
Type	Y	N	String	Type of P&L	‘Actual PL’
PLDriver	N	Y	String	Driver for the P&L value	‘Market moves’
IsFullReval	N	Y	String	Flag to indicate whether the P&L comes from a full revaluation in the risk engine. ‘Y’ or ‘N’.
Ccy	N	N	String	Currency of the P&L value
MarketDataSet	Y	N	String	The market data set that should be used when retrieving rates for FX conversion.	Official EOD
Bucket	N	Y	String	Placeholder for FRTB bucket of the risk factor.
SignOffAdjustmentSource	N	Y	String	Optional input for the source of a sign-off adjustment. Only available when using the `enable-signoff` profile.
SignOffAdjustmentInputType	N	Y	String	Optional input for the input type of a sign-off adjustment. Only available when using the `enable-signoff` profile.
LegId	Y	Y	String	Optional input to send in trades that will have multiple legs under a single TradeId. Only available when the property `mr.pnl.enable.leg-id` is set to true.

Documentation Index