|
Name |
|
|
Comment |
Region Results summary over aggregation periods. |
|
MTPASA_REGIONSUMMARY is public data. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Public |
|
Name |
|
AGGREGATION_PERIOD |
|
DEMAND_POE_TYPE |
|
PERIOD_ENDING |
|
REGIONID |
|
RUN_DATETIME |
|
RUN_NO |
|
RUNTYPE |
|
Name |
Data Type |
Mandatory |
Comment |
|
RUN_DATETIME |
DATE |
X |
Date processing of the run begins. |
|
RUN_NO |
NUMBER(4) |
X |
Unique run id. |
|
RUNTYPE |
VARCHAR2(20) |
X |
Type of run. Always RELIABILITY |
|
DEMAND_POE_TYPE |
VARCHAR2(20) |
X |
Demand POE type used. Value are POE10, POE50 |
|
AGGREGATION_PERIOD |
VARCHAR2(20) |
X |
Period data is aggregated over. Values are YEAR, MONTH |
|
PERIOD_ENDING |
DATE |
X |
Datetime of day at end of period (i.e. last day of month or year reported) |
|
REGIONID |
VARCHAR2(20) |
X |
The unique region identifier |
|
NATIVEDEMAND |
NUMBER(12,2) |
|
Native demand calculated from Operational As Generated trace supplied by Energy Forecasting |
|
USE_PERCENTILE10 |
NUMBER(12,2) |
|
Unserved energy period amount at the 10th percentile of iterations and reference years (MWh) |
|
USE_PERCENTILE20 |
NUMBER(12,2) |
|
Unserved energy period amount at the 20th percentile of iterations and reference years (MWh) |
|
USE_PERCENTILE30 |
NUMBER(12,2) |
|
Unserved energy period amount at the 30th percentile of iterations and reference years (MWh) |
|
USE_PERCENTILE40 |
NUMBER(12,2) |
|
Unserved energy period amount at the 40th percentile of iterations and reference years (MWh) |
|
USE_PERCENTILE50 |
NUMBER(12,2) |
|
Unserved energy period amount at the 50th percentile of iterations and reference years (MWh) |
|
USE_PERCENTILE60 |
NUMBER(12,2) |
|
Unserved energy period amount at the 60th percentile of iterations and reference years (MWh) |
|
USE_PERCENTILE70 |
NUMBER(12,2) |
|
Unserved energy period amount at the 70th percentile of iterations and reference years (MWh) |
|
USE_PERCENTILE80 |
NUMBER(12,2) |
|
Unserved energy period amount at the 80th percentile of iterations and reference years (MWh) |
|
USE_PERCENTILE90 |
NUMBER(12,2) |
|
Unserved energy period amount at the 90th percentile of iterations and reference years (MWh) |
|
USE_PERCENTILE100 |
NUMBER(12,2) |
|
Unserved energy period amount at the 100th percentile of iterations and reference years (MWh) |
|
USE_AVERAGE |
NUMBER(12,2) |
|
Average period unserved energy across iterations and reference years (MWh) |
|
NUMBEROFITERATIONS |
NUMBER(12,2) |
|
Total number of iterations and reference years performed |
|
USE_NUMBEROFITERATIONS |
NUMBER(12,2) |
|
Number of iterations and reference years showing unserved energy |
|
USE_EVENT_MAX |
NUMBER(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 |
NUMBER(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 |
NUMBER(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 |
NUMBER(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 |
NUMBER(12,2) |
|
Minimum unserved energy event size across all half hourly intervals and iterations and reference years that have unserved energy>0 (MW) |
|
WEIGHT |
NUMBER(16,6) |
|
Fixed Values of 0.696 for 50 POE and 0.304 for 10 POE. |
|
USE_WEIGHTED_AVG |
NUMBER(16,6) |
|
Weighted average USE per region = (USE_AVERAGE_POE10/NATIVE_DEMAND_POE_10*WEIGHT_POE_10 + USE_AVERAGE_POE50/NATIVE_DEMAND_POE_50*WEIGHT_POE_50)*100 |
|
LRC |
NUMBER(12,2) |
|
LRC Condition reported (Value=1) if USE_WEIGHTED_AVG >= 0.002% otherwise (Value=0) |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
|
|