JPM_GRP_MEM_VW

(SQL View)
 Index Back

JPM Profile Group Members

Profile Group Member table for Job Profile Management. Contains the profile IDs of profile that belong to the group.

SELECT A.JPM_JP_GRP_TYPE , A.JPM_JP_GROUP , A.JPM_PROFILE_ID , B.DESCR , B.JPM_JP_TYPE , B.EMPLID FROM PS_JPM_JP_GMEMB A , PS_JPM_PROFILE B WHERE A.JPM_PROFILE_ID = B.JPM_PROFILE_ID

  • Related Language Record: JPM_GRP_MEM_LVW

    • # 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_JP_GTYPE

    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

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

    Prompt Table: JPM_JP_GRP_VW

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

    Default Value: JPM_PROFILE.DESCR

    5 JPM_JP_TYPE Character(12) VARCHAR2(12) NOT NULL Profile Type name for a JPM Profile Type
    6 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID