SPF_WO_TEAM_LG

(SQL View)
 Index Back

Team by Business Unit

Team by Business Unit

SELECT DISTINCT C.BUSINESS_UNIT , A.TEAM_ID , B.PERSON_ID , L.LANGUAGE_CD , L.DESCR FROM PS_SPB_TEAM A , PS_SPB_TEAM_LANG L , PS_SPB_MEM_BY_TEAM B , PS_SPF_WORDERREC C , PS_SET_CNTRL_GROUP S WHERE A.SETID =B.SETID AND A.TEAM_ID= B.TEAM_ID AND A.SETID = L.SETID AND A.TEAM_ID = L.TEAM_ID AND A.EFFDT = L.EFFDT AND A.TEAM_TYPE = L.TEAM_TYPE 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)

  • Related Language Record for SPF_WO_BU_TEAM SPF_WO_BU_TEAM2

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description