JPM_JPGMPFL_LVW

(SQL View)
Index Back

Group Members/Groups joined

Used 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

  • Related Language Record for JPM_JP_GMPFL_VW
  • # 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