GPAU_NRP_RC2_AD

(SQL Table)
Index Back

Recipient Payee Sibling Rcd

This is the recipient payee sibling record.

# 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 RECIPIENT_ID Character(8) VARCHAR2(8) NOT NULL Payment recipient ID
5 EFFDT Date(10) DATE Effective Date
6 GPAU_MEMBER_ID Character(18) VARCHAR2(18) NOT NULL The Membership Group ID is required for the file generated by GPAU_RCPFILE.
7 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
8 GPAU_MBR_TYP Character(1) VARCHAR2(1) NOT NULL GPAUS - Stores the superannuation membership type for an employee - usually Spouse or Employee.
E=Employee Membership ID
S=Spouse Membership ID
9 GPAU_COMSUPER_FUND Character(1) VARCHAR2(1) NOT NULL GP AUS - Stores the ComSuper Fund name for Super Contribution reporting for Aus Public Service customers who need to report contributions in ComSuper file format.
A=Public Sector Super Fund Accum
C=Commonwealth Super Scheme
P=Public Sector Super Fund