GPES_TAX_RS_VW (SQL View)	Index Back
Inquire view Tax calculation results inquire

GPES_TAX_RS_VW

(SQL View)

Inquire view

Tax calculation results inquire

SELECT A.EMPLID , A.EMPL_RCD , A.GP_PAYGROUP , A.CAL_RUN_ID , A.CAL_ID , A.ORIG_CAL_RUN_ID , A.EFFDT , A.GPES_TAX_BASE , A.GPES_TAX_PCT , A.GPES_TAX_CONTRIBTN , A.GPES_SS_CT_EE , A.GPES_TAX_MIN_FAMLR , A.GPES_TAX_MIN_PERS , A.GPES_TAX_REDUCTION , A.GPES_GARN_SPOUSE , A.GPES_GARN_CHILDREN , A.GPES_TAX_INC_IRREG , A.GPES_TAX_NET_BS , A.GPES_RED_MORTGAGE , A.GPES_TAX_MORTG_PRE , A.GPES_TAX_CALC_TYPE , A.GPES_FAMLR_SITUATN , A.RSLT_VER_NUM , A.RSLT_REV_NUM , B.PRC_ORD_TS , %DatePart(B.PRC_ORD_TS) , %TimePart(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 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

3 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

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

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 EFFDT Date(10) DATE Effective Date
Default Value: %date

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

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

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

12 GPES_TAX_MIN_FAMLR Number(14,2) DECIMAL(13,2) NOT NULL Family Minimum Reduction. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.

13 GPES_TAX_MIN_PERS Number(14,2) DECIMAL(13,2) NOT NULL Personal Minimum Reduction. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.

14 GPES_TAX_REDUCTION Number(14,2) DECIMAL(13,2) NOT NULL Tax Reduction.

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

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

17 GPES_TAX_INC_IRREG Number(14,2) DECIMAL(13,2) NOT NULL Taxable base. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.

18 GPES_TAX_NET_BS Number(14,2) DECIMAL(13,2) NOT NULL Taxable base. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.

19 GPES_RED_MORTGAGE Character(1) VARCHAR2(1) NOT NULL Eligibility Flag for Home Mortgage Reduction
1=Reduction From 2011
1=Reduction From 2011
N=No Reduction
Y=Reduction
Y=Reduction Before 2011

20 GPES_TAX_MORTG_PRE Signed Number(15,2) DECIMAL(13,2) NOT NULL Previous Tax Reduction due home mortgage

21 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

22 GPES_FAMLR_SITUATN Character(1) VARCHAR2(1) NOT NULL Family situation.
1=1.- With fiscal dependent
2=2.- With spouse to support
3=3.- Other situations

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

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

25 PRC_ORD_TS DateTime(26) TIMESTAMP Process Order Timestamp

26 GPES_PRC_ORD_DT Date(10) DATE Process order date

27 GPES_PRC_ORD_TM Character(24) VARCHAR2(24) NOT NULL Process order time

#	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 Record
3	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
4	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
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	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
8	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.
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_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.
11	GPES_SS_CT_EE	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Employee Social Security contribution
12	GPES_TAX_MIN_FAMLR	Number(14,2)	DECIMAL(13,2) NOT NULL	Family Minimum Reduction. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.
13	GPES_TAX_MIN_PERS	Number(14,2)	DECIMAL(13,2) NOT NULL	Personal Minimum Reduction. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.
14	GPES_TAX_REDUCTION	Number(14,2)	DECIMAL(13,2) NOT NULL	Tax Reduction.
15	GPES_GARN_SPOUSE	Number(16,2)	DECIMAL(15,2) NOT NULL	Amount paid by the payee in concept of garnishment for spouse alimony.
16	GPES_GARN_CHILDREN	Number(16,2)	DECIMAL(15,2) NOT NULL	Amount paid by the payee in concept of garnishment for children alimony.
17	GPES_TAX_INC_IRREG	Number(14,2)	DECIMAL(13,2) NOT NULL	Taxable base. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.
18	GPES_TAX_NET_BS	Number(14,2)	DECIMAL(13,2) NOT NULL	Taxable base. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.
19	GPES_RED_MORTGAGE	Character(1)	VARCHAR2(1) NOT NULL	Eligibility Flag for Home Mortgage Reduction 1=Reduction From 2011 1=Reduction From 2011 N=No Reduction Y=Reduction Y=Reduction Before 2011
20	GPES_TAX_MORTG_PRE	Signed Number(15,2)	DECIMAL(13,2) NOT NULL	Previous Tax Reduction due home mortgage
21	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
22	GPES_FAMLR_SITUATN	Character(1)	VARCHAR2(1) NOT NULL	Family situation. 1=1.- With fiscal dependent 2=2.- With spouse to support 3=3.- Other situations
23	RSLT_VER_NUM	Number(4,0)	SMALLINT NOT NULL	Result Version Number
24	RSLT_REV_NUM	Number(4,0)	SMALLINT NOT NULL	Result Revision Number
25	PRC_ORD_TS	DateTime(26)	TIMESTAMP	Process Order Timestamp
26	GPES_PRC_ORD_DT	Date(10)	DATE	Process order date
27	GPES_PRC_ORD_TM	Character(24)	VARCHAR2(24) NOT NULL	Process order time