GPES_TX_RSED_VW

(SQL View)
Index Back

Tax Results VW Economical Data

Economical Data Tax Results VW

SELECT EMPLID , CAL_RUN_ID , EMPL_RCD , GP_PAYGROUP , CAL_ID , ORIG_CAL_RUN_ID , RSLT_SEG_NUM , EFFDT , RSLT_VER_NUM , RSLT_REV_NUM , GPES_TAX_BASE , GPES_TAX_INC_IRREG , GPES_SS_CT_EE , GPES_TAX_REDUCTION , GPES_GARN_SPOUSE , GPES_GARN_CHILDREN FROM PS_GPES_TAX_RSLT

# 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_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.
12 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.
13 GPES_SS_CT_EE Signed Number(17,2) DECIMAL(15,2) NOT NULL Employee Social Security contribution
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.