PC_RATE_ACT

(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 , PT.BILL_CURRENCY_CD , PA.START_DT , PA.END_DT FROM PS_PROJ_ACT_TEAM PT , PS_PROJ_ACTIVITY PA WHERE PT.TEAM_MEMBER_CLASS = 'L' AND PT.TEAM_MEMBER_IND = 'E' AND PT.BUSINESS_UNIT = PA.BUSINESS_UNIT AND PT.PROJECT_ID = PA.PROJECT_ID AND PT.ACTIVITY_ID = PA.ACTIVITY_ID AND PA.COSTING_ACT_SW = 'Y'

  • 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 BILL_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Bill Currency Code
    10 START_DT Date(10) DATE Start Date
    11 END_DT Date(10) DATE End Date