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

GPES_EXPT_RS_VW

(SQL View)

Retrieve Tax2 Results

SELECT A.EMPLID , A.EMPL_RCD , A.GPES_YEAR , A.GPES_MONTH , A.CAL_ID , A.COMPANY , A.GPES_FISCAL_KEY , A.GPES_FISCAL_SUBKEY , A. GPES_EARNING_TYPE , (A.GPES_SALARY_INCOME + A.GPES_SAL_INC_ADJ) , (A.GPES_SALARY_WITHLD + A.GPES_SAL_WITH_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) , (A.GPES_REDUCTIONS +A.GPES_REDCTIONS_ADJ) , A.RSLT_VER_NUM , A.RSLT_REV_NUM FROM PS_GPES_EXPT_RSLT A WHERE A. GPES_FISCAL_KEY IN ('T','20' ) AND %Sql(GPES_TX_MAX_VER_REV_NUM, PS_GPES_EXPT_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 GPES_YEAR Number(4,0) SMALLINT NOT NULL Year

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

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

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

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_EARNING_TYPE Character(1) VARCHAR2(1) NOT NULL Earning Type
D=Monetary
E=In kind

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

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

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

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

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

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

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

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

#	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	GPES_YEAR	Number(4,0)	SMALLINT NOT NULL	Year
4	GPES_MONTH	Number(2,0)	SMALLINT NOT NULL	Month
5	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
6	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
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_EARNING_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Earning Type D=Monetary E=In kind
10	GPES_SALARY_INCOME	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Salary Income.
11	GPES_SALARY_WITHLD	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Salary Withholding.
12	GPES_GARN_CHILDREN	Number(16,2)	DECIMAL(15,2) NOT NULL	Amount paid by the payee in concept of garnishment for children alimony.
13	GPES_GARN_SPOUSE	Number(16,2)	DECIMAL(15,2) NOT NULL	Amount paid by the payee in concept of garnishment for spouse alimony.
14	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.
15	GPES_REDUCTIONS	Number(16,2)	DECIMAL(15,2) NOT NULL	Taxes reductions
16	RSLT_VER_NUM	Number(4,0)	SMALLINT NOT NULL	Result Version Number
17	RSLT_REV_NUM	Number(4,0)	SMALLINT NOT NULL	Result Revision Number