CA_TEAM_PROM_VW

(SQL View)
 Index Back

Project Team Members Prompt Vw

Prompt table view of project team members.

SELECT DISTINCT TEAM.BUSINESS_UNIT ,TEAM.TEAM_MEMBER , TEAM.NAME , TEAM.NAME_PREFIX , TEAM.CITY , TEAM.STATE , TEAM.COUNTRY FROM PS_PC_TEAM_PROM_VW TEAM

  • Parent record: PROJECT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_PC_NONVW

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

    Prompt Table: PC_TEAM_EMP_VW

    3 NAME Character(50) VARCHAR2(50) NOT NULL Name
    4 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix
    1=Mr.
    2=Mrs.
    3=Ms.
    5 CITY Character(30) VARCHAR2(30) NOT NULL City
    6 STATE Character(6) VARCHAR2(6) NOT NULL State
    7 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country