GPES_TAX110_VW(SQL View) |
Index Back |
|---|---|
111 Tax Accumulators per EE111 Tax Accumulators per EE |
| SELECT A.PIN_NUM , A.EMPLID , A.ACM_THRU_DT , %Substring(A.USER_KEY1, 1, 3) , %Substring(A.USER_KEY2, 1, 5) , A.PIN_NM , D.GPES_PINS110 , C.CALYEAR , C.MONTHCD , A.CALC_RSLT_VAL FROM PS_GP_RSLT_ACUM_VW A , PS_GPES_TAX110_SET D , PS_ABSENCE_CAL C , PS_GP_CAL_RUN_DTL E WHERE A.PIN_NUM = D.PIN_NUM AND A.SLICE_END_DT BETWEEN C.ABS_MONTH_START_DT AND C.ABS_MONTH_END_DT AND A.CAL_ID = E.CAL_ID AND A.CAL_RUN_ID = A.ORIG_CAL_RUN_ID AND E.CAL_SEQ_NUM = ( SELECT MAX (F.CAL_SEQ_NUM) FROM PS_GP_CAL_RUN_DTL F WHERE F.CAL_RUN_ID = A.CAL_RUN_ID AND F.GP_PAYGROUP = A.GP_PAYGROUP) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PIN_NUM |
Number(8,0) | INTEGER NOT NULL | PIN Number |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | ACM_THRU_DT |
Date(10) | DATE | Through Date |
| 4 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 5 | 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. |
| 6 | PIN_NM | Character(18) | VARCHAR2(18) NOT NULL | Element Name field |
| 7 | GPES_PINS110 | Character(3) | VARCHAR2(3) NOT NULL |
Elements to be printed in report Model-110
001=Salary Income 002=Salary Withholding 003=In Kind Income 004=In Kind Withholding |
| 8 | CALYEAR | Number(4,0) | SMALLINT NOT NULL | Year |
| 9 | MONTHCD | Character(2) | VARCHAR2(2) NOT NULL |
Month
01=01 - January 02=02 - February 03=03 - March 04=04 - April 05=05 - May 06=06 - June 07=07 - July 08=08 - August 09=09 - September 10=10 - October 11=11 - November 12=12 - December |
| 10 | CALC_RSLT_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Calculation Numeric Result |