MTPASA_RESERVELIMIT
MT PASA input table defining a MT PASA Reserve Requirement within a single set. An MT PASA Reserve Requirement can span more than one region.
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 |
| DESCRIPTION |
varchar(200) |
varchar(200) |
Description of this Reserve Requirement |
| RHS |
numeric(16, 6) |
numeric(16, 6) |
Right hand side value for 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 |
clustered, unique, primary key |
EFFECTIVEDATE, VERSION_DATETIME, RESERVELIMITID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_MTPASA_RESERVELIMIT |
clustered, unique, primary key |
EFFECTIVEDATE, VERSION_DATETIME, RESERVELIMITID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_MTPASA_RESERVELIMIT |
clustered, unique, primary key |
EFFECTIVEDATE, VERSION_DATETIME, RESERVELIMITID |