RF_GRPMEM_ADDVW

(SQL View)
Index Back

Group Member Add View

Search view used when adding a new member to a provider group.

SELECT A.SETID , A.PROVIDER_GRP_ID , A.PERSON_ID , B.BO_NAME_DISPLAY , B.NAME_AC , B.LAST_NAME , B.FIRST_NAME FROM PS_RF_GRP_MEMBER A , PS_RB_PRSN_P_NM_VW B WHERE A.PERSON_ID = B.PERSON_ID

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

Default Value: OPR_DEF_TBL_RB.SETID

Prompt Table: SP_SETID_NONVW

2 PROVIDER_GRP_ID Character(10) VARCHAR2(10) NOT NULL Identification number for the provider group.

Prompt Table: RF_PROVIDER_GRP

3 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

Prompt Table: RF_WORKER_VW

4 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object
5 NAME_AC Character(50) VARCHAR2(50) NOT NULL Name (Alternate Character)
6 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
7 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name