| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 3 |
CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Calendar Run Id
|
| 4 |
CAL_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
calendar id
|
| 5 |
ORIG_CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Original Calendar Group ID
|
| 6 |
GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
|
| 7 |
PAY_ENTITY |
Character(10) |
VARCHAR2(10) NOT NULL |
Pay Entity
|
| 8 |
BALANCE_GRP_NUM |
Character(3) |
VARCHAR2(3) NOT NULL |
This field will be used to determine the grouping of balances from the different jobs of the employee.
|
| 9 |
RSLT_SEG_NUM |
Number(4,0) |
SMALLINT NOT NULL |
Result Segment Number
|
| 10 |
EMPLID_BGRP |
Character(14) |
VARCHAR2(14) NOT NULL |
Emplid
|
| 11 |
GPAU_TAX_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Tax Year - End of Year Processing
|
| 12 |
GPAU_STP_VERSION |
Number(3,0) |
SMALLINT NOT NULL |
Version for STP Update Event
Default Value: 0
|
| 13 |
USER_KEY1 |
Character(25) |
VARCHAR2(25) NOT NULL |
User Key 1
|
| 14 |
USER_KEY2 |
Character(25) |
VARCHAR2(25) NOT NULL |
User Key 2
|
| 15 |
PRD_BGN_DT |
Date(10) |
DATE |
Period Begin Date
|
| 16 |
PRD_END_DT |
Date(10) |
DATE |
Pay Period End Date
|
| 17 |
PYMT_DT |
Date(10) |
DATE |
Payment Date
|
| 18 |
GPAU_ABN |
Character(11) |
VARCHAR2(11) NOT NULL |
A unique number used by the ATO to identify a contractor.
|
| 19 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 20 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 21 |
ADDRESS_150 |
Character(150) |
VARCHAR2(150) NOT NULL |
Preparer's Address
|
| 22 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 23 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_AUS_VW
|
| 24 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 25 |
COUNTRY_2CHAR |
Character(2) |
VARCHAR2(2) NOT NULL |
2-Char Country Code
|
| 26 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 27 |
ADDRESS_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Type
|
| 28 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
|
| 29 |
EMAIL_ADDR |
Character(70) |
VARCHAR2(70) NOT NULL |
Email Address
|
| 30 |
DAY1 |
Number(2,0) |
SMALLINT NOT NULL |
Day 1
|
| 31 |
MONTH1 |
Number(2,0) |
SMALLINT NOT NULL |
Month 1
|
| 32 |
YEAR_DISPLAY |
Number(4,0) |
SMALLINT NOT NULL |
Year Display
|
| 33 |
FIRST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
First Name
|
| 34 |
MIDDLE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
MIDDLE_NAME
|
| 35 |
LAST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Name
|
| 36 |
NAME_DISPLAY |
Character(50) |
VARCHAR2(50) NOT NULL |
Display Name - name formatted for Display based on the Country
|
| 37 |
BIRTHDATE |
Date(10) |
DATE |
Date of Birth
|
| 38 |
REHIRE_DT |
Date(10) |
DATE |
Rehire Date
|
| 39 |
TERMINATION_DT |
Date(10) |
DATE |
Termination Date
|
| 40 |
GPAU_CESSATION_TYP |
Character(1) |
VARCHAR2(1) NOT NULL |
Cessation Type indicator
C=Contract Cessation
D=Deceased
F=Dismissed
I=Ill Health
R=Redundancy
T=Transfer
V=Voluntary
|
| 41 |
GPAU_PAYMENT_BASIS |
Character(2) |
VARCHAR2(2) NOT NULL |
This is the payee's basis of payment. It identiy whether the payment was made from full time, part time, casual, or labour hire employment, This field is part of the TFN Declaration form to be filled in by the employee.
10=Casual
20=Full Time
30=Labour Hire
40=Part Time
50=Pension/Annuity
|
| 42 |
GPAU_PREV_PAYID |
Character(14) |
VARCHAR2(14) NOT NULL |
Previous Payroll Identifier - STP
|
| 43 |
GPAU_TAX_OFFSET |
Signed Number(12,0) |
DECIMAL(11) NOT NULL |
Tax Offset - Single Touch Payroll
|
| 44 |
GPAU_HECS_YN |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No flag. This will identify if the payee should be paying HECS payments or not.
Y/N Table Edit
|
| 45 |
GPAU_SFSS_YN |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No flag. This will identify if payee should be paying SFSS contributions or not.
Y/N Table Edit
|
| 46 |
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.
|
| 47 |
GPAU_TFN_SIGNED_DT |
Date(10) |
DATE |
This is the date when the employee has signed the TFN Declaration Form.
|
| 48 |
GPAU_TFN_SIGNED_YN |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No flag. This will determine whether the payee has signed the TFN Declaration form that was submitted to the employer.
|
| 49 |
GPAU_RES_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Payee residency status
|
| 50 |
GPAU_TXFRE_CLAIMED |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax free treshold claimed
Y/N Table Edit
|
| 51 |
GPAU_STP_FINAL_PAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Final Event Indicator - Single Touch Payroll
A=All Payees
N=Not Applicable
T=Terminated Payees
Y=Active Payees
Y/N Table Edit
|
| 52 |
FINAL_PAY_CAL_RUN |
Character(18) |
VARCHAR2(18) NOT NULL |
Calendar Run Id
|
| 53 |
OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Override
Y/N Table Edit
Default Value: N
|
| 54 |
GPAU_INB_GROSS_PAY |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
INB Gross Pay - Single Touch Payroll
|
| 55 |
GPAU_INB_TAX_WHELD |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
INB Tax Withheld - Single Touch Payroll
|
| 56 |
GPAU_INB_CDEP_PAY |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
INB CDEP Salary and Wages - Single Touch Payroll
|
| 57 |
GPAU_INB_EFEI_PAY |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
INB Exempt Foreign Income - Single Touch Payroll
|
| 58 |
GPAU_VOL_GROSS_PAY |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Voluntary Gross Pay - Single Touch Payroll
|
| 59 |
GPAU_VOL_TAX_WHELD |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Voluntary Tax Withheld - Single Touch Payroll
|
| 60 |
GPAU_LAB_GROSS_PAY |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Labout Hire Arrangement Gross Pay - Single Touch Payroll
|
| 61 |
GPAU_LAB_TAX_WHELD |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Labour Hire Arrangement Tax Withheld - Single Touch Payroll
|
| 62 |
GPAU_REG_GROSS_PAY |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Specified By Regulation Gross Pay - Single Touch Payroll
|
| 63 |
GPAU_REG_TAX_WHELD |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Specified By Regulation Tax Withheld - Single Touch Payroll
|
| 64 |
GPAU_JDP_GROSS_PAY |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Joint Petroleum Development Gross Pay - Single Touch Payroll
|
| 65 |
GPAU_JDP_FRN_WHELD |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Joint Petroleum Development Area Foreign Withheld - Single Touch Payroll
|
| 66 |
GPAU_JDP_TAX_WHELD |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Joint Petroleum Development Area Tax Withheld - Single Touch Payroll
|
| 67 |
GPAU_WHM_GROSS_PAY |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
WHM Gross Pay - Single Touch Payroll
|
| 68 |
GPAU_WHM_TAX_WHELD |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
WHM Tax Withheld - Single Touch Payroll
|
| 69 |
GPAU_CHP_GROSS_PAY |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
CHP Gross Pay - Single Touch Payroll
|
| 70 |
GPAU_CHP_TAX_WHELD |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
CHP Tax Withheld - Single Touch Payroll
|
| 71 |
GPAU_IAA_GROSS_PAY |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
IAA Gross Pay - Single Touch Payroll
|
| 72 |
GPAU_IAA_TAX_WHELD |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
IAA Tax Withheld - Single Touch Payroll
|
| 73 |
GPAU_SWP_GROSS_PAY |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
SWP Gross Pay - Single Touch Payroll
|
| 74 |
GPAU_SWP_TAX_WHELD |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
SWP Tax Withheld - Single Touch Payroll
|
| 75 |
GPAU_FRN_GROSS_PAY |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Gross Pay - End of Year Processing
|
| 76 |
GPAU_FRN_WHELD |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Foreign Withheld Amount - Single Touch Payroll
|
| 77 |
GPAU_FRN_TAX_WHELD |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Tax Withheld - End of Year Processing
|
| 78 |
GPAU_STP_LUMPA |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Lump Sum A Payments - STP Processing
|
| 79 |
GPAU_LUMPA_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Lump sum A payment indicator
|
| 80 |
GPAU_STP_LUMPB |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Lump Sum B Payments - STP Processing
|
| 81 |
GPAU_STP_LUMPD |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Lump Sum D Payments - STP Processing
|
| 82 |
GPAU_STP_LUMPE |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Lump Sum E Payments - STP Processing
|
| 83 |
GPAU_SUPER_GUA_AMT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
This field is used to record the Superannuation Guarantee amount on STP
|
| 84 |
GPAU_STP_OTE_AMT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
GPAUS - Used to store the OTEamount of Super Contributions made to a Super Fund Administrator in the period for which ComSuper reporting is being undertaken - Single Touch Payroll
|
| 85 |
GPAU_STP_ER_SC |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
This field is used to record the reportable employer Superannuation Contributions on STP
|
| 86 |
GPAU_FBT_TAX_INC |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
FBT Taxable Income
|
| 87 |
GPAU_FBT_EXEMP_INC |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
FBT Exempt Income
|
| 88 |
GPAU_EVNT_GROS_PAY |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Gross PTD of Employee - Single Touch Payroll
|
| 89 |
GPAU_EVNT_TAX_PAY |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Tax PTD of Employee - Single Touch Payroll
|
| 90 |
GPAU_EVNT_CSD_PAY |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Child Support Deduction PTD of Employee - Single Touch Payroll
|
| 91 |
GPAU_EVNT_CSG_PAY |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Child Support Garnishment PTD of Employee - Single Touch Payroll
|
| 92 |
PRC_ORD_TS |
DateTime(26) |
TIMESTAMP |
Process Order Timestamp
|
| 93 |
GPAU_TFN_TERM_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Payee terminated indicator
|
| 94 |
GPAU_STP_EVENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Event Type is used to determine if it is Update Event or Payee Override.
P=Payee Override
U=Update Event
|
| 95 |
GPAU_STP_UPDEVT_DT |
Date(10) |
DATE |
Update Event Date
|
| 96 |
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.
|
| 97 |
GPAU_EVNT_GROS_CH |
Character(20) |
VARCHAR2(20) NOT NULL |
Gross PTD of Employee - Single Touch Payroll
|
| 98 |
GPAU_EVNT_TAX_CH |
Character(20) |
VARCHAR2(20) NOT NULL |
Tax PTD of Employee - Single Touch Payroll
|
| 99 |
GPAU_FBT_TAX_CH |
Character(20) |
VARCHAR2(20) NOT NULL |
FBT Taxable Income
|
| 100 |
GPAU_FRN_GROSS_CH |
Character(20) |
VARCHAR2(20) NOT NULL |
Gross Pay - End of Year Processing
|
| 101 |
GPAU_FRN_TAX_CH |
Character(20) |
VARCHAR2(20) NOT NULL |
Tax Withheld - End of Year Processing
|
| 102 |
GPAU_FRN_WHELD_CH |
Character(20) |
VARCHAR2(20) NOT NULL |
Foreign Withheld Amount - Single Touch Payroll
|
| 103 |
GPAU_INB_CDEP_CH |
Character(20) |
VARCHAR2(20) NOT NULL |
INB CDEP Salary and Wages - Single Touch Payroll
|
| 104 |
GPAU_INB_EFEI_CH |
Character(20) |
VARCHAR2(20) NOT NULL |
INB Exempt Foreign Income - Single Touch Payroll
|
| 105 |
GPAU_INB_GROSS_CH |
Character(20) |
VARCHAR2(20) NOT NULL |
INB Gross Pay - Single Touch Payroll
|
| 106 |
GPAU_INB_TAX_CH |
Character(20) |
VARCHAR2(20) NOT NULL |
INB Tax Withheld - Single Touch Payroll
|
| 107 |
GPAU_JDP_FRN_CH |
Character(20) |
VARCHAR2(20) NOT NULL |
Joint Petroleum Development Area Foreign Withheld - Single Touch Payroll
|
| 108 |
GPAU_JDP_GROSS_CH |
Character(20) |
VARCHAR2(20) NOT NULL |
Joint Petroleum Development Gross Pay - Single Touch Payroll
|
| 109 |
GPAU_JDP_TAX_CH |
Character(20) |
VARCHAR2(20) NOT NULL |
Joint Petroleum Development Area Tax Withheld - Single Touch Payroll
|
| 110 |
GPAU_LAB_GROSS_CH |
Character(20) |
VARCHAR2(20) NOT NULL |
Labout Hire Arrangement Gross Pay - Single Touch Payroll
|
| 111 |
GPAU_LAB_TAX_CH |
Character(20) |
VARCHAR2(20) NOT NULL |
Labour Hire Arrangement Tax Withheld - Single Touch Payroll
|
| 112 |
GPAU_REG_GROSS_CH |
Character(20) |
VARCHAR2(20) NOT NULL |
Specified By Regulation Gross Pay - Single Touch Payroll
|
| 113 |
GPAU_REG_TAX_CH |
Character(20) |
VARCHAR2(20) NOT NULL |
Specified By Regulation Tax Withheld - Single Touch Payroll
|
| 114 |
GPAU_STP_ER_CH |
Character(20) |
VARCHAR2(20) NOT NULL |
This field is used to record the reportable employer Superannuation Contributions on STP
|
| 115 |
GPAU_STP_LUMPA_CH |
Character(20) |
VARCHAR2(20) NOT NULL |
Lump Sum A Payments - STP Processing
|
| 116 |
GPAU_STP_LUMPB_CH |
Character(20) |
VARCHAR2(20) NOT NULL |
Lump Sum B Payments - STP Processing
|
| 117 |
GPAU_STP_LUMPD_CH |
Character(20) |
VARCHAR2(20) NOT NULL |
Lump Sum D Payments - STP Processing
|
| 118 |
GPAU_STP_LUMPE_CH |
Character(20) |
VARCHAR2(20) NOT NULL |
Lump Sum E Payments - STP Processing
|
| 119 |
GPAU_STP_OTE_CH |
Character(20) |
VARCHAR2(20) NOT NULL |
GPAUS - Used to store the OTEamount of Super Contributions made to a Super Fund Administrator in the period for which ComSuper reporting is being undertaken - Single Touch Payroll
|
| 120 |
GPAU_SUPER_GUA_CH |
Character(20) |
VARCHAR2(20) NOT NULL |
This field is used to record the Superannuation Guarantee amount on STP
|
| 121 |
GPAU_VOL_GROSS_CH |
Character(20) |
VARCHAR2(20) NOT NULL |
Voluntary Gross Pay - Single Touch Payroll
|
| 122 |
GPAU_VOL_TAX_CH |
Character(20) |
VARCHAR2(20) NOT NULL |
Voluntary Tax Withheld - Single Touch Payroll
|
| 123 |
GPAU_WHM_GROSS_CH |
Character(20) |
VARCHAR2(20) NOT NULL |
WHM Gross Pay - Single Touch Payroll
|
| 124 |
GPAU_WHM_TAX_CH |
Character(20) |
VARCHAR2(20) NOT NULL |
WHM Tax Withheld - Single Touch Payroll
|
| 125 |
GPAU_FBT_EXEMP_CH |
Character(20) |
VARCHAR2(20) NOT NULL |
FBT Exempt Income
|
| 126 |
GPAU_TAX_TRMT_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Tax Treatment Code - Single Touch Payroll
|
| 127 |
GPAU_MED_LEV_SRCHG |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No flag. This will identify if the payee is claiming medicare levy exemptions only for his/her spouse.
1=1
2=2
3=3
|
| 128 |
GPAU_SPOUSE_YN |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No flag. This will identify if the payee is claiming medicare levy exemptions only for his/her spouse.
|
| 129 |
GPAU_NOOF_DPNDNTS |
Number(2,0) |
SMALLINT NOT NULL |
This is the number of dependents that will affect the payee's medicare levy adjustments
|