VOLTAGE_INSTRUCTION_TRK

Parent record for Voltage Instructions (MVAr Dispatch). ''SIGNAL'' records will have no children; ''INSTRUCTION'' records will have children.

Package

VOLTAGE_INSTRUCTIONS

Public

Column	Official MMS Datatype	GR-MMS Datatype	Comment
RUN_DATETIME	datetime(3)	datetime2(0)	MVAr Interval - a timestamp of when instructions issued
VERSION_DATETIME	datetime(3)	datetime2(0)	Datetime the file was published by VDS - Versions differ from Run_DateTime only for Supplemental runs
FILE_TYPE	varchar(20)	varchar(20)	Either ''SIGNAL'' (childless) or ''INSTRUCTION
SE_DATETIME	datetime(3)	datetime2(0)	State Estimator start time, when a snapshot is taken of SCADA values
SOLUTION_CATEGORY	varchar(60)	varchar(60)	VDS solver solution category. Valid values: SUCCESS, WARNING, FAILURE
SOLUTION_STATUS	varchar(60)	varchar(60)	VDS solver solution status. Valid values: NOACTCNV [Solved with no instructions], NOVIOACT, CONVERGE, UNMANAGE, UNMANCTG, CTGDIV, SENHDIV [Failed with too many violations], BCDIV
OPERATING_MODE	varchar(60)	varchar(60)	The current VDS operating mode. Valid values: AUTO, AUTO-VERFIED, MANUAL
OPERATING_STATUS	varchar(100)	varchar(100)	Unstructured code and message from AEMO
EST_EXPIRY	datetime(3)	datetime2(0)	Estimated expiry time of current Instruction set
EST_NEXT_INSTRUCTION	datetime(3)	datetime2(0)	Estimated issue time of next Instruction set

Index name	Index type	Index columns (in order)
VOLTAGE_INSTRUCTION_TRK_PK	clustered, unique, primary key	RUN_DATETIME, VERSION_DATETIME

Index name	Index type	Index columns (in order)
PK_VOLTAGE_INSTRUCTION_TRK	clustered, unique, primary key	RUN_DATETIME, VERSION_DATETIME

Index name	Index type	Index columns (in order)
VOLTAGE_INSTRUCTION_TRK_PK	clustered, unique, primary key	RUN_DATETIME, VERSION_DATETIME