Skip to main content
Version: Next

Output Tables

This is a list of all the output tables available in the Hosting Capacity Service database, along with detailed descriptions of each column and how to use them. Note that depending on the specific implementation, your tables may not be located in a 'output' database, but may be be found alongside input tables in a 'input/results' database. Talk to your system administrator if you are unsure.

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).

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 ▼

Semi-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) ▼