http://in.compucrete.com/index.php?action=history&feed=atom&title=Payroll_Exemption_Queries 2026-05-15T19:30:38Z Revision history for this page on the wiki MediaWiki 1.40.0 http://in.compucrete.com/index.php?title=Payroll_Exemption_Queries&diff=490&oldid=prev 2023-07-14T13:00:34Z

<p>1 revision imported</p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <tr class="diff-title" lang="en"> <td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 13:00, 14 July 2023</td> </tr><tr><td colspan="2" class="diff-notice" lang="en"><div class="mw-diff-empty">(No difference)</div> </td></tr></table>

WikiAdmin http://in.compucrete.com/index.php?title=Payroll_Exemption_Queries&diff=489&oldid=prev 2017-01-10T00:02:08Z

<p>1 revision imported</p> <p><b>New page</b></p><div>==Exemptions vs. Federal Gross==<br /> &lt;PRE&gt;<br /> Select emp_id,em.display_name,run_no,session_no,trans_no,trx_date,def_value GROSS,<br /> (select sum(def_value) from prtempdefhst e1 where e1.session_no=eh.session_no and e1.trans_no=eh.trans_no<br /> and e1.def_id='FEDGRS') FEDGRS,<br /> (select sum(def_value) from prtempdefhst e1 where e1.session_no=eh.session_no and e1.trans_no=eh.trans_no<br /> and e1.def_id in<br /> (select (select def_id from prtcompdef where LINK_ID=(select link_id from prtcompdef cd where cd.def_id=cdx.def_id1) <br /> and def_type='D') from prtcompdefxref cdx where def_id2='FEDGRS') ) FEDdedExm,<br /> def_value- (select sum(def_value) from prtempdefhst e1 where e1.session_no=eh.session_no and e1.trans_no=eh.trans_no<br /> and e1.def_id='FEDGRS') FEDEEXM_Actual<br /> from prtempdefhst eh<br /> inner join prtemployee em on (em.emp_id = eh.emp_id)<br /> where def_id='GROSS' and trx_date&gt;='1/1/6'<br /> and<br /> (select sum(def_value) from prtempdefhst e1 where e1.session_no=eh.session_no and e1.trans_no=eh.trans_no<br /> and e1.def_id in<br /> (select (select def_id from prtcompdef where LINK_ID=(select link_id from prtcompdef cd where cd.def_id=cdx.def_id1) <br /> and def_type='D') from prtcompdefxref cdx where def_id2='FEDGRS') ) is not null<br /> and<br /> (select sum(def_value) from prtempdefhst e1 where e1.session_no=eh.session_no and e1.trans_no=eh.trans_no<br /> and e1.def_id in<br /> (select (select def_id from prtcompdef where LINK_ID=(select link_id from prtcompdef cd where cd.def_id=cdx.def_id1) <br /> and def_type='D') from prtcompdefxref cdx where def_id2='FEDGRS') ) &lt;&gt;<br /> def_value- (select sum(def_value) from prtempdefhst e1 where e1.session_no=eh.session_no and e1.trans_no=eh.trans_no<br /> and e1.def_id='FEDGRS')<br /> order by emp_id,em.display_name<br /> &lt;/PRE&gt;<br /> <br /> ==Exemptions vs SS Gross== <br /> &lt;PRE&gt;Select emp_id,em.display_name,run_no,session_no,trans_no,trx_date,def_value GROSS,<br /> (select sum(def_value) from prtempdefhst e1 where e1.session_no=eh.session_no and e1.trans_no=eh.trans_no<br /> and e1.def_id='SSGROSS') SSGROSS,<br /> (select sum(def_value) from prtempdefhst e1 where e1.session_no=eh.session_no and e1.trans_no=eh.trans_no<br /> and e1.def_id in<br /> (select (select def_id from prtcompdef where LINK_ID=(select link_id from prtcompdef cd where cd.def_id=cdx.def_id1) <br /> and def_type='D') from prtcompdefxref cdx where def_id2='SSGROSS') ) SSdedExm,<br /> def_value- (select sum(def_value) from prtempdefhst e1 where e1.session_no=eh.session_no and e1.trans_no=eh.trans_no<br /> and e1.def_id='SSGROSS') SSEEXM_Actual<br /> from prtempdefhst eh<br /> inner join prtemployee em on (em.emp_id = eh.emp_id)<br /> where def_id='GROSS' and trx_date&gt;='1/1/6'<br /> and<br /> (select sum(def_value) from prtempdefhst e1 where e1.session_no=eh.session_no and e1.trans_no=eh.trans_no<br /> and e1.def_id in<br /> (select (select def_id from prtcompdef where LINK_ID=(select link_id from prtcompdef cd where cd.def_id=cdx.def_id1) <br /> and def_type='D') from prtcompdefxref cdx where def_id2='SSGROSS') ) is not null<br /> and<br /> (select sum(def_value) from prtempdefhst e1 where e1.session_no=eh.session_no and e1.trans_no=eh.trans_no<br /> and e1.def_id in<br /> (select (select def_id from prtcompdef where LINK_ID=(select link_id from prtcompdef cd where cd.def_id=cdx.def_id1) <br /> and def_type='D') from prtcompdefxref cdx where def_id2='SSGROSS') ) &lt;&gt;<br /> def_value- (select sum(def_value) from prtempdefhst e1 where e1.session_no=eh.session_no and e1.trans_no=eh.trans_no<br /> and e1.def_id='SSGROSS')<br /> order by emp_id,em.display_name<br /> &lt;/PRE&gt;<br /> <br /> See [[Exemption Deductions List]]</div>

Intra>User