Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3

Excerpt

PeopleSoft provided provides on-line and batch process processes to search for the existence of a person prior to creating a new record (and potential duplicate). 


Search/Match is an extremely powerful feature in PeopleSoft. At Cornell it is primarily used for maintaining the integrity of the database, with users .  Users from many departments entering enter data into PeopleSoft there is always a chance for creating duplicate entities, to increasing the chances of duplicate entities.  To minimize the entry of duplicate or multiple records duplicates PeopleSoft's Search/Match functionality is the utilized as a the primary search engine. The three searchable ID types (called Search Types) are :

• Person (Emplid).
• Organization (organization IDs within PeopleSoft Enterprise Campus Solutions).
• Applicant (HRS_PERSON_ID within PeopleSoft Enterprise HRMS Talent Acquisition Manager).

Cornell Uses Search/Match in both, on-line transaction processing and batch processing. In both cases the possible matches are reported back to the user in a predefined result table format.  The user then makes a decision as to whether a new ID needs to be generated. Search/Match is only as reliable as the underlying data used in its processes.  If there are delays in the synchronization of data between applications the risk of duplicates increases. 

A process should be defined and maintained for cleaning up duplicates across application systems.

Even though there are several search/match rules in PeopleSoft there are only a few records that can be used by the Search/Match functionality.  In order to use Search/Match across multiple application systems (ie: PeopleSoft and Workday) the records/data selected below for the search/match rules must be passed into PeopleSoftEven though there are a quite a few Search/Match rules setup in the system there are only a few Records that are part of the rule, all the records used in Search/Match are listed below:

Record Name

PS_ADDRESSES

PS_EMAIL_ADDRESSES

PS_EXTERNAL_SYSTEM

PS_EXT_ORG_TBL

PS_HRS_APP_ADDRESS

PS_HRS_APP_EMAIL

PS_HRS_APP_NAMES

PS_HRS_APP_PHONE

PS_NAMES

PS_ORG_LOCATION

PS_PERSON

PS_PERSONAL_PHONE

PS_PERS_DATA_EFFDT

PS_PERS_NID

Attachments

Attachments