GPES_EXPT_AC_VW (SQL View)	Index Back
Expatriate Accumulated Results Expatriate employees accumulated results

GPES_EXPT_AC_VW

(SQL View)

Expatriate Accumulated Results

Expatriate employees accumulated results

SELECT A.EMPLID , A.EMPL_RCD , A.COMPANY , A.GPES_TAX_LOCATION , A.GPES_MONTH , A.GPES_YEAR , A.GPES_EARNING_TYPE , A.GPES_FISCAL_KEY , A.GPES_FISCAL_SUBKEY , A.GPES_SALARY_INCOME + A.GPES_SAL_INC_ADJ , A.GPES_SALARY_WITHLD + A.GPES_SAL_WITH_ADJ , 0 FROM PS_GPES_EXPT_RSLT A WHERE %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

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

3 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

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

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

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

7 GPES_EARNING_TYPE Character(1) VARCHAR2(1) NOT NULL Earning Type
D=Monetary
E=In kind

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

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
3	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
4	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.
5	GPES_MONTH	Number(2,0)	SMALLINT NOT NULL	Month
6	GPES_YEAR	Number(4,0)	SMALLINT NOT NULL	Year
7	GPES_EARNING_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Earning Type D=Monetary E=In kind
8	GPES_FISCAL_KEY	Character(2)	VARCHAR2(2) NOT NULL	Fiscal key. Used to identify the earnings.
9	GPES_FISCAL_SUBKEY	Character(2)	VARCHAR2(2) NOT NULL	Fiscal sub-key. Used to identify the earnings.
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_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.