PC_BD_PS_PRJ_VW

(SQL View)
 Index Back

Project Budget Plan Summary

View panned project budget summary information such as total budget amount and total cost.

SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.PC_BUDGET_ID , C.DESCR AS PROJ_DESCR , A.DESCR , A.START_DT , A.CALENDAR_ID , A.PC_BUD_TYPE , SUM(B.PC_BUDGET_AMOUNT) AS BUDGET_AMOUNT , SUM(B.ACTUAL_AMOUNT) AS ACTUAL_AMOUNT , SUM(B.PC_BUDGET_AMOUNT) - SUM(B.ACTUAL_AMOUNT) AS REMAINING_AMOUNT , D.CURRENCY_CD , C.RT_TYPE , ' ' AS PC_IM_PRIO_ICON FROM PS_PC_BUD_PLAN A , PS_PC_BUD_SUMMARY B , PS_PROJECT C , PS_BUS_UNIT_TBL_PC D WHERE A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.PROJECT_ID = C.PROJECT_ID AND C.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROJECT_ID = B.PROJECT_ID AND A.PC_BUDGET_ID = B.PC_BUDGET_ID GROUP BY A.BUSINESS_UNIT, A.PROJECT_ID, A.PC_BUDGET_ID, C.DESCR, A.DESCR, A.START_DT,A.CALENDAR_ID, A.PC_BUD_TYPE, D.CURRENCY_CD, C.RT_TYPE

  • Related Language Record: PC_BD_PS_PR_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
    3 PC_BUDGET_ID Number(3,0) SMALLINT NOT NULL Budget Plan ID
    4 PROJ_DESCR Character(30) VARCHAR2(30) NOT NULL Project ID Description
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 START_DT Date(10) DATE Start Date
    7 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID

    Prompt Table: CAL_BP_VW

    8 PC_BUD_TYPE Character(1) VARCHAR2(1) NOT NULL This field defines a Projects Budget as either Cost or Revenue Based.
    C=Cost Budget
    R=Revenue Budget
    9 BUDGET_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Projects Budget Amount
    10 ACTUAL_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Actual Invoice Amount
    11 REMAINING_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Remaining Amount
    12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    13 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
    14 PC_IM_PRIO_ICON Character(1) VARCHAR2(1) NOT NULL Issue Priority Icon
    0=Low Priority
    1=Medium Priority
    2=High Priority