GPDE_FM_VAL_VW

(SQL View)
 Index Back

Setup Record for GPDE

This record stores Name/Value pairs for values which might need to be commonly changed by Users. This UI allows the User to change values online without having to go into Application Designer.

SELECT A.GPDE_AL_PROP_NAME ,A.GPDE_AL_PROP_VAL FROM PS_GPDE_AL_VAL_PRS A WHERE A.GPDE_AL_PROCESS_NM = 'URLID' AND EXISTS ( SELECT 1 FROM PSURLDEFN U WHERE U.URL_ID = A.GPDE_AL_PROP_VAL )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GPDE_AL_PROP_NAME Character(30) VARCHAR2(30) NOT NULL A Property Name in the GPDE setup Name/Value Pair Table.
2 GPDE_AL_PROP_VAL Character(100) VARCHAR2(100) NOT NULL A Property Value in the GPDE setup Name/Value Pair Table.