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 |