It's that wonderful time of year for payroll administrators, where you need to validate employee information prior to sending out your W-2 wage reports.
The SQL script below can either be ran via SQL or inserted into SmartList Builder as a SQL statement and used to build a SmartList.
It will return Employee and Employee Address Information.
Run the following Script against each company Database:
select UPR00100.EMPLOYID ID, CASE INACTIVE WHEN 0 THEN 'ACTIVE' when 1 THEN 'INACTIVE' END AS STATUS, LASTDAYWORKED_I LASTDAY, EMPLCLAS CLASS, LASTNAME LAST_NAME, FRSTNAME FIRST_NAME, MIDLNAME MIDDLE, UPR00100.ADRSCODE ADDRESS_CODE, SOCSCNUM SOCIAL_SEC_NUM, CASE GENDER WHEN 1 THEN 'MALE' WHEN 2 THEN 'FEMALE' END AS GENDER, DEPRTMNT DEPARTMENT, DIVISIONCODE_I DIVISION, JOBTITLE TITLE, ADDRESS1, ADDRESS2, ADDRESS3, CITY, STATE, ZIPCODE from UPR00100
left outer join UPR00102
on UPR00100.EMPLOYID=UPR00102.EMPLOYID and UPR00100.ADRSCODE=UPR00102.ADRSCODE
order by LASTNAME
I appreciate the time and effort us put into this post. This article gives you a clear idea about Audit. It is, without a doubt, an informative article that will help us expand our knowledge. Thank you for bringing such interesting posts to our attention.
ReplyDeleteFedex Audit
I'm blown away by the little print you've provided information about Outsourced Accounting Firms India . It is an enlightening article for both myself and others. Thank you for bringing such interesting topics to our attention.
ReplyDelete