PROJECT_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. 06/09/2004 - PR_FS_B005 - Estimating Labor PRL /ARL Added 3 fields, BILL_RATE_TYPE_1, BILL_RATE and BILL_CURR_CD

SELECT PT.BUSINESS_UNIT , PT.PROJECT_ID , PT.TEAM_MEMBER_CLASS , PT.TEAM_MEMBER_IND , PT.TEAM_MEMBER , 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 , PT.BILL_RATE_TYPE_1 , PT.BILL_RATE , PT.BILL_CURRENCY_CD , PT.BUSINESS_UNIT_AM , PT.ASSET_TYPE , PT.ASSET_SUBTYPE , PT.MFG_ID , PT.MODEL , PT.DEF_CRATE_COST , PT.DEF_CRATE_BILL 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_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

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

    Default Value: E

    5 TEAM_MEMBER Character(30) VARCHAR2(30) NOT NULL Team Member

    Prompt Table: PROJECT_TEAM_VW

    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
    18 BILL_RATE_TYPE_1 Character(1) VARCHAR2(1) NOT NULL 06/03/2004 - PR_FS_B005 Estimanting Labor PRL/ARL Changes
    C=Override Rate
    E=Employee Rate
    J=Jobcode Rate
    R=Project Role Rate
    X=Custom Rate
    19 BILL_RATE Number(27,3) DECIMAL(26,3) NOT NULL Billing Rate
    20 BILL_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Bill Currency Code
    21 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
    22 ASSET_TYPE Character(3) VARCHAR2(3) NOT NULL Asset Type
    010=IT Hardware
    020=IT Software
    040=Equipment
    050=Property
    060=Fleet
    070=Machinery
    080=Furniture
    090=Facility
    100=Intangible
    200=Asset Retirement Obligations
    999=Other
    23 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Asset Subtype

    Prompt Table: AM_SUBTYPE

    24 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
    25 MODEL Character(30) VARCHAR2(30) NOT NULL Model

    Prompt Table: MFG_MODEL

    26 DEF_CRATE_COST Character(15) VARCHAR2(15) NOT NULL The default Custom Rate Name for costing rate
    27 DEF_CRATE_BILL Character(15) VARCHAR2(15) NOT NULL The default Custom Rate Name for billing rate