GPJP_IT_DEP_TAX

(SQL Table)
 Index Back

Contains an EE's dependent tax

This record should contain one record for each of an employee's dependents.

  • Parent record: DEPENDENT_BENEF

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 DEPENDENT_BENEF Character(2) VARCHAR2(2) NOT NULL Dependent Benefit
    01=default
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

    Prompt Table: %GP_EDIT_FLD1

    5 GPJP_IT_SUBJ_DED Character(1) VARCHAR2(1) NOT NULL Dependent Subjected to Deduction Flag

    Y/N Table Edit

    Default Value: N

    6 GPJP_PARENT_LWP Character(1) VARCHAR2(1) NOT NULL Parent Living with Payee

    Y/N Table Edit

    Default Value: N

    7 GPJP_IT_DEPDIS Character(2) VARCHAR2(2) NOT NULL Used in Dependent Tax Data.
    10=No Disability
    20=Disabled
    30=Special Disability
    40=Living with Special Disabled

    Default Value: 10

    8 GPJP_DEP_JOB Character(20) VARCHAR2(20) NOT NULL Dependent Job used in GPJP_IT_DEP_TAX
    9 GPJP_DEP_INC Signed Number(20,6) DECIMAL(18,6) NOT NULL Dependent Annual Income
    10 GPJP_DEP_RCHAN Character(50) VARCHAR2(50) NOT NULL Reason of change
    11 GPJP_DIS_DESCR Character(50) VARCHAR2(50) NOT NULL Disability Description
    12 GPJP_DIS_RCHAN Character(50) VARCHAR2(50) NOT NULL Reason of Disability Change