CF_DEV_PROJ_VW

(SQL View)
 Index Back

Projects from Project Table

Distinct Projects from the PSPROJECTDEFN Table.

SELECT DISTINCT PROJECTNAME , PROJECTDESCR FROM PSPROJECTDEFN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROJECTNAME Character(30) VARCHAR2(30) NOT NULL Project Name (see PSPROJECTDEFN).
2 PROJECTDESCR Character(30) VARCHAR2(30) NOT NULL Project Description