GPES_TAX_LOCATN

(SQL Table)
Index Back

Tax Location Codes

Payroll's Tax Location Table contains the tax location code relating to State/Local tax jurisdictions.

  • Related Language Record: GPES_TAX_LOCLNG
  • # 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 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: EUR

    Prompt Table: CURRENCY_CD_TBL

    7 GPES_MILEAGE_RT Number(6,2) DECIMAL(5,2) NOT NULL Statutory rate for mileage
    8 GPES_MAINT_DOM Number(9,2) DECIMAL(8,2) NOT NULL Statutory rate for domestic maintenance
    9 GPES_MAINT_INTL Number(9,2) DECIMAL(8,2) NOT NULL Statutory rate for non-domestic maintenance
    10 GPES_MAINT_FLG_DOM Number(9,2) DECIMAL(8,2) NOT NULL Domestic flight maintenance
    11 GPES_MAINT_FLG_INT Number(9,2) DECIMAL(8,2) NOT NULL International flight maintenance
    12 GPES_NIGHT_DOM Number(9,2) DECIMAL(8,2) NOT NULL Statutory rate for domestic night stay
    13 GPES_NIGHT_INTL Number(9,2) DECIMAL(8,2) NOT NULL Statutory rate for non-domestic night stay
    14 GPES_PIN_BR1_NUM Number(8,0) INTEGER NOT NULL Bracket Pin Num.

    Prompt Table: GPES_TX_BRK1_VW

    15 GPES_PIN_BR2_NUM Number(8,0) INTEGER NOT NULL Bracket Pin Num.

    Prompt Table: GPES_TX_BRK2_VW

    16 GPES_PIN_BR3_NUM Number(8,0) INTEGER NOT NULL Bracket Pin Num.

    Prompt Table: GPES_TX_BRK3_VW

    17 GPES_MAX_DEPNT_AGE Number(3,0) SMALLINT NOT NULL Maximum dependent age
    18 GPES_IRNR_PCT Number(5,2) DECIMAL(4,2) NOT NULL Non-resident Withholding

    Default Value: 25

    19 GPES_IRNR_EU_PCT Number(5,2) DECIMAL(4,2) NOT NULL European Union Non-resident percentage
    20 GPES_IRNR_MAX_INC Number(11,2) DECIMAL(10,2) NOT NULL European Union Non-resident Maximum Exempt Income
    21 GPES_IRNR_MAX_PCT Number(5,2) DECIMAL(4,2) NOT NULL European Union Non-resident percentage