| # |
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_PRV_LAST_NM |
Character(30) |
VARCHAR2(30) NOT NULL |
Payee previous surname
|
| 8 |
GPAU_PRV_FIRST_NM |
Character(30) |
VARCHAR2(30) NOT NULL |
Payee previous surname
|
| 9 |
GPAU_PRV_MIDDLE_NM |
Character(15) |
VARCHAR2(15) NOT NULL |
Payee previous middle name
|
| 10 |
GPAU_BIRTHDATE |
Date(10) |
DATE |
Payee date of birth
|
| 11 |
GPAU_ADDR1 |
Character(38) |
VARCHAR2(38) NOT NULL |
Street Address - line 1
|
| 12 |
GPAU_ADDR2 |
Character(38) |
VARCHAR2(38) NOT NULL |
Street Address - line 2
|
| 13 |
GPAU_CITY |
Character(27) |
VARCHAR2(27) NOT NULL |
Suburb, town or city
|
| 14 |
GPAU_STATE |
Character(3) |
VARCHAR2(3) NOT NULL |
State
|
| 15 |
GPAU_POSTCD |
Character(4) |
VARCHAR2(4) NOT NULL |
Postcode
|
| 16 |
GPAU_CNTRY |
Character(20) |
VARCHAR2(20) NOT NULL |
Country
|
| 17 |
GPAU_TFN_EMPLID |
Character(21) |
VARCHAR2(21) NOT NULL |
Payee payroll number
|
| 18 |
GPAU_TFN_TERM_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Payee terminated indicator
|
| 19 |
GPAU_RES_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Payee residency status
|
| 20 |
GPAU_TAX_SCALE |
Character(3) |
VARCHAR2(3) NOT NULL |
This is used to identify the rates, thresholds, and other factors that will be used in the calculation of the payee's tax.
|
| 21 |
GPAU_TFN_PAY_BASIS |
Character(1) |
VARCHAR2(1) NOT NULL |
Basis of payment
|
| 22 |
GPAU_TXFRE_CLAIMED |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax free treshold claimed
|
| 23 |
GPAU_FAMTX_CLAIMED |
Character(1) |
VARCHAR2(1) NOT NULL |
Family Tax benefit claimed
|
| 24 |
GPAU_SPCLRBT_CLAIM |
Character(1) |
VARCHAR2(1) NOT NULL |
Zone, dependent or special rebates claimed
|
| 25 |
GPAU_TFN_HECS_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
HECS Indicator
|
| 26 |
GPAU_STDNT_LOAN |
Character(1) |
VARCHAR2(1) NOT NULL |
Student Loan Indicator
|
| 27 |
GPAU_TFN_FOR_SUPN |
Character(1) |
VARCHAR2(1) NOT NULL |
Use of TFN for superannuation
|
| 28 |
GPAU_SUPN_RBT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Superannuation Pension/Annuity Rebate Indicator
|
| 29 |
GPAU_PAYEE_SIGN |
Character(1) |
VARCHAR2(1) NOT NULL |
Payee signature present
|
| 30 |
GPAU_TFN_DECL_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Date declaration signed by Payee
|
| 31 |
GPAU_EMAIL_ADDR |
Character(76) |
VARCHAR2(76) NOT NULL |
Supplier E-mail address
|
| 32 |
GPAU_FILLER |
Character(200) |
VARCHAR2(200) NOT NULL |
Report filler
|