how to change the unique employee id....

[saiorkrish]

the employee id is saved in database as <<1,2,3,4>> and so on..........

 

i would like to have the employee id to be saved in the database like prefixing with le as <<le1,le2,le3 >> how can i achieve it anyone please help me.....

[PascalVG]

Hi saior,

The ID is an integer number in the database so cannot contain any letters. You cannot just change it to varchar or so, as PS assumes all ID's to be Int(10)-s. You would have to make exceptions for this class everywhere it is used all over PS...

 

What exactly do you try to achieve? Maybe there is another way to do this. Please elaborate what/where/when/how you need it exactly.

 

my2 cents,

pascal

[MarcPierre]

Changing ID will affect your internal admin and accounting system. Try to allocate some unique type of codes so that in future you can get the desired information easily.Employee identification badges

Edited December 23, 2013 by MarcPierre (see edit history)