GPES_TAX2_R_HST

(SQL Table)
Index Back

Tax Calculation Results

This is the Archive (shadow) table used in Data Archiving for the record: GPES_TAX2_RSLT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: GPES_EMP_ORG_VW

4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

Prompt Table: EMPLOYMENT

5 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
6 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
7 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
8 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID
9 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
10 EFFDT Date(10) DATE Effective Date

Default Value: %date

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

Prompt Table: COMPANY_TBL

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

Prompt Table: GPES_TAX_LOCATN

13 GPES_YEAR Number(4,0) SMALLINT NOT NULL Year
14 GPES_MONTH Number(2,0) SMALLINT NOT NULL Month
15 GPES_YEAR_RETRO Number(4,0) SMALLINT NOT NULL Year Retro
16 GPES_FISCAL_KEY Character(2) VARCHAR2(2) NOT NULL Fiscal key. Used to identify the earnings.

Prompt Table: GPES_PERCEP_KEY

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

Prompt Table: GPES_PERCP_SKEY

18 GPES_TAX_TYPE Character(1) VARCHAR2(1) NOT NULL Field to differentiate the special row with the refunded amount (RD 2/2008, 21 April) of the normal rows in month of June 2008.
R=Regular Payrolls
Z=RD Law 2/2008

Default Value: R

19 GPES_MONTH_RETRO Number(2,0) SMALLINT NOT NULL Retroactivity Month
20 STATE Character(6) VARCHAR2(6) NOT NULL State
21 GPES_SALARY_INCOME Signed Number(17,2) DECIMAL(15,2) NOT NULL Salary Income.
22 GPES_TAX_INC_VR1 Signed Number(17,2) DECIMAL(15,2) NOT NULL Variable income paid during last year in the same period of time (Historical Rule)
23 GPES_TAX_INC_VR2 Signed Number(17,2) DECIMAL(15,2) NOT NULL Variable income for the whole of the previous year.
24 GPES_TAX_INC_VR3 Signed Number(17,2) DECIMAL(15,2) NOT NULL Variable Income entered through Earnings & Deduction assignment.
25 GPES_SALARY_WITHLD Signed Number(17,2) DECIMAL(15,2) NOT NULL Salary Withholding.
26 GPES_INKIND_INCOME Signed Number(17,2) DECIMAL(15,2) NOT NULL Total amount earned as in kind income.
27 GPES_INKIND_WITHLD Signed Number(17,2) DECIMAL(15,2) NOT NULL Contribution (payee + employer) as in-kind withholding.
28 GPES_INK_WITHLD_EE Signed Number(17,2) DECIMAL(15,2) NOT NULL Contribution (payee) as in-kind withholding.
29 GPES_REDUCTIONS Number(16,2) DECIMAL(15,2) NOT NULL Taxes reductions
30 GPES_GARN_SPOUSE Number(16,2) DECIMAL(15,2) NOT NULL Amount paid by the payee in concept of garnishment for spouse alimony.
31 GPES_GARN_CHILDREN Number(16,2) DECIMAL(15,2) NOT NULL Amount paid by the payee in concept of garnishment for children alimony.
32 GPES_SSTC_CT_EE Signed Number(17,2) DECIMAL(15,2) NOT NULL Employee Social Security Contributions. This field is used to populate the GP Write Array, which is used to generate the FAN File.
33 GPES_SAL_INC_ADJ Signed Number(16,2) DECIMAL(14,2) NOT NULL Salary Income Adjust
34 GPES_TAX_INCVR_ADJ Signed Number(16,2) DECIMAL(14,2) NOT NULL Variable Income Adjust
35 GPES_SAL_WITH_ADJ Signed Number(16,2) DECIMAL(14,2) NOT NULL Salary Withhold Adjust
36 GPES_INK_INC_ADJ Signed Number(16,2) DECIMAL(14,2) NOT NULL In Kind Income Adjust
37 GPES_INK_WITH_ADJ Signed Number(16,2) DECIMAL(14,2) NOT NULL In Kind Withhold Adjust
38 GPES_INKWITHEE_ADJ Signed Number(16,2) DECIMAL(14,2) NOT NULL EE In Kind Withhold Adjustment
39 GPES_REDCTIONS_ADJ Signed Number(16,2) DECIMAL(14,2) NOT NULL Reductions Adjust
40 GPES_GARN_SPSE_ADJ Signed Number(16,2) DECIMAL(14,2) NOT NULL Spouse Support Adjust
41 GPES_GARN_CHLD_ADJ Signed Number(16,2) DECIMAL(14,2) NOT NULL Children Support Adjust
42 GPES_SS_CT_EE_ADJ Signed Number(16,2) DECIMAL(14,2) NOT NULL Social Security Adjust
43 GPES_CHK_SEND Character(1) VARCHAR2(1) NOT NULL Sent

Y/N Table Edit

44 GPES_CEUTA_MELILLA Character(1) VARCHAR2(1) NOT NULL Payee is working in Spanish cities Ceuta or Melilla. This cities has a special tax status.

Y/N Table Edit

45 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
46 RSLT_VER_NUM Number(4,0) SMALLINT NOT NULL Result Version Number
47 RSLT_REV_NUM Number(4,0) SMALLINT NOT NULL Result Revision Number