HRS_PPROFL_I

(SQL View)
 Index Back

Active Person Profiles Intfc

Used to allow secure search for JPM Person Profiles when creating RS Job Openings or updating Profiles within a Job Opening - RS Administrator only

SELECT DISTINCT OPR.OPRID , SEC.EMPLID , P.JPM_PROFILE_ID , P.JPM_JP_TYPE , NM.NAME , NM.NAME_DISPLAY_SRCH , NM.LAST_NAME_SRCH , NM.NAME_AC FROM PS_SJT_PERSON SEC , PS_JPM_JP_SEC_VW S , PS_NAMES NM , PSOPRDEFN OPR , PS_JPM_PROFILE P WHERE SEC.EMPLID = P.EMPLID AND SEC.EMPLID = NM.EMPLID AND SEC.HR_STATUS = 'A' AND P.JPM_JP_PRFL_STATUS = 'A' AND S.JPM_JP_TYPE = P.JPM_JP_TYPE AND P.JPM_JP_TYPE = ( SELECT JPM_PRI_PERS_TYPE FROM PS_JPM_JP_PRI_TYPE) AND S.JPM_ROLE = 'EMP' AND SEC.APPT_TYPE <> '1' AND NM.EMPLID = SEC.EMPLID AND NM.NAME_TYPE = 'PRI' AND NM.EFFDT = ( SELECT MAX(NM1.EFFDT) FROM PS_NAMES NM1 WHERE NM1.EMPLID = NM.EMPLID AND NM1.NAME_TYPE = 'PRI' AND NM1.EFFDT <= %CurrentDateIn) AND (EXISTS ( SELECT 'X' FROM PS_SJT_CLASS_ALL CLS , PS_SJT_OPR_CLS SOC WHERE CLS.SCRTY_SET_CD = 'PPLJOB' AND CLS.SCRTY_TYPE_CD = SEC.SCRTY_TYPE_CD AND CLS.SCRTY_KEY1 = SEC.SCRTY_KEY1 AND CLS.SCRTY_KEY2 = SEC.SCRTY_KEY2 AND CLS.SCRTY_KEY3 = SEC.SCRTY_KEY3 AND CLS.TREE = 'Y' AND SOC.OPRID=OPR.OPRID AND SOC.CLASSID = CLS.CLASSID AND SOC.CLASSID = OPR.ROWSECCLASS AND SOC.SEC_RSC_FLG = '1' ) OR EXISTS ( SELECT 'X' FROM PS_SJT_CLASS_ALL CLS , PS_SJT_OPR_CLS SOC WHERE CLS.SCRTY_SET_CD = 'PPLJOB' AND CLS.SCRTY_TYPE_CD = SEC.SCRTY_TYPE_CD AND CLS.SCRTY_KEY1 = SEC.SCRTY_KEY1 AND CLS.SCRTY_KEY2 = SEC.SCRTY_KEY2 AND CLS.SCRTY_KEY3 = SEC.SCRTY_KEY3 AND CLS.TREE = 'N' AND SOC.OPRID=OPR.OPRID AND SOC.CLASSID = CLS.CLASSID ) OR EXISTS ( SELECT 'X' FROM PS_SJT_CLASS_ALL CLS , PS_SJT_OPR_CLS SOC WHERE CLS.SCRTY_SET_CD = 'PPLJOB' AND CLS.SCRTY_TYPE_CD = SEC.SCRTY_TYPE_CD AND CLS.SCRTY_KEY1 = SEC.SCRTY_KEY1 AND CLS.SCRTY_KEY2 = SEC.SCRTY_KEY2 AND CLS.SCRTY_KEY3 = SEC.SCRTY_KEY3 AND CLS.TREE = 'Y' AND SOC.OPRID=OPR.OPRID AND SOC.CLASSID = CLS.CLASSID AND SOC.CLASSID = OPR.ROWSECCLASS AND SOC.SEC_RSC_FLG = '3' ))

  • Related Language Record: HRS_PPROFL_I_LN

    • # 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    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.
    4 JPM_JP_TYPE Character(12) VARCHAR2(12) NOT NULL Profile Type name for a JPM Profile Type

    Prompt Table: JPM_JP_PTYPE_VW

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