Table: MTPASA_CONSTRAINTSUMMARY

MTPASA_CONSTRAINTSUMMARY

Name

MTPASA_CONSTRAINTSUMMARY

Comment

Constraint Summary results over aggregation periods


Description

MTPASA_CONSTRAINTSUMMARY is public data.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

AGGREGATION_PERIOD

CONSTRAINTID

DAY

DEMAND_POE_TYPE

RUN_DATETIME

RUN_NO

RUNTYPE


Content

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 is POE10

DAY

DATE

X

Day this result is for

CONSTRAINTID

VARCHAR2(20)

X

The unique identifier for the constraint. Only binding or violating constraints are reported

EFFECTIVEDATE

DATE

 

The effective date of the constraint used

VERSIONNO

NUMBER(3,0)

 

The version of the constraintID

AGGREGATION_PERIOD

VARCHAR2(20)

X

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

CONSTRAINTHOURSBINDING

NUMBER(12,2)

 

Constraint hours binding or violating for period, averaged across iterations and reference years

LASTCHANGED

DATE

 

Last date and time record changed