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.
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).
Voltage Limits
Network-Level Voltage Thresholds Voltage thresholds for over/under voltage events and hours and other related metrics found in the Network Performance Metrics Enhanced table are controlled by network-level voltage thresholds that are configured at a per environment level. These thresholds are applied consistently across any LV voltage base (under 1000V), such as 400V, 415V, or 433V systems.
Common Australian standard voltage thresholds (for a 230V (single phase) / 400V (3 phase) base) which is the default voltage base for the Hosting Capacity Service, are as follows:
| Label | Parameter | Single Phase / Line-to-neutral (Volts) | Three Phase / Line-to-line (Volts) |
|---|---|---|---|
| VH2 | emergVMaxLv | 260.0 | 450.3 |
| VH1 | normVMaxLv | 253.0 | 438.2 |
| VL1 | normVMinLv | 216.0 | 374.1 |
| VL2 | emergVMinLv | 207.0 | 358.5 |
These values can be adjusted for your entire network if needed. Please contact Zepben or your system administrator to discuss network-level threshold changes. Note that there are currently no equivalent voltage thresholds defined for medium voltage (MV).
Network Performance Metrics Enhanced
Weekly Reports
Constraints
Duration Curves
Link to Input
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
Raw Results Tables
Energy Meters Raw
Energy Meter Voltages Raw
Overloads Raw
Voltage Exceptions Raw
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.
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).
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.