mpi_cmpspec
The mpi_cmpspec table is used to define comparison roles.
- Expanded name
- Comparison Specification
- Table category
- Algorithm configuration
- Purpose
- This dictionary table provides comparison role definitions and specifies anonymous and equivalent filters at a comparison function level.
- Cross-reference
- This table references: mpi_cmphead table through cmpcode and mpi_strhead through anonstrcode and equistrcode.
| 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)