GPES_TAX2_VR_VW (SQL View)	Index Back
Retrieve Tax2 Results Retrieve Tax2 Results

GPES_TAX2_VR_VW

(SQL View)

Retrieve Tax2 Results

SELECT A.EMPLID , A.EMPL_RCD , A.CAL_RUN_ID , A.GPES_YEAR , A.GPES_MONTH , A.COMPANY , A.GPES_TAX_LOCATION , A.GPES_FISCAL_KEY , A.GPES_FISCAL_SUBKEY , A.GPES_TAX_TYPE , A.GPES_YEAR_RETRO , A.RSLT_VER_NUM , A.RSLT_REV_NUM , %Coalesce (B.RUN_TYPE, ' ') , (A.GPES_SALARY_INCOME + A.GPES_SAL_INC_ADJ) , (A.GPES_INKIND_INCOME + A.GPES_INK_INC_ADJ) , (A.GPES_SALARY_WITHLD + A.GPES_SAL_WITH_ADJ) , (A.GPES_INKIND_WITHLD + A.GPES_INK_WITH_ADJ) , (GPES_INK_WITHLD_EE + A.GPES_INKWITHEE_ADJ) , (A.GPES_REDUCTIONS + A.GPES_REDCTIONS_ADJ) , A.GPES_TAX_INC_VR1 , A.GPES_TAX_INC_VR2 , (A.GPES_TAX_INC_VR3 + A.GPES_TAX_INCVR_ADJ) , (A.GPES_GARN_CHILDREN + A.GPES_GARN_CHLD_ADJ) , (A.GPES_GARN_SPOUSE + A.GPES_GARN_SPSE_ADJ) , (A.GPES_SSTC_CT_EE + A.GPES_SS_CT_EE_ADJ) FROM PS_GPES_TAX2_RSLT A LEFT OUTER JOIN PS_GP_CALENDAR B ON A.GP_PAYGROUP = B.GP_PAYGROUP AND A.CAL_ID = B.CAL_ID WHERE A. GPES_FISCAL_KEY IN ('A' ,'L','M') AND %Sql(GPES_TX_MAX_VER_REV_NUM, PS_GPES_TAX2_RSLT, A)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: GPES_EMP_ORG_VW

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
Prompt Table: EMPLOYMENT

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

4 GPES_YEAR Number(4,0) SMALLINT NOT NULL Year

5 GPES_MONTH Number(2,0) SMALLINT NOT NULL Month

6 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Prompt Table: COMPANY_TBL

7 GPES_TAX_LOCATION Character(5) VARCHAR2(5) NOT NULL Fiscal Territory. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.
Prompt Table: GPES_TAX_LOCATN

8 GPES_FISCAL_KEY Character(2) VARCHAR2(2) NOT NULL Fiscal key. Used to identify the earnings.
Prompt Table: GPES_PERCEP_KEY

9 GPES_FISCAL_SUBKEY Character(2) VARCHAR2(2) NOT NULL Fiscal sub-key. Used to identify the earnings.
Prompt Table: GPES_PERCP_SKEY

10 GPES_TAX_TYPE Character(1) VARCHAR2(1) NOT NULL Field to differentiate the special row with the refunded amount (RD 2/2008, 21 April) of the normal rows in month of June 2008.
R=Regular Payrolls
Z=RD Law 2/2008

11 GPES_YEAR_RETRO Number(4,0) SMALLINT NOT NULL Year Retro

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

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

14 RUN_TYPE Character(10) VARCHAR2(10) NOT NULL Run Type Name

15 GPES_SALARY_INCOME Signed Number(17,2) DECIMAL(15,2) NOT NULL Salary Income.

16 GPES_INKIND_INCOME Signed Number(17,2) DECIMAL(15,2) NOT NULL Total amount earned as in kind income.

17 GPES_SALARY_WITHLD Signed Number(17,2) DECIMAL(15,2) NOT NULL Salary Withholding.

18 GPES_INKIND_WITHLD Signed Number(17,2) DECIMAL(15,2) NOT NULL Contribution (payee + employer) as in-kind withholding.

19 GPES_INK_WITHLD_EE Signed Number(17,2) DECIMAL(15,2) NOT NULL Contribution (payee) as in-kind withholding.

20 GPES_REDUCTIONS Number(16,2) DECIMAL(15,2) NOT NULL Taxes reductions

21 GPES_TAX_INC_VR1 Signed Number(17,2) DECIMAL(15,2) NOT NULL Variable income paid during last year in the same period of time (Historical Rule)

22 GPES_TAX_INC_VR2 Signed Number(17,2) DECIMAL(15,2) NOT NULL Variable income for the whole of the previous year.

23 GPES_TAX_INC_VR3 Signed Number(17,2) DECIMAL(15,2) NOT NULL Variable Income entered through Earnings & Deduction assignment.

24 GPES_GARN_CHILDREN Number(16,2) DECIMAL(15,2) NOT NULL Amount paid by the payee in concept of garnishment for children alimony.

25 GPES_GARN_SPOUSE Number(16,2) DECIMAL(15,2) NOT NULL Amount paid by the payee in concept of garnishment for spouse alimony.

26 GPES_SSTC_CT_EE Signed Number(17,2) DECIMAL(15,2) NOT NULL Employee Social Security Contributions. This field is used to populate the GP Write Array, which is used to generate the FAN File.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: GPES_EMP_ORG_VW
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr Prompt Table: EMPLOYMENT
3	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
4	GPES_YEAR	Number(4,0)	SMALLINT NOT NULL	Year
5	GPES_MONTH	Number(2,0)	SMALLINT NOT NULL	Month
6	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
7	GPES_TAX_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Fiscal Territory. This field is used to populate the GP Write Array, which is used to generate the Tax Reports. Prompt Table: GPES_TAX_LOCATN
8	GPES_FISCAL_KEY	Character(2)	VARCHAR2(2) NOT NULL	Fiscal key. Used to identify the earnings. Prompt Table: GPES_PERCEP_KEY
9	GPES_FISCAL_SUBKEY	Character(2)	VARCHAR2(2) NOT NULL	Fiscal sub-key. Used to identify the earnings. Prompt Table: GPES_PERCP_SKEY
10	GPES_TAX_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Field to differentiate the special row with the refunded amount (RD 2/2008, 21 April) of the normal rows in month of June 2008. R=Regular Payrolls Z=RD Law 2/2008
11	GPES_YEAR_RETRO	Number(4,0)	SMALLINT NOT NULL	Year Retro
12	RSLT_VER_NUM	Number(4,0)	SMALLINT NOT NULL	Result Version Number
13	RSLT_REV_NUM	Number(4,0)	SMALLINT NOT NULL	Result Revision Number
14	RUN_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Run Type Name
15	GPES_SALARY_INCOME	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Salary Income.
16	GPES_INKIND_INCOME	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Total amount earned as in kind income.
17	GPES_SALARY_WITHLD	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Salary Withholding.
18	GPES_INKIND_WITHLD	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Contribution (payee + employer) as in-kind withholding.
19	GPES_INK_WITHLD_EE	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Contribution (payee) as in-kind withholding.
20	GPES_REDUCTIONS	Number(16,2)	DECIMAL(15,2) NOT NULL	Taxes reductions
21	GPES_TAX_INC_VR1	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Variable income paid during last year in the same period of time (Historical Rule)
22	GPES_TAX_INC_VR2	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Variable income for the whole of the previous year.
23	GPES_TAX_INC_VR3	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Variable Income entered through Earnings & Deduction assignment.
24	GPES_GARN_CHILDREN	Number(16,2)	DECIMAL(15,2) NOT NULL	Amount paid by the payee in concept of garnishment for children alimony.
25	GPES_GARN_SPOUSE	Number(16,2)	DECIMAL(15,2) NOT NULL	Amount paid by the payee in concept of garnishment for spouse alimony.
26	GPES_SSTC_CT_EE	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Employee Social Security Contributions. This field is used to populate the GP Write Array, which is used to generate the FAN File.