PGM_EST_SUMM_VW

(SQL View)
 Index Back

Program Management Summ View


SELECT A.BUSINESS_UNIT ,A.PROJECT_ID ,A.ACTIVITY_ID ,A.START_DT ,A.END_DT ,%Round(%DecDiv(A.PC_DURATION, P.PC_HOURS_PER_DAY), 0) ,0 ,0 ,0 ,0 ,0 ,' ' ,' ' ,' ' ,0 , P.CURRENCY_CD ,' ' , A.DESCR , 0 , A.WBS_ID , A.LEVEL_NUM FROM PS_PROJ_ACTIVITY A ,PS_PROJECT P WHERE A.BUSINESS_UNIT = P.BUSINESS_UNIT AND A.PROJECT_ID = P.PROJECT_ID GROUP BY A.BUSINESS_UNIT, A.PROJECT_ID, A.ACTIVITY_ID, A.START_DT, A.END_DT, A.PC_DURATION, P.PC_HOURS_PER_DAY, P.CURRENCY_CD, A.DESCR, A.WBS_ID, A.LEVEL_NUM

  • Related Language Record: PROJ_ACTIVTY_LG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT

    Prompt Table: SP_BU_PC_NONVW

    2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

    Default Value: OPR_DEF_TBL_PC.PROJECT_ID

    Prompt Table: SP_PROJ_NONVW

    3 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

    Prompt Table: PC_TYPE_ACT_VW

    4 START_DT Date(10) DATE NOT NULL Start Date

    Default Value: PROJECT.START_DT

    5 END_DT Date(10) DATE NOT NULL End Date

    Default Value: PROJECT.END_DT

    6 PC_DURATION_DAYS Number(8,0) INTEGER NOT NULL Duration in Days
    7 ASSGND_WORK Signed Number(16,2) DECIMAL(14,2) NOT NULL Assigned Work
    8 REMAINING_WORK Signed Number(16,2) DECIMAL(14,2) NOT NULL New Remaining work in hours
    9 ACTUAL_WORK Signed Number(16,2) DECIMAL(14,2) NOT NULL Actual Work
    10 PROJ_TOTAL_WORK Signed Number(16,2) DECIMAL(14,2) NOT NULL Projected Total Work
    11 COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Cost
    12 TEAM_MEMBER_CLASS Character(1) VARCHAR2(1) NOT NULL 05/26/2004 - FS Translate Value "O" added.
    A=Asset
    L=Labor
    M=Material
    O=Other
    13 TEAM_MEMBER Character(30) VARCHAR2(30) NOT NULL Team Member
    14 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage

    Default Value: OPR_DEF_TBL_PC.UNIT_OF_MEASURE

    Prompt Table: UNITS_TBL

    15 AVAIL_UNITS Number(6,0) INTEGER NOT NULL Availability Units
    16 PC_USER_CURRENCY Character(3) VARCHAR2(3) NOT NULL User Currency
    17 TEAM_MEMBER_IND Character(1) VARCHAR2(1) NOT NULL Team Member Indicator
    E=Employee
    G=Generic Resource
    N=Not Applicable
    18 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    19 COST_RATE Number(27,3) DECIMAL(26,3) NOT NULL Cost Rate
    20 WBS_ID Character(100) VARCHAR2(100) NOT NULL WBS ID
    21 LEVEL_NUM Number(3,0) SMALLINT NOT NULL Level