PSCONTVIEW

(SQL View)
 Index Back

SELECT contname , descr FROM PSCONTDEFN WHERE altcontnum = 1 AND conttype = 1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CONTNAME Character(30) VARCHAR2(30) NOT NULL Content Name
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description