Difference between revisions of "CLEARANCE & LASTPAY"

Revision as of 17:22, 16 June 2016

Change User's Info in Clearance

/*Updating Names of users*/ SELECT * FROM myclearance.tbluseraccount WHERE USR_SYSID LIKE '%jtbautista%'

UPDATE myclearance.tbluseraccount SET USR_FNAME = 'Jennifer Guen',USR_LNAME = 'Bautista',USR_MNAME = 'T.' WHERE USR_SYSID LIKE '%jtbautista%'

15035 /* misc RESET RECORD FOR CLEARANCE*/ SELECT * FROM myclearance.tblemp WHERE EMPNUMB = '08006534'

SELECT * FROM myclearance.tblclrlog WHERE log_enumb = '08006534'

UPDATE myclearance.tblemp SET EMP_CLRNO = (NULL),EMP_CLRCDTE = '0000-00-00 00:00:00' WHERE EMPNUMB = '08006534' DELETE FROM myclearance.tblclrlog WHERE log_enumb = '08006534'

Clearing Employee have a wrong separation date.txt

Problem:Clearing Employee has a wrong separation date

Reason: Possible that the employee have been resigned and return to as SPGC employee employee have been transferred to rnf to vip

Solution: 1. go to 202.2.2.52 database 2. Open mypmsdb.pmhempl or mypmsdv.pmhempl 3. find the employee and update its employee number adding X on last part of empnumb example: 12345678 > 12345678x ...see query below 4. Wait two hours for the server will automatically update use this query: select * from mypmsdb.pmhempl where empnumb = '12345678' Update mypmsdb.pmhempl set empnumb = '12345678x' where empnumb = '12345678'

No Records of Hold Employee

Problem: No records of hold employee in clearance Solution: Check first in database open sqlyog 202.2.2.89 username:root password: myadmin_imail check myclearance.tblemp if theres a record mypmsdb.pmhempl mypmsdv.pmhempl

Retrieve Separated Employee 89

SELECT * FROM mypmsdv.pmtsepa

WHERE sepnumb = '15002196'

SELECT * FROM mypmsdv.pmtsepa_comp_checks WHERE sepnumb = '15002196' SELECT * FROM mypmsdv.pmtempl WHERE empnumb = '15002196' INSERT INTO `mypmsdv`.`pmtempl`(`EMPNUMB`,

            `EMPLNAM`,
            `EMPFNAM`,
            `EMPMNAM`,
            `EMPSXCD`,
            `EMPBDTE`,
            `EMPPOBT`,
            `EMPRGCD`,
            `EMPCSCD`,
            `EMPCADD`,
            `EMPTOWN`,
            `EMPCITY`,
            `EMPCZCD`,
            `EMPTXCD`,
            `EMPLDTE`,
            `EMPSSNO`,
            `EMPTINO`,
            `EMPHDTE`,
            `EMPODTE`,
            `EMPPMCD`,
            `EMPPCCD`,
            `EMPCOCD`,
            `EMPLCCD`,
            `EMPSTAT`,
            `EMPSTDT`,
            `EMPPINO`,
            `EMPAVOL`,
            `EMPPVOL`,
            `EMPTDPD`,
            `EMPCBAT`,
            `EMPDPCD`,
            `EMPESCD`,
            `EMPDPCC`,
            `EMPINCO`,
            `EMPALLO`,
            `EMPFEPF`,
            `EMPHLDT`,
            `EMPMENO`,
            `EMPDBNK`,
            `EMPEOCD`,
            `EMPEOCC`,
            `EMPADDR1`,
            `EMPADDR2`,
            `EMPADDR3`,
            `EMPADDR4`,
            `EMPATMP`,
            `EMPTELN`,
            `EMPBKCD`,
            `EMPUNITHEAD`,
            `EMPUNIT`)
            
            
            
SELECT EMPNUMB,EMPLNAM,EMPFNAM,EMPMNAM,EMPSXCD,EMPBDTE,EMPPOBT,EMPRGCD,EMPCSCD,EMPCADD,EMPTOWN,EMPCITY,EMPCZCD,EMPTXCD,EMPLDTE,EMPSSNO,EMPTINO,EMPHDTE,EMPODTE,EMPPMCD,EMPPCCD,EMPCOCD,EMPLCCD,EMPSTAT,EMPSTDT,EMPPINO,EMPAVOL,
EMPPVOL,EMPTDPD,EMPCBAT,EMPDPCD,EMPESCD,EMPDPCC,EMPINCO,EMPALLO,EMPFEPF,EMPHLDT,EMPMENO,EMPDBNK,EMPEOCD,EMPEOCC,EMPADDR1,EMPADDR2,EMPADDR3,EMPADDR4,
EMPATMP,EMPTELN,EMPBKCD,EMPUNITHEAD,EMPUNIT FROM mypmsdv.pmhrfempl
WHERE empnumb = '15002196'

Revert Last Pay 52

SELECT * FROM mypmsdb.pmtsepa WHERE SEPNUMB = '10003725'; UPDATE mypmsdb.pmtsepa SET SEPMARK = ' ' WHERE SEPNUMB = '10003725';

//UPDATE mypmsdb.`pmtsepa` SET SEPDATE = '2015-07-04 00:00:00' WHERE sepnumb = '14003192';

DELETE FROM mypmsdb.pmtsepa_comp WHERE SEPNUMB = '10003725'; DELETE FROM mypmsdb.pmtsepa_comp_checks WHERE SEPNUMB = '10003725';

Update Separation Date in Clearance 89

/*updating the sepdate of clearance*/ UPDATE myclearance.`tblemp` SET EMPSDTE = '2012-03-19' WHERE empnumb = '10003131'

UPDATE USER NAME IN Iclearance 89

/* name of employee not found in iclearance */

SELECT * FROM myclearance.`tbluseraccount` WHERE USR_SYSID IN( 'cmcaday', 'rice_prod_sup', 'rrrequejo')

UPDATE myclearance.`tbluseraccount` SET USR_FNAME = 'CESAR', USR_LNAME = 'CADAY', USR_MNAME = 'M.' WHERE USR_SYSID = 'cmcaday'

UPDATE myclearance.`tbluseraccount` SET USR_FNAME = 'ENRIQUE', USR_LNAME = 'COLLO', USR_MNAME = WHERE USR_SYSID = 'rice_prod_sup'

UPDATE myclearance.`tbluseraccount` SET USR_FNAME = 'REY', USR_LNAME = 'REQUEJO', USR_MNAME = 'R.', USR_EMAIL = 'rrrequejo@local.com' WHERE USR_SYSID = 'rrrequejo'