SSM_CONTRACT_UNIT_AVAIL
The variable parameters associated to the Unit within an SSM Contract, allowing changes to the base contract values due to unit availabilities (e. g Maintenance, Outages).
Package
SYSTEM_SECURITY_MANAGEMENT
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| CONTRACT_ID |
varchar(20)  |
varchar(20) |
Unique Contract Identifier |
| DUID |
varchar(20) |
varchar(10) |
Dispatchable Unit Identifier |
| INTERVAL_DATETIME |
datetime(3) |
datetime2(0) |
The starting Dispatch Interval for the availability change. This will be the active availability until the next INTERVAL_DATETIME record for this Contract and DUID. |
| VERSION_DATETIME |
datetime(3) |
datetime2(0) |
Effective Date and Time of this record. |
| AVAILABLE |
numeric(1, 0) |
bit |
Indicates if DUID is available for the INTERVAL_DATETIME (1 = True, 0 = False). |
| UNIT_COUNT |
numeric(4, 0) |
smallint |
Number of sub-units within a DUID that are available for enablement. |
| ACTIVATION_LEAD_TIME |
numeric(6, 0) |
int |
The expected maximum lead time for the system security service to be enabled from a non-operational state in minutes. |
| MIN_DISPATCH_MW |
numeric(18, 8) |
numeric(18, 8) |
Minimum Dispatch Target required for DUID to enable the contract. |
| MIN_ENABLEMENT_DURATION |
numeric(6, 0) |
int |
Minimum duration a unit must be active to enable the contract in minutes. |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last time record was changed |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SSM_CONTRACT_UNIT_AVAIL_PK |
clustered, unique, primary key |
CONTRACT_ID, DUID, INTERVAL_DATETIME, VERSION_DATETIME |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SSM_CONTRACT_UNIT_AVAIL |
clustered, unique, primary key |
CONTRACT_ID, DUID, INTERVAL_DATETIME, VERSION_DATETIME |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SSM_CONTRACT_UNIT_AVAIL |
clustered, unique, primary key |
CONTRACT_ID, DUID, INTERVAL_DATETIME, VERSION_DATETIME |