PGM_PRJ_ST_PATH

(SQL View)
 Index Back

Project Status Control

Project Status Path

SELECT A.BUSINESS_UNIT , A.PROJECT_TYPE , A.PROJECT_STATUS , A.PROJECT_STATUS_TO , B.DESCR FROM PS_PC_PRJ_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

  • Parent record: PC_PRJ_STAT_CTL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 PROJECT_TYPE Character(5) VARCHAR2(5) NOT NULL Project Type
    A=Activity
    G=Grant
    H=Phase
    P=Project
    S=Segment
    3 PROJ_STATUS_OLD Character(1) VARCHAR2(1) NOT NULL Old Project Status
    4 PROJECT_STATUS_TO Character(1) VARCHAR2(1) NOT NULL Project Status To

    Prompt Table: PROJ_STATUS_TBL

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description