FPP_CONSTRAINT_FREQ_MEASURE
This report delivers the weighted 4 second frequency measure data for each constraint.
Package
FPP
Visibility
Public
Table schema
| 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) |
| 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) |
| FM_RAISE_HZ |
numeric(18, 8) |
numeric(18, 8) |
Calculated 4 second Frequency Measure in Hz for that constraint from the FPP database. Frequency Measure data is split across these two raise and lower columns in the following ways: >0 = Allocated to the FM_RAISE_HZ column <0 = Allocated to the FM_LOWER_HZ column 0 = To fill any gaps where the alternative column is not applicable (or no deviation from 50 Hz) |
| FM_LOWER_HZ |
numeric(18, 8) |
numeric(18, 8) |
Calculated 4 second Frequency Measure in Hz for that constraint from the FPP database. Frequency Measure data is split across these two raise and lower columns in the following ways: >0 = Allocated to the FM_RAISE_HZ column <0 = Allocated to the FM_LOWER_HZ column 0 = To fill any gaps where the alternative column is not applicable (or no deviation from 50 Hz) |
| USED_IN_RCR_FLAG |
numeric(5, 0) |
tinyint |
Flag to indicate the result of the Frequency Measure alignment check between Mainland and Tasmania for global constraints. Supported values are: 0 = Not used in RCR calculation as the signs for the frequency measures between Mainland and Tasmania do not align 1 = Used in the RCR calculation as the signs for the frequency measures between Mainland and Tasmania do align in the case of global constraints. For non-global constraints this flag is set to 1 |
| CORRELATION_FLAG |
numeric(5, 0) |
tinyint |
Flag to indicate the result of the Frequency Measure correlation check between regions in the same constraint. Supported values are: 0 = Frequency measures in this constraint are not correlated (e.g. system separation between two regions) 1 = Frequency measures in this constraint are correlated |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| FPP_CONSTRAINT_FREQ_MEASURE_PK |
clustered, unique, primary key |
INTERVAL_DATETIME, MEASUREMENT_DATETIME, CONSTRAINTID, VERSIONNO |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_FPP_CONSTRAINT_FREQ_MEASURE |
clustered, unique, primary key |
INTERVAL_DATETIME, MEASUREMENT_DATETIME, CONSTRAINTID, VERSIONNO |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_FPP_CONSTRAINT_FREQ_MEASURE |
clustered, unique, primary key |
INTERVAL_DATETIME, MEASUREMENT_DATETIME, CONSTRAINTID, VERSIONNO |