GPNZ_RECIPIENT

(SQL Table)
Index Back

Stores extra recipient info

This is used to store additional recipient information for the NZ CE.

  • Parent record: RECIPIENT
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RECIPIENT_ID Character(8) VARCHAR2(8) NOT NULL Payment recipient ID
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 GPNZ_FILE_LAYOUT Character(17) VARCHAR2(17) NOT NULL This is the file layout to be used in creating recipient schedule files.

    Prompt Table: PSFLDDEFN_VW1