PROJECT_ALL_VW

(SQL View)
 Index Back

Operational Projects View

The view provides an easy to use on-line prompt for the project table and is used in locations within the Projects application since it references the PC Business Unit and not setid. It is a copy of PROJECT_VW, but it shows all the projects including summary project. All project id prompts should use PROJECT_VW (ie filter out summary projects) except in instances like the security definition where all the projects should be shown, so users can assign security to summary projects as well, if they choose to.

SELECT A.BUSINESS_UNIT ,A.PROJECT_ID ,A.DESCR ,A.INTEGRATION_TMPL FROM PS_PROJECT A

  • Related Language Record: PROJECT_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: PROJECT.SETID

    Prompt Table: SP_BU_PC_NONVW

    2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

    Prompt Table: PROJ_SCRTY_SRCH

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 INTEGRATION_TMPL Character(15) VARCHAR2(15) NOT NULL Integration

    Prompt Table: PC_INT_TMPL