Change employee number while promotion
I have a senario like,
When the HR Mgr transfers an employee from one level -(say workers) to another senior level-(say staff),they want that the employee number range should be of the staff level.
For ex- ram(500001234) is a worker -L8
PROMOTED TO STAFF
ram( (800001234) is now a staff)
Has anyone worked on a similar senario,if yes i wud need your help
Thanks in advance