GPJP_CM_PYE_DTA

(SQL Table)
 Index Back

Commutation Allowance Personal

This record will be used to store Commutation Allowance items for each employee.

  • Related Language Record: GPJP_CM_PYE_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 GPJP_DAT_INPUT_MTH Character(2) VARCHAR2(2) NOT NULL Select input by Commuting Route Section or Input Total Amount.
    10=Route Section Entry
    20=Total Amount Entry

    Default Value: 10

    5 GPJP_PAY_CYCLE Character(2) VARCHAR2(2) NOT NULL Pay Cycle. Translate Values: '10' - '1 Day' '20' - '1 Month' '30' - '3 Months' '40' - '6 Months'
    10=1 Day
    20=1 Month
    30=3 Months
    40=6 Months
    6 GPJP_CASH_FARE_AMT Number(7,0) INTEGER NOT NULL Amount Of Cash Fare.
    7 GPJP_CASH_FARE_RMK Character(50) VARCHAR2(50) NOT NULL Remark Of Cash Fare.
    8 GPJP_CASH_TOLL_AMT Number(7,0) INTEGER NOT NULL Amount Of Cash Toll.
    9 GPJP_CASH_TOLL_RMK Character(50) VARCHAR2(50) NOT NULL Remark Of Cash Toll.
    10 GPJP_NCSH_FARE_AMT Number(7,0) INTEGER NOT NULL Amount Of Non-Cash Fare.
    11 GPJP_NCSH_FARE_RMK Character(50) VARCHAR2(50) NOT NULL Remark Of Non-Cash Fare.
    12 GPJP_NCSH_TOLL_AMT Number(7,0) INTEGER NOT NULL Amount Of Non-Cash Toll.
    13 GPJP_NCSH_TOLL_RMK Character(50) VARCHAR2(50) NOT NULL Remark Of Non-Cash Toll.
    14 GPJP_MAX_NTAX_TOLL Number(7,0) INTEGER NOT NULL Maximum Non-Taxable Toll.
    15 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: JPY

    Prompt Table: CURRENCY_CD_TBL