RC_PROV_PER_VW

(SQL View)
Index Back

Provider - Person View

This view is used to get provider group ID and ID of group members.

SELECT DISTINCT C.SETID , C.PROVIDER_GRP_ID , B.PERSON_ID , D.NAME FROM PS_RF_PROVIDER_GRP C , PS_RF_GRP_MEMBER A , PS_RD_PERSON B , PS_RD_PERSON_NAME D WHERE C.SETID = A.SETID AND C.PROVIDER_GRP_ID = A.PROVIDER_GRP_ID AND C.STATUS = 'A' AND A.PERSON_ID = B.PERSON_ID AND A.STATUS = 'A' AND B.PERSON_ID = D.PERSON_ID AND D.PRIMARY_IND = 'Y'

# 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.

Prompt Table: SP_SETID_NONVW

2 PROVIDER_GRP_ID Character(10) VARCHAR2(10) NOT NULL Identification number for the provider group.
3 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
4 NAME_ASSIGNED_TO Character(80) VARCHAR2(80) NOT NULL The name of the assigned agent.