pd7day__interconnectorsolution__1
AEMO Description
PD7DAY intereconnector solution
Note that the provided table descriptions are truncated by AEMO.
| Total Schema Versions | 1 |
| Combined Rows | 488,856 |
| Combined Size | 15.30 MiB |
| MMS Table | pd7day_interconnectorsolution |
| Unified View | nemwebviews.pd7day__interconnectorsolution__1 |
Schema Evolution
| Column | Type | Description | 658655df |
|---|---|---|---|
EXPORTCONSTRAINTID |
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. | ✓ |
IMPORTCONSTRAINTID |
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 Predispatch case includes an intervention pricing run: 0 = case does not include an intervention pricing run, 1 = case does include an intervention pricing run. | ✓ |
LASTCHANGED |
Nullable(DateTime64(3)) |
Last date and time record changed | ✓ |
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 PD7DAY run, this value represents the cleared target for the previous period of that PD7DAY run. | ✓ |
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 |
|---|---|---|
658655df |
488,856 | 15.30 MiB |
Last updated: 2025-12-10 08:00:07