GPDE_TX_AGSC_VW (SQL View)	Index Back
AGS cities given an AGS code Thiw view returns valid cities for a given AGS code.

GPDE_TX_AGSC_VW

(SQL View)

AGS cities given an AGS code

Thiw view returns valid cities for a given AGS code.

SELECT DISTINCT GPDE_TX_AGS_ID , GPDE_POSTAL_CITY FROM PS_GPDE_TX_AGS_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GPDE_TX_AGS_ID Character(8) VARCHAR2(8) NOT NULL Municipality Code for GP Germany.

2 GPDE_POSTAL_CITY Character(30) VARCHAR2(30) NOT NULL 24-character city field for Global Payroll Germany

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPDE_TX_AGS_ID	Character(8)	VARCHAR2(8) NOT NULL	Municipality Code for GP Germany.
2	GPDE_POSTAL_CITY	Character(30)	VARCHAR2(30) NOT NULL	24-character city field for Global Payroll Germany