Banner - How to Resolve Duplicate IDs

• SRARECR
  • When copying to retained ID
    • Click the left/right arrows in the Application Questions and Answers block to see all of the questions and answers.
    • Move the data for all terms.
       
  • When deleting from DNU ID
    • If the communication plan screen opens, remove lines individually then click Return to exit the communication plan screen.
       
• SOAHSCH -- May also be present if student has admissions records
  • When deleting from DNU ID
    • If just the graduation date differs, it's okay to leave the retained ID as is.
       
• SOATEST -- May also be present if student has admissions records
  SOAPCOL -- May also be present if student has admissions records
  • When deleting from DNU ID
    The following deletion order should be followed:
    • Delete Major, Minor, and Concentration
    • Delete the Degree Details section
    • Delete the Prior College block data
    • The "Curricula Summary” and “Field Summary” blocks cannot be directly updated but will auto populate.

If data transfer is needed, SAAADMS must be deleted last. Deleting the SAAADMS record will permanently remove the associated data from these pages before you have the opportunity to transfer it to the retained record.

• SAAQUAN
  When copying to retained ID
  • Click the left/right arrows in the Application Questions and Answers block to see all of the questions and answers.
  • Move the data for all terms.
     
• SOASUPL
• SAADCRV
• SOAHOLD
  When copying to retained ID
  • If DNU ID is on the parking hold email list, email parking@hawaii.edu to notify Manoa so they can update their system, otherwise the holds will keep getting added to the DNU ID and removed from the retained ID.
     
• GOAMEDI
• GOAINTL
• SOAHSCH -- May also be present if student has a recruitment record
  • When deleting from DNU ID
    • If just the graduation date differs, it's okay to leave the retained ID as is.
       
• SOATEST -- May also be present if student has a recruitment records
• SOAPCOL -- May also be present if student has a recruitment records
  • When deleting from DNU ID
    The following deletion order should be followed:
    • Delete Major, Minor, and Concentration
    • Delete the Degree Details section
    • Delete the Prior College block data
    • The "Curricula Summary” and “Field Summary” blocks cannot be directly updated but will auto populate.
       
• SAAADMS -- Delete Last
  When copying to retained ID
  • Include the External Application ID item description as that is the application ID.

• SFAREGS

• SHAINST
• SHATCKN
• SHATERM
• SHACRSE

• SHATRNS

• SGASTDN -- If moving a username, delete only after the username has been moved. Deleting the SGASTDN record if the username is active will trigger the deprovisioning process. Please note the need to move the username when reporting cleaned records.
  • When deleting from DNU ID:
    • If you receive the following *ERROR* Cannot delete student record Attribute records exist:
      • Go to SGASADD.
      • Enter the ID and Term related to the SGASTDN record to be deleted.
      • Click into the Student Attribute - Attribute Code.
        If you can’t click into it, restart the process using the term noted in the From Term box.
        
      • Click Delete.
      • Click OK to clear the warning alert that changing student attribute values may impact Registration Fee Assessment.
      • Save.
    • If you receive the following *ERROR* Cannot delete student record academic history records exist:
      • Double check that all academic history pages were cleared out, especially SHAINST.
      • Double check that SGASADD is also clear (see above).
         
• SGAADVR
  If advisors have been assigned to the DNU ID, a message will display when attempting to delete the SGASTDN record.

• SIAINST
• SSASECT

• SPAIDEN
  • When copying to retained ID
    • Campus must determine which name to use following their policies if record names differ. Any names on the DNU ID will be cleared out, so the different name(s) should be documented in some form.
      • If the campus has name change documentation (as required by the campus), update the name in SPAIDEN on the Kept ID.
      • If the campus does not yet have name change documentation either: 
        • Add the name from the DNU to Alternative Identification as Name Type: P (Previous/Other); or
        • Add a SPACMNT entry, Comment Type: 100 (General Comment) to document the different name.
           
  • When deleting from DNU ID
  • Rename record using the following format:
    Last Name: DO NOT USE
    First Name: SEE 22222222 (where 22222222 is the correct ID)
    Middle name: RTD
    Note: The record name should be changed first as it generates another entry in the Alternative Identification tab.
     
  • Delete all entries in each tab, including Alternative Identification.
  • If unable to delete data from the Biographical tab due to a financial aid record, clear each field individually (tab into each field and delete the data) via SPAPERS. 
  • If an UH email is type as OTHR and not CAMP on the duplicate ID and the retained ID has the same UH email as CAMP, it is okay to delete the OTHR email from the duplicate ID.
     
• SOAFOLK

Campus Business Offices will need to be involved in moving data. Payment records should be left on the original ID and not deleted.  

• TSAAREV
  • This is a “manual change”. Moved AR records will say "moved from [old UH ID#]" (as opposed to “Web credit card payment”, etc.) when the student tries to view their Payment History.
• TFADETL

Campus Financial Aid offices will need to be involved in moving data. This should generally be done as one of the last steps as parts of SPAIDEN/SPAPERS need to be cleared first.

• ROASTAT
• RNIAPPL
  • See Banner - How to Remove EDE Records from Duplicate Student IDs (link)
• RPAAWRD

If there is any financial aid data needed to be kept on the DNU ID, create a RHACOMM comment on the kept ID referencing the DNU ID.