GPAU_THD_PTY_VW (SQL View)	Index Back
Third party details view This view lists Third party details for GP AUS.

GPAU_THD_PTY_VW

(SQL View)

Third party details view

This view lists Third party details for GP AUS.

SELECT A.GPAU_PARTY_ID , A.EFF_STATUS , A.GPAU_REGISTERED_NM , A.GPAU_ABN , A.GPAU_USI , A.GPAU_CONTACT_ID , A.SRC_BANK_ID FROM PS_GPAU_THIRD_PRTY A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_GPAU_THIRD_PRTY B WHERE A.GPAU_PARTY_ID = B.GPAU_PARTY_ID AND B.EFF_STATUS = 'A')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GPAU_PARTY_ID Character(30) VARCHAR2(30) NOT NULL Third Party ID

2 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

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

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

5 GPAU_USI Character(15) VARCHAR2(15) NOT NULL Unique Superannuation identifier

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

7 SRC_BANK_ID Character(8) VARCHAR2(8) NOT NULL Source Bank ID
Prompt Table: SRC_BANK

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPAU_PARTY_ID	Character(30)	VARCHAR2(30) NOT NULL	Third Party ID
2	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
3	GPAU_REGISTERED_NM	Character(200)	VARCHAR2(200) NOT NULL	This is the pay entity's registered name (company registered name).
4	GPAU_ABN	Character(11)	VARCHAR2(11) NOT NULL	A unique number used by the ATO to identify a contractor.
5	GPAU_USI	Character(15)	VARCHAR2(15) NOT NULL	Unique Superannuation identifier
6	GPAU_CONTACT_ID	Character(11)	VARCHAR2(11) NOT NULL	This is the contact person for reporting requirements. Prompt Table: PERSON_NAME
7	SRC_BANK_ID	Character(8)	VARCHAR2(8) NOT NULL	Source Bank ID Prompt Table: SRC_BANK