GP_NRP_PYESD_AD

(SQL Table)
Index Back

Payee Section Details

This is the grid for the Payee Section panel. It defines Payee Sections selected on the Panel for each employee.

  • Parent record: GP_PYE_SECTION1
  • # 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    4 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
    5 EFFDT Date(10) DATE Effective Date
    6 SEQ_NUM5 Number(5,0) INTEGER NOT NULL Sequence Number
    7 PIN_ELEM_NUM Number(8,0) INTEGER NOT NULL Element Number
    8 ENTRY_TYPE_SECT Character(3) VARCHAR2(3) NOT NULL Entry (element) type field
    9 RECALC_IND Character(1) VARCHAR2(1) NOT NULL Always Recalculate indicator