GPAU_NRP_PT4_VW

(SQL View)
 Index Back

SPT Grossed up FBT

This table is for the maintenance of FBT elements to be grossed up.

SELECT PAYROLL_STATE_AUS ,EFFDT ,GPAU_VAL_TYPE ,PIN_NUM + 50000000 ,EXPENSE_CD FROM PS_GPAU_SPT_FBT

  • Parent record: GPAU_SPT_ST_HDR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PAYROLL_STATE_AUS Character(3) VARCHAR2(3) NOT NULL Sal Package - Payroll Tax State

    Prompt Table: GPAU_STATES_VW

    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 GPAU_VAL_TYPE Character(2) VARCHAR2(2) NOT NULL Used in State Payroll Tax processing to determine whether an element is an Earnings, Deduction, or Expense.
    DD=Deduction
    ER=Earnings
    EX=Expense
    4 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

    Prompt Table: GPAU_DED_SRCH

    5 EXPENSE_CD Character(2) VARCHAR2(2) NOT NULL Expense code.
    01=Airfare
    02=Lodging
    03=Car Rental
    04=Meals
    05=Telephone
    06=Travel
    07=Relocation
    08=Entertainment
    09=Parking
    10=Mileage
    11=Advertising
    12=Referral Fee
    13=Postage
    14=Publication
    15=Membership
    16=Miscellaneous
    17=Staff Time
    18=Job Boards
    19=Pre-Employment Request