GPES_TX_RSTD_VW (SQL View)	Index Back
Tax Results VW Results Data Total Data Tax Results VW

GPES_TX_RSTD_VW

(SQL View)

Tax Results VW Results Data

Total Data Tax Results VW

SELECT A.EMPLID , A.CAL_RUN_ID , A.EMPL_RCD , A.GP_PAYGROUP , A.CAL_ID , A.ORIG_CAL_RUN_ID , A.RSLT_SEG_NUM , A.EFFDT , A.RSLT_VER_NUM , A.RSLT_REV_NUM , A.GPES_TAX_NET_BS , A.GPES_TAX_MIN_FAMLR , A.GPES_TAX_MIN_PERS , A.GPES_TAX_400E_DED , A.GPES_TAX_MORTGAGE , A.GPES_TAX_PCT , A.GPES_TAX_CONTRIBTN FROM PS_GPES_TAX_RSLT A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

4 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

5 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id

6 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID

7 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number

8 EFFDT Date(10) DATE Effective Date
Default Value: %date

9 RSLT_VER_NUM Number(4,0) SMALLINT NOT NULL Result Version Number

10 RSLT_REV_NUM Number(4,0) SMALLINT NOT NULL Result Revision Number

11 GPES_TAX_NET_BS Number(14,2) DECIMAL(13,2) NOT NULL Taxable base. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.

12 GPES_TAX_MIN_FAMLR Number(14,2) DECIMAL(13,2) NOT NULL Family Minimum Reduction. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.

13 GPES_TAX_MIN_PERS Number(14,2) DECIMAL(13,2) NOT NULL Personal Minimum Reduction. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.

14 GPES_TAX_400E_DED Number(14,2) DECIMAL(13,2) NOT NULL Deduction due article 80bis LIRPF (400 Euros deduction)

15 GPES_TAX_MORTGAGE Signed Number(15,2) DECIMAL(13,2) NOT NULL Tax Reduction due home mortgage

16 GPES_TAX_PCT Number(6,2) DECIMAL(5,2) NOT NULL Withholding percentage calculated. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.

17 GPES_TAX_CONTRIBTN Number(11,2) DECIMAL(10,2) NOT NULL Tax contribution. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
4	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
5	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
6	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
7	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
8	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
9	RSLT_VER_NUM	Number(4,0)	SMALLINT NOT NULL	Result Version Number
10	RSLT_REV_NUM	Number(4,0)	SMALLINT NOT NULL	Result Revision Number
11	GPES_TAX_NET_BS	Number(14,2)	DECIMAL(13,2) NOT NULL	Taxable base. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.
12	GPES_TAX_MIN_FAMLR	Number(14,2)	DECIMAL(13,2) NOT NULL	Family Minimum Reduction. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.
13	GPES_TAX_MIN_PERS	Number(14,2)	DECIMAL(13,2) NOT NULL	Personal Minimum Reduction. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.
14	GPES_TAX_400E_DED	Number(14,2)	DECIMAL(13,2) NOT NULL	Deduction due article 80bis LIRPF (400 Euros deduction)
15	GPES_TAX_MORTGAGE	Signed Number(15,2)	DECIMAL(13,2) NOT NULL	Tax Reduction due home mortgage
16	GPES_TAX_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Withholding percentage calculated. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.
17	GPES_TAX_CONTRIBTN	Number(11,2)	DECIMAL(10,2) NOT NULL	Tax contribution. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.