PERSON_IDSETIDPrompt Table: SP_SETID_NONVW
PROVIDER_GRP_IDPrompt Table: RF_PROVGRP_VW2
A=Active
I=Inactive
Default Value: A
RD_PER_PRVGRP_V(SQL View) |
Index Back |
|---|---|
Person Provider Group MemberView to see which Provider Groups a person is a member of. |
| SELECT PERSON_ID , SETID , PROVIDER_GRP_ID , STATUS FROM PS_RF_GRP_MEMBER |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 2 | 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 |
| 3 | PROVIDER_GRP_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Identification number for the provider group.
Prompt Table: RF_PROVGRP_VW2 |
| 4 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive Default Value: A |