SPB_TEAM_MEM_VW

(SQL View)
Index Back

Team Person View

Team Person View based on a team id Date Initials Reference # Description 08/28/2008 Raja 1767512003 Now effective dated team is selected for creating worklist/email for the service providers.

SELECT DISTINCT SETID , TEAM_ID ,A.PERSON_ID ,A.NOTIFY ,NAME FROM PS_SPB_MEM_BY_TEAM A , PS_SPB_PERSON_TBL B WHERE A.PERSON_ID =B.PERSON_ID AND A.EFFDT=( SELECT MAX(EFFDT) FROM PS_SPB_MEM_BY_TEAM C WHERE C.SETID=A.SETID AND C.TEAM_ID=A.TEAM_ID AND C.TEAM_TYPE=A.TEAM_TYPE AND C.EFFDT<=%CurrentDateIn)

# 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 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
4 NOTIFY Character(1) VARCHAR2(1) NOT NULL Field to specify the notification method - WorkList only, Email only or Worklist and Email
B=Email and Worklist
N=None
W=WorkList Only
5 NAME Character(50) VARCHAR2(50) NOT NULL Name