EME_RECCMPD

This derived data table stores the comparison data information for a record that is used for scoring records that met the bucketing pass. The purpose of storing information in eme_reccmpd, rather than spreading the information among the various record data tables, is to provide a performance enhancement.

This table is used by the following domain.
Name Comment Datatype Null Option Is PK
RECNO Unique record number from eme_rechead. BIGINT Not Null Yes
SRCRECNO Source record, from the Embedded Matching Engine configuration. SMALLINT Not Null No
CMPSEQNO Comparison sequence number. SMALLINT Not Null Yes
CMPVAL The comparison data. The comparison data itself is a derived copy of the source record from which it was obtains, altered to provide high-speed comparisons. VARCHAR(1020) Not Null No