| PREDISPATCHSEQNO |
varchar(20) |
int  |
Unique identifier of predispatch run in the form YYYYMMDDPP with 01 at 04:30 |
| REGIONID |
varchar(10) |
varchar(10) |
Unique region identifier |
| INTERVENTION |
numeric(2, 0) |
bit |
Flag to indicate if this result set was sourced from the pricing run (INTERVENTION=0) or the physical run (INTERVENTION=1). In the event that there is not intervention in the market, both pricing and physical runs correspond to INTERVENTION=0 |
| DATETIME |
datetime(3) |
datetime2(0) |
Period expressed as Date/Time |
| TOTALDEMAND |
numeric(15, 5) |
numeric(15, 5) |
Total demand in MW for period (less normally on loads) |
| AVAILABLEGENERATION |
numeric(15, 5) |
numeric(15, 5) |
Aggregate generation bid available in region |
| AVAILABLELOAD |
numeric(15, 5) |
numeric(15, 5) |
Aggregate load bid available in region |
| DEMANDFORECAST |
numeric(15, 5) |
numeric(15, 5) |
Delta MW value only |
| DISPATCHABLEGENERATION |
numeric(15, 5) |
numeric(15, 5) |
Generation dispatched in period |
| DISPATCHABLELOAD |
numeric(15, 5) |
numeric(15, 5) |
Load dispatched in period |
| NETINTERCHANGE |
numeric(15, 5) |
numeric(15, 5) |
Net interconnector flow from the regional reference node |
| EXCESSGENERATION |
numeric(15, 5) |
numeric(15, 5) |
Excess generation in period / Deficit generation if VOLL |
| LOWER5MINDISPATCH |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Lower 5 min MW dispatch |
| LOWER5MINIMPORT |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Lower 5 min MW imported |
| LOWER5MINLOCALDISPATCH |
numeric(15, 5) |
numeric(15, 5) |
Lower 5 min local dispatch |
| LOWER5MINLOCALPRICE |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Local price of lower 5 min |
| LOWER5MINLOCALREQ |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Lower 5 min local requirement |
| LOWER5MINPRICE |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Regional price of lower 5 min |
| LOWER5MINREQ |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Lower 5 min total requirement |
| LOWER5MINSUPPLYPRICE |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Supply price of lower 5 min |
| LOWER60SECDISPATCH |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Lower 60 sec MW dispatch |
| LOWER60SECIMPORT |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Lower 60 sec MW imported |
| LOWER60SECLOCALDISPATCH |
numeric(15, 5) |
numeric(15, 5) |
Lower 60 sec local dispatch |
| LOWER60SECLOCALPRICE |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Local price of lower 60 sec |
| LOWER60SECLOCALREQ |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Lower 60 sec local requirement |
| LOWER60SECPRICE |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Regional price of lower 60 sec |
| LOWER60SECREQ |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Lower 60 sec total requirement |
| LOWER60SECSUPPLYPRICE |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Supply price of lower 60 sec |
| LOWER6SECDISPATCH |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Lower 6 sec MW dispatch |
| LOWER6SECIMPORT |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Lower 6 sec MW imported |
| LOWER6SECLOCALDISPATCH |
numeric(15, 5) |
numeric(15, 5) |
Lower 6 sec local dispatch |
| LOWER6SECLOCALPRICE |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Local price of lower 6 sec |
| LOWER6SECLOCALREQ |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Lower 6 sec local requirement |
| LOWER6SECPRICE |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Regional price of lower 6 sec |
| LOWER6SECREQ |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Lower 6 sec total requirement |
| LOWER6SECSUPPLYPRICE |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Supply price of lower 6 sec |
| RAISE5MINDISPATCH |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Raise 5 min MW dispatch |
| RAISE5MINIMPORT |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Raise 5 min MW imported |
| RAISE5MINLOCALDISPATCH |
numeric(15, 5) |
numeric(15, 5) |
Raise 5 min local dispatch |
| RAISE5MINLOCALPRICE |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Local price of raise 5 min |
| RAISE5MINLOCALREQ |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Raise 5 min local requirement |
| RAISE5MINPRICE |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Regional price of raise 5 min |
| RAISE5MINREQ |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Raise 5 min total requirement |
| RAISE5MINSUPPLYPRICE |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Supply price of raise 5 min |
| RAISE60SECDISPATCH |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Raise 60 sec MW dispatch |
| RAISE60SECIMPORT |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Raise 60 sec MW imported |
| RAISE60SECLOCALDISPATCH |
numeric(15, 5) |
numeric(15, 5) |
Raise 60 sec local dispatch |
| RAISE60SECLOCALPRICE |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Local price of raise 60 sec |
| RAISE60SECLOCALREQ |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Raise 60 sec local requirement |
| RAISE60SECPRICE |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Regional price of raise 60 sec |
| RAISE60SECREQ |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Raise 60 sec total requirement |
| RAISE60SECSUPPLYPRICE |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Supply price of raise 60 sec |
| RAISE6SECDISPATCH |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Raise 6 sec MW dispatch |
| RAISE6SECIMPORT |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Raise 6 sec MW imported |
| RAISE6SECLOCALDISPATCH |
numeric(15, 5) |
numeric(15, 5) |
Raise 6 sec local dispatch |
| RAISE6SECLOCALPRICE |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Local price of raise 6 sec |
| RAISE6SECLOCALREQ |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Raise 6 sec local requirement |
| RAISE6SECPRICE |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Regional price of raise 6 sec |
| RAISE6SECREQ |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Raise 6 sec total requirement |
| RAISE6SECSUPPLYPRICE |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Supply price of raise 6 sec |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Period date and time |
| INITIALSUPPLY |
numeric(15, 5) |
numeric(15, 5) |
Sum of initial generation and import for region |
| CLEAREDSUPPLY |
numeric(15, 5) |
numeric(15, 5) |
Sum of cleared generation and import for region |
| LOWERREGIMPORT |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Lower Regulation MW imported |
| LOWERREGLOCALDISPATCH |
numeric(15, 5) |
numeric(15, 5) |
Lower Regulation local dispatch |
| LOWERREGLOCALREQ |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Lower Regulation local requirement |
| LOWERREGREQ |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Lower Regulation total requirement |
| RAISEREGIMPORT |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Raise Regulation MW imported |
| RAISEREGLOCALDISPATCH |
numeric(15, 5) |
numeric(15, 5) |
Raise Regulation local dispatch |
| RAISEREGLOCALREQ |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Raise Regulation local requirement |
| RAISEREGREQ |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Raise Regulation total requirement |
| RAISE5MINLOCALVIOLATION |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Violation (MW) of Raise 5 min local requirement |
| RAISEREGLOCALVIOLATION |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Violation (MW) of Raise Reg local requirement |
| RAISE60SECLOCALVIOLATION |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Violation (MW) of Raise 60 sec local requirement |
| RAISE6SECLOCALVIOLATION |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Violation (MW) of Raise 6 sec local requirement |
| LOWER5MINLOCALVIOLATION |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Violation (MW) of Lower 5 min local requirement |
| LOWERREGLOCALVIOLATION |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Violation (MW) of Lower Reg local requirement |
| LOWER60SECLOCALVIOLATION |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Violation (MW) of Lower 60 sec local requirement |
| LOWER6SECLOCALVIOLATION |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Violation (MW) of Lower 6 sec local requirement |
| RAISE5MINVIOLATION |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Violation (MW) of Raise 5 min requirement |
| RAISEREGVIOLATION |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Violation (MW) of Raise Reg requirement |
| RAISE60SECVIOLATION |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Violation (MW) of Raise 60 seconds requirement |
| RAISE6SECVIOLATION |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Violation (MW) of Raise 6 seconds requirement |
| LOWER5MINVIOLATION |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Violation (MW) of Lower 5 min requirement |
| LOWERREGVIOLATION |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Violation (MW) of Lower Reg requirement |
| LOWER60SECVIOLATION |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Violation (MW) of Lower 60 seconds requirement |
| LOWER6SECVIOLATION |
numeric(15, 5) |
numeric(15, 5) |
Not used since Dec 2003. Violation (MW) of Lower 6 seconds requirement |
| RAISE6SECACTUALAVAILABILITY |
numeric(16, 6) |
numeric(16, 6) |
trapezium adjusted raise 6sec availability |
| RAISE60SECACTUALAVAILABILITY |
numeric(16, 6) |
numeric(16, 6) |
trapezium adjusted raise 60sec availability |
| RAISE5MINACTUALAVAILABILITY |
numeric(16, 6) |
numeric(16, 6) |
trapezium adjusted raise 5min availability |
| RAISEREGACTUALAVAILABILITY |
numeric(16, 6) |
numeric(16, 6) |
trapezium adjusted raise reg availability |
| LOWER6SECACTUALAVAILABILITY |
numeric(16, 6) |
numeric(16, 6) |
trapezium adjusted lower 6sec availability |
| LOWER60SECACTUALAVAILABILITY |
numeric(16, 6) |
numeric(16, 6) |
trapezium adjusted lower 60sec availability |
| LOWER5MINACTUALAVAILABILITY |
numeric(16, 6) |
numeric(16, 6) |
trapezium adjusted lower 5min availability |
| LOWERREGACTUALAVAILABILITY |
numeric(16, 6) |
numeric(16, 6) |
trapezium adjusted lower reg availability |
| DECAVAILABILITY |
numeric(16, 6) |
numeric(16, 6) |
generation availability taking into account daily energy constraints |
| LORSURPLUS |
numeric(16, 6) |
numeric(16, 6) |
Not used after Feb 2006. Total short term generation capacity reserve used in assessing lack of reserve condition |
| LRCSURPLUS |
numeric(16, 6) |
numeric(16, 6) |
Not used after Feb 2006. Total short term generation capacity reserve above the stated low reserve condition requirement |
| TOTALINTERMITTENTGENERATION |
numeric(15, 5) |
numeric(15, 5) |
Allowance made for non-scheduled generation in the demand forecast (MW). |
| DEMAND_AND_NONSCHEDGEN |
numeric(15, 5) |
numeric(15, 5) |
Sum of Cleared Scheduled generation, imported generation (at the region boundary) and allowances made for non-scheduled generation (MW). |
| UIGF |
numeric(15, 5) |
numeric(15, 5) |
Regional aggregated Unconstrained Intermittent Generation Forecast of Semi-scheduled generation (MW). |
| SEMISCHEDULE_CLEAREDMW |
numeric(15, 5) |
numeric(15, 5) |
Regional aggregated Semi-Schedule generator Cleared MW |
| SEMISCHEDULE_COMPLIANCEMW |
numeric(15, 5) |
numeric(15, 5) |
Regional aggregated Semi-Schedule generator Cleared MW where Semi-Dispatch cap is enforced |
| SS_SOLAR_UIGF |
numeric(15, 5) |
numeric(15, 5) |
Regional aggregated Unconstrained Intermittent Generation Forecast of Semi-scheduled generation (MW) where the primary fuel source is solar |
| SS_WIND_UIGF |
numeric(15, 5) |
numeric(15, 5) |
Regional aggregated Unconstrained Intermittent Generation Forecast of Semi-scheduled generation (MW) where the primary fuel source is wind |
| SS_SOLAR_CLEAREDMW |
numeric(15, 5) |
numeric(15, 5) |
Regional aggregated Semi-Schedule generator Cleared MW where the primary fuel source is solar |
| SS_WIND_CLEAREDMW |
numeric(15, 5) |
numeric(15, 5) |
Regional aggregated Semi-Schedule generator Cleared MW where the primary fuel source is wind |
| SS_SOLAR_COMPLIANCEMW |
numeric(15, 5) |
numeric(15, 5) |
Regional aggregated Semi-Schedule generator Cleared MW where Semi-Dispatch cap is enforced and the primary fuel source is solar |
| SS_WIND_COMPLIANCEMW |
numeric(15, 5) |
numeric(15, 5) |
Regional aggregated Semi-Schedule generator Cleared MW where Semi-Dispatch cap is enforced and the primary fuel source is wind |
| WDR_AVAILABLE |
numeric(15, 5) |
numeric(15, 5) |
Regional aggregated available MW for Wholesale Demand Response (WDR) units |
| WDR_DISPATCHED |
numeric(15, 5) |
numeric(15, 5) |
Regional aggregated dispatched MW for Wholesale Demand Response (WDR) units |
| WDR_INITIALMW |
numeric(15, 5) |
numeric(15, 5) |
Regional aggregated MW value at start of interval for Wholesale Demand Response (WDR) units |
| LOWER1SECACTUALAVAILABILITY |
numeric(16, 6) |
numeric(16, 6) |
Trapezium adjusted Lower1Sec availability (summated from UnitSolution) |
| LOWER1SECLOCALDISPATCH |
numeric(15, 5) |
numeric(15, 5) |
Total Lower1Sec Dispatched in Region - RegionSolution element L1Dispatch attribute |
| RAISE1SECACTUALAVAILABILITY |
numeric(16, 6) |
numeric(16, 6) |
Trapezium adjusted Raise1Sec availability (summated from UnitSolution) |
| RAISE1SECLOCALDISPATCH |
numeric(15, 5) |
numeric(15, 5) |
Total Raise1Sec Dispatched in Region - RegionSolution element R1Dispatch attribute |
| SS_SOLAR_AVAILABILITY |
numeric(15, 5) |
numeric(15, 5) |
For Semi-Scheduled units. Aggregate Energy Availability from Solar units in that region |
| SS_WIND_AVAILABILITY |
numeric(15, 5) |
numeric(15, 5) |
For Semi-Scheduled units. Aggregate Energy Availability from Wind units in that region |
| BDU_CLEAREDMW_GEN |
numeric(15, 5) |
numeric(15, 5) |
Regional aggregated cleared MW where the DUID type is BDU. Net of export (Generation) |
| BDU_CLEAREDMW_LOAD |
numeric(15, 5) |
numeric(15, 5) |
Regional aggregated cleared MW where the DUID type is BDU. Net of import (Load) |
| BDU_ENERGY_STORAGE |
numeric(15, 5) |
numeric(15, 5) |
Regional aggregated energy storage where the DUID type is BDU (MWh) |
| BDU_MAX_AVAIL |
numeric(15, 5) |
numeric(15, 5) |
Total available generation side BDU summated for region (MW) |
| BDU_MIN_AVAIL |
numeric(15, 5) |
numeric(15, 5) |
Total available load side BDU summated for region (MW) |
| BDU_INITIAL_ENERGY_STORAGE |
numeric(15, 5) |
numeric(15, 5) |
Energy Storage for BDU at the start of the interval(MWh) - Region Aggregated |
| DECGEN_INITIAL_ENERGY_STORAGE |
numeric(15, 5) |
numeric(15, 5) |
Energy storage for Daily Energy Constrained Scheduled Generating Units at the start of the interval(MWh) - Region Aggregated |
| RUNNO |
numeric(3, 0) |
- |
- |
| PERIODID |
varchar(20) |
- |
- |