PC_RATE_PR_EX

(SQL View)
 Index Back

Project Team Member Empl View

View of assigned members (employees) in project team. Only the team members that are in the project 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 , PM.BILL_RATE , PT.BILL_RATE , PM.COST_RATE , PM.CURRENCY_CD , PR.SCEN_ADJUST_PCT_EX FROM PS_PROJECT PR , PS_PROJECT_TEAM PM , 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 = PM.BUSINESS_UNIT AND PR.PROJECT_ID = PM.PROJECT_ID 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 PM.TEAM_MEMBER_CLASS = PT.TEAM_MEMBER_CLASS AND PM.TEAM_MEMBER_IND = PT.TEAM_MEMBER_IND AND PM.TEAM_MEMBER = PT.TEAM_MEMBER AND PR.SCEN_ADJUST_PCT_EX <> 0 AND PR.SYSTEM_SOURCE = 'PPM'

# 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 BILL_RATE_ACT Number(27,3) DECIMAL(26,3) NOT NULL Bill Rate in Activity team (ARL).
8 COST_RATE Number(27,3) DECIMAL(26,3) NOT NULL Cost Rate
9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
10 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