PYKB_US_RTAX_VW

(SQL View)
 Index Back

Payroll Insights US ER Taxes

Payroll Insights US Employer Taxes

SELECT A.COMPANY ,A.PAYGROUP ,A.PAY_END_DT ,A.OFF_CYCLE ,A.PAGE_NUM ,A.LINE_NUM ,A.SEPCHK ,SUM(A.TAX_CUR) AS PY_ER_TAX_CUR FROM PS_PAY_TAX A WHERE A.TAX_CUR <> 0 AND A.TAX_CLASS IN ('AB','AD','0','2','4','6','8','9','E','J','Q','R','S','U','X','Y','Z') GROUP BY A.COMPANY, A.PAYGROUP, A.PAY_END_DT, A.OFF_CYCLE, A.PAGE_NUM, A.LINE_NUM, A.SEPCHK

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
2 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
3 PAY_END_DT Date(10) DATE Pay Period End Date
4 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?
5 PAGE_NUM Number(5,0) INTEGER NOT NULL Page Nbr
6 LINE_NUM Number(3,0) SMALLINT NOT NULL Line Nbr
7 SEPCHK Number(2,0) SMALLINT NOT NULL Separate check number.
8 PY_ER_TAX_CUR Signed Number(19,2) DECIMAL(17,2) NOT NULL Payroll Employer Tax Current