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. Each profile includes details such as the name, use type, optimisation type, and the normalised power output array. 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. Each profile includes details such as the name, use type, level of the charger, peak capacity, and the normalised power output array. 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.

Full Table: scenario_configuration ▼

---

Results Processor Inputs

Calibrated Taps

This table contains the tap settings from a calibration run. Each entry includes details such as the calibration set, feeder ID, transformer ID, nominal tap position, new tap position post calibration, high and low limits for the tap position, control enabled setting, and step voltage increment.

Full Table: calibrated_taps ▼

CECV - Customer export curtailment value

This table contains the CECV values for each half-hour interval of the day, including the year, month, day, and day of the week. The values represent the cost of curtailing customer exports in $/MWh. It uses the same format as the AEMO table, to allow for easy integration with AEMO data.

Full Table: cecv ▼

CO2

This table contains the CO2 values for each half-hour interval of the day, including the year, month, day, and day of the week. The values represent the cost of CO2 emissions in $/MWh. It uses the same format as the AEMO table, to allow for easy integration with AEMO data.

Full Table: CO2 ▼

CVVR

This table contains the CVVR values for each half-hour interval of the day, including the year, month, day, and day of the week. The values represent the cost of curtailing virtual voltage regulation in $/MWh. It uses the same format as the AEMO table, to allow for easy integration with AEMO data.

Full Table: CVVR ▼

VCR

This table contains the VCR values for each half-hour interval of the day, including the year, month, day, and day of the week. The values represent the value of customer reliability in $/MWh. It uses the same format as the AEMO table, to allow for easy integration with AEMO data.

Full Table: VCR ▼

ENUMS

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

BESS Allocation Criteria

This table contains the criteria for allocating Battery Energy Storage Systems (BESS) to measurement zones. It includes the name of the criteria, the percentage distance from the measurement zone terminal, and the capacity scaling factor.

Full Table: bess_allocation_criteria ▼

BESS Instances

This table contains the instances of Battery Energy Storage Systems (BESS) profiles. It includes the name of the instance, the feeder it applies to, charging and discharging rates, reserve percentage, control mode, monitored phase, target power levels for charging and discharging, rated energy storage and capacity, profile ID, year of installation, number of data points in the control curve, x and y arrays for control curves, and triggers for charging and discharging.

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. It includes the name of the criteria, the percentage distance from the measurement zone terminal, and the minimum X/R ratio.

Full Table: lv_statcom_allocation_criteria ▼

LV Statcom Instances

This table contains the instances of Low Voltage Static Synchronous Compensators (LV Statcom) profiles. It includes the name of the instance, the kVA rating, reference voltage, tolerances for reactive power and voltage changes, reference reactive power, hysteresis offset, average window length, number of data points in the control curve, x and y arrays for control curves, and phase information.

Full Table: lv_statcom_instances ▼

Distribution Transformer OLTC Instances

This table contains the instances of distribution transformer On-Load Tap Changers (OLTC). It includes the name of the instance, current and voltage ratios, set point, bandwidth, resistance, reactance, primary current transformer ratio, time delay in seconds, and reverse resistance and reactance.

Full Table: distribution_transformer_oltc_instances ▼

Intervention Candidate Criteria

This table contains the criteria for intervention candidates. It includes the name of the criteria set, various thresholds for voltage and thermal limits, and minimum hours and events for different conditions. These criteria are used to determine if a measurement zone qualifies as an intervention candidate based on its performance metrics.

Full Table: intervention_candidate_criteria ▼

Intervention Candidates

This table contains the intervention candidates for work packages. It includes the work package ID, scenario, intervention class, rank, start and end years, feeder, conducting equipment mRID, terminal sequence number, measurement zone type, and class-specific information in JSON format. Each candidate is ranked within its work package and scenario.

Full Table: intervention_candidates ▼

Distribution Transformer OLTC Allocation Criteria

This table contains the criteria for allocating distribution transformer On-Load Tap Changers (OLTC). It includes the name of the criteria and the minimum transformer size in kVA.

Full Table: distribution_transformer_oltc_allocation_criteria ▼

Load Reshape Strategies

This table contains the strategies for load reshaping. It includes the criteria name, rank of the strategy, optional year, feeder, customer type, customer phasing, filters for EV, solar, and controlled load presence, percentage of customers to apply the strategy to, and the instance name of the load reshape to apply.

Full Table: load_reshape_strategies ▼

Load Reshape Instances

This table contains the instances of load reshape profiles. It includes the name of the instance, the profile to apply, the number of intervals in the profile, and the mode of operation (additive or multiplicative). The profile is applied to customers based on the specified mode.

Full Table: load_reshape_instances ▼

Energy Consumer Meters

This table contains the energy consumer meters, which are used to track the energy consumption of different consumer groups. It includes the energy consumer mRID, meter group ID, and direction of the meter (e.g., import or export). Each meter is uniquely identified by its mRID and group ID.

Full Table: energy_consumer_meters ▼