JPM_SRCH_CFG_V2

(SQL View)
 Index Back

JPM Search Configuration

Selects search configuration entries for each role.

SELECT A.OBJECTOWNERID , A.JPM_SRCH_SUB_ID , A.JPM_SRCH_ID , JPM_ROLE , JPM_SOURCE_JP , JPM_TARGET_JP , JPM_DISPLAY_MAX , JPM_CRITERIA_RULE , JPM_SRCH_NAME , JPM_SRCH_RANK_MTHD , JPM_DISP_EMPLID , JPM_DISP_INT_LIST , JPM_CSC_PCFG_ID , JPM_CSC_NPCFG_ID FROM PS_JPM_SRCH_CFG A , PS_JPM_SRCH_ROLE B WHERE A.OBJECTOWNERID = B.OBJECTOWNERID AND A.JPM_SRCH_SUB_ID = B.JPM_SRCH_SUB_ID AND A.JPM_SRCH_ID = B.JPM_SRCH_ID AND A.EFF_STATUS = 'A'

  • Related Language Record: JPM_SRCH_CFGLV2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
    2 JPM_SRCH_SUB_ID Character(4) VARCHAR2(4) NOT NULL Sub Application Id
    SP=Succession Planning
    3 JPM_SRCH_ID Character(18) VARCHAR2(18) NOT NULL Search Id
    4 JPM_ROLE Character(3) VARCHAR2(3) NOT NULL Role
    ADM=Administrator
    EMP=Employee
    MGR=Manager
    5 JPM_SOURCE_JP Character(12) VARCHAR2(12) NOT NULL Source Profile

    Prompt Table: JPM_JP_TYPES

    6 JPM_TARGET_JP Character(12) VARCHAR2(12) NOT NULL Target Profile

    Prompt Table: JPM_JP_TYPES

    7 JPM_DISPLAY_MAX Number(4,0) SMALLINT NOT NULL Search Display Maximum

    Default Value: 10

    8 JPM_CRITERIA_RULE Character(1) VARCHAR2(1) NOT NULL Search Criteria Rule
    A=No Default, Display (Adhoc)
    D=Default and Display
    N=Default, No Display
    9 JPM_SRCH_NAME Character(100) VARCHAR2(100) NOT NULL Search Name
    10 JPM_SRCH_RANK_MTHD Character(1) VARCHAR2(1) NOT NULL Rating Relevancy
    F=Closest Fit
    R=Relative to Person Rating
    11 JPM_DISP_EMPLID Character(1) VARCHAR2(1) NOT NULL Empl ID
    12 JPM_DISP_INT_LIST Character(1) VARCHAR2(1) NOT NULL Add to Interest List Button
    13 JPM_CSC_PCFG_ID Character(10) VARCHAR2(10) NOT NULL Person Compare ID
    14 JPM_CSC_NPCFG_ID Character(10) VARCHAR2(10) NOT NULL Non-Person Compare ID