PROJ_STA_CA_VW

(SQL View)
Index Back

Project Status

To be used on Console

SELECT DISTINCT CONTRACT_NUM , BUSINESS_UNIT , PS.PROJECT_ID , EFFDT , EFFSEQ , PROJECT_STATUS , PROJECT_PRIORITY , PERCENT_COMPLETE , INTEREST_FACTOR , TO_CHAR(DESCRLONG ) FROM PS_CA_DETAIL_PROJ DTL , PS_PROJECT_STATUS PS WHERE PS.BUSINESS_UNIT = DTL.BUSINESS_UNIT_PC AND PS.PROJECT_ID = DTL.PROJECT_ID AND PS.EFFDT = ( SELECT MAX(PS1.EFFDT) FROM PS_PROJECT_STATUS PS1 WHERE PS1.BUSINESS_UNIT = PS.BUSINESS_UNIT AND PS1.PROJECT_ID = PS.PROJECT_ID AND PS1.EFFDT <= %CurrentDateIn AND PS1.EFFSEQ = ( SELECT MAX(PS2.EFFSEQ) FROM PS_PROJECT_STATUS PS2 WHERE PS2.BUSINESS_UNIT = PS1.BUSINESS_UNIT AND PS2.PROJECT_ID = PS1.PROJECT_ID AND PS2.EFFDT = PS1.EFFDT))

  • Parent record: PROJECT
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

    Prompt Table: CA_CONTR_HDR

    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

    Prompt Table: PROJECT

    4 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    5 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    6 PROJECT_STATUS Character(1) VARCHAR2(1) NOT NULL Project Status
    B=Budgeted
    C=Closed
    H=Hold
    O=Open
    P=Proposed

    Prompt Table: %EDITTABLE3

    7 PROJECT_PRIORITY Number(3,0) SMALLINT NOT NULL Project Priority
    8 PERCENT_COMPLETE Number(6,2) DECIMAL(5,2) NOT NULL % Complete
    9 INTEREST_FACTOR Signed Number(5,2) DECIMAL(3,2) NOT NULL Interest Calculation Factor
    10 DESCRLONG Long Character CLOB Long Description