SSM_INSTRUCTION
An enablement of an SSM Contract that instructs a Dispatchable Unit is to provide a System Security Service.
Package
SYSTEM_SECURITY_MANAGEMENT
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| INSTRUCTION_ID |
varchar(20)  |
varchar(20) |
Unique Instruction Identifier. |
| VERSION_DATETIME |
datetime(3) |
datetime2(0) |
Effective Date and Time of this record. |
| INITIAL_INSTRUCTION_ID |
varchar(20) |
varchar(20) |
Unique transaction identifier of initiating transaction if instruction related to an amendment or cancellation. |
| DUID_PARTICIPANTID |
varchar(10) |
varchar(10) |
Primary recipient (SSM Service Provider) of enablement instruction. |
| CONTRACT_ID |
varchar(20) |
varchar(20) |
Unique Contract Identifier used to create enablement. |
| TNSP_PARTICIPANTID |
varchar(10) |
varchar(10) |
Participant ID of TNSP if contract procurer is TNSP. |
| DUID |
varchar(20) |
varchar(10) |
Dispatchable Unit Identifier |
| UNIT_COUNT |
numeric(4, 0) |
smallint |
Number of sub-units within a DUID that are required for enablement. Value of zero means cancellation of instruction. |
| EQUIPMENT_TYPE |
varchar(40) |
varchar(40) |
Dispatchable Unit resource (for example, GENERATOR, LOAD, BIDIRECTIONAL, SYNCHRONOUS CONDENSER). |
| SERVICE_TYPE |
varchar(40) |
varchar(40) |
Requested Service to provide(System strength-combination,System strength-coefficient,NSCAS-voltage control,NSCAS,Inertia,Transitional service-type 1 MSL,Transitional service-type 1,Transitional service-type 2). |
| MIN_DISPATCH_MW |
numeric(18, 8) |
numeric(18, 8) |
Minimum Dispatch Target required for DUID to enable the contract. Value of zero means cancellation of instruction. |
| START_INTERVAL_DATETIME |
datetime(3) |
datetime2(0) |
The first Dispatch Interval of the enablement. |
| END_INTERVAL_DATETIME |
datetime(3) |
datetime2(0) |
The last Dispatch Interval of the enablement. |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last time record was changed. |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SSM_INSTRUCTION_PK |
clustered, unique, primary key |
INSTRUCTION_ID, VERSION_DATETIME |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SSM_INSTRUCTION |
clustered, unique, primary key |
INSTRUCTION_ID, VERSION_DATETIME |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SSM_INSTRUCTION |
clustered, unique, primary key |
INSTRUCTION_ID, VERSION_DATETIME |