GPUS_EE_TAX_OTH

(SQL Table)
 Index Back

Special Tax Other

This record stores at payee level information regarding special tax flags required for the tax calculation.

  • Parent record: EMPLMT_SRCH_GBL

    • # 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

    Default Value: %date

    4 GPUS_TAX_LOC_CD Character(10) VARCHAR2(10) NOT NULL Tax Location

    Prompt Table: GPUS_TAXLOC_TBL

    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    6 GPUS_FICA_EE Character(1) VARCHAR2(1) NOT NULL FICA Status Employee
    D=Deferred
    E=Exempt
    M=Medicare Only
    N=Subject
    7 GPUS_TIP_EE Character(1) VARCHAR2(1) NOT NULL Tipped
    D=Directly Tipped
    I=Indirectly Tipped
    N=Not Tipped

    Default Value: N

    8 GPUS_TAX_RPT_TYPE Character(2) VARCHAR2(2) NOT NULL Tax Report Type
    10=W-2
    20=W-2AS
    30=W-2GU
    40=W-2PR
    50=W-2VI
    60=1099-R
    70=1099-MISC
    9 GPUS_RET_IND Character(1) VARCHAR2(1) NOT NULL Retirement Plan Indicator

    Y/N Table Edit

    Default Value: N