SP_PROJP_NONVW

(SQL View)
 Index Back

Project - Non Secured View

This is the non-secured view of projects that are either pending or active, detail only.

SELECT BUSINESS_UNIT ,PROJECT_ID ,DESCR ,SUMMARY_PRJ FROM PS_PROJECT WHERE SUMMARY_PRJ = 'N' AND EFF_STATUS IN ('A', 'P')

  • 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
    2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 SUMMARY_PRJ Character(1) VARCHAR2(1) NOT NULL An indicator to determine whether project is summary or detail.
    N=Detail Project
    Y=Program