RD_PRVGRP_SETID (SQL View)	Index Back
Provider Group Setids This view selects all SETIDS from RF_PROVIDER_GRP that have active provider groups associated with them. This view is used to fill a drop down on the Worker Groups page so that the user only sees SETIDS that have valid provider groups associated with them.

RD_PRVGRP_SETID

(SQL View)

Provider Group Setids

This view selects all SETIDS from RF_PROVIDER_GRP that have active provider groups associated with them. This view is used to fill a drop down on the Worker Groups page so that the user only sees SETIDS that have valid provider groups associated with them.

SELECT DISTINCT SETID FROM PS_RF_PROVIDER_GRP WHERE STATUS = '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.