PGM_REQ_VER_VW

(SQL View)
 Index Back

View of Projects to Request

This view shows for each project on the Enterprise Program Tree, the closest parent project that is associated with a Project Request. This is the final view that shows Project to Project Request relationship.

SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.PC_PROCESS_STATUS , A.SUMMARY_PRJ , A.PROJ_REQUEST_ID , A.PPK_PROJ_VERSION FROM PS_PGM_XREF_VW2 A WHERE A.TREE_NODE_NUM = ( SELECT MAX(B.TREE_NODE_NUM) FROM PS_PGM_XREF_VW2 B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROJECT_ID = B.PROJECT_ID)

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