SPB_TEAM_PER_VW

(SQL View)
 Index Back

Team by Oprid

Team by Oprid

SELECT A.SETID , A.TEAM_ID , C.OPRID , A.DESCR FROM PS_SPB_TEAM A , PS_SPB_MEM_BY_TEAM B , PSOPRALIAS C WHERE A.SETID = B.SETID AND A.TEAM_ID = B.TEAM_ID AND A.TEAM_TYPE = B.TEAM_TYPE AND B.PERSON_ID = C.PERSON_ID AND C.OPRALIASTYPE = 'SPP' AND A.EFF_STATUS = 'A' AND %EffdtCheck(SPB_TEAM,A,%CurrentDateIn)

  • Related Language Record: SPB_TEAM_PER_LG

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