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.
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.
BESS Profiles
This table contains the BESS profiles configurations. The profiles can be allocated to scenarios based on year and feeder code settings.
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.
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.
EV Profiles
This table contains the EV profiles configurations. The profiles can be allocated to scenarios based on year and feeder code settings.
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.
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.
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.
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.
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 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.
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, new tap position post calibration, high and low limits for the tap position, control enabled setting, and step voltage increment.
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.
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.
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.
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.
PQV
This table contains power quality and voltage (PQV) readings for each meter and time interval. It includes the CPI, meter ID, reading type, reading phase, timestamp, and value. The pqv_reading_type and phase_reading are defined as ENUM types.
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.
Intervention
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.
BESS Allocation Criteria
This table contains the criteria for allocating Battery Energy Storage Systems (BESS) to measurement zones.
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.
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.
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.
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.
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.
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.
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.
Load Reshape Strategies
This table contains the strategies for load reshaping. It includes the criteria name, rank of the strategy, 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.
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.
Semi-Depreciated 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.