FPP_UNIT_MW

This report delivers the curated 4 second measurement MW data for each FPP unit.

Package

FPP

Private, Public Next-Day

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)
MEASUREMENT_DATETIME	datetime(3)	datetime2(0)	Date and time of the SCADA data (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time)
FPP_UNITID	varchar(20)	varchar(20)	FPP Unit ID (registered DUID/TNI)
VERSIONNO	numeric(5, 0)	smallint	Version (FPP run number from the FPP database)
MEASURED_MW	numeric(18, 8)	numeric(18, 8)	Measured MW (4 second SCADA measurement in MW)
MW_QUALITY_FLAG	numeric(5, 0)	smallint	MW Quality (4 second SCADA measurement Quality) Supported values are: 0 = Bad Quality 1 = Good Quality 2 = Suspect Quality -1 = Value not used as input in the FPP calculation (generally used to indicate when SCADA data was late arriving after the FPP calculation commenced)
SCHEDULED_MW	numeric(18, 5)	numeric(18, 5)	Scheduled MW (reference trajectory value from FPP calculation process)
DEVIATION_MW	numeric(18, 5)	numeric(18, 5)	Unit Deviation (output of the FPP calculation process)
PARTICIPANTID	varchar(20)	varchar(10)	Participant ID

Index name	Index type	Index columns (in order)
FPP_UNIT_MW_PK	clustered, unique, primary key	INTERVAL_DATETIME, MEASUREMENT_DATETIME, FPP_UNITID, VERSIONNO

Index name	Index type	Index columns (in order)
PK_FPP_UNIT_MW	clustered, unique, primary key	INTERVAL_DATETIME, MEASUREMENT_DATETIME, FPP_UNITID, VERSIONNO

Index name	Index type	Index columns (in order)
FPP_UNIT_MW_CCI	clustered, columnstore	n/a
PK_FPP_UNIT_MW	nonclustered, unique, primary key	INTERVAL_DATETIME, MEASUREMENT_DATETIME, FPP_UNITID, VERSIONNO