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

Pages

Wednesday, 11 May 2016

Employee tax info and fedral tax rules

select ppf.employee_number "employee number",
  (select state_name from pay_us_states where state_abbrev = add_information17
  ) "resident",
  (select hlat.region_2
  from hr_locations_all hlat
  where hlat.location_id = paaf.location_id
  ) "work",
  pus.state_name "sui state",
  paa.add_information18 "resident city",
  pus.state_name "work city",
  paa.add_information19 "resident county",
  (select hlat.region_1
  from hr_locations_all hlat
  where hlat.location_id = paaf.location_id
  ) "work county",
  hrl1.meaning "filing status",
  ftr.withholding_allowances "allowances",
  ftr.fit_additional_tax "additional tax",
  ftr.fit_exempt "tax exemption :fit",
  ftr.futa_tax_exempt "tax exemption :futa",
  ftr.medicare_tax_exempt "tax exemption :medicare",
  ftr.ss_tax_exempt "tax exemption :ss",
  ftr.fit_override_amount "fo:regular amount",
  ftr.fit_override_rate "fo:regular rate",
  ftr.supp_tax_override_rate "fo:supplemental rate",
  ftr.excessive_wa_reject_date "lock in date",
  ftr.statutory_employee "statutory employee",
  ftr.cumulative_taxation "cumulative taxation",
  ftr.wage_exempt "fit exempt wage acc",
  hrl2.meaning "eic filling status",
  ftr.effective_start_date "effec dates: from",
  decode (ftr.effective_end_date, to_date ('31124712', 'ddmmyyyy'), null, ftr.effective_end_date ) "effec dates: to",
  ftr.emp_fed_tax_rule_id,
  paaf.assignment_id,
  paaf.location_id
from pay_us_emp_fed_tax_rul ftr,
  per_all_assignments_f paaf,
  pay_us_states pus,
  per_addresses paa,
  hr_lookups hrl1,
  hr_lookups hrl2,
  per_all_people_f ppf
where 1=1
and ftr.sui_state_code         = pus.state_code
and ftr.assignment_id          = paaf.assignment_id
and paa.person_id              = paaf.person_id
and ftr.filing_status_code     = hrl1.lookup_code
and hrl1.lookup_type           = 'us_fit_filing_status'
and ftr.eic_filing_status_code = hrl2.lookup_code
and hrl2.lookup_type           = 'us_eic_filing_status'
  --     and nvl (paaf.effective_end_date, sysdate) > sysdate - 1
and ftr.assignment_id   = paaf.assignment_id
and paaf.person_id      = ppf.person_id
---and ppf.employee_number = '30987'
--and paaf.assignment_number   = '471-96-6472'
group by ppf.employee_number,
  pus.state_name,
  paa.add_information18,
  pus.state_name,
  add_information17,
  paa.add_information19,
  hrl1.meaning,
  ftr.withholding_allowances,
  ftr.fit_additional_tax,
  ftr.fit_exempt,
  ftr.futa_tax_exempt,
  ftr.medicare_tax_exempt,
  ftr.ss_tax_exempt,
  ftr.fit_override_amount,
  ftr.fit_override_rate,
  ftr.supp_tax_override_rate,
  ftr.excessive_wa_reject_date,
  ftr.statutory_employee,
  ftr.cumulative_taxation,
  ftr.wage_exempt,
  hrl2.meaning,
  ftr.effective_start_date,
  decode (ftr.effective_end_date, to_date ('31124712', 'ddmmyyyy'), null, ftr.effective_end_date ),
  ftr.emp_fed_tax_rule_id,
  paaf.assignment_id,
  paaf.location_id
order by 1,

  2;   
Share this article :

10 comments:

  1. I'm certainly very happy to read this blog site posts which carries plenty of helpful data, thanks for providing such information. Visit this website

    ReplyDelete
    Replies
    1. IEEE Final Year Project centers make amazing deep learning final year projects ideas for final year students Final Year Projects for CSE to training and develop their deep learning experience and talents.

      IEEE Final Year projects Project Centers in India are consistently sought after. Final Year Students Projects take a shot at them to improve their aptitudes, while specialists like the enjoyment in interfering with innovation.

      corporate training in chennai corporate training in chennai

      corporate training companies in india corporate training companies in india

      corporate training companies in chennai corporate training companies in chennai

      I have read your blog its very attractive and impressive. I like it your blog. Digital Marketing Company in Chennai Project Centers in Chennai

      Delete
  2. Medicare's commencement in 1965. Nancy considered dropping Part B since it has a monthbuy modvigil in usa

    ReplyDelete
  3. 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
  4. I really appreciate the kind of topics you post here. Thanks for sharing us a great information that is actually helpful. Good day! current interest rate in pakistan | ubl saving account

    ReplyDelete
  5. It's superior, however , check out material at the street address. webpage

    ReplyDelete
  6. Failing to do so can add to the taxable amount you need to pay, thereby putting a dent on your pockets, as well as degrade your image in the banking sector, which may lead to rejection of loans, etc. Filing Income Tax Returns

    ReplyDelete
  7. There are numerous solutions to credit rating fix and also when you have weak fico scores next you should think about repairing the credit rating. You may take pleasure in a growth within your economic flexibility once you make a plan in the direction of negative credit rating fix.md credit repair

    ReplyDelete
  8. Before Registration and Filing of your Income Tax Return, it is recommended that one should establish basic understanding regarding these processes. Knowledge of basic concepts would not only ensure that the tasks are performed easily but also in the prescribed manner. best tax relief company

    ReplyDelete
  9. The principal region is in choosing the lawyer and the subsequent region is botches made in the wake of choosing the lawyer.
    Brain Injury Attorneys

    ReplyDelete