HRS_PPROFL_DR_I

(SQL View)
 Index Back

Active Person Profiles Intfc

Dynamic view used as prompt for JPM Person Profiles belonging to the currently logged-on user and their direct reports when creating RS Job Openings or updating Profiles within a Job Opening - for roles other than RS Administrator

SELECT PRFL.EMPLID , PRFL.JPM_PROFILE_ID , PRFL.JPM_JP_TYPE , PER.NAME_DISPLAY FROM PS_JPM_PROFILE_I PRFL , PS_PERSON_NAME PER , PS_JPM_JP_SEC_VW S WHERE PRFL.EMPLID = PER.EMPLID AND PRFL.JPM_JP_TYPE = S.JPM_JP_TYPE AND PRFL.JPM_JP_PRFL_STATUS = 'A' AND PRFL.JPM_JP_TYPE = ( SELECT JPM_PRI_PERS_TYPE FROM PS_JPM_JP_PRI_TYPE) AND S.JPM_ROLE = 'EMP'

  • Related Language Record: HRS_PPROFL_DR_L

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 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.
    3 JPM_JP_TYPE Character(12) VARCHAR2(12) NOT NULL Profile Type name for a JPM Profile Type

    Prompt Table: JPM_JP_PTYPE_VW

    4 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country