GPAU_VOL_AGREE(SQL Table) |
Index Back |
---|---|
Voluntary AgreementVoluntary 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 |