MARKETNOTICEDATA
MARKETNOTICEDATA shows market notices data provided to all participants (market) and specific participants (participant).
Package
MARKET_NOTICE
Visibility
Private and Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| NOTICEID |
numeric(10, 0)  |
int |
Notice Identifier |
| EFFECTIVEDATE |
datetime(3) |
datetime2(0) (not nullable) |
Effective Date of Market notice |
| TYPEID |
varchar(25) |
varchar(25) |
Market Notice Type Identifier (Market - all participants. Participant - selected participants) |
| NOTICETYPE |
varchar(25) |
varchar(25) |
Market Notice Type |
| LASTCHANGED |
datetime(3) |
datetime2(0) (not nullable) |
Last date and time record changed |
| REASON |
varchar(2000) |
varchar(2000) |
Detail of market notices. |
| EXTERNALREFERENCE |
varchar(255) |
varchar(255) |
External Reference for extra data pertaining to market notice |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MARKETNOTICEDATA_LCX |
nonclustered |
LASTCHANGED |
| MARKETNOTICEDATA_PK |
clustered, unique, primary key |
NOTICEID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_MARKETNOTICEDATA_EFFECTIVEDATE |
nonclustered |
EFFECTIVEDATE |
| IX_MARKETNOTICEDATA_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_MARKETNOTICEDATA |
clustered, unique, primary key |
NOTICEID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MARKETNOTICEDATA_LCX |
nonclustered |
LASTCHANGED |
| PK_MARKETNOTICEDATA |
clustered, unique, primary key |
NOTICEID |