mpi_wgtnval

The mpi_wgtnval table is used to define weights for numeric values.

Expanded name
Weight numeric values
Table category
Algorithm configuration
Purpose
This dictionary table is part of the weight definitions for calculating match scores for numeric values.
Cross-reference
This table references mpi_wgthead table through wgtcode.
Table 1. mpi_wgtnval Attribute Descriptions
Attribute Description
caudrecno Creation of this particular record, from mpi_audhead
maudrecno Last time the record value was modified, from mpi_audhead
recstat Record status; A(ctive) or I(nactive)
wgtcode Weight code from the mpi_wgthead table
numval Numeric value
wgtval Weight value

mpi_wgtnval SQL:

CREATE TABLE mpi_wgtnval
(
caudrecno  bigint      	NOT NULL,
maudrecno  bigint      	NOT NULL,
recstat    nchar(1)     NOT NULL,
wgtcode    nvarchar(40) NOT NULL,
numval     int		NOT NULL,
wgtval     int		NOT NULL
)
CREATE UNIQUE INDEX mpi_wgtnval1 ON mpi_wgtnval (wgtcode, numval)