GP_NRP_PYES1_AD

(SQL Table)
Index Back

Payee Section 1

This record is a child to Payee Section, setting an Effective Date with each Payee Pin Number.

  • Parent record: GP_PYE_SECTION
  • # 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 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive