SPF_WO_BU_TEAM2

(SQL View)
 Index Back

Team by Business Unit

Team by Business Unit

SELECT DISTINCT C.BUSINESS_UNIT , A.TEAM_ID , B.PERSON_ID , A.DESCR , P.OPRID FROM PS_SPB_TEAM A , PS_SPB_MEM_BY_TEAM B , PS_SPF_WORDERREC C , PS_SET_CNTRL_GROUP S , PSOPRALIAS P WHERE A.SETID =B.SETID AND A.TEAM_ID= B.TEAM_ID AND A.EFFDT=B.EFFDT AND A.TEAM_TYPE = B.TEAM_TYPE AND A.EFF_STATUS = 'A' AND B.TEAM_TYPE = 'SC' AND C.BUSINESS_UNIT = S.SETCNTRLVALUE AND S.REC_GROUP_ID = 'SP_02' AND B.SETID = S.SETID AND %EffdtCheck(SPB_TEAM,A,%CurrentDateIn) AND P.PERSON_ID = B.PERSON_ID AND P.OPRALIASTYPE = 'SPP'

  • Related Language Record: SPF_WO_TEAM_LG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 TEAM_ID Character(15) VARCHAR2(15) NOT NULL Team ID
    3 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).