GPAU_STATES_VW (SQL View)	Index Back
Australian States Retrieves all Australian States defined on STATE_NAMES_TBL

GPAU_STATES_VW

(SQL View)

Australian States

Retrieves all Australian States defined on STATE_NAMES_TBL

SELECT %TrimSubstr(A.STATE, 1,3) , A.DESCR FROM PS_STATE_TBL A WHERE A.COUNTRY = 'AUS'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PAYROLL_STATE_AUS Character(3) VARCHAR2(3) NOT NULL Sal Package - Payroll Tax State

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PAYROLL_STATE_AUS	Character(3)	VARCHAR2(3) NOT NULL	Sal Package - Payroll Tax State
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description