The mpi_cmpspec table is used to define comparison roles.

Expanded name
Comparison Specification
Table category
Algorithm configuration
This dictionary table provides comparison role definitions and specifies anonymous and equivalent filters at a comparison function level.
This table references: mpi_cmphead table through cmpcode and mpi_strhead through anonstrcode and equistrcode.
Table 1. mpi_cmpspec 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)
cmpcode Comparison code
cmpseqno Comparison sequence number
cmpfunccode Comparison function code
cmpspeccode Comparison specification code
isri Is review identifier; indicates if review identifier tasks are created
cmprole1 Comparison role 1; comparison roles are used to tie the comparison function to a derived data to generate a score
cmprole2 Comparison role 2
cmprole3 Comparison role 3
cmprole4 Comparison role 4
anonstrcode Anonymous string code for filtering anonymous strings
equistrcode Equivalent string code for translating equivalent strings
wgtcut Defines a cut-off for weight tables. When generating the sval or nval weight table, typically only the most common values are listed. wgtcut defines the cumulative percentage of the listed values that are written to the enumerated weight table.
cmpgroupno Defines the comparison group number of which this comparison role is a member. The default is 0 and means that the cmpspec is its own group.
cmpmode Defines whether the comparison mode is Match and Link only (1), Search only (2), or Search, Match, and Link (3). Flag 3 is the default behavior. This option allows you to configure a single algorithm and specify which comparison functions are used during a search operation or a match operation.
wgtargs Weight arguments passed to the weight library function
cmpdesc Optional comparison description

mpi_cmpspec SQL:

CREATE TABLE mpi_cmpspec
caudrecno    bigint		NOT NULL,
maudrecno    bigint		NOT NULL,
recstat      nchar(1)		NOT NULL,
cmpcode      nvarchar(12)	NOT NULL,
cmpseqno     smallint		NOT NULL,
cmpfunccode  nvarchar(12)	NOT NULL, 
cmpspeccode  nvarchar(12)	NOT NULL,
isri         nvarchar(1)	NOT NULL,
cmprole1     smallint		NOT NULL,
cmprole2     smallint		NOT NULL,
cmprole3     smallint		NOT NULL,
cmprole4     smallint		NOT NULL,
anonstrcode  nvarchar(40)	NULL,
equistrcode  nvarchar(40)	NULL,
wgtcut       smallint		NOT NULL,
cmpgroupno   smallint		NOT NULL,
cmpmode      smallint		NOT NULL, 
wgtargs      nvarchar(255)	NULL,
cmpargs      nvarchar(255)	NULL,
cmpdesc      nvarchar(255)	NULL
CREATE UNIQUE INDEX mpi_cmpspec1 ON mpi_cmpspec (cmpcode,cmpseqno)
CREATE UNIQUE INDEX mpi_cmpspec2 ON mpi_cmpspec (cmpcode,cmpspeccode)