GPDE_TX_AGSN_VW (SQL View)	Index Back
Distinct AGS Numbers This view returns all distinct AGS Numbers which are stored in record GPDE_TX_AGS_TBL.

GPDE_TX_AGSN_VW

(SQL View)

Distinct AGS Numbers

This view returns all distinct AGS Numbers which are stored in record GPDE_TX_AGS_TBL.

SELECT DISTINCT GPDE_TX_AGS_ID 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.