Working With External Search/Match

These topics discuss how to use External Search/Match from within PeopleSoft HCM, provide an overview of working with external search/match, and discuss working with external search/match.

Page Name

Definition Name

Usage

Search Criteria Page

HCR_SM_SEARCH

Enter criteria to search for duplicate person or multiple person records contained inside an external system. When the page is accessed through the SCC_SM_SEARCH component, then the system performs the External Search/Match evaluation.

Integrated Search Results Page

SCC_SM_RESULTS

View Search/Match results of an external system search and investigate potential duplicate IDs.

Biographical Details Page

SCC_SM_RESP_DTL

View personal data stored inside the external system.

Regional Page

SCC_BIO_DEMO_REG

View regional data stored inside the external system.

Use the Search Criteria page (HCR_SM_SEARCH) to enter criteria to search for duplicate person or multiple person records contained inside an external system.

When the page is accessed through the SCC_SM_SEARCH component, then the system performs the External Search/Match evaluation.

Image: Search Criteria page (1 of 2)

This example illustrates the fields and controls on the Search Criteria page (1 of 2). You can find definitions for the fields and controls later on this page.

Search Criteria page (1 of 2)

Image: Search Criteria page (2 of 2)

This example illustrates the fields and controls on the Search Criteria page (2 of 2). You can find definitions for the fields and controls later on this page.

Search Criteria page (2 of 2)

The fields on this page are the same as those on the Search/Match page. However, the SCC_SM_SEARCH component includes logic that evaluates the external system data settings when you click the Search or Selective Search button. Note that this is only true when the Search Type is Person.

Note: For a Search Type of Applicant or Organization, the system triggers Search/Match only if on the Search Match Options for External Systems page, External Search Match is set to Inactive and Internal Search Match is set to Active.

Use the Integrated Search Results page (SCC_SM_RESULTS) to view Search/Match results of an external system search and investigate potential duplicate IDs.

Image: Integrated Search Results page: Results tab

This example illustrates the fields and controls on the Integrated Search Results page: Results tab. You can find definitions for the fields and controls later on this page.

Integrated Search Results page: Results tab

Image: Integrated Search Results page: Results2 tab

This example illustrates the fields and controls on the Integrated Search Results: Results2 tab. You can find definitions for the fields and controls later on this page.

Integrated Search Results page: Results2 tab

Image: Integrated Search Results page: Additional Information tab

This example illustrates the fields and controls on the Integrated Search Results page: Additional Information tab. You can find definitions for the fields and controls later on this page.

Integrated Search Results page: Additional Information tab

Many fields on this page are the same as those on the Search Results page. However, there are some important distinctions:

  • Records with no HCM employee IDs appear first in the Search Results group box.

  • Records with no HCM employee IDs are assigned an External Sys ID..

  • Where an HCM employee ID exists, the Detail link accesses a page where you can view details of the ID record from the HCM system.

  • Where no HCM employee ID exists, the Detail link accesses a page where you can view details of the data from the external system.

  • The Import button appears when a person meets the criteria in the external system.

  • The external system ID column appears based on the settings defined on the Search Match Options for External Systems page. The column heading depends on the Display Name that is defined for the Universal ID column, in this case CS Employee ID.

  • Masking configuration is in effect for all matching individuals, even those with no employee ID.

  • For matching person records found by External Search/Match, this page displays information that is not necessarily stored inside the external system (for example, Campus SolutionsAid Year).

Field or Control

Definition

Number of ID's Found

The system displays the total number of distinct IDs returned by both Search/Match and External Search/Match, just Search/Match, or just External Search/Match.

Search Order Number

The system shows the Search Order Number where results were found.

When the internal and external searches find results under different search rules, the Results Engine evaluates the Search Order Number returned by both searches and displays the results for the search that found results under the smallest search order number (the most restrictive search).

When the internal and external searches find results under the same search rule, the Results Engine displays them both.

Search Results

The fields in this group box are similar to those on the Search Results page. The system displays the results returned from both the HCM database and the external system, along with additional data to describe the IDs that are retuned. However, the columns are dynamic and they can refer to personal data information or transaction data information. You define static columns to appear here on the Search Match Options for External Systems page.

Field or Control

Definition

Import or Carry ID

The Carry ID button appears when an employee ID exists; otherwise the system displays the Import button. Security access to the Add/Update Person component controls whether users can use the Import button.

Click the Import button to import external system data when the person does not exist in the HCM system. When you click the button, the system displays a message asking if you want to create the new ID in the system.

If you click Yes, the system performs a Fetch Request to request the complete constituent record from the external system. When the system receives the Fetch Response from the external system, it uses the personal data in it to create a new employee.

After successfully importing the data, the Search Results group box refreshes and the newly created employee appears; the Import button for the person row changes to Carry ID. Notice that no other import can be performed (all the Import buttons are then unavailable). This is to prevent the user from importing multiple matching candidates.

If you click No, the system does not import any data and returns to the Integrated Search Results page.

Detail

If an HCM employee ID exists, click this link to access the page that is set up inside the Search Results Code to view more information about the person. The default page for HCM is Biographical Details (PERSONAL_DATA1).

If no HCM employee ID exists for the person, click this link to invoke a Fetch Request to retrieve the complete constituent record from the external system. When the system receives the Fetch Response from the external system, it displays the personal data in the response on the Biographical Details (SCC_SM_RESP_DTL) page.

Note: Both the Import button and the Detail link (when no employee ID exists) trigger the same Fetch Request. The data received inside the Fetch Response will only be saved to your database when the Fetch request is triggered from the Import button. It is therefore good practice to always review the detailed information prior to importing.

Additional Information

A column with the external system IDs appears on the Additional Information tab when a Universal ID static column to display is selected on the Search Match Options for External Systems page. The column heading depends on the Display Name defined, in this case CS Employee ID.

Use the Biographical Details page (SCC_SM_RESP_DTL) to view personal data stored inside the external system.

Note: The sample component shown is Biographical Details (SCC_SM_RESP_DTL), which is accessed by clicking the Detail link for an individual with no HCM employee ID.

Image: Biographical Details page (1 of 2)

This example illustrates the fields and controls on the Biographical Details page (1 of 2). You can find definitions for the fields and controls later on this page.

Biographical Details page (1 of 2)

Image: Biographical Details page (2 of 2)

This example illustrates the fields and controls on the Biographical Details page (2 of 2). You can find definitions for the fields and controls later on this page.

Biographical Details page (2 of 2)

This page displays sections of data that are not stored in the HCM database until you click the Import button.

The system displays messages on this page based on the following conditions:

Note: Where no data exists, the system hides the fields and displays a message in the Missing Information group box.

Data Region

Condition

Message

Current Names

No name information exists

No Current Name Information

Personal Information

No personal information exists

No Personal Information

Biographical Information

No biographical information exists

No Biographical Information

National ID

No national ID information exists

No National ID Information

Email Addresses

No email address information exists

No Email Addresses Information

Phone Numbers

No phone information exists

No Phone Number Information

Current Addresses

No address information exists

No Address Information

Regional

No regional data exists

No Regional Information

Field or Control

Definition

Import

Click this button to import the external system ID and all the information displayed, into the HCM system and create an emplID.

Current Names

Field or Control

Definition

History

This link appears only if the external system ID contains a past or future date in addition to the current row. Click the link to access the Name Type History page.

Current Addresses

Field or Control

Definition

History

This link appears only if the external system ID contains a past or future date in addition to the current row. Click the link to access the Address Type History page.

Use the Regional page (SCC_BIO_DEMO_REG) to view regional data stored inside the external system.

Image: Regional page

This example illustrates the fields and controls on the Regional page. You can find definitions for the fields and controls later on this page.

Regional page

This page is available only if it contains data. If the fetch response contains no regional information, this message appears on the Missing Information group box on the Biographical Details page.

Data Region

Condition

Message

Regional

No regional data exists

No Regional Information