MTPASA_REGIONAVAIL_TRK
The tracking table to assist in versioning of the region-aggregate offered PASA Availability data published to the MTPASA_REGIONAVAILABILITY table.
Package
MTPASA
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| PUBLISH_DATETIME |
datetime(3)  |
datetime2(0) |
Date Time the report was published. |
| STARTDATE |
datetime(3) |
datetime2(0) |
First date of the report inclusive. |
| ENDDATE |
datetime(3) |
datetime2(0) |
Last date of the report inclusive. |
| LATEST_OFFER_DATETIME |
datetime(3) |
datetime2(0) |
Date Time of the latest offer used in the report. |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MTPASA_REGIONAVAIL_TRK_PK |
clustered, unique, primary key |
PUBLISH_DATETIME |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_MTPASA_REGIONAVAIL_TRK |
clustered, unique, primary key |
PUBLISH_DATETIME |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MTPASA_REGIONAVAIL_TRK_PK |
clustered, unique, primary key |
PUBLISH_DATETIME |