TEAM_MEMBERS_VW (SQL View)	Index Back
Sales Team Members This record stores the individual member codes of the Support Team, and the member designated as the manager. This is an optional record.

TEAM_MEMBERS_VW

(SQL View)

Sales Team Members

This record stores the individual member codes of the Support Team, and the member designated as the manager. This is an optional record.

SELECT m.setid , m.support_team_cd , m.effdt , m.support_team_mbr , m.manager , m.priority , t.eff_status FROM PS_TEAM_MEMBERS m , ps_team_code_tbl t WHERE m.setid = t.setid AND m.support_team_cd = t.support_team_cd AND m.effdt = t.effdt

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

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

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

4 SUPPORT_TEAM_MBR Character(8) VARCHAR2(8) NOT NULL Team Member
Prompt Table: MEMBER_ACTIV_VW

5 MANAGER Character(1) VARCHAR2(1) NOT NULL Manager
Y/N Table Edit
Default Value: N

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

7 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	SUPPORT_TEAM_CD	Character(6)	VARCHAR2(6) NOT NULL	Support Team Code
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	SUPPORT_TEAM_MBR	Character(8)	VARCHAR2(8) NOT NULL	Team Member Prompt Table: MEMBER_ACTIV_VW
5	MANAGER	Character(1)	VARCHAR2(1) NOT NULL	Manager Y/N Table Edit Default Value: N
6	PRIORITY	Number(3,0)	SMALLINT NOT NULL	Priority Default Value: 0
7	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive