Skip to content

VALUATIONID

VALUATIONID shows the identifiers and descriptions of the valuers submitting estimates of upcoming settlement residues. VALUATIONID supports the Settlement Residue Auction.

Package

IRAUCTION

Visibility

Public

Table schema

Column Official MMS Datatype GR-MMS Datatype Comment
VALUATIONID varchar(15) 🔑 varchar(15) 🔑 Identifier of the estimator
DESCRIPTION varchar(80) varchar(80) Full name of estimator
LASTCHANGED datetime(3) datetime2(0) Timestamp of record creation or modification

Official MMS data model indexes

Index name Index type Index columns (in order)
VALUATIONID_NDX_LCHD nonclustered LASTCHANGED
VALUATIONID_PK clustered, unique, primary key VALUATIONID

GR-MMS data model indexes

Index name Index type Index columns (in order)
IX_VALUATIONID_LASTCHANGED nonclustered LASTCHANGED
PK_VALUATIONID clustered, unique, primary key VALUATIONID

Historical-MMS data model indexes

Index name Index type Index columns (in order)
VALUATIONID_NDX_LCHD nonclustered LASTCHANGED
VALUATIONID_PK clustered, unique, primary key VALUATIONID