Skip to content

MTPASA_REGIONRESULT

Region results for interval of max demand per day.

Package

MTPASA

Visibility

Public

Table schema

Column Official MMS Datatype GR-MMS Datatype Comment
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 is POE10
DAY datetime(3) 🔑 datetime2(0) 🔑 Day this result is for
REGIONID varchar(20) 🔑 varchar(20) 🔑 The unique region identifier
PERIODID numeric(3, 0) smallint Half hourly period reported, selected as period of maximum NEM scheduled demand (calculated as maximum of scheduled demands, averaged across iterations and reference years)
DEMAND numeric(12, 2) numeric(12, 2) Demand value from selected half hourly interval (MW)
AGGREGATEINSTALLEDCAPACITY numeric(12, 2) numeric(12, 2) The total installed capacity of all generation (MW)
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 with unserved energy>0
USE_MAX numeric(12, 2) numeric(12, 2) Maximum unserved energy, across iterations and reference years (MW)
USE_UPPERQUARTILE numeric(12, 2) numeric(12, 2) Upper quartile unserved energy, across iterations and reference years (MW)
USE_MEDIAN numeric(12, 2) numeric(12, 2) Median unserved energy, across iterations and reference years (MW)
USE_LOWERQUARTILE numeric(12, 2) numeric(12, 2) Lower quartile unserved energy, across iterations and reference years (MW)
USE_MIN numeric(12, 2) numeric(12, 2) Minimum unserved energy, across iterations and reference years (MW)
USE_AVERAGE numeric(12, 2) numeric(12, 2) Average unserved energy, across iterations and reference years (MW)
USE_EVENT_AVERAGE numeric(12, 2) numeric(12, 2) Average unserved energy event size, across iterations and reference years (MW)
TOTALSCHEDULEDGEN90 numeric(12, 2) numeric(12, 2) The 90th percentile for scheduled generation across iterations and reference years (MW)
TOTALSCHEDULEDGEN50 numeric(12, 2) numeric(12, 2) The 50th percentile for scheduled generation across iterations and reference years (MW)
TOTALSCHEDULEDGEN10 numeric(12, 2) numeric(12, 2) The 10th percentile for scheduled generation across iterations and reference years (MW)
TOTALINTERMITTENTGEN90 numeric(12, 2) numeric(12, 2) The 90th percentile for intermittent generation, across iterations and reference years (MW)
TOTALINTERMITTENTGEN50 numeric(12, 2) numeric(12, 2) The 50th percentile for intermittent generation, across iterations and reference years (MW)
TOTALINTERMITTENTGEN10 numeric(12, 2) numeric(12, 2) The 10th percentile for intermittent generation, across iterations and reference years (MW)
DEMANDSIDEPARTICIPATION90 numeric(12, 2) numeric(12, 2) The 90th percentile for demand side participation, across iterations and reference years (MW)
DEMANDSIDEPARTICIPATION50 numeric(12, 2) numeric(12, 2) The 50th percentile for demand side participation, across iterations and reference years (MW)
DEMANDSIDEPARTICIPATION10 numeric(12, 2) numeric(12, 2) The 10th percentile for demand side participation, across iterations and reference years (MW)
LASTCHANGED datetime(3) datetime2(0) Last date and time record changed
TOTALSEMISCHEDULEGEN90 numeric(12, 2) numeric(12, 2) The 90% percentile for semi-scheduled generation across iterations and reference years (MW)
TOTALSEMISCHEDULEGEN50 numeric(12, 2) numeric(12, 2) The 50% percentile for semi-scheduled generation across iterations and reference years (MW)
TOTALSEMISCHEDULEGEN10 numeric(12, 2) numeric(12, 2) The 10% percentile for semi-scheduled generation across iterations and reference years (MW)
TOTALAVAILABLEGENMIN numeric(12, 2) numeric(12, 2) Minimum available capacity, across iterations and reference years (MW).
TOTALAVAILABLEGEN10 numeric(12, 2) numeric(12, 2) The 10% percentile for available capacity, across iterations and reference years (MW).
TOTALAVAILABLEGEN50 numeric(12, 2) numeric(12, 2) The 50% percentile for available capacity, across iterations and reference years (MW).
TOTALAVAILABLEGEN90 numeric(12, 2) numeric(12, 2) The 90% percentile for available capacity, across iterations and reference years (MW).
TOTALAVAILABLEGENMAX numeric(12, 2) numeric(12, 2) Maximum available capacity, across iterations and reference years (MW).

Official MMS data model indexes

Index name Index type Index columns (in order)
MTPASA_REGIONRESULT_PK clustered, unique, primary key RUN_DATETIME, RUN_NO, RUNTYPE, DEMAND_POE_TYPE, DAY, REGIONID

GR-MMS data model indexes

Index name Index type Index columns (in order)
PK_MTPASA_REGIONRESULT clustered, unique, primary key RUN_DATETIME, RUN_NO, RUNTYPE, DEMAND_POE_TYPE, DAY, REGIONID

Historical-MMS data model indexes

Index name Index type Index columns (in order)
MTPASA_REGIONRESULT_PK clustered, unique, primary key RUN_DATETIME, RUN_NO, RUNTYPE, DEMAND_POE_TYPE, DAY, REGIONID