PGM_ORPH_PRJ_VW

(SQL View)
 Index Back

View of Projects not on EPT

This view selects all active or pending projects not on the Enterprise Program Tree. These projects are also called orphans.

SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.DESCR , A.SUMMARY_PRJ , A.EFF_STATUS , A.PROJ_REQUEST_ID , A.PPK_PROJ_VERSION FROM PS_PROJECT A , PS_PGM_EPT_TREE_VW B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.EFF_STATUS IN ('A', 'P') AND NOT EXISTS ( SELECT 'X' FROM PSTREENODE C WHERE C.SETCNTRLVALUE = B.BUSINESS_UNIT AND C.TREE_NAME = B.TREE_NAME AND C.EFFDT = B.EFFDT AND C.TREE_NODE = A.PROJECT_ID)

  • 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
    5 PC_PROCESS_STATUS Character(1) VARCHAR2(1) NOT NULL The processing state of a project.
    A=Active
    I=Inactive
    P=Pending
    T=Template
    6 PROJ_REQUEST_ID Character(15) VARCHAR2(15) NOT NULL A unique identifier that represents a Project Request.
    7 PPK_PROJ_VERSION Character(15) VARCHAR2(15) NOT NULL An identifier that represents a version of the Project Request.