| # |
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_BIRTHDATE |
Date(10) |
DATE |
Payee date of birth
|
| 5 |
GPAU_LAST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Payee Surname
|
| 6 |
GPAU_FIRST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Payee first name
|
| 7 |
GPAU_MIDDLE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Payee middle name
|
| 8 |
GPAU_ADDR1 |
Character(38) |
VARCHAR2(38) NOT NULL |
Street Address - line 1
|
| 9 |
GPAU_ADDR2 |
Character(38) |
VARCHAR2(38) NOT NULL |
Street Address - line 2
|
| 10 |
GPAU_CITY |
Character(27) |
VARCHAR2(27) NOT NULL |
Suburb, town or city
|
| 11 |
GPAU_STATE |
Character(3) |
VARCHAR2(3) NOT NULL |
State
|
| 12 |
GPAU_POSTCD |
Character(4) |
VARCHAR2(4) NOT NULL |
Postcode
|
| 13 |
GPAU_CNTRY |
Character(20) |
VARCHAR2(20) NOT NULL |
Country
|
| 14 |
GPAU_PSM_EE_ST_DT |
Date(10) |
DATE |
Period of payment start date
|
| 15 |
GPAU_PSM_EE_END_DT |
Date(10) |
DATE |
Period payment end date
|
| 16 |
GPAU_PSM_TAXWHELD |
Character(8) |
VARCHAR2(8) NOT NULL |
Total tax witheld
|
| 17 |
GPAU_PSM_FRNTAX |
Character(8) |
VARCHAR2(8) NOT NULL |
Foreign Tax Paid
|
| 18 |
GPAU_PSM_GROSSPAY |
Character(8) |
VARCHAR2(8) NOT NULL |
Gross Payments
|
| 19 |
GPAU_GROSS_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Gross Income Type
|
| 20 |
GPAU_LUMPA |
Character(8) |
VARCHAR2(8) NOT NULL |
Lump Sum Payment A
|
| 21 |
GPAU_LUMPD |
Character(8) |
VARCHAR2(8) NOT NULL |
Lump Sum Payment A
|
| 22 |
GPAU_LUMPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Lump Sum Payment E
|
| 23 |
GPAU_LUMPA_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Lump sum A payment indicator
|
| 24 |
GPAU_FBT_EARNS |
Character(8) |
VARCHAR2(8) NOT NULL |
Reportable Fringe Benefits
|
| 25 |
GPAU_PSM_ERSC |
Character(8) |
VARCHAR2(8) NOT NULL |
Reportable Super Contributions
|
| 26 |
GPAU_AMENDED_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Amended Payment Summary Indicator
|
| 27 |
GPAU_FILLER |
Character(200) |
VARCHAR2(200) NOT NULL |
Report filler
|