GPJP_IH_PYE_TAX

(SQL Table)
 Index Back

Employee Inhabitant Tax data

This record should contain one record for each employee paying Inhabitant Tax.

  • Parent record: PERSON

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 MUNICIPAL_CD_JPN Character(6) VARCHAR2(6) NOT NULL Japanese Municipal Code

    Prompt Table: GPJP_IH_MUNIC

    4 GPJP_RECIPIENT_NBR Character(25) VARCHAR2(25) NOT NULL Used in Inhabitant Tax Data for GP/Japan

    Default Value: GPJP_IH_PYE_TAX.EMPLID

    5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

    Prompt Table: %GP_EDIT_FLD1

    6 GPJP_INDIV_NBR Character(5) VARCHAR2(5) NOT NULL Individual Number
    7 GPJP_SPEC_COL_AMT Number(19,6) DECIMAL(18,6) NOT NULL Special Collection Tax
    8 GPJP_MTH_COL_HIR Character(2) VARCHAR2(2) NOT NULL Previous Employment Last Month
    01=January
    02=February
    03=March
    04=April
    05=May
    06=June
    07=July
    08=August
    09=September
    10=October
    11=November
    12=December

    Prompt Table: GPJP_MTH_COL_VW

    9 GPJP_CHANGED_MTH Number(2,0) SMALLINT NOT NULL Month Of Change In Salary.
    10 GPJP_DESCR Character(120) VARCHAR2(120) NOT NULL This field is used in file layouts to store constant values.