JPM_CAREER_SRCH

(SQL View)
 Index Back

Career Profile Search View

Returns person profiles for those Emplid's that have a Career Plan defined.

SELECT %subrec(PER_KEY_SBR, A) , P.JPM_PROFILE_ID , P.JPM_JP_TYPE , A.NAME , A.NAME_DISPLAY_SRCH , A.LAST_NAME_SRCH , A.NAME_AC FROM PS_PERS_SRCH_GBL A , PS_JPM_PROFILE P , PS_JPM_JP_SEC_VW S WHERE A.EMPLID = P.EMPLID AND S.JPM_JP_TYPE = P.JPM_JP_TYPE AND S.JPM_ROLE = 'ADM' AND EXISTS ( SELECT 'X' FROM PS_CAREERPLAN C WHERE C.EMPLID = P.EMPLID)

  • Related Language Record: PERSON_NAME_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 ROWSECCLASS Character(30) VARCHAR2(30) NOT NULL The class used to determine row level security
    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    5 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.
    6 JPM_JP_TYPE Character(12) VARCHAR2(12) NOT NULL Profile Type name for a JPM Profile Type

    Prompt Table: JPM_JP_TYP_P_VW

    7 NAME Character(50) VARCHAR2(50) NOT NULL Name
    8 NAME_DISPLAY_SRCH Character(50) VARCHAR2(50) NOT NULL Uppercase version of Name to improve performance on searches.
    9 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
    10 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name