View: PAYBV_US_FEDERAL_ARCHIVE

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAYBV_US_FEDERAL_ARCHIVE

View Text

SELECT PAI.ACTION_CONTEXT_ID ACTION_NUMBER
, PAI.TAX_UNIT_ID
, PAI.EFFECTIVE_DATE EFFECTIVE_DATE
, PAI.ASSIGNMENT_ID
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION23)
, 0) FIT_GROSS
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION1 )
, 0) FIT_WITHHELD
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION2 )
, 0) REGULAR_EARNINGS
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION3 )
, 0) SUPPLEMENTAL_EARNINGS_FOR_FIT
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION4 )
, 0) SUPP_EARNINGS_FOR_NWFIT
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION5 )
, 0) PRE_TAX_DEDUCTIONS
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION6 )
, 0) 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
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION7 )
, 0) SS_EE_TAXABLE
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION8 )
, 0) SS_EE_WITHHELD
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION9 )
, 0) SS_ER_LIABILITY
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION10)
, 0) SS_ER_TAXABLE
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION11)
, 0) SUPPLEMENTAL_EARNINGS_FOR_SS
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION12)
, 0) 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
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION13)
, 0) MEDICARE_EE_TAXABLE
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION14)
, 0) MEDICARE_EE_WITHHELD
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION15)
, 0) MEDICARE_ER_LIABILITY
, NVL( TO_NUMBER(PAI.ACTION_INFORMATION16)
, 0) MEDICARE_ER_TAXABLE
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION17)
, 0) SUPP_EARNINGS_FOR_MEDICARE
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION18)
, 0) 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
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION19)
, 0) SUPP_EARNINGS_FOR_FUTA
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION20)
, 0) PRE_TAX_DEDUCT_FOR_FUTA
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION21)
, 0) FUTA_TAXABLE
, NVL( TO_NUMBER(PAI.ACTION_INFORMATION22)
, 0) 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
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION26)
, 0) EIC_ADVANCE
FROM PAY_ACTION_INFORMATION PAI
WHERE PAI.ACTION_INFORMATION_CATEGORY = 'US FEDERAL' WITH READ ONLY

Columns