GPES_TAX_PD_VW (SQL View)	Index Back
Inquire View Used to build 190 tax report inquire pages.

GPES_TAX_PD_VW

(SQL View)

Inquire View

Used to build 190 tax report inquire pages.

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.GPES_TAX_PCT ,0 ,A.GPES_TAX_PCT ,A.GPES_TAX_BASE ,A.GPES_TAX_CONTRIBTN ,A.GPES_SS_CT_EE ,A.GPES_TAX_MIN_FAMLR + A.GPES_TAX_MIN_PERS + A.GPES_TAX_REDUCTION ,A.EFFDT ,A.GPES_TAX_CALC_TYPE ,B.PRC_ORD_TS FROM PS_GPES_TAX_RSLT A ,PS_GP_PYE_PRC_STAT B WHERE A.EMPLID = B.EMPLID AND A.CAL_RUN_ID = B.CAL_RUN_ID AND A.EMPL_RCD = B.EMPL_RCD AND A.GP_PAYGROUP = B.GP_PAYGROUP AND A.CAL_ID = B.CAL_ID AND A.ORIG_CAL_RUN_ID = B.ORIG_CAL_RUN_ID AND %Sql(GPES_MAX_VER_REV_NUM, 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 GPES_EFFDT Date(10) DATE Date

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

10 GPES_TAX_OLD_PCT Number(6,2) DECIMAL(5,2) NOT NULL Old Percentage

11 GPES_TAX_PCT_DIF Signed Number(7,2) DECIMAL(5,2) NOT NULL Difference

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

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

14 GPES_SS_CT_EE Signed Number(17,2) DECIMAL(15,2) NOT NULL Employee Social Security contribution

15 GPES_TOT_REDUCTION Number(16,3) DECIMAL(15,3) NOT NULL Total Reductions

16 PRIOR_EFFDT Date(10) DATE Prior Effdt

17 GPES_TAX_CALC_TYPE Character(1) VARCHAR2(1) NOT NULL Tax calculation process type. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.
C=Calculated
U=User Updated

18 PRC_ORD_TS DateTime(26) TIMESTAMP Process Order Timestamp

#	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	GPES_EFFDT	Date(10)	DATE	Date
9	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.
10	GPES_TAX_OLD_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Old Percentage
11	GPES_TAX_PCT_DIF	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Difference
12	GPES_TAX_BASE	Number(11,2)	DECIMAL(10,2) NOT NULL	Taxable base. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.
13	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.
14	GPES_SS_CT_EE	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Employee Social Security contribution
15	GPES_TOT_REDUCTION	Number(16,3)	DECIMAL(15,3) NOT NULL	Total Reductions
16	PRIOR_EFFDT	Date(10)	DATE	Prior Effdt
17	GPES_TAX_CALC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Tax calculation process type. This field is used to populate the GP Write Array, which is used to generate the Tax Reports. C=Calculated U=User Updated
18	PRC_ORD_TS	DateTime(26)	TIMESTAMP	Process Order Timestamp