GP_PYE_SECT_DTL

(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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    3 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 SEQ_NUM5 Number(5,0) INTEGER NOT NULL Sequence Number
    6 PIN_ELEM_NUM Number(8,0) INTEGER NOT NULL Element Number

    Prompt Table: %RECNAME_EDIT

    7 ENTRY_TYPE_SECT Character(3) VARCHAR2(3) NOT NULL Entry (element) type field

    Prompt Table: GP_ENTRY_TYPE

    8 RECALC_IND Character(1) VARCHAR2(1) NOT NULL Always Recalculate indicator

    Y/N Table Edit

    Default Value: N