Skip to main content
Version: 1.0.0

Output Tables

This is a list of all the output tables available in the Hosting Capacity Service database, such as the Network Performance Metrics Enhanced, Link to Input, Logs and more. It contains detailed descriptions of each column and how to use them.

note

All times in all tables are expressed in UTC. To convert to local time, apply the relevant timezone offset for your location, such as +10:00 for Australian Eastern Standard Time (NEM Time).


General Output Tables

Network Performance Metrics Enhanced

How to use the network_performance_metrics_enhanced Table
Row by row table breakdown: network_performance_metrics_enhanced

Weekly Reports

How to use the weekly_reports Table
Row by row table breakdown: weekly_reports

Constraints

How to use the constraints Table
Row by row table breakdown: constraints

Duration Curves

How to use the duration_curves Table
Row by row table breakdown: duration_curves
How to use the link_to_input Table
Row by row table breakdown: link_to_input

Calibration Meter Results

How to use the calibration_meter_results Table
Row by row table breakdown: calibration_meter_results

Node Level Results Table

For information on node level results, a feature in active development only available to select customers, see Node Level Results.

Logs

How to use the logs Table
Row by row table breakdown: logs

Raw Results Tables

Energy Meters Raw

How to use the energy_meters_raw Table
Row by row table breakdown: energy_meters_raw

Energy Meter Voltages Raw

How to use the energy_meter_voltages_raw Table
Row by row table breakdown: energy_meter_voltages_raw

Overloads Raw

How to use the overloads_raw Table
Row by row table breakdown: overloads_raw

Voltage Exceptions Raw

How to use the voltage_exceptions_raw Table
Row by row table breakdown: voltage_exceptions_raw

Metrics Enhanced Profile Raw

How to use the metrics_enhanced_profile_raw Table
Row by row table breakdown: metrics_enhanced_profile_raw

Intrinsic Hosting Capacity

These tables are produced by Intrinsic Hosting Capacity Mode. They answer a different question to the general output tables above: not "what constraints exist given a DER scenario?" but "how much additional load or generation can the network support before hitting a limit?" Each table plays a specific role in that answer. Start with lv_group_hosting_capacity or hv_node_headroom for the headline results, use constraint_violations and binding_constraints to understand what stopped the search, and use customer_allocations to drill into per-customer detail.

LV Group Hosting Capacity

How to use the lv_group_hosting_capacity table
Row by row table breakdown: lv_group_hosting_capacity

HV Node Headroom

How to use the hv_node_headroom table
Row by row table breakdown: hv_node_headroom

Constraint Violations

How to use the constraint_violations table
Row by row table breakdown: constraint_violations

Binding Constraints

How to use the binding_constraints table
Row by row table breakdown: binding_constraints

Customer Allocations

How to use the customer_allocations table
Row by row table breakdown: customer_allocations

Deprecated Tables

Network Performance Metrics

This table contains the basic (non-enhanced) network performance metrics. It has been superseded by the network_performance_metrics_enhanced table, which provides a more comprehensive set of results and metrics. Users are encouraged to transition to the enhanced table, as this table may be removed in a future version.

Row by row table breakdown: network_performance_metrics

Parquet Hierarchy (Blob Storage)

For users storing results in blob storage, parquet files follow the same logical table structure described above and are organised under each Work Package ID. Files are grouped by table, then by scenario, feeder and year, with individual parquet files named by their timestamp (see the hierarchy below).

Parquet File Hierarchy

Feeder Load Analysis (Segment Level Loading) outputs

This table is the output of the feeder load analysis (segment level loading) process, which provides detailed loading and utilization metrics at the asset and segment level. Note that this is separate from the main power flow results and is only generated when the feeder load analysis process is run. For more information on the feeder load analysis process, please refer to the documentation section on Feeder Load Analysis.

Row by row table breakdown: Feeder Load Analysis (Segment Level Loading)