GPCH_TX_DATA

(SQL Table)
 Index Back

Source Tax Data CHE

Source Tax Data CHE

  • Parent Record Of GPCH_TX_CANT_VW GPCH_TX_CAN_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    3 EFFDT Date(10) DATE NOT NULL Effective Date
    4 GPCH_TX_CANTON Character(2) VARCHAR2(2) NOT NULL Canton

    Prompt Table: GPCH_TX_CANT_VW

    5 GPCH_TX_VILLAGE_CD Character(4) VARCHAR2(4) NOT NULL Municipality Code

    Prompt Table: GPCH_MCD_VW

    6 CITIZENSHIP_STATUS Character(1) VARCHAR2(1) NOT NULL Citizenship Status

    Default Value: GPCH_CTZN_VW.CITIZENSHIP_STATUS

    Prompt Table: GPCH_CITIZEN_VW

    7 GPCH_TX_EXEMPT_TAX Character(1) VARCHAR2(1) NOT NULL Exempt from Withholding Tax

    Y/N Table Edit

    Default Value: N

    8 EXPIRATN_DT Date(10) DATE Expiration Date
    9 COUNTRY_FROM Character(3) VARCHAR2(3) NOT NULL From Country

    Prompt Table: COUNTRY_TBL

    10 GPCH_TX_TRF_TYPE Character(1) VARCHAR2(1) NOT NULL Tariff Group
    A=A Single Person
    B=B Sole Earner (Married)
    C=C Double Earner
    D=D Secondary Occupation
    K=K Cohabitants GR Only
    L=I1 Spouse Intl Function 0.5 GE
    M=I2 Spouse Intl Function 1.0 GE
    N=I3 Spouse Intl Function 1.5 GE
    O=I4 Spouse Intl Function 2.0 GE
    V=V Double Earner (Female) VD
    11 GPCH_TX_NUM_CHILD Character(1) VARCHAR2(1) NOT NULL Number of Children
    12 GPCH_TX_CHRCH Character(1) VARCHAR2(1) NOT NULL Church Tax
    1=Including Church Tax
    2=Excluding Church Tax
    13 GPCH_TX_TRF_CD Character(10) VARCHAR2(10) NOT NULL Withholding Tax Tariff

    Prompt Table: %RECNAME_EDIT

    14 GPCH_TX_OVRD_TARIF Character(1) VARCHAR2(1) NOT NULL Override Tariff

    Y/N Table Edit

    Default Value: N

    15 GPCH_TX_OVRD_AMT Number(11,4) DECIMAL(10,4) NOT NULL Override Tax Amount
    16 GPCH_TX_OVRD_PCT Number(8,4) DECIMAL(7,4) NOT NULL Override Percent
    17 GPCH_TX_QS_PROVED Character(1) VARCHAR2(1) NOT NULL ST Status Proved

    Y/N Table Edit

    Default Value: N

    18 GPCH_TX_VALID_TODT Date(10) DATE Valid to Date
    19 GPCH_GR_OVRD Character(1) VARCHAR2(1) NOT NULL Override

    Y/N Table Edit

    Default Value: N

    20 GPCH_TX_QS_SW Character(1) VARCHAR2(1) NOT NULL Exempt From Source Tax

    Y/N Table Edit

    Default Value: N

    21 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY

    Prompt Table: CURRENCY_CD_TBL

    22 GPCH_TX_EST_YRLY Number(11,2) DECIMAL(10,2) NOT NULL Estimated yearly income for source tax

    Default Value: 0

    23 GPCH_TX_SPOUSE_WL Character(1) VARCHAR2(1) NOT NULL Indicates whether spouse works in Switzerland. Required for Source Tax GE and TI
    0=No
    1=Works in Switzerland
    2=Works in Geneva
    3=Works outside Switzerland

    Default Value: 0

    24 GPCH_TX_SEX_OVRD Character(1) VARCHAR2(1) NOT NULL Source Tax Gender Override
    F=Female
    M=Male
    25 GPCH_TX_VD_ID Number(9,0) DECIMAL(9) NOT NULL VD SoureTax ID
    26 GPCH_TX_VD_ACT Character(1) VARCHAR2(1) NOT NULL SourceTax Event.
    A=A-Hire
    B=B-Termination
    C=C-Marriage
    D=D-BeginAllowance
    E=E-EndAllowance
    F=F-FTE change
    G=G-separated
    H=H-divorced
    I=I-Death
    27 GPCH_BEGIN_DATE Date(10) DATE Begin Date
    28 FTE_INDICATOR Character(1) VARCHAR2(1) NOT NULL Apply FTE for Annualization

    Y/N Table Edit

    Default Value: N

    29 GPCH_TX_DENOM Character(1) VARCHAR2(1) NOT NULL GP Switzerland Tax Denomination
    0=romanCatholic
    1=christianCatholic
    3=reformedEvangelical
    4=jewishCommunity
    5=otherOrNone
    30 GPCH_TX_SIDEJOB Character(1) VARCHAR2(1) NOT NULL SideJob

    Y/N Table Edit

    31 GPCH_TX_OTHERACT Character(1) VARCHAR2(1) NOT NULL Other
    0=CH
    1=abroad
    2=abroadAndCH
    32 GPCH_TX_ANNUITY Character(1) VARCHAR2(1) NOT NULL Tax Annuity

    Y/N Table Edit

    33 GPCH_TX_CONCUBIN Character(1) VARCHAR2(1) NOT NULL GP Switzerland Tax Concubinage
    0=unknowm
    1=concubinage
    2=no concubinage
    34 GPCH_TX_GRANTCODE Character(1) VARCHAR2(1) NOT NULL GP Switzerland Grant Tax At Source Code
    35 GPCH_TX_FTE_3RD Number(8,6) DECIMAL(7,6) NOT NULL This field represent Full Time Equivalence for Employee in other Company
    36 GPCH_TX_HRLY_LKUP Character(1) VARCHAR2(1) NOT NULL Hourly Full time lookup

    Y/N Table Edit

    37 GPCH_TX_NEW_METHOD Character(2) VARCHAR2(2) NOT NULL Tax method.
    VD=Annual [VD]
    ZH=Monthly [ZH]
    38 GPCH_SING_PAR_FMLY Character(4) VARCHAR2(4) NOT NULL Single Parent Family
    1=No Concubinage
    2=Sole Custody
    3=Share Custody & Higher Income
    4=Adult Child & Higher Income
    39 GPCH_TX_CROSSBORD Character(1) VARCHAR2(1) NOT NULL Hourly Full time lookup
    40 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
    41 GPCH_CB_VALIDASOF Date(10) DATE Canton
    42 GPCH_TX_CB_DAY_CHE Number(3,0) SMALLINT NOT NULL Non-return days (Switzerland)
    43 GPCH_TX_CB_DAY_FRA Number(3,0) SMALLINT NOT NULL Business Trip in France
    44 GPCH_TX_CB_DAY_OTH Number(3,0) SMALLINT NOT NULL Business Trip 3rd Countries
    45 GPCH_TX_CB_PERCENT Number(6,2) DECIMAL(5,2) NOT NULL Teleworking Percentage
    46 COMMENTS Long Character CLOB