Difference between revisions of "Change User Name"

From Galen Healthcare Solutions - Allscripts TouchWorks EHR Wiki
Jump to navigation Jump to search
(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...)
 
Line 1: Line 1:
 
 
Usually this has to do with a user getting married and wanting to change their username
 
Usually this has to do with a user getting married and wanting to change their username
  
 
Procedure:
 
Procedure:
In SA change the users Name to what you will want it to be
+
# 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
+
# In SA change the Mnemonic to what you want it to be
Log into TWAdmin and delete user
+
# Log into TWAdmin and delete user
Create a new user making sure that they are setup as USER and NOT USER/PROVIDER
+
# 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  
+
# Notify Technical Support of the the username that you deleted AND the username that you created  
  
Then the technical support rep will need to perform the following:
+
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'
  
Pull Old ID with the following:
+
Then Run the following to update the links:
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 IsinactiveFlag = 'Y' where ID = NewID
 
Update IDX_User set ausername = 'zzztgodwin' where ID = NewID
 
Update IDX_User set ausername = 'zzztgodwin' where ID = NewID
Line 27: Line 23:
 
zzztogowin is the rename of the 'old' userid
 
zzztogowin is the rename of the 'old' userid
 
togodwin is the new username.
 
togodwin is the new username.
 +
 +
(NOTE the user will have to re-select their site when logging in)
  
 
Testing:
 
Testing:
Verify that the user now shows in TWAdmin as User/Provider
+
# 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.
+
# Verify that you can log in the user and see the schedule, tasks search patients.

Revision as of 13:27, 18 July 2008

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

Procedure:

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

The technical support rep will need to perform the following:

  1. Pull Old ID with the following: Select * from IDX_User where ausername Like '%OldUserName'
  2. Pull New ID with the following: Select * from IDX_User where ausername Like 'NewUserName'

Then Run the following to update the links:

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.

(NOTE the user will have to re-select their site when logging in)

Testing:

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