JPM_SRCH_GRP_VW(SQL View) |
Index Back |
---|---|
JPM Profile Groups ViewProfile Search Filter grid view |
SELECT JPM_JP_GRP_TYPE ,JPM_JP_GROUP FROM PS_JPM_JP_GROUPS |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | JPM_JP_GRP_TYPE | Character(12) | VARCHAR2(12) NOT NULL |
Group type to which a JPM profile group belongs
Prompt Table: JPM_SRCH_GTP_VW |
2 | JPM_JP_GROUP | Character(12) | VARCHAR2(12) NOT NULL |
ID of the Profile Group to which a JPM profile belongs
Prompt Table: JPM_JP_GROUPS |