TL_PROJ_TEAM_VW

(SQL View)
 Index Back

TL Project Team Member View

This record is based on the PROJECT_TEAM record. However, it addes the Project ID and changes the Business Unit to Business Unit PC so that it may be used by TL for prompting during Time Reporting.

SELECT A.TEAM_MEMBER , A.BUSINESS_UNIT , A.PROJECT_ID , B.DESCR , A.START_DT , A.END_DT FROM PS_PROJECT_TEAM A , PS_PROJECT B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROJECT_ID = B.PROJECT_ID

  • Related Language Record: TL_PROJ_TEAM_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
    3 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project/Grant

    Prompt Table: PROJECT_VW

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 START_DT Date(10) DATE Start Date
    6 END_DT Date(10) DATE end date