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.SEQ_NUM , JPM_ROLE , JPM_SOURCE_JP , JPM_TARGET_JP , JPM_DISPLAY_MAX , JPM_CRITERIA_RULE , JPM_SRCH_NAME , JPM_SRCH_ALGORITHM 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.SEQ_NUM = B.SEQ_NUM 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
    3 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
    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(50) VARCHAR2(50) NOT NULL Search Name
    10 JPM_SRCH_ALGORITHM Character(4) VARCHAR2(4) NOT NULL Search Algorithm
    1=Ratings in excess get < 100%
    2=Ratings in excess get 100%