TRW_PY_EER_UTXB (SQL View)	Index Back
NA Payroll EE/ER Tax Class B This view retrieves Tax Class B that is a combination of employee and employer tax from US Tax pay detail from North American Payroll. Tax Class B is a local tax where the tax rate is the same for the employee and the employer, therefore it is divided 50/50.

TRW_PY_EER_UTXB

(SQL View)

NA Payroll EE/ER Tax Class B

This view retrieves Tax Class B that is a combination of employee and employer tax from US Tax pay detail from North American Payroll. Tax Class B is a local tax where the tax rate is the same for the employee and the employer, therefore it is divided 50/50.

SELECT PC.COMPANY , PC.PAYGROUP , PC.PAY_END_DT , PC.OFF_CYCLE , PC.PAGE_NUM , PC.LINE_NUM , PC.SEPCHK , PC.EMPLID , PC.EMPL_RCD , PT.STATE , PT.LOCALITY , PT.TAX_CLASS , %Round(%DecMult(PT.TAX_CUR, 0.5), 2) , %Round(%DecMult(PT.TAX_CUR, 0.5), 2) , PG.CURRENCY_CD , PC.PAYCHECK_NBR , PC.CHECK_DT , 'USA' FROM PS_PAY_CHECK PC , PS_PAYGROUP_TBL PG , PS_PAY_TAX PT WHERE PC.PAYCHECK_STATUS IN ('F','R') AND PC.COMPANY = PG.COMPANY AND PC.PAYGROUP = PG.PAYGROUP AND PG.EFFDT = ( SELECT MAX(PG_ED.EFFDT) FROM PS_PAYGROUP_TBL PG_ED WHERE PG.COMPANY = PG_ED.COMPANY AND PG.PAYGROUP = PG_ED.PAYGROUP AND PG_ED.EFFDT <= PC.PAY_END_DT) AND PC.COMPANY = PT.COMPANY AND PC.PAYGROUP = PT.PAYGROUP AND PC.PAY_END_DT = PT.PAY_END_DT AND PC.OFF_CYCLE = PT.OFF_CYCLE AND PC.PAGE_NUM = PT.PAGE_NUM AND PC.LINE_NUM = PT.LINE_NUM AND PC.SEPCHK = PT.SEPCHK AND PT.TAX_CUR <> 0 AND PT.TAX_CLASS IN ('B')

# 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

9 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

10 STATE Character(6) VARCHAR2(6) NOT NULL State

11 LOCALITY Character(10) VARCHAR2(10) NOT NULL Locality

12 TAX_CLASS Character(3) VARCHAR2(3) NOT NULL Tax Balance Class

13 TRW_CUR_EE_AMT Signed Number(12,2) DECIMAL(10,2) NOT NULL Employee Current Deduction

14 TRW_CUR_ER_AMT Signed Number(12,2) DECIMAL(10,2) NOT NULL Employer Current Amount

15 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

16 PAYCHECK_NBR Number(15,0) DECIMAL(15) NOT NULL Paycheck number.

17 CHECK_DT Date(10) DATE Check date.

18 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

#	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	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
9	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
10	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
11	LOCALITY	Character(10)	VARCHAR2(10) NOT NULL	Locality
12	TAX_CLASS	Character(3)	VARCHAR2(3) NOT NULL	Tax Balance Class
13	TRW_CUR_EE_AMT	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Employee Current Deduction
14	TRW_CUR_ER_AMT	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Employer Current Amount
15	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
16	PAYCHECK_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Paycheck number.
17	CHECK_DT	Date(10)	DATE	Check date.
18	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country