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.
ReplyDeleteA cruise deliver lacks the ballast of a sail boat. If used similarly to the principle engine(s) the kite will growth gasoline efficiency.Shipping from china
ReplyDeleteWhere the reels are marked to stop in order to to} match paylines are commonly referred to as “Reel Stops”. Lining up certain combinations of symbols in three, 4, 5 or extra reels, relying on the slot machine, provides the player a winline. Always hold this in thoughts, especially when you love playing in} slots with progressive jackpots. Many games provide you with entry to the top wins only whenever you wager the maximum — and that is why an accurate slot strategy and bankroll strategy are important to have an opportunity to successful at slots. All the measures in 슬롯커뮤니티 place are there to help you|that will help you|that can help you} play slot machine games on websites that use audited random number turbines and pay out winnings to their gamers. We a glance at|have a glance at} over 25 sorts if slot machines throughout the most effective PA on-line casino and NJ on-line casino websites and we found out that the payout share has very little to do with the games' reputation.
ReplyDelete