PASA_CONTINGENCY_DEFINITION
PASA_CONTINGENCY_DEFINITION shows the contingency details used by PD and ST PASA.
Package
GENERIC_CONSTRAINT
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| CONTINGENCYID |
varchar(20)  |
varchar(20) |
The contingency identifier |
| EFFECTIVEDATE |
datetime(3) |
datetime2(0) |
The effective date for this contingency |
| VERSIONNO |
numeric(3, 0) |
smallint |
Version number for the Effective date |
| CONTINGENCYDESCRIPTION |
varchar(100) |
varchar(100) |
The description for this contingency |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Date time this record was created |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PASA_CONTINGENCY_DEFINITION_PK |
clustered, unique, primary key |
CONTINGENCYID, EFFECTIVEDATE, VERSIONNO |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PASA_CONTINGENCY_DEFINITION_PK |
clustered, unique, primary key |
CONTINGENCYID, EFFECTIVEDATE, VERSIONNO |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PASA_CONTINGENCY_DEFINITION_PK |
clustered, unique, primary key |
CONTINGENCYID, EFFECTIVEDATE, VERSIONNO |