KK_PROJ_ID_VW

(SQL View)
 Index Back

KK 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". It will return all active projects, including summary level values.

SELECT SETID ,PROJECT_ID ,DESCR FROM PS_PROJECT_FS WHERE EFF_STATUS='A'

  • 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