billing__billing_direction_recon_other__1
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 | 5,665 |
| Combined Size | 95.03 KiB |
| MMS Table | billing_direction_recon_other |
| Unified View | nemwebviews.billing__billing_direction_recon_other__1 |
Schema Evolution
| Column | Type | Description | 0250a8bf |
|---|---|---|---|
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_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 | ✓ |
WEEKNO |
Nullable(Float64) |
Billing week no | ✓ |
processed_at |
DateTime64(3) |
✓ | |
source_zip |
String |
✓ |
Schema Versions
| Version | Rows | Size |
|---|---|---|
0250a8bf |
5,665 | 95.03 KiB |
Last updated: 2025-12-10 08:00:03