RC_GRP_MEM_LVW

(SQL View)
 Index Back

Group Member Prompt View

This is a Provider Group Members Prompt View.

SELECT A.SETID , D.PROVIDER_GRP_ID , A.PERSON_ID , C.LANGUAGE_CD , C.NAME1 FROM PS_RF_PROVIDER_GRP D , PS_RF_PROVGRP_LNG C , PS_RF_GRP_MEMBER A , PS_RD_PERSON_NAME B WHERE C.SETID = D.SETID AND C.PROVIDER_GRP_ID = D.PROVIDER_GRP_ID AND D.PROVIDER_GRP_ID = A.PROVIDER_GRP_ID AND D.STATUS = 'A' AND A.PERSON_ID = B.PERSON_ID AND A.STATUS = 'A' AND D.SETID = A.SETID AND B.PRIMARY_IND = 'Y'

  • Related Language Record for RC_GRP_MEM_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 PROVIDER_GRP_NAME Character(50) VARCHAR2(50) NOT NULL Provider Group Name