PGM_XREF_VW2

(SQL View)
 Index Back

View of Projects to Request

This is an interim view that is used to determine provide a cross-reference between Project and Project Request. This view selects all projects on the Enterprise Program Tree that is a child of a program associated with a Project Request.

SELECT A.BUSINESS_UNIT , %Substring(B.TREE_NODE, 1, 15) , A.TREE_NODE_NUM , C.EFF_STATUS , C.SUMMARY_PRJ , A.PROJ_REQUEST_ID , A.PPK_PROJ_VERSION FROM PS_PGM_XREF_VW1 A , PSTREENODE B , PS_PROJECT C WHERE A.BUSINESS_UNIT = B.SETCNTRLVALUE AND A.TREE_NAME = B.TREE_NAME AND A.EFFDT = B.EFFDT AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.TREE_NODE = C.PROJECT_ID AND B.TREE_NODE_NUM BETWEEN A.TREE_NODE_NUM AND A.TREE_NODE_NUM_END

# 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 TREE_NODE_NUM Number(10,0) DECIMAL(10) NOT NULL Internal beginning node range number
4 PC_PROCESS_STATUS Character(1) VARCHAR2(1) NOT NULL The processing state of a project.
A=Active
I=Inactive
P=Pending
T=Template
5 SUMMARY_PRJ Character(1) VARCHAR2(1) NOT NULL An indicator to determine whether project is summary or detail.
N=Detail Project
Y=Program
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.