PROJECT_ID_VW2

(SQL View)
 Index Back

Project ID ChartField View

This is a view used primarily by customers that are not using the Projects application since it uses "setid" mapping rather than the Projects "Integration Templates". This view fetches both active and inactive Projects.

SELECT SETID ,PROJECT_ID ,DESCR FROM PS_PROJECT_FS WHERE SUMMARY_PRJ = 'N'

  • Related Language Record: PROJECT_ID_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description