PRJ_TEAM_VW

(SQL View)
 Index Back

Project Team Members View

View of Project Team members that includes the assigned employees as well as the resource requirements. Retrieves all employees and requirement schedules without applying as-of-current-date filter. Both open and fulfilled requirements are shown.

SELECT PT.BUSINESS_UNIT , PT.PROJECT_ID , PT.TEAM_MEMBER , PT.TEAM_MEMBER_CLASS , PT.TEAM_MEMBER_IND , SC.SCHED_NUM , SC.PROJ_ROLE , SC.START_DT , SC.END_DT , %Substring(PT.TEAM_MEMBER,1,11) , PT.SOURCE_REQ , PT.EMAILID , PT.UNIT_OF_MEASURE , PT.PGM_RATE_TYPE , PT.COST_RATE , PT.CURRENCY_CD , PT.PC_BUDGET_ITEM FROM PS_PROJECT_TEAM PT , PS_PROJ_TEAM_SCHED SC WHERE PT.BUSINESS_UNIT = SC.BUSINESS_UNIT AND PT.PROJECT_ID = SC.PROJECT_ID AND PT.TEAM_MEMBER_CLASS = SC.TEAM_MEMBER_CLASS AND PT.TEAM_MEMBER_IND = SC.TEAM_MEMBER_IND AND PT.TEAM_MEMBER = SC.TEAM_MEMBER

  • 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 TEAM_MEMBER Character(30) VARCHAR2(30) NOT NULL Team Member

    Prompt Table: PROJECT_TEAM_VW

    4 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

    Default Value: L

    5 TEAM_MEMBER_IND Character(1) VARCHAR2(1) NOT NULL Team Member Indicator
    E=Employee
    G=Generic Resource
    N=Not Applicable

    Default Value: E

    6 SCHED_NUM Number(5,0) INTEGER NOT NULL Team sequence number

    Prompt Table: PROJ_TEAM_SCHED

    7 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role

    Prompt Table: PROJ_ROLE

    8 START_DT Date(10) DATE Start Date
    9 END_DT Date(10) DATE End Date
    10 ASSIGN_EMPLID Character(11) VARCHAR2(11) NOT NULL Assigned To Employee ID
    11 SOURCE_REQ Character(25) VARCHAR2(25) NOT NULL Source Requirement ID
    12 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
    13 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage
    14 PGM_RATE_TYPE Character(1) VARCHAR2(1) NOT NULL 06/15/2004 FS - Changed eff. dates to 1/1/1900 from 1/1/2000
    C=Override Rate
    E=Employee Rate
    J=Jobcode Rate
    R=Project Role Rate
    X=Custom Rate
    15 COST_RATE Number(27,3) DECIMAL(26,3) NOT NULL Cost Rate
    16 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    17 PC_BUDGET_ITEM Character(15) VARCHAR2(15) NOT NULL Project Budgeting: Budget Item 11/15/2004- FS - Added label COST_BUDGET_ITEM