CDEMEMATCHFUNCTIONTP
This table represent the IBM InfoSphere MDM Probabilistic Matching Engine match function details. A match function is a component of a larger algorithm that compares the data for two entities and derives a score based on their likenesses. The match function determines if a subset of the data in an entity (for example a street number, a phone number, a first name, a last name, and so forth) are the same, different, or similar (that is, a partial match), and so forth.
This table is used by the following domain.
| Name | Comment | Datatype | Null Option | Is PK |
|---|---|---|---|---|
| LANG_TP_CD | Identifies a spoken language, such as English, French, Spanish, or German. When used as part of the primary key of a code value lookup table, the Language Type Code also represents the language of the code name. | BIGINT | Not Null | Yes |
| MATCH_FUNCTION_TP_CD | The match function type code is a numerical value returned from eME engine that represents the results of a matching function that was used on a portion of the data. The values can be one of 68, 69, 70, 77, 80, 84, 42. | VARCHAR(5) | Not Null | Yes |
| NAME | A short, meaningful label for the value of the type code. The current names for the corresponding type codes can be: Different, Equal, False, Missing, Partial, True, Unknown. | VARCHAR(120) | Not Null | No |
| DESCRIPTION | Provides extra information either as an additional definition of the type code value or as free form user comments to provide further meaning to the type code. | VARCHAR(255) | Null | No |
| EXPIRY_DT | The date that the type code is no longer valid. | TIMESTAMP | Null | No |
| LAST_UPDATE_DT | When a record is added or updated, this field is updated with the date and time. On subsequent updates, the system uses this information to ensure that the update request includes a matching date and time on this field; if it does not, the update fails. | TIMESTAMP | Not Null | No |
| LAST_UPDATE_USER | The ID of the user who last updated the data. | VARCHAR(20) | Null | No |