Input Tables

HCM Scenario Definition Tables

BESS Allocations

This table contains the BESS profile allocations for a given scenario. Each allocation is linked to a specific BESS profile and includes settings that control how the profile is applied to the scenario, such as year and feeder code locking.

Full Table: bess_allocations ▼

BESS Forecasts

This table contains the BESS forecasts for a given scenario. Each forecast is linked to a specific network level and includes details such as the financial year end, installed capacity, and maximum percentage of multiphase installations.

Full Table: bess_forecasts ▼

BESS Profiles

This table contains the BESS profiles configurations. The profiles can be allocated to scenarios based on year and feeder code settings.

Full Table: bess_profiles ▼

EV Allocations

This table contains the EV profile allocations for a given scenario. Each allocation is linked to a specific EV profile and includes settings that control how the profile is applied to the scenario, such as year and feeder code locking.

Full Table: ev_allocations ▼

EV Forecasts

This table contains the EV forecasts for a given scenario. Each forecast is linked to a specific network level and includes details such as the financial year end, vehicle class, and number of electric vehicles forecasted.

Full Table: ev_forecasts ▼

EV Profiles

This table contains the EV profiles configurations. The profiles can be allocated to scenarios based on year and feeder code settings.

Full Table: ev_profiles ▼

PV Allocations

This table contains the PV profile allocations for a given scenario. Each allocation is linked to a specific PV profile and includes settings that control how the profile is applied to the scenario, such as year and feeder code locking.

Full Table: pv_allocations ▼

PV Forecasts

This table contains the PV forecasts for a given scenario. Each forecast is linked to a specific network level and includes details such as the financial year end, installed capacity, and maximum percentage of multiphase installations.

Full Table: pv_forecasts ▼

PV Profiles

This table contains the PV profiles configurations. Each profile includes details such as the tilt angle, orientation angle, DC to AC ratio, and the normalised power output array. The profiles can be allocated to scenarios based on year and feeder code settings.

Full Table: pv_profiles ▼

Demand Forecasts

This table contains the demand forecasts for a given scenario. Each forecast is linked to a specific network level and includes details such as the financial year end, demand type, probability of exceedance (PoE), and the total demand in MW and MVAR.

Full Table: demand_forecasts ▼

Scenario Configuration

This table contains the scenario configurations. Each configuration includes details such as the scenario ID, name, forecast levels for PV, EV, BESS, and demand, as well as the specific forecasts to be used in the scenario.

Note

Note that base scenario is a hardcoded scenario that is always included in addition to any scenarios you provide in the configuration. The base scenario represents the current state of the network without any additional DER uptake, and is used for comparing the impact of other scenarios. Do not name another scenario base as it will cause issues.

Full Table: scenario_configuration ▼

---

Results Processor Inputs

Calibrated Taps

This table contains the tap settings from a calibration run.

Full Table: calibrated_taps ▼

CECV - Customer Export Curtailment Value

This table contains the CECV values for each half-hour interval of the day in $/MWh. CECVs represent the detriment to all customers from the curtailment of exports from distributed energy resources (DER) due to network limitation. The values represent the cost of curtailing customer exports in $/MWh. It uses the exact same format as the AER table, to allow for 'drag-and-drop' functionality. As of October 2025, the latest values can be found at AER Customer Export Curtailment Values.

Full Table: cecv ▼

CO2 - CO₂ Avoidance Values

This table contains the value of emissions reduction for each half-hour interval of the day. The values represent the cost of CO2 emissions in $/tonne/MWh. It is calculated by taking the emission intensity profile data from the AER (as of October 2025, found here) and multiplying it by a value of CO2 per tonne, either interally agreed on or using an external figure such as the AERs Valuing emissions reduction interim value - May 2024. It uses the same format as the AER emissions intensity table, for ease of calculation.

Full Table: CO2 ▼

CVVR

This table contains the CVVR values for each half-hour interval of the day. The values represent the Customer Value of Voltage Reduction in $/MWh. At the moment there is no official published CVVR values, so users will need to determine their own values to use. Talk to Zepben for more information.

Full Table: CVVR ▼

VCR - Values of Customer Reliability

This table contains the Value of Customer Reliability (VCR) values for each half-hour interval in $/MWh. The values represent the value of customer reliability in $/MWh. It uses the same format as the AER CECV table. Currently, time-based VCR values are not widely used, so you may wish to just populate the table with a flat value for each half-hour interval. As of October 2025, the latest VCR values can be found at AER Value of Customer Reliability. Note that the values in the AER report vary by customer segment, which we do not currently support, so you will need to determine an appropriate average value to use.

Full Table: VCR ▼

PQV

This table is used for Calibration. It contains power quality and voltage (PQV) readings for each meter and time interval.

Full Table: pqv ▼

Inverter Control Profiles

This table contains the inverter control profiles used as part of the Volt-Var feature, also called 'Advanced PV'.

Only available for some customers

This feature is only available to certain customers. If you are interested in using this feature, please contact Zepben for more information.

Full Table: inverter_control_profiles ▼

ENUMS (Data Type Definitions)

This table contains the ENUM types used in the database. It is used to define the possible values for various fields in the database, such as measurement zone types, constraint types, log levels, and more.

Full Table: ENUMS ▼

---

Intervention Tables

Only available for some customers

This feature is only available to certain customers. If you are interested in using this feature, please contact Zepben for more information.

These tables are only required if you are using the Intervention feature. They are used to define the interventions that can be applied to the model, such as changing the load or generation profiles, or applying constraints to the model. See Intervention Options for more details.

Critera-Type Interventions

These tables are required for COMMUNITY_BESS, DISTRIBUTION_TAP_OPTIMIZATION and LV_STATCOMS interventions.

Intervention Candidate Criteria

This table contains the criteria for intervention candidates. Based on the rules set here, intervention candidates are then stored in the intervention_candidates table.

Full Table: intervention_candidate_criteria ▼

Intervention Candidates

This table contains the intervention candidates that are generated as part of the intervention process for COMMUNITY_BESS, DISTRIBUTION_TAP_OPTIMIZATION, and LV_STATCOMS interventions.

Full Table: intervention_candidates ▼

COMMUNITY_BESS TABLES

BESS Allocation Criteria

This table contains the criteria for allocating Battery Energy Storage Systems (BESS) to measurement zones. This table is required for COMMUNITY_BESS interventions.

Full Table: bess_allocation_criteria ▼

BESS Instances

This table contains the instances of Battery Energy Storage Systems (BESS) profiles. This table is required for COMMUNITY_BESS interventions.

Full Table: bess_instances ▼

LV Statcom Allocation Criteria

This table contains the criteria for allocating Low Voltage Static Synchronous Compensators (LV Statcom) to measurement zones. This table is required for LV_STATCOMS interventions.

Full Table: lv_statcom_allocation_criteria ▼

LV Statcom Instances

This table contains the instances of Low Voltage Static Synchronous Compensators (LV Statcom) profiles. This table is required for LV_STATCOMS interventions.

Full Table: lv_statcom_instances ▼

DISTRIBUTION_TX_OLTC Tables

Distribution Transformer OLTC Instances

This table contains the instances of distribution transformer On-Load Tap Changers (OLTC). This table is required for DISTRIBUTION_TX_OLTC interventions.

Full Table: distribution_transformer_oltc_instances ▼

Distribution Transformer OLTC Allocation Criteria

This table contains the criteria for allocating distribution transformer On-Load Tap Changers (OLTC). This table is required for DISTRIBUTION_TX_OLTC interventions.

Full Table: distribution_transformer_oltc_allocation_criteria ▼

TARIFF_REFORM and CONTROLLED_LOAD_HOT_WATER Tables

Load Reshape Strategies

This table contains the strategies for load reshaping. This table is required for TARIFF_REFORM or CONTROLLED_LOAD_HOT_WATER interventions.

Full Table: load_reshape_strategies ▼

Load Reshape Instances

This table contains the instances of load reshape profiles. This table is required for TARIFF_REFORM or CONTROLLED_LOAD_HOT_WATER interventions.

Full Table: load_reshape_instances ▼

---

Semi-Deprecated Tables

Energy Consumer Meters

This table is used 'under the hood' during the calibration process. It used to be used for manual testing of individual consumer level results, however this functionality has been replaced with the more versatile and easy to use Node Level Results feature (see Configuration - Node Level Results). It is used for allocating meters to specific customers for testing and analysis purposes, over and above the existing measurement zones on a feeder/transformer level. It should be used sparingly and with caution. It must be edited manually for all workflows other than calibration runs, and is intended mainly as a debug tool.

Full Table: energy_consumer_meters ▼