Skip Navigation Links | |
Exit Print View | |
Configuring Oracle Java CAPS Master Indexes (Repository) Java CAPS Documentation |
Configuring Oracle Java CAPS Master Indexes (Repository)
Master Index Configuration Overview (Repository)
About the Master Index Configuration Files (Repository)
Modifying the Master Index XML Files Directly (Repository)
Using the Master Index Configuration Editor-Repository
Match Configuration File (matchConfigFile.cfg)
Maintaining Version Control in the Master Index (Repository) Configuration Files
Checking Configuration Files Out With the Configuration Editor-Repository
Checking Configuration Files In With the Configuration Editor-Repository
Saving a Configuration File to the Repository
Copying, Cutting, and Pasting Files
Configuring the Master Index Object Structure (Repository)
Adding an Object to the Master Index Object Structure (Repository)
To Add an Undefined Object (Configuration Editor)
To Add a Predefined Object (Configuration Editor)
To Add an Undefined Object (XML editor)
Modifying an Object's Name In the Master Index Object Definition (Repository)
To Modify an Object's Name (Configuration Editor)
To Modify an Object's Name (XML Editor)
Deleting an Object From the Master Index Object Structure (Repository)
To Delete an Object (Configuration Editor)
To Delete an Object (XML Editor)
Adding a Field to the Master Index Object Structure (Repository)
To Add a Field (Configuration Editor)
Deleting a Field from the Master Index Object Structure (Repository)
To Delete a Field (Configuration Editor)
To Delete a Field (XML Editor)
Modifying Master Field Properties (Repository)
To Modify Field Properties (Configuration Editor)
To Modify Field Properties (XML Editor)
Defining Relationships Between Master Index Objects (Repository)
To Define Object Relationships (XML Editor)
Master Index Field Properties and Name Restrictions (Repository)
Master Index Field Name Restrictions (Repository)
Master Index Configuration Editor Field Properties (Repository)
Master Index Field Property Elements (Repository)
Creating a Master Index Basic Query (Repository)
To Create a Basic Query (Configuration Editor)
To Create a Basic Query (XML Editor)
Master Index Query Builder Dialog Box Fields and XML Elements (Repository)
Creating Master Index Blocking Queries (Repository)
To Create a Blocking Query (Configuration Editor)
To Create a Blocking Query (XML Editor)
Master Index Query Block Fields and XML Elements (Repository)
Modifying Master Index Queries (Repository)
Modifying a Master Index Query (Repository)
To Modify a Basic Query (Configuration Editor)
To Modify a Query (XML Editor)
Adding a Query Block to a Master Index Query (Repository)
To Add a Query Block (Configuration Editor)
To Add a Query Block (XML Editor)
Modifying a Query Block for a Master Index Query (Repository)
To Modify a Query Block (Configuration Editor)
To Modify a Query Block (XML Editor)
Deleting a Query Block From a Master Index Query (Repository)
Deleting a Master Index Query (Repository)
To Delete a Query (Configuration Editor)
Configuring Master Index Processing Options (Repository)
Specifying Master Index Custom Logic Classes (Repository)
To Specify Custom Logic for External System Messages
To Specify Custom Logic for the Enterprise Data Manager
Specifying the Master Index Update Mode (Repository)
To Specify Potential Duplicates be Reevaluated at Each Update
To Specify Potential Duplicates not be Reevaluated at Each Update
Configuring Master Index Merged Record Updates (Repository)
To Allow Merged Record Updates
To Prevent Merged Record Updates
Specifying the Master Index Blocking Query for Matching (Repository)
To Specify the Blocking Query for Matching
Setting Master Index Blocking Query Options (Repository)
Configuring Matching Parameters (Repository)
Specifying the Master Index Decision Maker Class (Repository)
To Specify the Decision Maker Class
Defining How to Handle Multiple Assumed Matches (OneExactMatch) (Repository)
To Create Potential Duplicates When Multiple Records Match
To Match the Highest Weighted Records When Multiple Records Match
Specifying Whether Same System Matches are Allowed (SameSystemMatch) (Repository)
To Allow Same System Records to be Automatically Merged
To Prevent Same System Records From Being Automatically Merged
Specifying the Master Index Duplicate Threshold (Repository)
To Specify the Duplicate Threshold (Configuration Editor)
To Specify the Duplicate Threshold (XML Editor)
Specifying the Master Index Match Threshold (Repository)
To Specify the Match Threshold (Configuration Editor)
To Specify the Match Threshold (XML Editor)
Adding and Deleting Master Index Decision Maker Parameters (Repository)
To Add a New Decision Maker Parameter
To Delete a Decision Maker Parameter
Configuring Master Index EUIDs (Repository)
Specifying the Master Index EUID Generator Class (Repository)
To Specify the EUID Generator Class
Specifying the Master Index EUID Length (Repository)
Specifying a Master Index Checksum Length (Repository)
Specifying the Master Index Chunk Size (Repository)
Adding and Deleting Master Index EUID Generator Parameters (Repository)
To Add EUID Generator Parameters
To Delete EUID Generator Parameters
Defining Master Index Normalization Rules (Repository)
Defining a Master Index Field to be Normalized (Repository)
To Define a Field to be Normalized (Configuration Editor)
To Define a Field to be Normalized (XML Editor)
Master Index Normalization and Standardization Structure Properties (Repository)
Master Index Locale Codes Properties (Repository)
Modifying a Master Index Normalization Definition (Repository)
To Modify a Normalization Definition (Configuration Editor)
To Modify a Normalization Structure (XML Editor)
Deleting a Master Index Normalization Definition (Repository)
To Delete a Normalization Definition
To Delete a Normalization Structure
Defining Master Index Standardization Rules (Repository)
Defining Master Index Fields to be Standardized (Repository)
To Define Fields to be Standardized (Configuration Editor)
To Define Fields to be Standardized (XML Editor)
Master Index Standardization Source and Target Field Elements (Repository)
Modifying a Master Index Standardization Definition (Repository)
To Modify a Standardization Definition (Configuration Editor)
To Modify a Standardization Definition (XML Editor)
Deleting a Master Index Standardization Definition (Repository)
To Delete a Standardization Definition (Configuration Editor)
To Delete a Standardization Definition (Configuration Editor)
Defining Phonetic Encoding for the Master Index (Repository)
Defining Master Index Fields for Phonetic Encoding (Repository)
To Define a Field for Phonetic Encoding (Configuration Editor)
To Define a Field for Phonetic Encoding (XML Editor)
Master Index Phonetic Encoding Fields and Elements (Repository)
Modifying a Master Index Phonetic Encoding Definition (Repository)
To Modify a Phonetic Encoding Definition (Configuration Editor)
To Modify a Phonetic Encoding Definition (XML Editor)
Deleting a Master Index Phonetic Encoding Definition (Repository)
To Delete a Phonetic Encoding Definition (Configuration Editor)
To Delete a Phonetic Encoding Definition (XML Editor)
Defining a Master Index Phonetic Encoder (Repository)
To Define a Phonetic Encoder (Configuration Editor)
To Define a Phonetic Encoder (XML Editor)
Master Index Encoder Elements and Types (Repository)
Modifying a Master Index Phonetic Encoder (Repository)
To Modify a Phonetic Encoder (Configuration Editor)
To Modify a Phonetic Encoder (XML Editor)
Deleting a Master Index Phonetic Encoder (Repository)
To Delete a Phonetic Encoder (Configuration Editor)
To Delete a Phonetic Encoder (XML Editor)
Defining the Master Index Match String (Repository)
Creating the Master Index Match String (Repository)
To Create the Match String (Configuration Editor)
To Create the Match String (XML Editor)
Modifying the Master Index Match String (Repository)
To Modify the Match String (Configuration Editor)
To Modify the Match String (XML Editor)
Defining how Master Index Query Blocks are Processed (Repository)
To Specify the Pass Controller Class
Defining the Master Index Survivor Calculator (Repository)
Specifying the Master Index Survivor Helper (Repository)
To Specify the Survivor Helper
Specifying a Master Index Default Survivor Strategy (Repository)
To Specify a Default Survivor Strategy
Configuring the Default Survivor Strategy
Master Index Default Survivor Strategy Parameter Elements (Repository)
Defining the Master Index Single Best Record Structure (Repository)
Defining a Master Index Survivor Strategy for a Field or Object (Repository)
To Define a Survivor Strategy for a Field
Defining Master Index Custom Weighted Strategies (Repository)
Defining Custom Weighted Strategies
Configuring Weighted Strategies
Modifying Weighted Calculator Parameters
Deleting Weighted Calculator Parameters
Master Index Weighted Calculator Parameter Elements (Repository)
Configuring Master Index Update Policies (Repository)
Defining Master Index Update Policies (Repository)
Setting the Master Index Update Policy Flag (Repository)
Defining Custom Field Validations for the Master Index (Repository)
To Implement a Validation Rule
Configuring the Match Engine (Repository)
Specifying a Match Engine for the Master Index (Repository)
Configuring the Comparison Functions for a Master Index Application (Repository)
To Configure the Comparison Functions (Configuration Editor)
To Configure the Comparison Functions (Text Editor)
Match Comparator Configuration Properties for Oracle Java CAPS Master Index (Repository)
Configuring the Standardization Engine (Repository)
Specifying a Standardization Engine for the Master Index (Repository)
To Specify the Standardization Engine
Modifying Master Index Standardization Files (Repository)
To Modify Standardization Data Configuration Files
Loading Standardization Files to a Master Index Application (Repository)
Configuring the Master Index EDM Appearance (Repository)
EDM Field Configuration Elements
To Remove a Field From the EDM
Modifying EDM Field Display Options
To Modify a Field's Display Options
Specifying a Drop-Down List for an EDM Field
Specifying an EDM Field's Length and Format
To Modify a Field's Length and Format
Modifying an EDM Field's Data Type
Defining Key Fields for an Object (Repository)
Masking Field Values on the EDM
To Mask Field Values on the EDM
Defining EDM Object Relationships (Repository)
Defining EDM Local ID Labels (Repository)
Configuring the Master Index EDM Search Pages (Repository)
Specifying Standard EDM Search Page Properties (Repository)
To Specify Standard Search Page Properties
Creating a Search Page for the EDM (Repository)
Step 1: Define the Search Page
Step 2: Define the Search Fields
Step 3: Specify Search Options
EDM Search Page Definition Elements
EDM Search Field Definition Elements
Modifying a Search Page on the EDM (Repository)
Modifying a Search Page Definition
Configuring Master Index EDM Page Layouts (Repository)
Specifying the Initial View for the EDM (Repository)
Configuring the EDM Search Results Page (Repository)
To Configure the Search Results Page
Configuring the EDM View/Edit Page (Repository)
To Configure the View/Edit Page
Configuring the EDM Create System Record Page (Repository)
To Configure the Create EO Page
Configuring the EDM History Page (Repository)
Configuring the EDM Match Review Page (Repository)
To Configure the Match Review Page
Configuring the EDM Reports and Reports Page (Repository)
EDM Reports and Reports Page Configuration Elements (Repository)
Configuring the EDM Audit Log Pages (Repository)
To Configure the Audit Log Pages
Configuring Master Index EDM Implementation Information (Repository)
Specifying the Master Controller JNDI Class (Repository)
To Specify the Master Controller JNDI Class
Specifying the Master Index Report Generator JNDI Class (Repository)
To Specify the Report Generator JNDI Class
Specifying Master Index Validation Services (Repository)
To Specify the Validation Service
Setting Master Index Debug Options (Repository)
By default, two basic queries and one blocking query are predefined in the Candidate Select file and you can create additional queries. Once a query is defined, you can modify it as needed. If you make changes to a query defined for a search in the EDM, you might need to modify the search definition in the Enterprise Data Manager file. For example, if you deselect the Use Wildcard option for a query and the wildcard feature is enabled for that query in the EDM, you need to disable that feature in the Enterprise Data Manager file.
You can customize the queries used in your implementation by performing any of the following actions.
Modifying a Query Block for a Master Index Query (Repository)
Deleting a Query Block From a Master Index Query (Repository)
Once you define a basic query, you can modify the attributes and parameters for that query. If you defined a custom query, you might need to modify certain elements of the query directly in the XML file instead of through the Configuration Editor.
The Configuration Editor appears.
The Query page appears.
The Blocking Query Builder dialog box appears.
The Basic Query Builder dialog box appears.
The file opens in the NetBeans XML editor.
For example:
<query-builder name="ALPHA-SEARCH" class= "com.stc.eindex.querybuilder.MyQueryBuilder" parser-class= "com.stc.eindex.configurator.impl.querybuilder.KeyValueConfiguration" standardize="true" phoneticize="false"> </query-builder>
For example:
<config> <option key="SearchAlias" value="true"/> </config>
See Master Index Query Builder Dialog Box Fields and XML Elements (Repository) for information about the key and value pairs available to the default basic queries.
For example, to remove the SearchAlias parameter in the following sample, delete the boldface text.
<config> <option key="SearchAlias" value="true"/> <option key="UseWildCard" value="false"/> </config>
Some query blocks might be predefined for you based on information you specified in the wizard. You can create additional query blocks for a blocking query.
The Configuration Editor appears.
The Query page appears.
The Blocking Query Builder dialog box appears.
The Block Definition dialog box appears.
The Block Rule dialog box appears, where you can specify a field to include in the query block.
The file opens in the NetBeans XML editor.
For example:
<config> <block-definition number="ID1"> </block-definition> </config> </query-builder>
The following example illustrates an Oracle hint.
<config> <block-definition number="ID1"> <hint>FIRST_ROWS_100</hint> </block-definition> <config>
For example:
<config> <block-definition number="ID1"> <hint>FIRST_ROWS_100</hint> <block-rule> <equals> <field>Enterprise.SystemSBR.Person.FirstNamePh</field> <source>Person.FirstNamePh</source> </equals> <equals> <field>Enterprise.SystemSBR.Person.LastNamePh</field> <source>Person.LastNamePh</source> </equals> <range> <field>Enterprise.SystemSBR.Person.DateOfBirth</field> <source>Person.DateOfBirth</source> <default> <lower-bound type=”offset”>-5</lower-bound> <upper-bound type=”constant”>2006-01-01 </upper-bound> </default> </range> </block-rule> </block-definition> <config>
Once block definitions are created for a blocking query, you can modify those definitions if needed. You can add, modify, and remove block fields. When adding or removing fields from a query block, verify that the query will still include all the needed fields.
The Configuration Editor appears.
The Query page appears.
The Blocking Query Builder dialog box appears.
The Block Definition dialog box appears.
The file opens in the NetBeans XML editor.
For example:
<block-rule> <equals> <field>Enterprise.SystemSBR.Person.DOB</field> <source>Person.DOB</source> </equals> ...
For example, to delete the DOB field defined above, you would delete the text between and including the equals elements.
Once you create a block definition, you can delete it if needed. When deleting a query block, verify that the query will still include all the needed fields.
The Configuration Editor appears.
The Query page appears.
The Blocking Query Builder dialog box appears.
The file opens in the NetBeans XML editor.
For example, in the sample below, to delete the SSN block you would delete the boldface text.
<config> <block-definition number="ID000007"> <block-rule> <equals> <field>Enterprise.SystemSBR.Person.SSN</field> <source>Person.SSN</source> </equals> </block-rule> </block-definition> <block-definition number="ID000008"> <block-rule> <equals> <field>Enterprise.SystemSBR.Person.DOB</field> <source>Person.DOB</source> </equals> </block-rule> </block-definition>
Note - Each blocking query must contain one config element, and the config element must contain at least one block definition.