GM_MD_TEAM_VW

(SQL View)
 Index Back

Award Prj Team Member Schedule

Max Project Team Member Schedule associated with an award

SELECT DISTINCT CA.CONTRACT_NUM ,SC.BUSINESS_UNIT , SC.PROJECT_ID , SC.TEAM_MEMBER_CLASS , SC.TEAM_MEMBER_IND , SC.TEAM_MEMBER , SC.PROJ_ROLE , SC.SCHED_NUM , PRJTM.TEAM_SCHED_CNT , SC.START_DT , SC.END_DT FROM PS_CA_DETAIL_PROJ CA , PS_PROJECT_TEAM PRJTM , PS_PROJ_TEAM_SCHED SC WHERE CA.BUSINESS_UNIT_PC = SC.BUSINESS_UNIT AND CA.PROJECT_ID = SC.PROJECT_ID AND %Join(COMMON_KEYS, PROJECT_TEAM PRJTM, PROJ_TEAM_SCHED SC) AND SC.SCHED_NUM = ( SELECT MAX(SC1.SCHED_NUM) FROM PS_PROJ_TEAM_SCHED SC1 WHERE SC.BUSINESS_UNIT = SC1.BUSINESS_UNIT AND SC.PROJECT_ID = SC1.PROJECT_ID AND SC.TEAM_MEMBER_CLASS = SC1.TEAM_MEMBER_CLASS AND SC.TEAM_MEMBER_IND = SC1.TEAM_MEMBER_IND AND SC.TEAM_MEMBER = SC1.TEAM_MEMBER ) AND PRJTM.TEAM_MEMBER_CLASS = 'L' AND PRJTM.TEAM_MEMBER_IND = 'E'

  • Parent record: PROJECT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
    4 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
    5 TEAM_MEMBER_IND Character(1) VARCHAR2(1) NOT NULL Team Member Indicator
    E=Employee
    G=Generic Resource
    N=Not Applicable
    6 TEAM_MEMBER Character(30) VARCHAR2(30) NOT NULL Team Member
    7 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role
    8 SCHED_NUM Number(5,0) INTEGER NOT NULL Team sequence number
    9 TEAM_SCHED_CNT Number(4,0) SMALLINT NOT NULL Project Team Count
    10 START_DT Date(10) DATE Start Date
    11 END_DT Date(10) DATE NOT NULL End Date