ETK

From SPGC Document Wiki
Revision as of 15:47, 14 June 2016 by Admin (Talk | contribs)

Jump to: navigation, search

Reset ETK password

  1. Open SQL Yog connect to 52 server
  2. Get the employee number
  3. Run this query
  4. UPDATE myleave.myuser SET password=md5("init1234") WHERE myusername="123456"

Transfer Employee from RNF to VIP

  1. Open SQL Yog connect to 52 server
  2. Get the employee number
  3. Run this query
  4. UPDATE myleave.olvemp SET emppccd=2 WHERE empnumb="123456"
  1. UPDATE myleave.myuser SET emppccd=2,myuseraccess="VIP" WHERE empnumb="123456"

PAYROLL

Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=ETK&oldid=239"