MTPASA_CONSTRAINTSUMMARY

Constraint Summary results over aggregation periods.

Package

MTPASA

Public

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)	date	Day this result is for
CONSTRAINTID	varchar(20)	varchar(20)	The unique identifier for the constraint. Only binding or violating constraints are reported
AGGREGATION_PERIOD	varchar(20)	varchar(20)	Period data is aggregated over. Values are PEAK, SHOULDER, OFFPEAK. PEAK = 14:00-19:59, SHOULDER = 07:00-13:59 and 20:00-21:59, OFFPEAK = 22:00-06:59
EFFECTIVEDATE	datetime(3)	datetime2(0) (not nullable)	The effective date of the constraint used
VERSIONNO	numeric(3, 0)	smallint (not nullable)	The version of the constraintID
CONSTRAINTHOURSBINDING	numeric(12, 2)	numeric(12, 2)	Constraint hours binding or violating for period, averaged across iterations and reference years
LASTCHANGED	datetime(3)	datetime2(0) (not nullable)	Last date and time record changed

Index name	Index type	Index columns (in order)
MTPASA_CONSTRAINTSUMMARY_PK	clustered, unique, primary key	RUN_DATETIME, RUN_NO, RUNTYPE, DEMAND_POE_TYPE, DAY, CONSTRAINTID, AGGREGATION_PERIOD

Index name	Index type	Index columns (in order)
PK_MTPASA_CONSTRAINTSUMMARY	clustered, unique, primary key	RUN_DATETIME, RUN_NO, RUNTYPE, DEMAND_POE_TYPE, DAY, CONSTRAINTID, AGGREGATION_PERIOD

Index name	Index type	Index columns (in order)
PK_MTPASA_CONSTRAINTSUMMARY	clustered, unique, primary key	RUN_DATETIME, RUN_NO, RUNTYPE, DEMAND_POE_TYPE, DAY, CONSTRAINTID, AGGREGATION_PERIOD