JPM_SRCH_CFGLV2

(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 , B.JPM_ROLE , L.LANGUAGE_CD , L.JPM_SRCH_NAME FROM PS_JPM_SRCH_CFG A , PS_JPM_SRCH_CFGLNG L , 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' AND A.OBJECTOWNERID = L.OBJECTOWNERID AND A.JPM_SRCH_SUB_ID = L.JPM_SRCH_SUB_ID AND A.JPM_SRCH_ID = L.JPM_SRCH_ID

  • Related Language Record for JPM_SRCH_CFG_V2

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 JPM_SRCH_NAME Character(100) VARCHAR2(100) NOT NULL Search Name