GP_PYENT_SGPAU (SQL Table)	Index Back
Pay Entity - Australia Ext This table will be used to record the pay entity information that is required for Australia. These information are in addition to the details that ca be entered through the core pages. This table is a sibling table of GP_PYENT.

GP_PYENT_SGPAU

(SQL Table)

Pay Entity - Australia Ext

This table will be used to record the pay entity information that is required for Australia. These information are in addition to the details that ca be entered through the core pages. This table is a sibling table of GP_PYENT.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
Default Value: GP_PYENT.PAY_ENTITY

2 EFFDT Date(10) DATE Effective Date
Default Value: GP_PYENT_DTL.EFFDT

3 GPAU_TRADING_NM Character(200) VARCHAR2(200) NOT NULL The pay entity's trading name (company trading name).

4 GPAU_REGISTERED_NM Character(200) VARCHAR2(200) NOT NULL This is the pay entity's registered name (company registered name).

5 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Country Code

6 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone

7 EXTENSION Character(6) VARCHAR2(6) NOT NULL Phone number extension

8 FAX Character(24) VARCHAR2(24) NOT NULL Fax Number

9 GPAU_CONTACT_ID Character(11) VARCHAR2(11) NOT NULL This is the contact person for reporting requirements.
Prompt Table: PERS_SRCH_GBL

10 GPAU_INDUSTRY Character(30) VARCHAR2(30) NOT NULL The pay entity's industry (company industry). This is for information only

11 GPAU_SIGNATORY Character(40) VARCHAR2(40) NOT NULL This is the pay entity's signatory that will be on the payee's payment summary.

12 GPAU_ABN Character(11) VARCHAR2(11) NOT NULL A unique number used by the ATO to identify a contractor.

13 GPAU_ABN_BRANCH Number(3,0) SMALLINT NOT NULL ABN Branch is issued by the ATO to payers that wush to sub-divide their activities. Valid values iare 001 - 999. Default value is 001.

14 GPAU_ATO_OFFICE_CD Character(2) VARCHAR2(2) NOT NULL This is the ATO's Office Code.

15 GPAU_PYENT_REG_NO Character(10) VARCHAR2(10) NOT NULL This is the pay entity's registered number

16 GPAU_PYENT_TAX_REF Character(11) VARCHAR2(11) NOT NULL This is the tax reference number.

17 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address

18 GPAU_EFT_CODE Character(18) VARCHAR2(18) NOT NULL This field will be used to store the Electronic File Transfer (EFT) Code of the pay entity.

19 PHONE1 Character(24) VARCHAR2(24) NOT NULL Phone number field for discounts and perks eligibility file.

20 GPAU_ERROR_ENABLED Character(1) VARCHAR2(1) NOT NULL Error handling enabled indicator
Y/N Table Edit
Default Value: N

21 GPAU_SENDER_URL Character(254) VARCHAR2(254) NOT NULL Sender E-Service Address

22 GPAU_STP_BMS_ID Character(200) VARCHAR2(200) NOT NULL Business Management System Identifier - Single Touch Payroll.

23 GPAU_BMS_ID_PB Character(1) VARCHAR2(1) NOT NULL Business Management System Identifier - Single Touch Payroll.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity Default Value: GP_PYENT.PAY_ENTITY
2	EFFDT	Date(10)	DATE	Effective Date Default Value: GP_PYENT_DTL.EFFDT
3	GPAU_TRADING_NM	Character(200)	VARCHAR2(200) NOT NULL	The pay entity's trading name (company trading name).
4	GPAU_REGISTERED_NM	Character(200)	VARCHAR2(200) NOT NULL	This is the pay entity's registered name (company registered name).
5	COUNTRY_CODE	Character(3)	VARCHAR2(3) NOT NULL	Country Code
6	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
7	EXTENSION	Character(6)	VARCHAR2(6) NOT NULL	Phone number extension
8	FAX	Character(24)	VARCHAR2(24) NOT NULL	Fax Number
9	GPAU_CONTACT_ID	Character(11)	VARCHAR2(11) NOT NULL	This is the contact person for reporting requirements. Prompt Table: PERS_SRCH_GBL
10	GPAU_INDUSTRY	Character(30)	VARCHAR2(30) NOT NULL	The pay entity's industry (company industry). This is for information only
11	GPAU_SIGNATORY	Character(40)	VARCHAR2(40) NOT NULL	This is the pay entity's signatory that will be on the payee's payment summary.
12	GPAU_ABN	Character(11)	VARCHAR2(11) NOT NULL	A unique number used by the ATO to identify a contractor.
13	GPAU_ABN_BRANCH	Number(3,0)	SMALLINT NOT NULL	ABN Branch is issued by the ATO to payers that wush to sub-divide their activities. Valid values iare 001 - 999. Default value is 001.
14	GPAU_ATO_OFFICE_CD	Character(2)	VARCHAR2(2) NOT NULL	This is the ATO's Office Code.
15	GPAU_PYENT_REG_NO	Character(10)	VARCHAR2(10) NOT NULL	This is the pay entity's registered number
16	GPAU_PYENT_TAX_REF	Character(11)	VARCHAR2(11) NOT NULL	This is the tax reference number.
17	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email Address
18	GPAU_EFT_CODE	Character(18)	VARCHAR2(18) NOT NULL	This field will be used to store the Electronic File Transfer (EFT) Code of the pay entity.
19	PHONE1	Character(24)	VARCHAR2(24) NOT NULL	Phone number field for discounts and perks eligibility file.
20	GPAU_ERROR_ENABLED	Character(1)	VARCHAR2(1) NOT NULL	Error handling enabled indicator Y/N Table Edit Default Value: N
21	GPAU_SENDER_URL	Character(254)	VARCHAR2(254) NOT NULL	Sender E-Service Address
22	GPAU_STP_BMS_ID	Character(200)	VARCHAR2(200) NOT NULL	Business Management System Identifier - Single Touch Payroll.
23	GPAU_BMS_ID_PB	Character(1)	VARCHAR2(1) NOT NULL	Business Management System Identifier - Single Touch Payroll.