GPGB_PSPBS_NRAD

(SQL Table)
Index Back

Payslip Defn. -- Balances

UK Payslip Definition -- Balance Accumulators

  • Parent record: GPGB_PSLIP_HDR
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GP_PKG_ID Character(10) VARCHAR2(10) NOT NULL Field used for element packaging
    2 GPGB_PSLIP_ID Character(6) VARCHAR2(6) NOT NULL Payslip ID
    3 EFFDT Date(10) DATE Effective Date
    4 GPGB_ELE_ORDER Number(6,0) INTEGER NOT NULL Payslip Element Order
    5 GPGB_PSLIP_DESCR Character(15) VARCHAR2(15) NOT NULL Payslip Description
    6 ENTRY_TYPE_ELEM2 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field
    7 GPGB_PSLIP_DETAIL Number(8,0) INTEGER NOT NULL Payslip detail Pin
    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
    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
    12 GPGB_PSLIP_UK2_ALL Character(1) VARCHAR2(1) NOT NULL Display All Occurences User K2
    13 GPGB_PSLIP_UK2_DIS Character(1) VARCHAR2(1) NOT NULL Display User Key2