PC_PRJ_STAT_LVW

(SQL View)
 Index Back

Proj Status Language contol

View to support Multilingual

SELECT A.BUSINESS_UNIT , A.PROJECT_TYPE , A.PROJECT_STATUS , A.PROJECT_STATUS_TO , D.LANGUAGE_CD , D.DESCR FROM PS_PC_PRJ_STATPATH A , PS_PROJ_STATUS_TBL B , PS_SET_CNTRL_REC C , PS_PROJ_STATUS_LNG D 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 D.EFFDT = ( SELECT MAX(D_ED.EFFDT) FROM PS_PROJ_STATUS_LNG D_ED WHERE D.SETID = D_ED.SETID AND D.PROJECT_STATUS = D_ED.PROJECT_STATUS AND D_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 AND C.SETID = D.SETID AND A.PROJECT_STATUS_TO = D.PROJECT_STATUS

  • Related Language Record for PC_PRJ_STAT_VW2

  • 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 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

    Prompt Table: PROJ_STATUS_TBL

    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description