Change User Name

From Galen Healthcare Solutions - Allscripts TouchWorks EHR Wiki
Revision as of 13:22, 18 July 2008 by Michael.Ficociello (talk | contribs) (New page: Usually this has to do with a user getting married and wanting to change their username Procedure: In SA change the users Name to what you will want it to be In SA change the Mnemonic to...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Usually this has to do with a user getting married and wanting to change their username

Procedure: In SA change the users Name to what you will want it to be In SA change the Mnemonic to what you want it to be Log into TWAdmin and delete user Create a new user making sure that they are setup as USER and NOT USER/PROVIDER Notify Technical Support of the the username that you deleted ANS the username that you created

Then the technical support rep will need to perform the following:

Pull Old ID with the following: select * from IDX_User where ausername Like '%OldUserName'

Pull New ID with the following: select * from IDX_User where ausername Like 'NewUserName'

Then Run the following to update the links (NOTE the user will have to re-select their site when logging in) Update IDX_User set IsinactiveFlag = 'Y' where ID = NewID Update IDX_User set ausername = 'zzztgodwin' where ID = NewID Update Person set IsInactiveFlag = 'Y' where ID = NewID Update IDX_User set Ausername = 'tgodwin' where ID = OldID Update IDX_User set IsinactiveFLAG = 'N' where ID = OldID

NOTE: NewID and OldID are numeric "ID" fields that link Person and IDX_User, not the Old/New UserID. zzztogowin is the rename of the 'old' userid togodwin is the new username.

Testing: Verify that the user now shows in TWAdmin as User/Provider Verify that you can log in the user and see the schedule, tasks search patients.