I have a user who's labor code was created as his craft code (30022226) and not his personid (WOFFK002) which is our company standard. He has 319 existing labor transactions with the 30022226 laborcode so it will not allow me to change it to his personid. How do I fix this? Thank you for any help that can be provided.
Senior Maximo Specialist, Reedy Creek Energy Services Email: Chelsea.R.McCabe@Disney.com Cell: (407) 701-4239
Work Schedule: Mon-Fri 7:00-16:00 (effective 1/3/2022)
Maximo Inquiries, please submit a Service Request in Maximo: Click Here
"How-To" Submit a SR Document: How To Create SR in Maximo
Thank you both for your input – I appreciate the ideas. I do have a preferred SQL Management Studio that we use – what SQL query would I use to update the laborcode on the labtrans table?
Still learning SQL...
set laborcode = 'xxxxx'
where laborcode = 'yyyyy'
and orgid = 'zzzz'
Remember, it's a good idea to always have a backup.