Skip to content

SSM_ENABLEMENT_COSTS

SSM Contract Enablement Costs for NEM.

Package

SYSTEM_SECURITY_MANAGEMENT

Visibility

Public

Table schema

Column Official MMS Datatype GR-MMS Datatype Comment
END_TRADINGDATE datetime(3) 🔑 datetime2(0) 🔑 Trading Date of the end of the enablement
ENABLEMENT_REASON varchar(40) 🔑 varchar(40) 🔑 Primary Service type associated.
ESTIMATED_COSTS numeric(18, 8) numeric(18, 8) Cost estimation for the service type.
LASTCHANGED datetime(3) datetime2(0) Last time record was changed.

Official MMS data model indexes

Index name Index type Index columns (in order)
SSM_ENABLEMENT_COSTS_PK clustered, unique, primary key END_TRADINGDATE, ENABLEMENT_REASON

GR-MMS data model indexes

Index name Index type Index columns (in order)
PK_SSM_ENABLEMENT_COSTS clustered, unique, primary key END_TRADINGDATE, ENABLEMENT_REASON

Historical-MMS data model indexes

Index name Index type Index columns (in order)
PK_SSM_ENABLEMENT_COSTS clustered, unique, primary key END_TRADINGDATE, ENABLEMENT_REASON