GPAU_VOL_AGREE

(SQL Table)
Index Back

Voluntary Agreement

Voluntary Agreement details for Contractors

# 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_EE_ABN Character(11) VARCHAR2(11) NOT NULL Payee ABN
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_WRATE Character(5) VARCHAR2(5) NOT NULL Withholding rate
18 GPAU_PSM_GROSSPAY Character(8) VARCHAR2(8) NOT NULL Gross Payments
19 GPAU_FILLER Character(200) VARCHAR2(200) NOT NULL Report filler