PC_SA_LEFT_VW

(SQL View)
 Index Back

Project Analytics View


SELECT A.BUSINESS_UNIT , A.PROJECT_ID ,A.DESCR ,A.PROJECT_TYPE ,A.START_DT ,A.END_DT ,C.PROJECT_STATUS ,B.OPRID FROM PS_PROJECT A , PS_PC_OPRID_PRJACT B ,PS_PROJECT_STATUS C WHERE A.PROJECT_ID = B.PROJECT_ID AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROJECT_ID = C.PROJECT_ID AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_PROJECT_STATUS C1 WHERE C.PROJECT_ID = C1.PROJECT_ID AND C.BUSINESS_UNIT = C1.BUSINESS_UNIT ) AND C.EFFSEQ = ( SELECT MAX(C2.EFFSEQ) FROM PS_PROJECT_STATUS C2 WHERE C.PROJECT_ID = C2.PROJECT_ID AND C.BUSINESS_UNIT = C2.BUSINESS_UNIT )

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

Prompt Table: SP_BU_PC_NONVW

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

Prompt Table: PROJECT

3 PROJECT_NAME Character(30) VARCHAR2(30) NOT NULL Displays the Project names.
4 PROJECT_TYPE Character(5) VARCHAR2(5) NOT NULL Project Type
A=Activity
G=Grant
H=Phase
P=Project
S=Segment
5 START_DT Date(10) DATE Start Date
6 END_DT Date(10) DATE End Date
7 PROJECT_STATUS Character(1) VARCHAR2(1) NOT NULL Project Status
B=Budgeted
C=Closed
H=Hold
O=Open
P=Proposed
8 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).