PeopleSoft provided on-line and batch process to search for existence of

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

Even 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

Cornell Uses Search/Match in both, Online Transaction Processing and Batch Processing. In both cases the possible matches are reported back to the user in a predefined Result table format and 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.