PC_ACT_STAT_VW4

(SQL View)
 Index Back

Activity Status View with Desc


SELECT A.BUSINESS_UNIT , A.ACTIVITY_TYPE , A.PROJECT_STATUS , A.PROJECT_STATUS_TO , B.DESCR FROM PS_PC_ACT_STATPATH A , PS_PROJ_STATUS_TBL B , PS_SET_CNTRL_REC C WHERE B.EFF_STATUS = 'A' AND B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PS_PROJ_STATUS_TBL B_ED WHERE B.SETID = B_ED.SETID AND B.PROJECT_STATUS = B_ED.PROJECT_STATUS AND B_ED.EFFDT <= %CurrentDateIn) AND C.SETID = B.SETID AND C.RECNAME = 'PROJ_STATUS_TBL' AND C.SETCNTRLVALUE = A.BUSINESS_UNIT AND A.PROJECT_STATUS_TO = B.PROJECT_STATUS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 ACTIVITY_TYPE Character(5) VARCHAR2(5) NOT NULL Activity Type
A=Activity Type
E=Entry Type
G=Group Type/Origin
O=Activity Type/Origin
R=Entry Type/Reason
3 PROJECT_STATUS Character(1) VARCHAR2(1) NOT NULL Project Status
B=Budgeted
C=Closed
H=Hold
O=Open
P=Proposed
4 PROJECT_STATUS_TO Character(1) VARCHAR2(1) NOT NULL Project Status To
5 DESCR Character(30) VARCHAR2(30) NOT NULL Description