| # |
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_SENDTRANSDATE |
DateTime(26) |
TIMESTAMP |
GPAUS - Unique reference used in SuperEC processing to identify the message file to the receiver and the sender.
|
| 4 |
GPAU_INTERCHANGEID |
Character(30) |
VARCHAR2(30) NOT NULL |
GPAUS - Used as an identifier on a SuperEC message file.
|
| 5 |
GPAU_RECEIVERID |
Character(30) |
VARCHAR2(30) NOT NULL |
GPAUS - Stores the ID of the Super Fund Administrator that is to receive a SuperEC message file.
|
| 6 |
GPAU_ACKREQUEST |
Character(1) |
VARCHAR2(1) NOT NULL |
GPAUS - Indicator for SuperEC processing. When checked it means that the sender wishes to receive an acknowledgement after a SuperEC message file is sent.
|
| 7 |
GPAU_TESTINDICATOR |
Character(1) |
VARCHAR2(1) NOT NULL |
GPAUS - Indicates if a SuperEC message file is a test file only. Used in SuperEC processing.
|
| 8 |
GPAU_MSGRELEASE |
Character(30) |
VARCHAR2(30) NOT NULL |
GPAUS - stores the SuperEC release number during SuperEC processing.
|
| 9 |
GPAU_NOMSGHEADER |
Number(1,0) |
SMALLINT NOT NULL |
GPAUS - Stores the number of Header records in the SuperEC messages file. Should usually only be 1 in each file.
|
| 10 |
GPAU_TOTAL_PYMENT |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
GPAUS - Stores the total SuperEC payment amount for all employees in the period just processed.
|