| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
GPAU_PSM_REC_LEN |
Character(3) |
VARCHAR2(3) NOT NULL |
Record Length
|
| 2 |
GPAU_PSM_IDENT |
Character(14) |
VARCHAR2(14) NOT NULL |
Record Idenftifier
|
| 3 |
GPAU_TFN |
Character(9) |
VARCHAR2(9) NOT NULL |
This is the payee's tax file number. This is the payee's unique identification number for tax purposes.
|
| 4 |
GPAU_LAST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Payee Surname
|
| 5 |
GPAU_FIRST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Payee first name
|
| 6 |
GPAU_MIDDLE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Payee middle name
|
| 7 |
GPAU_ADDR1 |
Character(38) |
VARCHAR2(38) NOT NULL |
Street Address - line 1
|
| 8 |
GPAU_ADDR2 |
Character(38) |
VARCHAR2(38) NOT NULL |
Street Address - line 2
|
| 9 |
GPAU_CITY |
Character(27) |
VARCHAR2(27) NOT NULL |
Suburb, town or city
|
| 10 |
GPAU_STATE |
Character(3) |
VARCHAR2(3) NOT NULL |
State
|
| 11 |
GPAU_POSTCD |
Character(4) |
VARCHAR2(4) NOT NULL |
Postcode
|
| 12 |
GPAU_CNTRY |
Character(20) |
VARCHAR2(20) NOT NULL |
Country
|
| 13 |
GPAU_BIRTHDATE |
Date(10) |
DATE |
Payee date of birth
|
| 14 |
GPAU_EE_PAY_DT |
Date(10) |
DATE |
Date of payment
|
| 15 |
GPAU_EE_SRV_DT |
Date(10) |
DATE |
Date Started
|
| 16 |
GPAU_DAYS_PRE83 |
Character(5) |
VARCHAR2(5) NOT NULL |
Number of days before 1 July 1983
|
| 17 |
GPAU_DAYS_POST83 |
Character(5) |
VARCHAR2(5) NOT NULL |
Number of days after 30 June 83
|
| 18 |
GPAU_CGT_EXEMPT |
Character(8) |
VARCHAR2(8) NOT NULL |
CGT except component
|
| 19 |
GPAU_NON_QUAL |
Character(8) |
VARCHAR2(8) NOT NULL |
Non-qualifying component
|
| 20 |
GPAU_PSM_UNDEDUCT |
Character(8) |
VARCHAR2(8) NOT NULL |
Undeducted contribution
|
| 21 |
GPAU_CONCESS |
Character(8) |
VARCHAR2(8) NOT NULL |
Concessional Component
|
| 22 |
GPAU_PSM_ETP_PRE83 |
Character(8) |
VARCHAR2(8) NOT NULL |
Pre July 83 component
|
| 23 |
GPAU_POST83_NT |
Character(8) |
VARCHAR2(8) NOT NULL |
Post June 1983 untaxed component
|
| 24 |
GPAU_POST83_T |
Character(8) |
VARCHAR2(8) NOT NULL |
Post June 1983 taxed component
|
| 25 |
GPAU_ETP_POST94 |
Character(8) |
VARCHAR2(8) NOT NULL |
Post June 1994 invalidity component
|
| 26 |
GPAU_AMENDED_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Amended Payment Summary Indicator
|
| 27 |
GPAU_PSM_ETP_GROSS |
Character(8) |
VARCHAR2(8) NOT NULL |
Gross amount of payment
|
| 28 |
GPAU_PSM_ETP_TAX |
Character(8) |
VARCHAR2(8) NOT NULL |
Total tax withheld
|
| 29 |
GPAU_ETP_ASSESS |
Character(8) |
VARCHAR2(8) NOT NULL |
Asssessable amount
|
| 30 |
GPAU_PSM_DEATH_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Death benefit (Y/N)
|
| 31 |
GPAU_DEATH_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of death benefit (T or O)
|
| 32 |
GPAU_FILLER |
Character(200) |
VARCHAR2(200) NOT NULL |
Report filler
|