MTPASA_RESERVELIMIT_REGION
MT PASA input table to define the regions that are part of a single MT PASA Reserve Requirement.
Package
RESERVE_DATA
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| EFFECTIVEDATE |
datetime(3)  |
datetime2(0) |
Trade date when the set of reserve requirements become effective |
| VERSION_DATETIME |
datetime(3) |
datetime2(0) |
Timestamp when the set of reserve requirements become effective |
| RESERVELIMITID |
varchar(20) |
varchar(20) |
MT PASA Reserve requirement identifier |
| REGIONID |
varchar(20) |
varchar(20) |
Region ID - identifier of a NEM region included in this requirement |
| COEF |
numeric(16, 6) |
numeric(16, 6) |
Coefficient for the region in this reserve requirement |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Timestamp the record was last modified |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_MTPASA_RESERVELIMIT_REGION |
clustered, unique, primary key |
EFFECTIVEDATE, VERSION_DATETIME, RESERVELIMITID, REGIONID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_MTPASA_RESERVELIMIT_REGION |
clustered, unique, primary key |
EFFECTIVEDATE, VERSION_DATETIME, RESERVELIMITID, REGIONID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_MTPASA_RESERVELIMIT_REGION |
clustered, unique, primary key |
EFFECTIVEDATE, VERSION_DATETIME, RESERVELIMITID, REGIONID |