RBW_ACT_TEAM_VW (SQL View)	Index Back
Client Account team This view is returns the Active Account Team members associated with a Client.

RBW_ACT_TEAM_VW

(SQL View)

Client Account team

This view is returns the Active Account Team members associated with a Client.

SELECT A.BO_ID_2 , B.PERSON_ID , A.BO_ID_1 FROM PS_BO_REL A , PS_RB_WORKER_VW B WHERE A.BO_ID_1 = B.BO_ID AND A.ROLE_TYPE_ID_2 = 9 AND B.EMPL_STATUS = 'A' AND EXISTS ( SELECT 'X' FROM PS_RD_ACCT_TM_VW P WHERE A.REL_TYPE_ID = P.REL_TYPE_ID AND A.BO_ID_2 = P.BO_ID_2 AND P.ROLE_TYPE_ID_2 = 9) AND A.START_DT <= %CurrentDateIn AND A.END_DT > %CurrentDateIn

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BO_ID_2 Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID 2

2 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

3 BO_ID_1 Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID 1

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_ID_2	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID 2
2	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
3	BO_ID_1	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID 1