PC_TEAM_SC2_WVW

(SQL View)
 Index Back

Project Team Member work View

Work view of project team schedule. Used as primary record (instead of work record0 in the project team component.

SELECT SC.BUSINESS_UNIT , SC.PROJECT_ID , SC.TEAM_MEMBER_CLASS , SC.TEAM_MEMBER_IND , SC.TEAM_MEMBER , SC.SCHED_NUM , SC.PROJ_ROLE , SC.START_DT , SC.END_DT , SC.DESCR FROM PS_PROJ_TEAM_SCHED SC

  • 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: PC_TEAM_SUMR_VW

    6 SCHED_NUM Number(5,0) INTEGER NOT NULL Team sequence number
    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 DESCR Character(30) VARCHAR2(30) NOT NULL Description