| # |
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 |
GPAU_GRP_TAX_RCPNT |
Character(1) |
VARCHAR2(1) NOT NULL |
This is used for the Group Tax Receipient processing.
Y/N Table Edit
Default Value: N
|
| 4 |
GPAU_FILE_LAYOUT |
Character(30) |
VARCHAR2(30) NOT NULL |
This is the file layout that is used for CEMTEX processing.
Prompt Table:
PSFLDDEFN_VW1
|
| 5 |
GPAU_SENDERID |
Character(30) |
VARCHAR2(30) NOT NULL |
GPAUS - Stores the ID of the Sender for SuperEC processing.
|
| 6 |
EMAIL_ADDR |
Character(70) |
VARCHAR2(70) NOT NULL |
Email Address
|
| 7 |
GPAU_CONTACT_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
This is the contact person for reporting requirements.
Prompt Table:
PERSON_NAME
Set Control Field: NAME
|
| 8 |
COUNTRY_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Country Code
|
| 9 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
|
| 10 |
GPAU_FAX_NO |
Character(15) |
VARCHAR2(15) NOT NULL |
Supplier Fax No
|
| 11 |
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.
|
| 12 |
GPAU_EMAIL_ADDR |
Character(76) |
VARCHAR2(76) NOT NULL |
Supplier E-mail address
|
| 13 |
GPAU_TARGETFUNDSFN |
Number(9,0) |
DECIMAL(9) NOT NULL |
GPAUS - Stores the target Superannuation Fund's Super Fund Number. Used in SuperEC processing.
|
| 14 |
GPAU_TARGETFUNDABN |
Number(11,0) |
DECIMAL(11) NOT NULL |
GPAUS - Stores the target Superannuation Fund's Australian Business Number. Used in SuperEC processing.
|
| 15 |
GPAU_TARGTPRODID |
Character(14) |
VARCHAR2(14) NOT NULL |
GPAUS - Stores the target Superannuation Fund's Product ID. Used in SuperEC processing.
|
| 16 |
GPAU_TGTFUNDNAME |
Character(76) |
VARCHAR2(76) NOT NULL |
Target Fund Name used on SuperEC Detail page.
|
| 17 |
GPAU_SFA_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
GPAUS - Used to identify Deduction Recipients who are also Super Fund Administrators. Used in SuperEC processing.
|
| 18 |
GPAU_SUPEREC_FMT |
Character(1) |
VARCHAR2(1) NOT NULL |
This flag indicates whether a GP AUS Superannuation reporting file should be produced in SuperEC (XML) or ComSuper (flat text) format. This depends on the Super Fund that is being reported to. If the Super Fund is ComSuper, the file format should be the ComSuper file format. For all other Superannuation Fund, the format should be SuperEC format.
A=Agest
C=ComSuper File Format
D=SuperStream File Format
S=SuperEC File Format
|
| 19 |
GPAU_COMSUPR_AGCY |
Character(20) |
VARCHAR2(20) NOT NULL |
GPAUS - Stores the Scheme ID for ComSuper Employees - CSS or PSS.
|
| 20 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 21 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 22 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 23 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 24 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 25 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 26 |
NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 27 |
NUM2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2
|
| 28 |
HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type
AB=House Boat Reference
WW=House Trailer Reference
|
| 29 |
ADDR_FIELD1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Address Field 1
|
| 30 |
ADDR_FIELD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 2
|
| 31 |
ADDR_FIELD3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 3
|
| 32 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 33 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TBL
|
| 34 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 35 |
GEO_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code
|
| 36 |
IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit
|
| 37 |
GPAU_PYMT_METHOD |
Character(2) |
VARCHAR2(2) NOT NULL |
Payment Method
01=BPAY
02=DirectCredit
03=DirectDebit
|
| 38 |
GPAU_TGT_FUND_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Target Fund Indicator
Y/N Table Edit
Default Value: N
|
| 39 |
GPAU_RECEIVER_NAME |
Character(76) |
VARCHAR2(76) NOT NULL |
Receiver Name
|
| 40 |
GPAU_RECEIVER_ABN |
Character(11) |
VARCHAR2(11) NOT NULL |
Receiver ABN
|
| 41 |
GPAU_BILLER_CODE |
Character(20) |
VARCHAR2(20) NOT NULL |
BPAY Biller Code
|
| 42 |
GPAU_TARGET_URL |
Character(254) |
VARCHAR2(254) NOT NULL |
E-service address used in SuperStream reporting
|
| 43 |
GPAU_PYENT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Pay Entity Indicator
Y/N Table Edit
Default Value: N
|
| 44 |
GPAU_SENDER_NAME |
Character(76) |
VARCHAR2(76) NOT NULL |
Sender Name
|
| 45 |
GPAU_ERROR_ENABLED |
Character(1) |
VARCHAR2(1) NOT NULL |
Error handling enabled indicator
Y/N Table Edit
Default Value: N
|
| 46 |
GPAU_SENDER_URL |
Character(254) |
VARCHAR2(254) NOT NULL |
Sender E-Service Address
|
| 47 |
GPAU_SENDER_ABN |
Character(11) |
VARCHAR2(11) NOT NULL |
Sender ABN
|
| 48 |
GPAU_SS_CSS_RPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable SuperStream for ComSuper Reporting
Y/N Table Edit
Default Value: Y
|