RC_GRP_MEM_LVW6

(SQL View)
 Index Back

Group Member Prompt View

This is a Provider Group Members Prompt View.

SELECT D.SETID , D.PROVIDER_GRP_ID , C.LANGUAGE_CD , C.NAME1 FROM PS_RF_PROVIDER_GRP D ,PS_RF_PROVGRP_LNG C WHERE C.SETID = D.SETID AND C.PROVIDER_GRP_ID = D.PROVIDER_GRP_ID

  • Related Language Record for RC_GRP_MEM_VW6

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