{"id":6397,"date":"2016-09-06T18:59:20","date_gmt":"2016-09-06T18:59:20","guid":{"rendered":"http:\/\/learning2.pcrecruiter.net\/?p=6397"},"modified":"2024-01-17T22:06:41","modified_gmt":"2024-01-17T22:06:41","password":"","slug":"merge-duplicate-records","status":"publish","type":"docs","link":"https:\/\/learning.pcrecruiter.net\/site\/docs\/managing-records\/merge-duplicate-records\/","title":{"rendered":"Merge Duplicate Records"},"content":{"rendered":"\n<p>Merging duplicate company or name records can be performed in three areas: Reports, Search Results and Rollups. It can also be done via the <a href=\"https:\/\/learning.pcrecruiter.net\/site\/docs\/pcr-capture\/capture-use\/\" data-type=\"docs\" data-id=\"10946\">PCR Capture<\/a> extension.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Non-admin users must have the&nbsp;<a href=\"https:\/\/learning.pcrecruiter.net\/site\/docs\/user-settings\/user-security\/#other\">Allow Record Merging security permission<\/a>&nbsp;enabled on their User Record in order to perform this operation.<\/li>\n\n\n\n<li>When merging, you will select the Master record and one or more records to be merged into the Master record. Activity logs, attachments, and other items will be combined into the single record.<\/li>\n\n\n\n<li>Merging completes any empty fields from the Master with data from the other records. Where the field exists in both records, the Master data will be retained.<\/li>\n\n\n\n<li>An Activity with the type MERGEDUPE will be recorded and a &#8220;Record merged&#8221; text file containing a log of merge details will be saved in the Attachments for the completed record.<\/li>\n<\/ul>\n\n\n\n<p class=\"important\">Please note that there is no Undo when merging records. Please verify your merge before executing.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Auditing Reports<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Click <strong>Reports<\/strong> from the Main Menu<\/li>\n\n\n\n<li>Click <strong>Auditing Reports<\/strong><\/li>\n\n\n\n<li>Select the icon for <strong>Duplicate Companies Report<\/strong> or <strong>Duplicate Names Report<\/strong><\/li>\n\n\n\n<li>Select <strong>criteria <\/strong>to locate possible duplicate records. Please note that in selected criteria with more than one item, all of the selected criteria must match. This is especially important if one of the fields selected is empty this could cause inaccurate or missed duplicates within the system<\/li>\n\n\n\n<li>To generate a list of possible duplicate companies, you can search records based on:\n<ul class=\"wp-block-list\">\n<li>Company Name, Phone Number<\/li>\n\n\n\n<li>Company Name, City<\/li>\n\n\n\n<li>Company Name, City, Phone Number<\/li>\n\n\n\n<li>Company Name, Zip<\/li>\n\n\n\n<li>Company Name<\/li>\n\n\n\n<li>Phone Number<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>To generate a list of possible duplicate names, you can search records based on:\n<ul class=\"wp-block-list\">\n<li>First Name, Last Name, Cell Phone<\/li>\n\n\n\n<li>First Name, Last Name, Home phone<\/li>\n\n\n\n<li>First Name, Last Name, Work Phone<\/li>\n\n\n\n<li>First Name, Last Name, City<\/li>\n\n\n\n<li>First Name, Last Name, Company Name<\/li>\n\n\n\n<li>First Name, Last Name, Email Address<\/li>\n\n\n\n<li>First Name, Last Lame<\/li>\n\n\n\n<li>Last Name, Email Address<\/li>\n\n\n\n<li>Last Name, Cell Phone<\/li>\n\n\n\n<li>Email Address<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Select a <strong>Rollup List<\/strong> if you would like to run this report for a specific list of records; if no Rollup list is selected it will duplicate check your entire database.<\/li>\n\n\n\n<li>Click the <strong>Search <\/strong>action icon at the top right to run the report, which will be displayed in a new tab. The count reflects the number of records with the same data as the selected duplicate checking criteria.<\/li>\n\n\n\n<li>Click <strong>Merge<\/strong> to view the records that are possible duplicates \u2013 Here you can click the record if you wish to view the details prior to merging.<\/li>\n\n\n\n<li>Review the records, if the records should be merged; click the<strong> Master<\/strong> check box for the record that you want to be the final record. The record you select as master should contain the most accurate\/recent data.<\/li>\n\n\n\n<li>Click the <strong>Merge<\/strong> checkbox for each record that should be merged to the master record.<\/li>\n\n\n\n<li>Click the <strong>Merge <\/strong>button. A message will display to alert you that the other records will be deleted, resumes cannot be combined, and to verify that you have selected the proper merge criteria.<\/li>\n\n\n\n<li>Click <b style=\"font-size: revert; background-color: var(--global--color-background); color: var(--global--color-primary); font-family: var(--global--font-secondary);\">OK to continue the merge process. A message will alert you when the merge process is finished.<\/b><\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">Merge from Search<\/h2>\n\n\n\n<p>PCR also provides the ability to merge duplicate records from the search results screen. For example, if you perform a quick search for a person and two or more Name records are returned who are the same person:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>From a Search Result screen, click the <strong>checkbox<\/strong> to the left of each record you want to merge.<\/li>\n\n\n\n<li>Click the <strong>Merge<\/strong> icon from the action dropdown menu.<\/li>\n\n\n\n<li>Review the records, if the records should be merged; click the <strong>Master<\/strong> check box for the record that will become the final record. The record you select as master should contain the most accurate data or most recent data in the fields.<\/li>\n\n\n\n<li>Click the <strong>Merge<\/strong> checkbox for each record that should be merged to the master record.<\/li>\n\n\n\n<li>Click the <strong>Merge <\/strong>button. A message will display to alert you that the other records will be deleted, resumes cannot be combined, and to verify that you have selected the proper merge criteria.<\/li>\n\n\n\n<li>Click <strong>OK<\/strong> to continue the merge process.<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">Merge from Rollup Lists<\/h2>\n\n\n\n<p>Finally the last merge functionality allows users to merge Company and Name records from within a rollup list. This is incredibly useful when nicknames may have been used that would not be returned in a basic search, for instance; Bill\/William, Liz\/Elizabeth, etc.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Select <strong>Rollup <\/strong>from the Main Toolbar<\/li>\n\n\n\n<li>Click on the <strong>number<\/strong> under the record type of any rollup list to access the records.<\/li>\n\n\n\n<li>Select the <strong>checkbox<\/strong> for two names that are alike and in need of being merged<\/li>\n\n\n\n<li>Click the <strong>Merge<\/strong> action icon from the dropdown on the right<\/li>\n\n\n\n<li>Review the records, if the records should be merged; click the <strong>Master<\/strong> check box for the record that will become the final record. The record you select as master should contain the most accurate data or most recent data in the fields.<\/li>\n\n\n\n<li>Click the <strong>Merge <\/strong>button. A message will display to alert you that the other records will be deleted, resumes cannot be combined, and to verify that you have selected the proper merge criteria <\/li>\n\n\n\n<li> Click <strong>OK<\/strong> to continue the merge process.<\/li>\n<\/ol>\n\n\n\n<p>Once your records have been merged, an Attachment will be created under the new record highlighting any information that did not merge.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Merging Placed Name Records<\/h2>\n\n\n\n<p>When merging a Name Record that has been <a href=\"https:\/\/learning.pcrecruiter.net\/site\/docs\/placements\/add-a-permanent-placement\/\" data-type=\"docs\" data-id=\"5788\">placed<\/a> with a Name record that does not have a placement, an additional option will appear: \u201cRetain Company Association and Status value from non-master record\u201d<\/p>\n\n\n\n<p>This is useful for scenarios where the master record has updated information, but the other record has been placed. Checking the box keeps the person associated with the same Company for their current placement\/assignment.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Merging duplicate company or name records can be performed in three areas: Reports, Search Results and Rollups. It can also be done via the PCR Capture extension. Please note that there is no Undo when merging records. Please verify your merge before executing. Auditing Reports Merge from Search PCR also provides the ability to merge&hellip; <a class=\"more-link\" href=\"https:\/\/learning.pcrecruiter.net\/site\/docs\/managing-records\/merge-duplicate-records\/\">Continue reading <span class=\"screen-reader-text\">Merge Duplicate Records<\/span><\/a><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"pcr-menu-id":[],"footnotes":""},"doc_category":[30],"doc_tag":[],"knowledge_base":[25],"class_list":["post-6397","docs","type-docs","status-publish","hentry","doc_category-managing-records","knowledge_base-nine","entry"],"year_month":"2026-05","word_count":958,"total_views":"1749","reactions":{"happy":"0","normal":"0","sad":"0"},"author_info":{"name":"PCRecruiter","author_nicename":"arothman","author_url":"https:\/\/learning.pcrecruiter.net\/site\/author\/arothman\/"},"doc_category_info":[{"term_name":"Managing Records","term_url":"https:\/\/learning.pcrecruiter.net\/site\/docs\/nine\/managing-records\/"}],"doc_tag_info":[],"knowledge_base_info":[{"term_name":"PCRecruiter 9","term_url":"https:\/\/learning.pcrecruiter.net\/site\/docs\/nine\/","term_slug":"nine"}],"knowledge_base_slug":["nine"],"_links":{"self":[{"href":"https:\/\/learning.pcrecruiter.net\/site\/wp-json\/wp\/v2\/docs\/6397","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/learning.pcrecruiter.net\/site\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/learning.pcrecruiter.net\/site\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/learning.pcrecruiter.net\/site\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/learning.pcrecruiter.net\/site\/wp-json\/wp\/v2\/comments?post=6397"}],"version-history":[{"count":11,"href":"https:\/\/learning.pcrecruiter.net\/site\/wp-json\/wp\/v2\/docs\/6397\/revisions"}],"predecessor-version":[{"id":12286,"href":"https:\/\/learning.pcrecruiter.net\/site\/wp-json\/wp\/v2\/docs\/6397\/revisions\/12286"}],"wp:attachment":[{"href":"https:\/\/learning.pcrecruiter.net\/site\/wp-json\/wp\/v2\/media?parent=6397"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/learning.pcrecruiter.net\/site\/wp-json\/wp\/v2\/doc_category?post=6397"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/learning.pcrecruiter.net\/site\/wp-json\/wp\/v2\/doc_tag?post=6397"},{"taxonomy":"knowledge_base","embeddable":true,"href":"https:\/\/learning.pcrecruiter.net\/site\/wp-json\/wp\/v2\/knowledge_base?post=6397"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}