GPES_TX_RSRD_VW

(SQL View)
 Index Back

Tax Results VW Regularztn Data

Regularization Data Tax Result VW

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.RSLT_VER_NUM , A.RSLT_REV_NUM , A.GPES_TAX_AC_TOT , A.GPES_TAX_AC_CT , A.GPES_TAX_BASE , A.GPES_TAX_CONTRIBTN , A.GPES_TAX_NET_BS , A.GPES_TAX_MIN_FAMLR , A.GPES_TAX_MIN_PERS , A.GPES_TAX_PCT , A.GPES_TAX_MORTG_PRE , 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

# 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 Record
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 EFFDT Date(10) DATE Effective Date

Default Value: %date

9 RSLT_VER_NUM Number(4,0) SMALLINT NOT NULL Result Version Number
10 RSLT_REV_NUM Number(4,0) SMALLINT NOT NULL Result Revision Number
11 GPES_TAX_AC_TOT 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.
12 GPES_TAX_AC_CT 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.
13 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.
14 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.
15 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.
16 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.
17 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.
18 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.
19 GPES_TAX_MORTG_PRE Signed Number(15,2) DECIMAL(13,2) NOT NULL Previous Tax Reduction due home mortgage
20 PRC_ORD_TS DateTime(26) TIMESTAMP Process Order Timestamp