MARKET_SUSPEND_SCHEDULE_TRK
Parent table for pricing regimes used in suspensions.
Package
FORCE_MAJEURE
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| EFFECTIVEDATE |
datetime(3)  |
datetime2(0) |
Calendar date from when this record set is effective |
| SOURCE_START_DATE |
datetime(3) |
datetime2(0) |
Start Date of the date range for the source data |
| SOURCE_END_DATE |
datetime(3) |
datetime2(0) |
End Date of the date range for the source data |
| COMMENTS |
varchar(1000) |
varchar(1000) |
Reason why this regime was applied |
| AUTHORISEDDATE |
datetime(3) |
datetime2(0) |
DateTime this record set was loaded |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MARKET_SUSPEND_SCHEDULE_TRK_PK |
clustered, unique, primary key |
EFFECTIVEDATE |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_MARKET_SUSPEND_SCHEDULE_TRK |
clustered, unique, primary key |
EFFECTIVEDATE |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MARKET_SUSPEND_SCHEDULE_TRK_PK |
clustered, unique, primary key |
EFFECTIVEDATE |