PC_RATE_ACT_EX

(SQL View)
 Index Back

Activity Team Member Empl View

View of assigned members (employees) in activity team. Only the team members that are in the activity as of the current date will be shown.

SELECT PT.BUSINESS_UNIT , PT.PROJECT_ID , PT.ACTIVITY_ID , PT.TEAM_MEMBER , PT.UNIT_OF_MEASURE , PT.BILL_RATE , PT.COST_RATE , PT.CURRENCY_CD , PR.SCEN_ADJUST_PCT_EX FROM PS_PROJECT PR , PS_PROJ_ACT_TEAM PT , PS_PROJ_ACTIVITY PA WHERE PT.TEAM_MEMBER_CLASS = 'L' AND PT.TEAM_MEMBER_IND = 'E' AND PR.BUSINESS_UNIT = PA.BUSINESS_UNIT AND PR.PROJECT_ID = PA.PROJECT_ID AND PT.BUSINESS_UNIT = PR.BUSINESS_UNIT AND PT.PROJECT_ID = PR.PROJECT_ID AND PT.ACTIVITY_ID = PA.ACTIVITY_ID AND PA.COSTING_ACT_SW = 'Y' AND PR.SCEN_ADJUST_PCT_EX <> 0 AND PR.SYSTEM_SOURCE = 'PPM'

  • Parent record: PROJECT

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

    Default Value: PROJECT.BUSINESS_UNIT

    Prompt Table: SP_BU_PC_NONVW

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

    Prompt Table: PROJECT_VW

    3 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
    4 TEAM_MEMBER Character(30) VARCHAR2(30) NOT NULL Team Member

    Prompt Table: PC_TEAM_SUMR_VW

    5 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage
    6 BILL_RATE Number(27,3) DECIMAL(26,3) NOT NULL Billing Rate
    7 COST_RATE Number(27,3) DECIMAL(26,3) NOT NULL Cost Rate
    8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    9 SCEN_ADJUST_PCT_EX Signed Number(7,2) DECIMAL(5,2) NOT NULL Scenario Adjustment % for Expense 06/09/2004 PR_FS_B005 Added Label NON_LABOR_ADJUST