GPGB_PSPPX_NRVW

(SQL View)
Index Back

Payslip Defn.-- P/T D NPR View

UK Payslip Definition -- Pre-Tax Deductions

SELECT GPGB_PSLIP_ID , EFFDT , GPGB_ELE_ORDER , GPGB_PSLIP_DESCR , ENTRY_TYPE_ELEM2 , GPGB_PSLIP_DETAIL , ENTRY_TYPE_ELEM , GPGB_PIN_CODE_CUR , GPGB_PIN_NUM_CUR + 50000000 , GPGB_PIN_CODE_YTD , GPGB_PIN_NUM_YTD + 50000000 FROM PS_GPGB_PSLIP_PTXD

  • Parent record: GPGB_PSLIP_HDR
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPGB_PSLIP_ID Character(6) VARCHAR2(6) NOT NULL Payslip ID

    Prompt Table: GPGB_PSLIP_HDR

    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 GPGB_ELE_ORDER Number(6,0) INTEGER NOT NULL Payslip Element Order
    4 GPGB_PSLIP_DESCR Character(15) VARCHAR2(15) NOT NULL Payslip Description
    5 ENTRY_TYPE_ELEM2 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field
    6 GPGB_PSLIP_DETAIL Number(8,0) INTEGER NOT NULL Payslip detail Pin
    7 ENTRY_TYPE_ELEM Character(3) VARCHAR2(3) NOT NULL entry type element

    Prompt Table: GP_ENT_NUMER_VW

    8 GPGB_PIN_CODE_CUR Character(21) VARCHAR2(21) NOT NULL Pin Code Current Value
    9 GPGB_PIN_NUM_CUR Number(8,0) INTEGER NOT NULL Pin Number Current Value

    Prompt Table: %GP_EDIT_FLD1

    10 GPGB_PIN_CODE_YTD Character(21) VARCHAR2(21) NOT NULL Pin Code Year to Date
    11 GPGB_PIN_NUM_YTD Number(8,0) INTEGER NOT NULL Pin Number Year to Date

    Prompt Table: GP_PIN_AC0_VW