billing__billing_direction_recon_other

AEMO Description

Billing reconciliation result table for both provisional and

Note that the provided table descriptions are truncated by AEMO.


Total Schema Versions	2
Combined Rows	8,380
Combined Size	190.20 KiB
MMS Table	`billing_direction_recon_other`
Unified View	`nemwebviews.billing__billing_direction_recon_other`

Schema Evolution

Column	Type	Description	0250a8bf	2adec545
`BILLRUNNO`	`Nullable(Float64)`	Billing run no	✓	✓
`COMPENSATION_AMOUNT`	`Nullable(Float64)`	The final compensation amount for the direction. The same value for all regions	✓	✓
`CONTRACTYEAR`	`Nullable(Float64)`	Billing contract year	✓	✓
`CRA`	`Nullable(Float64)`	The total recovery amount for the direction. The same value for all regions	✓	✓
`DIRECTION_DESC`	`LowCardinality(String)`	Direction description	✓	✓
`DIRECTION_END_DATE`	`Nullable(DateTime64(3))`	Settlement day on which the direction ends. The same value for all regions	✓	✓
`DIRECTION_END_INTERVAL`	`Nullable(DateTime64(3))`	Dispatch interval in which the direction ends. The same value for all regions	✓	✓
`DIRECTION_ID`	`LowCardinality(String)`	Direction identifier	✓	✓
`DIRECTION_SERVICE_ID`	`LowCardinality(String)`	The Direction Service ID associated with the Direction Type ID. Eg For FCAS Direction Type, Direction Service could be any contingency service.	-	✓
`DIRECTION_START_DATE`	`Nullable(DateTime64(3))`	Settlement day on which the direction starts	✓	✓
`DIRECTION_START_INTERVAL`	`Nullable(DateTime64(3))`	Dispatch interval in which the direction starts. The same value for all regions	✓	✓
`DIRECTION_TYPE_ID`	`LowCardinality(String)`	The service for which the direction occurred (ENERGY, ANCILLARY, NON_ENERGY_NON_AS, etc)	✓	✓
`INDEPENDENT_EXPERT_FEE`	`Nullable(Float64)`	The independent expert fee amount for the direction. The same value for all regions	✓	✓
`INTEREST_AMOUNT`	`Nullable(Float64)`	The interest amount calculated on the final compensation amount for the direction. The same value for all regions	✓	✓
`REGIONAL_BENEFIT_FACTOR`	`Nullable(Float64)`	The regional benefit factor allocated to this region for the direction	✓	✓
`REGIONAL_CUSTOMER_ENERGY`	`Nullable(Float64)`	The total customer energy for this region, over the duration of the direction. NULL for Billing Week post the IESS rule effective date.	✓	✓
`REGIONAL_GENERATOR_ENERGY`	`Nullable(Float64)`	The total generator energy for this region, over the duration of the direction. NULL for Billing Week post the IESS rule effective date.	✓	✓
`REGIONID`	`LowCardinality(String)`	Region Identifier	✓	✓
`REGION_ACE_MWH`	`Nullable(Float64)`	The Sum of ACE MWh value for the Region over the duration of the direction. NULL for Billing Week prior to the IESS rule effective date	-	✓
`REGION_ASOE_MWH`	`Nullable(Float64)`	The Sum of ASOE MWh value for the Region over the duration of the direction. NULL for Billing Week prior to the IESS rule effective date	-	✓
`WEEKNO`	`Nullable(Float64)`	Billing week no	✓	✓
`processed_at`	`DateTime64(3)`		✓	✓
`source_zip`	`String`		✓	✓

Schema Versions

Version	Rows	Size
`0250a8bf`	5,665	95.03 KiB
`2adec545`	2,715	95.17 KiB

Last updated: 2026-01-02 16:00:05

billing_direction_recon_other v1