Note: The results listed above reflect the default match sensitivity (85).
This definition should be used to find potential matches between database column names.
SAS Quality Knowledge Base for Contact Information 25
In the SAS Quality Knowledge Base (QKB), the Chinese definitions are shared by all Chinese-language locales. Shared Chinese definitions are described below.
Case Definitions
Gender Analysis Definitions
Identification Analysis Definitions
Match Definitions
Parse Definitions
Pattern Analysis Definitions
Standardization Definitions
Inherited Definitions
None.
None.
| Field Name | ||
|---|---|---|
| Description |
The Field Name identification analysis definition identifies database column names. |
|
| Possible Outputs | NAME ORGANIZATION ADDRESS CITY STATE/PROVINCE POSTALCODE COUNTRY PHONE DATE UNKNOWN URL GENDER MATCHCODE PERSONAL_ID ORGANIZATION_ID GENERIC_ID COUNTY MARITAL_STATUS |
|
| Examples | Input | Output |
| Company Name | ORGANIZATION | |
| 单位性质 | ORGANIZATION | |
| Address | ADDRESS | |
| 通信地址 | ADDRESS | |
| Telephone | PHONE | |
| 客户姓名 | NAME | |
| Remarks |
This definition is recommended to determine the type of data stored in a database column based on the name of the column. |
|
|
The Field Name (v23) identification analysis definition is now deprecated and will be removed in a future release of the QKB. The Field Name identification analysis definition has been replaced with a copy of the Field Name (v23) definition which takes advantage of updated processing. If you changed your jobs to use the Field Name (v23) definition it is suggested that you change them back. |
||
| Field Name (v23) | ||
|---|---|---|
| Description |
The Field Name (v23) identification analysis definition identifies database column names. |
|
| Possible Outputs | NAME ORGANIZATION ADDRESS CITY STATE/PROVINCE POSTALCODE COUNTRY PHONE DATE UNKNOWN URL GENDER MATCHCODE PERSONAL_ID ORGANIZATION_ID GENERIC_ID COUNTY MARITAL_STATUS |
|
| Examples | Input | Output |
| Company Name | ORGANIZATION | |
| 单位性质 | ORGANIZATION | |
| Address | ADDRESS | |
| 通信地址 | ADDRESS | |
| Telephone | PHONE | |
| 客户姓名 | NAME | |
| Remarks |
This definition is recommended to determine the type of data stored in a database column based on the name of the column. |
|
|
The Field Name (v23) identification analysis definition is now deprecated and will be removed in a future release of the QKB. The Field Name identification analysis definition has been replaced with a copy of the Field Name (v23) definition which takes advantage of updated processing. If you changed your jobs to use the Field Name (v23) definition it is suggested that you change them back. |
||
| Field Name | ||
|---|---|---|
| Description | The Field Name match definition generates match codes which can be used to cluster records containing database field names. | |
| Max Length of Match Code | 15 characters | |
| Examples | Input | Cluster ID |
| Company Name | 0 | |
| 单位性质 | 0 | |
| Address | 1 | |
| 通信地址 | 1 | |
| Telephone | 2 | |
| 客户姓名 | 3 | |
| NAME | 3 | |
| Remarks |
|
|
|
This definition should be used to find potential matches between database column names. |
||
None.
None.
None.
In addition to the definitions listed on this page, all Chinese-language locales also inherit all Global definitions.
|
Documentation Feedback: yourturn@sas.com
|
Doc ID: QKBCI_ZH_defs.html |