billing__billing_direction_recon_other__2

AEMO Description

Billing reconciliation result table for both provisional and

Note that the provided table descriptions are truncated by AEMO.


Total Schema Versions	1
Combined Rows	2,430
Combined Size	87.44 KiB
MMS Table	`billing_direction_recon_other`
Unified View	`nemwebviews.billing__billing_direction_recon_other__2`

Schema Evolution

Column	Type	Description	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
`2adec545`	2,430	87.44 KiB

Last updated: 2025-12-10 08:00:03

billing_direction_recon_other v1 csp_supportdata_sra