CDEMEMATCHWORDTP
This table contains the codes and values for the word-by-word comparisons that each InfoSphere MDM Probabilistic Matching Engine match function code performs (see the CDEMEMATCHFUNCTIONTP table). Some examples of word comparisons that are done are Nickname (for example, Nick or Nicholas) and acronym (for example, IBM or International Business Machines).
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_WORD_TP_CD | The match word type code is the numerical value that represents the the outcome of a comparison of two individual words carried out by a matching function. These values can be : 65, 67, 68, 69, 89, 88, 73, 49, 77, 78, 80, 79, 50, 42. | VARCHAR(5) | Not Null | Yes |
| NAME | A short, meaningful label for the value of the type code. The current names of the codes are: Acronym, Compound Word Match, Different, Edit Distance, Equal Initials, Equal Word, Initials match word first character, Left prefix of right, Missing, Nickname, Phonetic, Phonetic Nickname Equal, Right prefix of left, 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 |