Table: MTPASA_CONSTRAINTRESULT

MTPASA_CONSTRAINTRESULT

Name

MTPASA_CONSTRAINTRESULT

Comment

Constraint results for Binding or Violating Constraints


Description

MTPASA_CONSTRAINTRESULT is public data.

 


Primary Key Columns

Name

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 constraint used

PERIODID

NUMBER(3,0)

 

Half hourly period reported, selected as period of maximum NEM scheduled demand (calculated as maximum of scheduled demands, averaged across iterations and reference years)

PROBABILITYOFBINDING

NUMBER(8,5)

 

Proportion of a constraint binding, across iterations and reference years

PROBABILITYOFVIOLATION

NUMBER(8,5)

 

Proportion of a constraint violating, across iterations and reference years

CONSTRAINTVIOLATION90

NUMBER(12,2)

 

The 90th percentile violation degree for this constraint, across iterations and reference years (MW)

CONSTRAINTVIOLATION50

NUMBER(12,2)

 

The 50th percentile violation degree for this constraint, across iterations and reference years (MW)

CONSTRAINTVIOLATION10

NUMBER(12,2)

 

The 10th percentile violation degree for this constraint, across iterations and reference years (MW)

LASTCHANGED

DATE

 

Last date and time record changed