PC_RES_DTL_VW

(SQL View)
 Index Back

Project Team Resource

Project Team Resouce search view

SELECT DISTINCT A.BUSINESS_UNIT , A.PROJECT_ID , A.TEAM_MEMBER , CASE WHEN A.PERSON_NAME = ' ' THEN A.TEAM_MEMBER ELSE A.PERSON_NAME END , A.PROJ_ROLE , B.DESCR , A.RESOURCE_STS , A.TEAM_MEMBER_IND FROM PS_PC_PROJ_TEAM_VW A LEFT OUTER JOIN PS_PROJ_ROLE B ON B.PROJ_ROLE = A.PROJ_ROLE WHERE B.SETID = ( SELECT C.SETID FROM PS_SET_CNTRL_REC C WHERE C.RECNAME = 'PROJ_ROLE' AND C.SETCNTRLVALUE = A.BUSINESS_UNIT)

  • Related Language Record: PC_RES_DTL_LVW

    • # 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
    4 PERSON_NAME Character(100) VARCHAR2(100) NOT NULL Name
    5 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role

    Prompt Table: PROJ_ROLE

    6 PROJ_ROLE_DESCR Character(30) VARCHAR2(30) NOT NULL Project Role
    7 RESOURCE_STS Character(2) VARCHAR2(2) NOT NULL 11/15/2004 - New field added.
    AL=Allocated
    CA=Cancelled
    CM=Committed
    CO=Considered
    CP=Completed
    RE=Rejected
    RQ=Requested
    8 TEAM_MEMBER_IND Character(1) VARCHAR2(1) NOT NULL Team Member Indicator
    E=Employee
    G=Generic Resource
    N=Not Applicable