GPES_TX2_RSL_VW (SQL View)	Index Back
Tax Results Tax results view

GPES_TX2_RSL_VW

(SQL View)

Tax Results

Tax results view

SELECT A.EMPLID , A.EMPL_RCD , A.GPES_YEAR , A.GPES_MONTH , A.COMPANY , A.GPES_TAX_LOCATION , A.GPES_FISCAL_KEY , A.GPES_FISCAL_SUBKEY , A.GPES_YEAR_RETRO , A.GPES_SALARY_INCOME + A.GPES_SAL_INC_ADJ , A.GPES_TAX_INC_VR1 + A.GPES_TAX_INC_VR2 + A.GPES_TAX_INC_VR3 + A.GPES_TAX_INCVR_ADJ , A.GPES_SALARY_WITHLD + A.GPES_SAL_WITH_ADJ , A.GPES_INKIND_INCOME + A.GPES_INK_INC_ADJ , A.GPES_INKIND_WITHLD + A.GPES_INK_WITH_ADJ , A.GPES_INK_WITHLD_EE + A.GPES_INKWITHEE_ADJ , A.GPES_REDUCTIONS + A.GPES_REDCTIONS_ADJ , A.GPES_GARN_SPOUSE + A.GPES_GARN_SPSE_ADJ , A.GPES_GARN_CHILDREN + A.GPES_GARN_CHLD_ADJ , A.GPES_SSTC_CT_EE + A.GPES_SS_CT_EE_ADJ , A.GPES_CEUTA_MELILLA FROM PS_GPES_TAX2_RSLT A WHERE %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 Record
Prompt Table: EMPLOYMENT

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

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

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

6 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

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

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

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

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

11 GPES_TAX_INC_VR Signed Number(17,2) DECIMAL(15,2) NOT NULL Variable income total

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

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

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

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

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

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

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

19 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.

20 GPES_CEUTA_MELILLA Character(1) VARCHAR2(1) NOT NULL Payee is working in Spanish cities Ceuta or Melilla. This cities has a special tax status.
Y/N Table Edit

#	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 Record Prompt Table: EMPLOYMENT
3	GPES_YEAR	Number(4,0)	SMALLINT NOT NULL	Year
4	GPES_MONTH	Number(2,0)	SMALLINT NOT NULL	Month
5	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
6	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
7	GPES_FISCAL_KEY	Character(2)	VARCHAR2(2) NOT NULL	Fiscal key. Used to identify the earnings. Prompt Table: GPES_PERCEP_KEY
8	GPES_FISCAL_SUBKEY	Character(2)	VARCHAR2(2) NOT NULL	Fiscal sub-key. Used to identify the earnings. Prompt Table: GPES_PERCP_SKEY
9	GPES_YEAR_RETRO	Number(4,0)	SMALLINT NOT NULL	Year Retro
10	GPES_SALARY_INCOME	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Salary Income.
11	GPES_TAX_INC_VR	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Variable income total
12	GPES_SALARY_WITHLD	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Salary Withholding.
13	GPES_INKIND_INCOME	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Total amount earned as in kind income.
14	GPES_INKIND_WITHLD	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Contribution (payee + employer) as in-kind withholding.
15	GPES_INK_WITHLD_EE	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Contribution (payee) as in-kind withholding.
16	GPES_REDUCTIONS	Number(16,2)	DECIMAL(15,2) NOT NULL	Taxes reductions
17	GPES_GARN_SPOUSE	Number(16,2)	DECIMAL(15,2) NOT NULL	Amount paid by the payee in concept of garnishment for spouse alimony.
18	GPES_GARN_CHILDREN	Number(16,2)	DECIMAL(15,2) NOT NULL	Amount paid by the payee in concept of garnishment for children alimony.
19	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.
20	GPES_CEUTA_MELILLA	Character(1)	VARCHAR2(1) NOT NULL	Payee is working in Spanish cities Ceuta or Melilla. This cities has a special tax status. Y/N Table Edit