JPM_JPGMPFL_LVW(SQL View) |
Index Back |
---|---|
Group Members/Groups joinedUsed by the non-person profile advanced search. Language record |
SELECT DISTINCT GMEM.JPM_JP_GROUP , GRPS.JPM_JP_GRP_TYPE , GRPS.LANGUAGE_CD , GMEM.JPM_PROFILE_ID , GRPS.DESCR FROM PS_JPM_JP_GMEMB GMEM , PS_JPM_JP_GRP_LNG GRPS WHERE GRPS.JPM_JP_GRP_TYPE = GMEM.JPM_JP_GRP_TYPE AND GRPS.JPM_JP_GROUP = GMEM.JPM_JP_GROUP |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | JPM_JP_GROUP | Character(12) | VARCHAR2(12) NOT NULL | ID of the Profile Group to which a JPM profile belongs |
2 | JPM_JP_GRP_TYPE | Character(12) | VARCHAR2(12) NOT NULL | Group type to which a JPM profile group belongs |
3 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
4 | JPM_PROFILE_ID | Character(12) | VARCHAR2(12) NOT NULL | The id, autoassigned or user assigned of the profile. This id is used to group items and other related material together into one coherent profile. |
5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |