Skip Navigation Links | |
Exit Print View | |
![]() |
Understanding Oracle Java CAPS Master Index Processing (Repository) Java CAPS Documentation |
Understanding Oracle Java CAPS Master Index Processing (Repository)
About Oracle Java CAPS Master Index (Repository)
Understanding Master Index Operational Processes (Repository)
Learning About Master Index Message Processing (Repository)
Master Index Inbound Message Processing (Repository)
Master Index Outbound Message Processing (Repository)
Outbound Message Trigger Events
Master Index Inbound Message Processing Logic (Repository)
Master Index Custom Decision Point Logic (Repository)
Master Index Primary Function Processing Logic (Repository)
The Master Index Database Structure (Repository)
About the Master Index Database (Repository)
Master Index Database Table Details (Repository)
Sample Master Index Database Model (Repository)
Working with the Master Index Java API (Repository)
Master Index Java Class Types (Repository)
Static Master Index Java Classes (Repository)
Dynamic Master Index Object Classes (Repository)
Dynamic Business Process Methods
Dynamic Master Index Object Classes (Repository)
Master Index Parent Object Classes (Repository)
Master Index Child Object Classes (Repository)
Dynamic Master Index OTD Methods (Repository)
Dynamic Master Index OTD Methods (Repository)
Dynamic Business Process Methods (Repository)
Master Index Helper Classes (Repository)
SystemObjectName Master Index Class (Repository)
Master Index Parent Beans (Repository)
Master Index Child Beans (Repository)
DestinationEO Master Index Class (Repository)
SearchObjectNameResult Master Index Class (Repository)
SourceEO Master Index Class (Repository)
You can select a Match Type for each field defined in the Oracle Java CAPS Master Index wizard. Each match type defines a different type of standardization, normalization, phonetic encoding, and matching logic in the Match Field file. The following topics describe each match type and how each affects the logic in the Match Field file.
For each field that will be used for matching in the master index application, you can select a match type in the wizard. When you select a match type for a field, Oracle Java CAPS Master Index automatically adds that field to the match string in the Match Field file and, in many cases, generates additional fields in the object definition that are not visible on the wizard. These fields are used for searching and matching and they should not be modified.
If new fields are generated, they are automatically incorporated into the configuration files and the database script that creates the master index tables. These fields store standardized, normalized, or phonetic versions of the field, depending on the type of matching you choose. In addition, these fields are assigned a match type in the match string in the Match Field file. They might also be defined for standardization in the Match Field file, in which case they will also be assigned a standardization type.
Note - The match types specified in the Match Field file for the fields in the match string are not always the same as the match types you specify in the wizard. Information about match types is provided in the following sections. For more information, see Understanding the Oracle Java CAPS Match Engine.
The Oracle Java CAPS Master Index wizard match types fall into four primary categories.
The actual standardization and match types entered into the Match Field file vary for each match type you select in the wizard. The match and standardization types for each type of field are listed in the following descriptions. The match types entered into the Match Field file correspond to the match types defined in the match configuration file, MatchConfigFile.cfg.
The Person match types include PersonLastName and PersonFirstName. These match types are used to normalize and phonetically encode name fields for person matching. For each field with one of these match types, the wizard adds two fields to the object structure for phonetic and standardized versions. If you specify a field with a person match type for blocking in the wizard, the phonetic version of the name is automatically added to the blocking query. The following fields are created when you specify one of the Person match types for a field (field_name refers to the name of the field specified for Person matching).
field_name_Std – This field contains the normalized version of the name.
field_name_Phon – This field contains the phonetic version of the name.
The corresponding standardization and match types in the Match Field file are listed in Table 24.
Table 24 Person Name Standardization and Match Types
|
The BusinessName match type is designed to help parse, normalize, and phonetically encode a business name. BusinessName matching adds several fields to the object structure and to the match string. If you specify a business name field for blocking, each parsed business name field is added to the blocking query. The corresponding standardization type in the Match Field file for all fields selected for BusinessName matching is also BusinessName. The actual match type assigned to each field varies depending on the type of information in each field.
Table 25 lists the fields created when you select the BusinessName match type for a field along with their corresponding match types in the Match Field file (field_name refers to the name of the field selected for BusinessName matching).
Note - Only specify this type of matching for one business name field; otherwise, the wizard will create duplicate entries in the object structure. If more than one field contains the business name, you can add those fields to the standardization structure in the Match Field file after the wizard creates the configuration files.
Table 25 BusinessName Match Types
|
The Address match type is designed to help parse, normalize, and phonetically encode an address for matching or standardizing address information. Address matching adds several fields to the object structure and to the match string. If you specify an address field for blocking, the parsed fields are added to the blocking query. The corresponding standardization type for fields selected for Address matching is Address. The actual match type assigned to each field varies depending on the type of information in each field.
The fields created when you select the Address match type for a field are listed below along with their corresponding match types in the Match Field file (field_name refers to the name of the field selected for Address matching).
Note - Only specify this type of matching for one street address field; otherwise, the wizard will create duplicate entries in the object structure. If more than one field contains the street address, you can define the additional fields in the standardization structure in the Match Field file after the wizard creates the configuration files.
Table 26 Address Match Types
|
If you want to search on street addresses but do not want to use these fields for matching, select the Address match type for only one street address field in the wizard. When the wizard is complete, you can remove the address fields from the match string in the Match Field file.
Several additional match types are defined in the wizard for the Oracle Java CAPS Match Engine. These match types are used to indicate matching on a string, date, or number fields other than those described above or to indicate matching on a field that contains a single character (such as the gender field, which might accept “F” for female or “M” for male). These match types do not define standardization for the specified field and do not add any fields to the object structure. If you specify one of these match types for a field in the wizard, the field is added to the match string with a match type of String, Date, Number, or Char.