RC_GRP_MEM_VWX (SQL View)	Index Back
Group Member Prompt View This view brings the name and provider id of provider groups.The view is modified to accomodate inactive provider groups.

RC_GRP_MEM_VWX

(SQL View)

Group Member Prompt View

This view brings the name and provider id of provider groups.The view is modified to accomodate inactive provider groups.

SELECT A.SETID , A.NAME1 ,A.STATUS FROM PS_RF_PROVIDER_GRP A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

2 PROVIDER_GRP_NAME Character(50) VARCHAR2(50) NOT NULL Provider Group Name

3 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
2	PROVIDER_GRP_NAME	Character(50)	VARCHAR2(50) NOT NULL	Provider Group Name
3	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive