Back to Home

SAM3 Termed (Terminated)

Overview

Business will send over a list of users that are no longer active. Requests will come over as SAM3 Termed with an attached excel file.

The following script will set the User to inactive and clean up tables that no longer need the user assignment.

Script 1: SAM3 Termed

SELECT UserNo INTO #TerminatedUser
FROM smart.sam_Master_UserList
WHERE EmployeeID in (
    -- Add list of users here

) AND Status = 1

UPDATE smart.sam_Master_UserLiSt SET Status = 0
WHERE UserNo IN (SELECT UserNo FROM #TerminatedUser)
    -- Remove the user from the team
    DELETE FROM smart.sam_Team_Member
    WHERE UserNo IN (SELECT UserNo FROM #TerminatedUser)
    -- Remove the user from the group
    DELETE FROM smart.sam_Group_Member
    WHERE UserNo IN (SELECT UserNo FROM #TerminatedUser)
    -- Remove the assigned menu
    DELETE FROM smart.sam_User_Menu
    WHERE UserNo IN (SELECT UserNo FROM #TerminatedUser)