GM_TEAMEMBER_VW (SQL View)	Index Back
GM_TEAM_MEMBER This record is a view of the the team_members table

GM_TEAMEMBER_VW

(SQL View)

GM_TEAM_MEMBER

This record is a view of the the team_members table

SELECT A.SETID , A.SUPPORT_TEAM_MBR , A.NAME1 , A.TEAM_MEMBER_TYPE , B.SALES_PERSON FROM PS_MEMBER_PERSON A , PS_MEMBER_TYPE_TBL B WHERE A.TEAM_MEMBER_TYPE = B.TEAM_MEMBER_TYPE AND B.SETID = A.SETID AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_MEMBER_TYPE_TBL B1 WHERE B.SETID = B1.SETID AND B.TEAM_MEMBER_TYPE = B1.TEAM_MEMBER_TYPE AND B1.EFFDT <= %CurrentDateIn) AND B.SALES_PERSON = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 SALES_PERSON Character(8) VARCHAR2(8) NOT NULL Specifies the personnel code for the person who works with a customer as a sales representative. This field is required for a customer that functions as a bill-to customer.

3 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1

4 TEAM_MEMBER_TYPE Character(6) VARCHAR2(6) NOT NULL Team Member Type Code

5 SALES_PERSN_FLG Character(8) VARCHAR2(8) NOT NULL Specifies the personnel code for the person who works with a customer as a sales representative. This field is required for a customer that functions as a bill-to customer.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	SALES_PERSON	Character(8)	VARCHAR2(8) NOT NULL	Specifies the personnel code for the person who works with a customer as a sales representative. This field is required for a customer that functions as a bill-to customer.
3	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
4	TEAM_MEMBER_TYPE	Character(6)	VARCHAR2(6) NOT NULL	Team Member Type Code
5	SALES_PERSN_FLG	Character(8)	VARCHAR2(8) NOT NULL	Specifies the personnel code for the person who works with a customer as a sales representative. This field is required for a customer that functions as a bill-to customer.