Setting Up External Search/Match Functionality

This section discusses how to:

  • Configure external core data integration.

  • Configure External Search/Match options.

  • Configure External Search/Match web services.

Page Name

Definition Name

Navigation

Usage

External Core Data Integration

SCC_EXT_SYSTEM

Set Up SACR > Install > External Core Data Integration

Specify an external system that is integrated with CS for core person data.

External System Search Match Options

SCC_CS_HUB_INSTALL

Set Up SACR > System Administration > Utilities > Search/Match > Search Match with External Sys

Specify External Search/Match options when integrating with an external system.

Access the External Core Data Integration page (Set Up SACR > Install > External Core Data Install).

Field or Control

Definition
Is External System Installed

Select this check box to indicate whether CS is integrated with any external system. If you do not select this check box, the other fields on the page are unavailable for input.

When users perform a Search/Match, the system evaluates this indicator and determines whether to invoke External Search/Match functionality.

Integrated External System

Select an option to indicate which system is integrated:

HCM installed as third party: Select to indicate that CS and an HCM system are in separate instances and the administrative user has distinguished the HCM system as an External System with direct integration to it (for example, HCM 9.0, HCM 9.1, or another CS system).

Other external system:Select to indicate that an external system other than an HCM system has been integrated to CS. This could potentially be another third-party data hub.

[Blank]: Leave the field blank to indicate that CS has no external system integrated with it. This is the default setting for this field.
Data Hub Name

Define the name of the external system, based on the selected Integrated External System. If you selected HCM installed as third party, this field changes to HCM Installed as Third Party and is unavailable for input. However, if you selected Other external system, this field becomes active; enter the external system name.

Note: PeopleSoft assumes that only one external system will be used.

Access the External System Search Match Options page (Set Up SACR > System Administration > Utilities > Search/Match > Search Match with External Sys).

Image: External System Search Match Options page

This example illustrates the fields and controls on the External System Search Match Options page. You can find definitions for the fields and controls later on this page.

External System Search Match Options page

If the Is External System Installed check box is not selected on the External Core Data Integration page, the following message appears: "Currently, no External System is configured with Campus Solutions. To configure an External System, navigate to External Core Data Integration page."

Search/Match Options

Fields in this group box determine the conditions under which the system uses Search/Match, External Search/Match, or both when adding a new person or saving an updated bio/demo page.

Field or Control

Definition
Search Type

Select Person, Applicant, or Organization.

Note: At this time, you may only select the Person option. The other search types are not yet integrated with External Search/Match.

Search/Match Option

Select the Search/Match functionality to use when an external system is installed:

If you select Internal Search/Match and you make it Active, then the Search/Match process searches for person IDs inside the CS database.

If you select External Search/Match and you make it Active, then the External Search/Match process searches for person IDs inside the integrated external system.

If you clear the status or make the status Inactive, the system does not trigger a specific Search/Match tool.

Note: Both searches can be selected at the same time, and results from both searches appear on the same Integrated Search Results page.

Static Columns to Displays in the Results Grid

Fields in this group box contain information about additional columns to display inside the Results grid of the Integrated Search Results page.

Field or Control

Definition
Default Column Name

Select EmplID, Universal ID, Score, or External Employee ID.

These are delivered translate values; do not modify them.

EmplID is displayed by default (just like for Search/Match).

Universal ID is a generic term that refers to the external system ID in use. When selected, the external system ID is displayed inside the Additional Information tab of the Results grid.

Score is a generic term that refers to your external system method for ranking the matches found. It is the weight or the accuracy of the results found. It is sometimes expressed by a percentage or a number. If your external system does not have ranking capability, do not select this option. When selected, the column appears first in the Results grid.

If you select Score, then the system sorts search results in the Results grid by score in descending order and by EmplID in ascending order. If you do not select Score, then the search results appear only by EmplID in ascending order.

External Employee ID refers to the External HCM system EmplID. It is specifically used when the institution has selected to import external EmplIDs rather than generate a CS-unique EmplID.
Display Name

Enter a custom column name for the static columns that appear in the Results grid.

Configure the same service operations in both your Campus Solutions (CS) and Human Capital Management (HCM) systems.

  1. Activate the Search Service SCC_SM_SERVICE.

    1. Log on to the Campus Solutions database and navigate to: Integration Broker > Integration Setup > Services > SCC_SM_SERVICE.

    2. Click Search.

    3. Click the link for the Operation.Default Version SCC_SM_SERVICE_SYNC.

    4. Ensure that the Active check box is checked.

  2. Set up the Handler for SCC_SM_SERVICE.

    1. Click the Handlers Tab and enter the following:

      Field or Control

      Definition
      Name

      REQUESTHDLR
      Type

      OnRequest
      Implementation

      Application Class
      Status

      Active

    2. Click the Details link and enter the following:

      Field or Control

      Definition
      Description

      Search Request Handler
      Package Name

      SCC_HR_INTEGRATION
      Path

      Request_Handler
      ClassID

      ProcessMatchRequest
      Method

      OnRequest

    3. Click OK.

  3. Set up the Routings for SCC_SM_SERVICE.

    1. Click the Routings Tab.

    2. Enter the Outbound Routing details:

      Field or Control

      Definition
      Routing Name

      For example,

      On CS: SCC_SM_Request_to_HR

      On HCM: SCC_SM_Request_to_CS
      Description

      On CS: Search Request to HR db

      On HCM: Search Request to CS db

      Sender Node

      On CS: CS92ESM (CS database name)

      On HCM: HR92ESM (HR database name)
      Receiver Node

      On CS: HR92ESM (HR database name)

      On HCM: CS92ESM (CS database name)
      Log Detail

      Header and Detail

    3. Save and click Return.

    4. Enter Inbound Routing details.

      Field or Control

      Definition
      Routing Name

      For example,

      On CS: SCC_SM_Resp_from_HR

      On HCM: SCC_SM_Resp_from_CS
      Description

      On CS: Search Response from HR db

      On HCM: Search Response from CS db
      Sender Node

      On CS: HR92ESM (HR database name)

      On HCM: CS92ESM (CS database name)

      Receiver Node

      On CS: CS92ESM (CS database name)

      On HCM: HR92ESM (HR database name)
      Log Detail

      Header and Detail

    5. Save and Return.

    6. Verify that Status is Active and Direction is Inbound within Grid for Routing Name SCC_SM_Resp_from_HR. Save.

  4. Activate the Fetch Service SCC_SM_FETCH.

    1. Navigate to: Integration Broker > Integration Setup > Services > SCC_SM_FETCH, and click Search.

    2. Click the link for the Operation.Default Version SCC_SM_FETCH_SYNC.

    3. Ensure that the Active check box is checked.

  5. Set up the handler for SCC_SM_FETCH.

    1. Click the Handlers Tab and enter the following:

      Field or Control

      Definition
      Name

      REQUESTHDLR
      Type

      OnRequest
      Implementation

      Application Class
      Status

      Active

    2. Click the Details link and enter the following:

      Field or Control

      Definition
      Description

      Request Handler
      Package Name

      SCC_HR_INTEGRATION
      Path

      Request_Handler
      ClassID

      ProcessFetchRequest
      Method

      OnRequest

    3. Click OK.

  6. Set up the Routings for SCC_SM_FETCH.

    1. Click the Routings tab and define the Outbound Routing as follows:

      Field or Control

      Definition
      Routing Name

      For example,

      On CS: SCC_SM_FETCH_REQ_to_HR

      On HCM: SCC_SM_FETCH_REQ_to_CS
      Description

      On CS: Fetch Request to HR db

      On HCM: Fetch Request to CS.db
      Sender Node

      On CS: CS92ESM (CS database name)

      On HCM: HR92ESM (HR database name)
      Receiver Node

      On CS: HR92ESM (HR database name)

      On HCM: CS92ESM (CS database name)
      Log Detail

      Header and Detail

    2. Save and Return.

    3. Verify that Status is Active and Direction is Outbound for the Routing Name (SCC_SM_FETCH_REQ_to_HR in Campus Solutions and SCC_SM_FETCH_REQ_to_CS in HCM).

    4. Define Inbound Routing as follows:

      Field or Control

      Definition
      Routing Name

      For example,

      On CS: SCC_SM_FETCH_RESP_from_HR

      On HCM: SCC_SM_FETCH_RESP_from_CS
      Description

      On CS: Fetch Response from HR db

      On HCM: Fetch Response from CS db
      Sender Node

      On CS: HR92ESM (HR database name)

      On HCM: CS92ESM (CS database name)
      Receiver Node

      On CS: CS92ESM (CS database name)

      On HCM: HR92ESM (HR database name)
      Log Detail

      Header and Detail

    5. Save and Return.

    6. Verify that Status is Active and Direction is Inbound within Grid for Routing Name (SCC_SM_FETCH_REQ_from_HR for Campus Solutions and SCC_SM_FETCH_REQ_from_CS for HCM).

    7. Save.