RC_GRP_MEM_VW

(SQL View)
 Index Back

Group Member Prompt View

This is a Provider Group Members Prompt View.

SELECT A.SETID , C.PROVIDER_GRP_ID , A.PERSON_ID , C.NAME1 , B.LAST_NAME , B.FIRST_NAME , B.BO_NAME_DISPLAY , B.NAME_AC FROM PS_RF_PROVIDER_GRP C , PS_RF_GRP_MEMBER A , PS_RD_PERSON_NAME B WHERE C.PROVIDER_GRP_ID = A.PROVIDER_GRP_ID AND C.STATUS = 'A' AND A.PERSON_ID = B.PERSON_ID AND A.STATUS = 'A' AND C.SETID = A.SETID AND B.PRIMARY_IND = 'Y'

  • Related Language Record: RC_GRP_MEM_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID_PROV_GRP Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    2 PROVIDER_GRP_ID Character(10) VARCHAR2(10) NOT NULL Identification number for the provider group.
    3 ASSIGNED_TO Character(15) VARCHAR2(15) NOT NULL This is a field to store assignment information.
    4 PROVIDER_GRP_NAME Character(50) VARCHAR2(50) NOT NULL Provider Group Name
    5 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    6 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
    7 BO_NAME_DISPLAY_5 Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object
    8 NAME_AC Character(50) VARCHAR2(50) NOT NULL Name (Alternate Character)