GPES_TAX2_R_HST(SQL Table) |
Index Back |
---|---|
Tax Calculation ResultsThis 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 |