SSM_SCHEDULE
Scheduled SSM contract enablements.
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 |
| CONTRACT_ID |
varchar(20) |
varchar(20) |
Unique Contract Identifier used to create enablement. |
| DUID_PARTICIPANTID |
varchar(10) |
varchar(10) |
Primary recipient (SSM Service Provider) |
| 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. |
| 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. |
| 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_SCHEDULE_PK |
clustered, unique, primary key |
INSTRUCTION_ID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SSM_SCHEDULE |
clustered, unique, primary key |
INSTRUCTION_ID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SSM_SCHEDULE |
clustered, unique, primary key |
INSTRUCTION_ID |