SPB_TEAM_MEM_VW(SQL View) |
Index Back |
---|---|
Team Person ViewTeam 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 |