VIEW: APPS.PAY_US_FEDERAL_ACTION_INFO_V

Source

View Text - Preformatted

SELECT pai.action_context_id action_number, pai.effective_date effective_date, pai.assignment_id, to_number(pai.action_information23) FIT_Gross, to_number(pai.action_information1 ) FIT_Withheld, to_number(pai.action_information2 ) Regular_Earnings, to_number(pai.action_information3 ) Supplemental_Earnings_for_FIT, to_number(pai.action_information4 ) Supp_Earnings_for_NWFIT, to_number(pai.action_information5 ) Pre_Tax_Deductions, to_number(pai.action_information6 ) Pre_Tax_Deductions_for_FIT, nvl(to_number(pai.action_information2 ), 0) + nvl(to_number(pai.action_information3), 0) FIT_Subject_Whable, ((nvl(to_number(pai.action_information2), 0) + nvl(to_number(pai.action_information3),0) + nvl(to_number(pai.action_information4),0)) - (nvl(to_number(pai.action_information5), 0) - nvl(to_number(pai.action_information6),0))) FIT_Reduced_Subject, to_number(pai.action_information7 ) SS_EE_Taxable, to_number(pai.action_information8 ) SS_EE_Withheld, to_number(pai.action_information9 ) SS_ER_Liability, to_number(pai.action_information10) SS_ER_Taxable, to_number(pai.action_information11) Supplemental_Earnings_for_SS, to_number(pai.action_information12) Pre_Tax_Deductions_for_SS, nvl(to_number(pai.action_information2 ), 0) + nvl(to_number(pai.action_information11), 0) SS_Subject, ((nvl(to_number(pai.action_information2), 0) + nvl(to_number(pai.action_information11), 0)) - (nvl(to_number(pai.action_information5), 0) - nvl(to_number(pai.action_information12), 0))) SS_Reduced_Subject, to_number(pai.action_information13) Medicare_EE_Taxable, to_number(pai.action_information14) Medicare_EE_Withheld, to_number(pai.action_information15) Medicare_ER_Liability, to_number(pai.action_information16) Medicare_ER_Taxable, to_number(pai.action_information17) Supp_Earnings_for_Medicare, to_number(pai.action_information18) Pre_Tax_Deduct_for_Medicare, nvl(to_number(pai.action_information2 ), 0) + nvl(to_number(pai.action_information17), 0) Medicare_Subject, ((nvl(to_number(pai.action_information2), 0) + nvl(to_number(pai.action_information17), 0)) - (nvl(to_number(pai.action_information5), 0) - nvl(to_number(pai.action_information18), 0))) Medicare_Reduced_Subject, to_number(pai.action_information19) Supp_Earnings_for_FUTA, to_number(pai.action_information20) Pre_Tax_Deduct_for_FUTA, to_number(pai.action_information21) FUTA_Taxable, to_number(pai.action_information22) FUTA_Liability, nvl(to_number(pai.action_information2 ), 0) + nvl(to_number(pai.action_information19), 0) FUTA_Subject, ((nvl(to_number(pai.action_information2), 0) + nvl(to_number(pai.action_information19), 0)) - (nvl(to_number(pai.action_information5), 0) - nvl(to_number(pai.action_information20), 0))) FUTA_Reduced_Subject, to_number(pai.action_information26) eic_advance, to_number (pai.action_information27) medicare_ee_taxable_over_limit from pay_action_information pai WHERE pai.action_information_category = 'US FEDERAL'

View Text - HTML Formatted

SELECT PAI.ACTION_CONTEXT_ID ACTION_NUMBER
, PAI.EFFECTIVE_DATE EFFECTIVE_DATE
, PAI.ASSIGNMENT_ID
, TO_NUMBER(PAI.ACTION_INFORMATION23) FIT_GROSS
, TO_NUMBER(PAI.ACTION_INFORMATION1 ) FIT_WITHHELD
, TO_NUMBER(PAI.ACTION_INFORMATION2 ) REGULAR_EARNINGS
, TO_NUMBER(PAI.ACTION_INFORMATION3 ) SUPPLEMENTAL_EARNINGS_FOR_FIT
, TO_NUMBER(PAI.ACTION_INFORMATION4 ) SUPP_EARNINGS_FOR_NWFIT
, TO_NUMBER(PAI.ACTION_INFORMATION5 ) PRE_TAX_DEDUCTIONS
, TO_NUMBER(PAI.ACTION_INFORMATION6 ) PRE_TAX_DEDUCTIONS_FOR_FIT
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION2 )
, 0) + NVL(TO_NUMBER(PAI.ACTION_INFORMATION3)
, 0) FIT_SUBJECT_WHABLE
, ((NVL(TO_NUMBER(PAI.ACTION_INFORMATION2)
, 0) + NVL(TO_NUMBER(PAI.ACTION_INFORMATION3)
, 0) + NVL(TO_NUMBER(PAI.ACTION_INFORMATION4)
, 0)) - (NVL(TO_NUMBER(PAI.ACTION_INFORMATION5)
, 0) - NVL(TO_NUMBER(PAI.ACTION_INFORMATION6)
, 0))) FIT_REDUCED_SUBJECT
, TO_NUMBER(PAI.ACTION_INFORMATION7 ) SS_EE_TAXABLE
, TO_NUMBER(PAI.ACTION_INFORMATION8 ) SS_EE_WITHHELD
, TO_NUMBER(PAI.ACTION_INFORMATION9 ) SS_ER_LIABILITY
, TO_NUMBER(PAI.ACTION_INFORMATION10) SS_ER_TAXABLE
, TO_NUMBER(PAI.ACTION_INFORMATION11) SUPPLEMENTAL_EARNINGS_FOR_SS
, TO_NUMBER(PAI.ACTION_INFORMATION12) PRE_TAX_DEDUCTIONS_FOR_SS
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION2 )
, 0) + NVL(TO_NUMBER(PAI.ACTION_INFORMATION11)
, 0) SS_SUBJECT
, ((NVL(TO_NUMBER(PAI.ACTION_INFORMATION2)
, 0) + NVL(TO_NUMBER(PAI.ACTION_INFORMATION11)
, 0)) - (NVL(TO_NUMBER(PAI.ACTION_INFORMATION5)
, 0) - NVL(TO_NUMBER(PAI.ACTION_INFORMATION12)
, 0))) SS_REDUCED_SUBJECT
, TO_NUMBER(PAI.ACTION_INFORMATION13) MEDICARE_EE_TAXABLE
, TO_NUMBER(PAI.ACTION_INFORMATION14) MEDICARE_EE_WITHHELD
, TO_NUMBER(PAI.ACTION_INFORMATION15) MEDICARE_ER_LIABILITY
, TO_NUMBER(PAI.ACTION_INFORMATION16) MEDICARE_ER_TAXABLE
, TO_NUMBER(PAI.ACTION_INFORMATION17) SUPP_EARNINGS_FOR_MEDICARE
, TO_NUMBER(PAI.ACTION_INFORMATION18) PRE_TAX_DEDUCT_FOR_MEDICARE
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION2 )
, 0) + NVL(TO_NUMBER(PAI.ACTION_INFORMATION17)
, 0) MEDICARE_SUBJECT
, ((NVL(TO_NUMBER(PAI.ACTION_INFORMATION2)
, 0) + NVL(TO_NUMBER(PAI.ACTION_INFORMATION17)
, 0)) - (NVL(TO_NUMBER(PAI.ACTION_INFORMATION5)
, 0) - NVL(TO_NUMBER(PAI.ACTION_INFORMATION18)
, 0))) MEDICARE_REDUCED_SUBJECT
, TO_NUMBER(PAI.ACTION_INFORMATION19) SUPP_EARNINGS_FOR_FUTA
, TO_NUMBER(PAI.ACTION_INFORMATION20) PRE_TAX_DEDUCT_FOR_FUTA
, TO_NUMBER(PAI.ACTION_INFORMATION21) FUTA_TAXABLE
, TO_NUMBER(PAI.ACTION_INFORMATION22) FUTA_LIABILITY
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION2 )
, 0) + NVL(TO_NUMBER(PAI.ACTION_INFORMATION19)
, 0) FUTA_SUBJECT
, ((NVL(TO_NUMBER(PAI.ACTION_INFORMATION2)
, 0) + NVL(TO_NUMBER(PAI.ACTION_INFORMATION19)
, 0)) - (NVL(TO_NUMBER(PAI.ACTION_INFORMATION5)
, 0) - NVL(TO_NUMBER(PAI.ACTION_INFORMATION20)
, 0))) FUTA_REDUCED_SUBJECT
, TO_NUMBER(PAI.ACTION_INFORMATION26) EIC_ADVANCE
, TO_NUMBER (PAI.ACTION_INFORMATION27) MEDICARE_EE_TAXABLE_OVER_LIMIT
FROM PAY_ACTION_INFORMATION PAI
WHERE PAI.ACTION_INFORMATION_CATEGORY = 'US FEDERAL'