MTPASA_RESERVELIMIT_SET
MT PASA input table defining a set of MT PASA Reserve Requirements. Note only one set can be active on a given date.
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 |
| RESERVELIMIT_SET_ID |
varchar(20) |
varchar(20) |
MT PASA LRC Reserve Requirement Set Identifier |
| DESCRIPTION |
varchar(200) |
varchar(200) |
Description of this set of Reserve Requirements |
| AUTHORISEDDATE |
datetime(3) |
datetime2(0) |
Date the requirement set was authorised |
| AUTHORISEDBY |
varchar(20) |
varchar(20) |
User authorising this requirement set |
| 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_SET |
clustered, unique, primary key |
EFFECTIVEDATE, VERSION_DATETIME |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_MTPASA_RESERVELIMIT_SET |
clustered, unique, primary key |
EFFECTIVEDATE, VERSION_DATETIME |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_MTPASA_RESERVELIMIT_SET |
clustered, unique, primary key |
EFFECTIVEDATE, VERSION_DATETIME |