RD_PRSN_GRP_VW (SQL View)	Index Back
Person Provider Group View Person Provider Group View. It lists out the provide group the person belongs to.

RD_PRSN_GRP_VW

(SQL View)

Person Provider Group View

Person Provider Group View. It lists out the provide group the person belongs to.

SELECT B.OPRID , A.BO_ID , B.RD_GROUP_ID , B.GROUP_NAME FROM PS_RD_GRP_MBR A , PS_RD_CNTCT_GROUP B WHERE A.RD_GROUP_ID = B.RD_GROUP_ID AND A.OPRID = B.OPRID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

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

3 RD_GROUP_ID Number(6,0) INTEGER NOT NULL Contact Group ID used to identify a group of Contacts.

4 GROUP_NAME Character(30) VARCHAR2(30) NOT NULL Contact Management - Group Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
3	RD_GROUP_ID	Number(6,0)	INTEGER NOT NULL	Contact Group ID used to identify a group of Contacts.
4	GROUP_NAME	Character(30)	VARCHAR2(30) NOT NULL	Contact Management - Group Name