FPP_USAGE

This report delivers the calculated usage for each constraint for each 5 minute trading interval.

Package

FPP

Public

Column	Official MMS Datatype	GR-MMS Datatype	Comment
INTERVAL_DATETIME	datetime(3)	datetime2(0)	Date and time of the trading interval (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time)
CONSTRAINTID	varchar(20)	varchar(20)	Constraint ID (binding constraint ID from FCAS data used in FPP calculations)
VERSIONNO	numeric(5, 0)	smallint	Version (FPP run number from the FPP database)
BIDTYPE	varchar(10)	varchar(10)	Bid type (the bid type saved in relation to constraint ID from FCAS data used in FPP calculations)
REGULATION_MW	numeric(18, 8)	numeric(18, 8)	Enabled regulation MW used in the FPP calculation (from FPP database)
USED_MW	numeric(18, 8)	numeric(18, 8)	Maximum used regulation MW value (quantity of regulation FCAS that was calculated to be used in MW)
USAGE_VALUE	numeric(18, 8)	numeric(18, 8)	Usage (calculation of the proportion of regulation FCAS that was calculated to be used)
USAGE_REASON_FLAG	numeric(5, 0)	tinyint	The reason flag showing the decision matrix for the usage calculation Supported values are: 0 = Usage is calculated based on good input data 1 = Usage is 0 as FM is unreliable 2 = Usage is 0 as the percentage of units with unavailable input or bad data is greater than the threshold percentage
LASTCHANGED	datetime(3)	datetime2(0)	Last date and time record changed

Index name	Index type	Index columns (in order)
FPP_USAGE_PK	clustered, unique, primary key	INTERVAL_DATETIME, CONSTRAINTID, VERSIONNO

Index name	Index type	Index columns (in order)
PK_FPP_USAGE	clustered, unique, primary key	INTERVAL_DATETIME, CONSTRAINTID, VERSIONNO

Index name	Index type	Index columns (in order)
PK_FPP_USAGE	clustered, unique, primary key	INTERVAL_DATETIME, CONSTRAINTID, VERSIONNO