| RUN_DATETIME |
datetime(3)  |
datetime2(0) |
Date processing of the run begins. |
| RUN_NO |
numeric(4, 0) |
smallint |
Unique run id. |
| RUNTYPE |
varchar(20) |
varchar(20) |
Type of run. Always RELIABILITY |
| DEMAND_POE_TYPE |
varchar(20) |
varchar(20) |
Demand POE type used. Value are POE10, POE50 |
| AGGREGATION_PERIOD |
varchar(20) |
varchar(20) |
Period data is aggregated over. Values are YEAR, MONTH |
| PERIOD_ENDING |
datetime(3) |
datetime2(0) |
Datetime of day at end of period (i.e. last day of month or year reported) |
| REGIONID |
varchar(20) |
varchar(20) |
The unique region identifier |
| NATIVEDEMAND |
numeric(12, 2) |
numeric(12, 2) |
Native demand calculated from Operational As Generated trace supplied by Energy Forecasting |
| USE_PERCENTILE10 |
numeric(12, 2) |
numeric(12, 2) |
Unserved energy period amount at the 10th percentile of iterations and reference years (MWh) |
| USE_PERCENTILE20 |
numeric(12, 2) |
numeric(12, 2) |
Unserved energy period amount at the 20th percentile of iterations and reference years (MWh) |
| USE_PERCENTILE30 |
numeric(12, 2) |
numeric(12, 2) |
Unserved energy period amount at the 30th percentile of iterations and reference years (MWh) |
| USE_PERCENTILE40 |
numeric(12, 2) |
numeric(12, 2) |
Unserved energy period amount at the 40th percentile of iterations and reference years (MWh) |
| USE_PERCENTILE50 |
numeric(12, 2) |
numeric(12, 2) |
Unserved energy period amount at the 50th percentile of iterations and reference years (MWh) |
| USE_PERCENTILE60 |
numeric(12, 2) |
numeric(12, 2) |
Unserved energy period amount at the 60th percentile of iterations and reference years (MWh) |
| USE_PERCENTILE70 |
numeric(12, 2) |
numeric(12, 2) |
Unserved energy period amount at the 70th percentile of iterations and reference years (MWh) |
| USE_PERCENTILE80 |
numeric(12, 2) |
numeric(12, 2) |
Unserved energy period amount at the 80th percentile of iterations and reference years (MWh) |
| USE_PERCENTILE90 |
numeric(12, 2) |
numeric(12, 2) |
Unserved energy period amount at the 90th percentile of iterations and reference years (MWh) |
| USE_PERCENTILE100 |
numeric(12, 2) |
numeric(12, 2) |
Unserved energy period amount at the 100th percentile of iterations and reference years (MWh) |
| USE_AVERAGE |
numeric(12, 2) |
numeric(12, 2) |
Average period unserved energy across iterations and reference years (MWh) |
| NUMBEROFITERATIONS |
numeric(12, 2) |
numeric(12, 2) |
Total number of iterations and reference years performed |
| USE_NUMBEROFITERATIONS |
numeric(12, 2) |
numeric(12, 2) |
Number of iterations and reference years showing unserved energy |
| USE_EVENT_MAX |
numeric(12, 2) |
numeric(12, 2) |
Maximum unserved energy event size across all half hourly intervals and iterations and reference years that have unserved energy>0 (MW) |
| USE_EVENT_UPPERQUARTILE |
numeric(12, 2) |
numeric(12, 2) |
Upper quartile unserved energy event size across all half hourly intervals and iterations and reference years that have unserved energy>0 (MW) |
| USE_EVENT_MEDIAN |
numeric(12, 2) |
numeric(12, 2) |
Median unserved energy event size across all half hourly intervals and iterations and reference years that have unserved energy>0 (MW) |
| USE_EVENT_LOWERQUARTILE |
numeric(12, 2) |
numeric(12, 2) |
Lower quartile unserved energy event size across all half hourly intervals and iterations and reference years that have unserved energy>0 (MW) |
| USE_EVENT_MIN |
numeric(12, 2) |
numeric(12, 2) |
Minimum unserved energy event size across all half hourly intervals and iterations and reference years that have unserved energy>0 (MW) |
| WEIGHT |
numeric(16, 6) |
numeric(16, 6) |
Fixed Values of 0.696 for 50 POE and 0.304 for 10 POE. |
| USE_WEIGHTED_AVG |
numeric(16, 6) |
numeric(16, 6) |
Weighted average USE per region = (USE_AVERAGE_POE10/NATIVE_DEMAND_POE_10WEIGHT_POE_10 + USE_AVERAGE_POE50/NATIVE_DEMAND_POE_50WEIGHT_POE_50)*100 |
| LRC |
numeric(12, 2) |
numeric(12, 2) |
LRC Condition reported (Value=1) if USE_WEIGHTED_AVG >= 0.002% otherwise (Value=0) |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |