mpi_dvdxcmp

The mpi_dvdxcmp table defines the associations between comparison functions and standardization functions.

Expanded name: Derived Data Comparison-to-Standardization Definitions
Table category: Algorithm configuration
Purpose: This table provides the linkage between a comparison function and a standardization function through the stdrole and cmprole fields.
Cross-reference: This table references the mpi_dvdhead table through dvdcode, the mpi_cmpspec table through cmprole and the mpi_dvdxstd table through stdrole.

Table 1. mpi_dvdxcmp 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)
dvdcode	Derived data code value
dvdseqno	Derived data sequence number
stdrole	Standardization role number
cmprole	Comparison role number
cmprolelabel	Comparison role name
rsfilter	Record status on which to filter; any combination of the following statuses– ‘A'ctive, ‘I'nactive, ‘D'eleted, ‘S'hadow (comma-delimited)
dvdargs	Derived data arguments passed to the library function
dvddesc	Optional derived data bucket instance description
minwgtfreq	Defines the minimum count listed in the mpi_strfreq table generated by the mpxfreq utility. If minwgtfreq is 10, only values that occur 10 or more times are listed in the table.

mpi_dvdxcmp SQL:

CREATE TABLE mpi_dvdxcmp
(
caudrecno    bigint		NOT NULL,
maudrecno    bigint		NOT NULL,
recstat      nchar(1)		NOT NULL,
dvdcode      nvarchar(12)	NOT NULL,
dvdseqno     smallint		NOT NULL,
stdrole      smallint		NOT NULL,
cmprole      smallint		NOT NULL,
cmprolelabel nvarchar(32)	NOT NULL,
rsfilter     nvarchar(8)	NOT NULL,
minwgtfreq   int		NOT NULL,
dvdargs      nvarchar(255)	NULL,
dvddesc      nvarchar(255)	NULL 
)
CREATE UNIQUE INDEX mpi_dvdxcmp1 ON mpi_dvdxcmp (dvdcode,dvdseqno)