VOLTAGE_INSTRUCTION

Child record for Voltage Instructions (MVAr Dispatch).

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
EMS_ID	varchar(60)	varchar(60)	The unique identifier for reference within AEMO -matches equipment names between NOS and EMS
VERSION_DATETIME	datetime(3)	datetime2(0)	Datetime the file was published by VDS - Versions differ from Run_DateTime only for Supplemental runs
PARTICIPANTID	varchar(20)	varchar(20)	The NEM id of the participant who owns the equipment
STATION_ID	varchar(60)	varchar(60)	The id of the station where the control equipment resides
DEVICE_ID	varchar(60)	varchar(60)	The company/participant preferred name of an equipment
DEVICE_TYPE	varchar(20)	varchar(20)	One of REACTOR, CAPACITOR, GEN, SVC, TRANS or GRPGEN but may be extended to other types
CONTROL_TYPE	varchar(20)	varchar(20)	One of VOLTAGE, TAP, MVAR, SWITCH or COMMIT but may be extended to other types
TARGET	numeric(20, 5)	real	Instruction for the device, for this interval null denotes no instruction
CONFORMING	numeric(1, 0)	tinyint	[0,1] Denotes if the Device is currently conforming
INSTRUCTION_SUMMARY	varchar(400)	varchar(400)	Verbose summary of instruction
INSTRUCTION_SEQUENCE	numeric(4, 0)	smallint	Order for execution of Instruction
ADDITIONAL_NOTES	varchar(60)	varchar(60)	Additional information pertaining to a particular instruction, e.g. Previously issued instruction revoked

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

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

Index name	Index type	Index columns (in order)
PK_VOLTAGE_INSTRUCTION	nonclustered, unique, primary key	RUN_DATETIME, VERSION_DATETIME, EMS_ID
VOLTAGE_INSTRUCTION_CCI	clustered, columnstore	n/a