GPAU_SUPHDR_TMP

(SQL Table)
Index Back

GPAU - SuperEC Super Header

This temporary table stores information about the Sender of the SuperEC message file. The details will be written the SuperEC message file.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 RECIPIENT_ID Character(8) VARCHAR2(8) NOT NULL Payment recipient ID
3 GPAU_TARGTPRODID Character(14) VARCHAR2(14) NOT NULL GPAUS - Stores the target Superannuation Fund's Product ID. Used in SuperEC processing.
4 GPAU_TGTFUNDNAME Character(76) VARCHAR2(76) NOT NULL Target Fund Name used on SuperEC Detail page.
5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 GPAU_SENDTRANSREF Number(15,0) DECIMAL(15) NOT NULL GPAUS - Unique reference used in SuperEC processing to identify the SuperEC message file to both the sender and receiver.
7 GPAU_SENDERTRNCRDT Date(10) DATE GPAUS - Sender Transaction Create Date. Used in SuperEC processing,
8 GPAU_SNDRTRANSFUNC Character(1) VARCHAR2(1) NOT NULL GPAUS - Flag to indicate if the SuperEC message file to be created is a replacement for a file with errors.
9 GPAU_NUMBEROFMSGS Number(3,0) SMALLINT NOT NULL Number of Messages