GPES_TAX_CAL_VW(SQL View) |
Index Back |
|---|---|
Tax Location Calendar ViewTax Location Calendar View |
| SELECT A.GPES_TAX_LOCATION , A.EFFDT , A.PAY_ENTITY , A.GPES_TAX_CALENDAR , B.GPES_MONTHCD , B.GPES_TAX_CALC_RUN , B.GPES_MONTH FROM PS_GPES_TAX_LOC_CL A , PS_GPES_TX_CAL_DTL B WHERE A.GPES_TAX_CALENDAR = B.GPES_TAX_CALENDAR AND B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PS_GPES_TX_CAL_DTL B_ED WHERE B.GPES_TAX_CALENDAR = B_ED.GPES_TAX_CALENDAR AND B_ED.EFFDT <= A.EFFDT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  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. |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | PAY_ENTITY |
Character(10) | VARCHAR2(10) NOT NULL |
Pay Entity
Prompt Table: GP_PYENT1_VW |
| 4 | GPES_TAX_CALENDAR |
Character(3) | VARCHAR2(3) NOT NULL |
Tax calendar. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.
Prompt Table: GPES_TX_CAL_HDR |
| 5 | GPES_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 |
| 6 | GPES_TAX_CALC_RUN | Character(1) | VARCHAR2(1) NOT NULL |
Tax Calculation Process indicator. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.
Y/N Table Edit |
| 7 | GPES_MONTH | Number(2,0) | SMALLINT NOT NULL | Month |