Follow us: Connect on YouTube Connect on YouTube Connect on YouTube

Pages

Sunday, 5 February 2017

Query to find Employee Tax Info State Tax rules

select ppf.employee_number "employee number",
  hrl.lookup_type,
  --pus.state_name "state",
  hrl.meaning "w4 info :filing status",
  str.withholding_allowances "w4 info :allowances",
  str.secondary_wa "w4 info: secon allowances",
  str.additional_wa_amount "w4 info:exemption aaount",
  str.sit_additional_tax "w4 info:addn tax",
  str.sit_optional_calc_ind "w4 info :opt calc",
  str.sit_exempt "tax ex: sit",
  str.sdi_exempt "tax ex: sdi",
  str.sui_exempt "tax ex: sui",
  str.wc_exempt "tax ex: wc",
  str.sit_override_rate "sit override:regular rate",
  str.sit_override_amount "sit override:regular amount",
  str.supp_tax_override_rate "sit override: supp rate",
  str.sui_wage_base_override_amount "sui base override",
  str.excessive_wa_reject_date "lock in date",
  str.state_non_resident_cert "non resi certi",
  str.wage_exempt "sit exm fm wg accm",
  str.effective_start_date "effective date : from",
  decode (str.effective_end_date, to_date ('31124712', 'ddmmyyyy'), null, str.effective_end_date ) "effective date: to",
  str.assignment_id,
  str.business_group_id
from pay_us_emp_state_tax_rul str,
  pay_us_states pus,
  pay_state_rules psr,
  hr_lookups hrl,
  per_all_assignments_f paaf,
  per_all_people_f ppf
where 1 =1
  and str.state_code=pus.state_code
  and psr.state_code   = pus.state_abbrev
and hrl.lookup_type = psr.fs_lookup_type
and sysdate between paaf.effective_start_date and paaf.effective_end_date
and nvl (str.effective_end_date, sysdate)  > sysdate - 1
and hrl.lookup_code                        = ltrim (str.filing_status_code, '0')
and str.assignment_id                      = paaf.assignment_id
and nvl (paaf.effective_end_date, sysdate) > sysdate - 1
and paaf.person_id                         = ppf.person_id
--and ppf.employee_number                    = '30987'
--and paaf.assignment_number   = '471-96-6472'
group by ppf.employee_number,
  hrl.lookup_type,
  pus.state_name,pus.state_code,
  hrl.meaning,psr.state_code , pus.state_abbrev,
  str.withholding_allowances,
  str.secondary_wa,
  str.additional_wa_amount,
  str.sit_additional_tax,
  str.sit_optional_calc_ind,
  str.sit_exempt,
  str.sdi_exempt,
  str.sui_exempt,
  str.wc_exempt,
  str.sit_override_rate,
  str.sit_override_amount,
  str.supp_tax_override_rate,
  str.sui_wage_base_override_amount,
  str.excessive_wa_reject_date,
  str.state_non_resident_cert,
  str.wage_exempt,
  str.effective_start_date,
  decode (str.effective_end_date, to_date ('31124712', 'ddmmyyyy'), null, str.effective_end_date ),
  str.assignment_id,

  str.business_group_id;
Share this article :

17 comments:

  1. It is extremely nice to see the greatest details presented in an easy and understanding manner. meezan bank car financing calculator - bank alfalah car loan

    ReplyDelete
  2. This is my first time i visit here. I found so many interesting stuff in your blog especially its discussion. From the tons of comments on your articles, I guess I am not the only one having all the enjoyment here keep up the good work global tax information

    ReplyDelete
  3. The exception is applied on the principal $100K taxable salary and requires the organization to meet the accompanying conditionshow to reduce tax singapore

    ReplyDelete
  4. Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check https://www.oracleappstechnical.com for Never Before Offers and Discount Coupon Codes.

    ReplyDelete
  5. The initial step requires the Fiduciary to record IRS Form 4506, Request for Copy or Transcript of Tax Form, with the IRS.Verfahrensdokumentation Muster

    ReplyDelete
  6. This was really an interesting topic and I kinda agree with what you have mentioned here! Tax

    ReplyDelete
  7. I’ve been searching for some decent stuff on the subject and haven't had any luck up until this point, You just got a new biggest fan!.. Restaurant Payroll Tax Problems

    ReplyDelete
  8. This is my first time visit here. From the tons of comments on your articles,I guess I am not only one having all the enjoyment right here! ettevõtte kustutamine

    ReplyDelete
  9. Calif estimated tax payments Wow, cool post. I'd like to write like this too - taking time and real hard work to make a great article... but I put things off too much and never seem to get started. Thanks though.

    ReplyDelete
  10. This is because they do not realize that they can opt for the cheap and not the expensive one. cheap car insurance az

    ReplyDelete
  11. I like your post. It is good to see you verbalize from the heart and clarity on this important subject can be easily observed... tax service providers

    ReplyDelete
  12. It was wondering if I could use this write-up on my other website, I will link it back to your website though.Great Thanks. orland park real estate agents

    ReplyDelete
  13. Interesting post. I Have Been wondering about this issue, so thanks for posting. Pretty cool post.It 's really very nice and Useful post.Thanks wimbledon tax accountants

    ReplyDelete
  14. Filing return happened to be a cumbersome task earlier. But , with passage of time, government has simplified the procedure up to a great extent by introducing the process of filing online income tax return. visit this link



    ReplyDelete
  15. Each of these activities in its own right involves some form of tax advice and each professional can be regarded as a "tax professional", each of which, play a very important part in ensuring that our tax administration and systems work.IR35 Limited Company registration

    ReplyDelete
  16. Withholding and reciprocity laws vary per state. See Calculation Guide for the United States Vertex Payroll Tax Q Series for more details on each state's standard operating procedure. The resident wage accumulation rules that are accessible to you are determined by these tax withholding regulations. The default tax withholding information for the payroll process is provided by the federal and state withholding forms.

    tax accounting

    ReplyDelete