Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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 :

...

.

Even though there are a quite a few Search/Match rules setup several search/match rules in the system there are only a few Records that are part of the rule, all the records used in records can be used by 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

Cornell Uses Search/Match in both, Online Transaction Processing and Batch Processingonline transaction processing and batch processing. In both cases the possible matches are reported back to the user in a predefined Result result table format and the .  The user then makes a decision as to whether a new ID needs to be generated. It is very critical for the Underlying tables producing the Search/Match results to be populated with up to the second information, if HR is migrated to Workday then there needs to be a real time Synchronization between PeopleSoft and Workday to avoid disruption in PeopleSoft Search/Match Functionality.is only as reliable as the underlying data used in its processes.  If there is a delay in the data synchronization rules between applications the risk of duplicates increases.  A process should be defined and maintained for cleaning up duplicates.

Attachments

Attachments