pd7day__interconnectorsolution

AEMO Description

PD7DAY intereconnector solution

Note that the provided table descriptions are truncated by AEMO.


Total Schema Versions	1
Combined Rows	1,867,488
Combined Size	58.82 MiB
MMS Table	`pd7day_interconnectorsolution`
Unified View	`nemwebviews.pd7day__interconnectorsolution`

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`	1,867,488	58.82 MiB

Last updated: 2026-07-16 05:00:09

constraintsolution v1 interconnectorsolution v1