SALES_MEMBER_VW (SQL View)	Index Back
Sales Member - priority 1 view This view selects the priority 1 sales person for a SupportTeam

SALES_MEMBER_VW

(SQL View)

Sales Member - priority 1 view

This view selects the priority 1 sales person for a SupportTeam

SELECT TC.SETID , TC.SUPPORT_TEAM_CD , TC.EFFDT , TM.SUPPORT_TEAM_MBR , TM.MANAGER , TM.PRIORITY FROM PS_TEAM_CODE_TBL TC , PS_TEAM_MEMBERS TM , PS_MEMBER_PERSON MP WHERE TC.SETID = TM.SETID AND TC.SUPPORT_TEAM_CD = TM.SUPPORT_TEAM_CD AND TC.EFFDT = TM.EFFDT AND %EffdtCheck(TEAM_CODE_TBL TC2, TC, %CurrentDateIn) AND TC.EFF_STATUS = 'A' AND TM.SETID = MP.SETID AND TM.SUPPORT_TEAM_MBR = MP.SUPPORT_TEAM_MBR AND MP.EFF_STATUS = 'A' AND %EffdtCheck(TEAM_MEMBERS TM2, TM, %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 SUPPORT_TEAM_CD Character(6) VARCHAR2(6) NOT NULL Support Team Code

3 EFFDT Date(10) DATE Effective Date
Default Value: %date

4 SUPPORT_TEAM_MBR Character(8) VARCHAR2(8) NOT NULL Team Member

5 MANAGER Character(1) VARCHAR2(1) NOT NULL Manager

6 PRIORITY Number(3,0) SMALLINT NOT NULL Priority

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	SUPPORT_TEAM_CD	Character(6)	VARCHAR2(6) NOT NULL	Support Team Code
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	SUPPORT_TEAM_MBR	Character(8)	VARCHAR2(8) NOT NULL	Team Member
5	MANAGER	Character(1)	VARCHAR2(1) NOT NULL	Manager
6	PRIORITY	Number(3,0)	SMALLINT NOT NULL	Priority