GPAU_THD_PRT_VW

(SQL View)
 Index Back

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') AND A.GPAU_CLRHOUSE ='N'

# 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