GP_SRCH_PINC_VW

(SQL View)
Index Back

PIN Category by Country

PIN Category by Country - used as prompt view when country has been given

SELECT DISTINCT B.PIN_CATEGORY , B.DESCR FROM PS_GP_PIN_CATEGORY B

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PIN_CATEGORY Character(4) VARCHAR2(4) NOT NULL Element Category
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description