GPES_TA2_RST_VW(SQL View) |
Index Back |
|---|---|
Tax resultsTax results to generate 190 record type 02. |
| SELECT A.EMPLID ,A.COMPANY ,A.GPES_TAX_LOCATION ,A.GPES_YEAR ,A.GPES_FISCAL_KEY ,A.GPES_FISCAL_SUBKEY ,MIN(A.EMPL_RCD ) ,A.GPES_YEAR_RETRO ,MAX(B.FIRST_NAME) ,MAX(B.LAST_NAME) ,MAX(B.SECOND_LAST_NAME) , SUM (A.GPES_SALARY_INCOME+ A.GPES_SAL_INC_ADJ + A.GPES_TAX_INC_VR1 + A.GPES_TAX_INC_VR2 + A.GPES_TAX_INC_VR3 + A.GPES_TAX_INCVR_ADJ) , SUM (A.GPES_SALARY_WITHLD+ A.GPES_SAL_WITH_ADJ) ,SUM(A.GPES_INKIND_INCOME+A.GPES_INK_INC_ADJ) ,SUM(A.GPES_INKIND_WITHLD+A.GPES_INK_WITH_ADJ) ,SUM(A.GPES_INK_WITHLD_EE+A.GPES_INKWITHEE_ADJ) ,SUM(A.GPES_REDUCTIONS+GPES_REDCTIONS_ADJ) ,SUM(A.GPES_GARN_SPOUSE+A.GPES_GARN_SPSE_ADJ) ,SUM(A.GPES_GARN_CHILDREN+A.GPES_GARN_CHLD_ADJ) ,SUM(A.GPES_SSTC_CT_EE+A.GPES_SS_CT_EE_ADJ) ,MAX(A.GPES_CHK_SEND) ,MAX(A.GPES_CEUTA_MELILLA) ,MAX(A.CURRENCY_CD) FROM PS_GPES_TAX2_RSLT A , PS_PERSON_NAME B WHERE A.EMPLID = B.EMPLID AND %Sql(GPES_TX_MAX_VER_REV_NUM, PS_GPES_TAX2_RSLT, A) GROUP BY A.EMPLID ,A.COMPANY ,A.GPES_TAX_LOCATION,A.GPES_YEAR ,A.GPES_YEAR_RETRO ,A.GPES_FISCAL_KEY ,A.GPES_FISCAL_SUBKEY HAVING SUM (A.GPES_SALARY_INCOME+ A.GPES_SAL_INC_ADJ + A.GPES_TAX_INC_VR1 + A.GPES_TAX_INC_VR2 + A.GPES_TAX_INC_VR3 + A.GPES_TAX_INCVR_ADJ) + SUM (A.GPES_SALARY_WITHLD+ A.GPES_SAL_WITH_ADJ) + SUM(A.GPES_INKIND_INCOME+A.GPES_INK_INC_ADJ) + SUM(A.GPES_INKIND_WITHLD+A.GPES_INK_WITH_ADJ) + SUM(A.GPES_INK_WITHLD_EE+A.GPES_INKWITHEE_ADJ) + SUM(A.GPES_REDUCTIONS+GPES_REDCTIONS_ADJ) + SUM(A.GPES_GARN_SPOUSE+A.GPES_GARN_SPSE_ADJ) + SUM(A.GPES_GARN_CHILDREN+A.GPES_GARN_CHLD_ADJ) + SUM(A.GPES_SSTC_CT_EE+A.GPES_SS_CT_EE_ADJ) <> 0 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: GPES_EMP_ORG_VW |
| 2 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 3 | 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 |
| 4 | GPES_YEAR |
Number(4,0) | SMALLINT NOT NULL | Year |
| 5 | GPES_FISCAL_KEY |
Character(2) | VARCHAR2(2) NOT NULL |
Fiscal key. Used to identify the earnings.
Prompt Table: GPES_PERCEP_KEY |
| 6 | GPES_FISCAL_SUBKEY |
Character(2) | VARCHAR2(2) NOT NULL |
Fiscal sub-key. Used to identify the earnings.
Prompt Table: GPES_PERCP_SKEY |
| 7 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 8 | GPES_YEAR_RETRO | Number(4,0) | SMALLINT NOT NULL | Year Retro |
| 9 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 10 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 11 | SECOND_LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Second Last Name |
| 12 | GPES_SALARY_INCOME | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Salary Income. |
| 13 | GPES_SALARY_WITHLD | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Salary Withholding. |
| 14 | GPES_INKIND_INCOME | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Total amount earned as in kind income. |
| 15 | GPES_INKIND_WITHLD | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Contribution (payee + employer) as in-kind withholding. |
| 16 | GPES_INK_WITHLD_EE | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Contribution (payee) as in-kind withholding. |
| 17 | GPES_REDUCTIONS | Number(16,2) | DECIMAL(15,2) NOT NULL | Taxes reductions |
| 18 | GPES_GARN_SPOUSE | Number(16,2) | DECIMAL(15,2) NOT NULL | Amount paid by the payee in concept of garnishment for spouse alimony. |
| 19 | GPES_GARN_CHILDREN | Number(16,2) | DECIMAL(15,2) NOT NULL | Amount paid by the payee in concept of garnishment for children alimony. |
| 20 | GPES_SS_CT_EE | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Employee Social Security contribution |
| 21 | GPES_CHK_SEND | Character(1) | VARCHAR2(1) NOT NULL |
Sent
Y/N Table Edit |
| 22 | 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 |
| 23 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |