p5min__interconnectorsoln__4
AEMO Description
The five-minute predispatch (P5Min) is a MMS system providin
Note that the provided table descriptions are truncated by AEMO.
| Total Schema Versions | 1 |
| Combined Rows | 8,393,184 |
| Combined Size | 221.41 MiB |
| MMS Table | p5min_interconnectorsoln |
| Unified View | nemwebviews.p5min__interconnectorsoln__4 |
Schema Evolution
| Column | Type | Description | 48bb1219 |
|---|---|---|---|
EXPORTGENCONID |
LowCardinality(String) |
Generic Constraint setting the export limit | ✓ |
EXPORTLIMIT |
Nullable(Float64) |
Calculated Interconnector limit of exporting energy on the basis of invoked constraints and static interconnector export limit | ✓ |
FCASEXPORTLIMIT |
Nullable(Float64) |
Calculated export limit applying to energy + Frequency Controlled Ancillary Services. | ✓ |
FCASIMPORTLIMIT |
Nullable(Float64) |
Calculated import limit applying to energy + Frequency Controlled Ancillary Services. | ✓ |
IMPORTGENCONID |
LowCardinality(String) |
Generic Constraint setting the import limit | ✓ |
IMPORTLIMIT |
Nullable(Float64) |
Calculated Interconnector limit of importing energy on the basis of invoked constraints and static interconnector import limit. Note unlike the input interconnector import limit this is a directional quantity and should be defined with respect to the interconnector flow. | ✓ |
INTERCONNECTORID |
LowCardinality(String) |
Interconnector identifier | ✓ |
INTERVAL_DATETIME |
Nullable(DateTime64(3)) |
The unique identifier for the interval within this study | ✓ |
INTERVENTION |
Nullable(Float64) |
Flag to indicate if this result set was sourced from the pricing run (INTERVENTION=0) or the physical run (INTERVENTION=1). In the event there is not intervention in the market, both pricing and physical runs correspond to INTERVENTION=0) | ✓ |
LASTCHANGED |
Nullable(DateTime64(3)) |
Last changed date of this record | ✓ |
LOCALLY_CONSTRAINED_EXPORT |
Nullable(Float64) |
Key for Local_Price_Adjustment_Export: 2 = at least one Outage Constraint; 1 = at least 1 System Normal Constraint (and no Outage Constraint); 0 = No System Normal or Outage Constraints | ✓ |
LOCALLY_CONSTRAINED_IMPORT |
Nullable(Float64) |
Key for Local_Price_Adjustment_Import: 2 = at least one Outage Constraint; 1 = at least 1 System Normal Constraint (and no Outage Constraint); 0 = No System Normal or Outage Constraints | ✓ |
LOCAL_PRICE_ADJUSTMENT_EXPORT |
Nullable(Float64) |
Aggregate Constraint contribution cost of this Interconnector: Sum(MarginalValue x Factor) for all relevant Constraints, for Export (Factor >= 0) | ✓ |
LOCAL_PRICE_ADJUSTMENT_IMPORT |
Nullable(Float64) |
Aggregate Constraint contribution cost of this Interconnector: Sum(MarginalValue x Factor) for all relevant Constraints, for Import (Factor >= 0) | ✓ |
MARGINALLOSS |
Nullable(Float64) |
Marginal loss factor at the cleared flow | ✓ |
MARGINALVALUE |
Nullable(Float64) |
Marginal cost of Interconnector standing data limits (if binding) | ✓ |
METEREDMWFLOW |
Nullable(Float64) |
SCADA MW Flow measured at Run start. For periods subsequent to the first period of a P5MIN run, this value represents the cleared target for the previous period of that P5MIN run. | ✓ |
MNSP |
Nullable(Float64) |
Flag indicating MNSP registration | ✓ |
MWFLOW |
Nullable(Float64) |
Cleared Interconnector loading level (MW) | ✓ |
MWLOSSES |
Nullable(Float64) |
Interconnector Losses at cleared flow | ✓ |
RUN_DATETIME |
Nullable(DateTime64(3)) |
Unique Timestamp Identifier for this study | ✓ |
VIOLATIONDEGREE |
Nullable(Float64) |
Violation of Interconnector standing data limits | ✓ |
processed_at |
DateTime64(3) |
✓ | |
source_zip |
String |
✓ |
Schema Versions
| Version | Rows | Size |
|---|---|---|
48bb1219 |
8,393,184 | 221.41 MiB |
Last updated: 2025-12-10 08:00:07