| 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 |
|---|