GPAU_STP_VAR_VW

(SQL View)
 Index Back

STP Category SOVR Variable

STP Category SOVR Variable

SELECT A.PIN_NUM , A.PIN_NM , A.DESCR FROM PS_GP_PIN A , PS_GP_VARIABLE D WHERE A.PIN_NUM = D.PIN_NUM AND A.PIN_NUM < 50000000 AND A.PIN_CATEGORY = 'STP'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
2 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description