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 Record

    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_NO_RSDNT_RLTV Character(1) VARCHAR2(1) NOT NULL Non-Resident Relative indicator

    Y/N Table Edit

    Default Value: N

    11 GPJP_FCT_UNFY_LVNG Signed Number(20,6) DECIMAL(18,6) NOT NULL The fact unifying a living
    12 GPJP_DEP_RCHAN Character(50) VARCHAR2(50) NOT NULL Reason of change
    13 GPJP_DIS_DESCR Character(50) VARCHAR2(50) NOT NULL Disability Description
    14 GPJP_DIS_RCHAN Character(50) VARCHAR2(50) NOT NULL Reason of Disability Change
    15 GPJP_INC_AMT_DED Character(1) VARCHAR2(1) NOT NULL Subject to Income Amount Deduction
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    16 GPJP_NON_RSDT_TYPE Character(2) VARCHAR2(2) NOT NULL Non-Resident Type
    10=Between 16 and 29 or Over 70
    20=Studying abroad
    30=Disabled
    40=Payment of 380000 yen or above
    17 GPJP_EST_ANNUL_INC Signed Number(20,6) DECIMAL(18,6) NOT NULL Estimated annual income excluding retirement allowance amount
    18 GPJP_RETIR_ALLWNCE Character(1) VARCHAR2(1) NOT NULL Has Retiremet Allowance
    N=No
    Y=Yes