JPM_SRCH_PRPLV3

(SQL View)
 Index Back

JPM Searchable Properties

selects all properties that are searchable for a content section of a profile type.

SELECT S1.OBJECTOWNERID ,S1.JPM_SRCH_SUB_ID , S1.JPM_SRCH_SUB_ID ,S1.JPM_CAT_TYPE ,S1.JPM_TGT_FIELDNAME ,S1.LANGUAGE_CD ,S1.JPM_LABEL_TEXT FROM PS_JPM_SRCH_PROPS S ,PS_JPM_SRCH_PRPLNG S1 WHERE S.JPM_SRCH_FLG ='Y' AND S1.OBJECTOWNERID = S.OBJECTOWNERID AND S1.JPM_SRCH_SUB_ID = S.JPM_SRCH_SUB_ID AND S1.JPM_SRCH_ID = S.JPM_SRCH_ID

  • Related Language Record for JPM_SRCH_PRP_V3

    • # 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_CAT_TYPE Character(12) VARCHAR2(12) NOT NULL The name of the type of items that will be used in a Catalog and or in a Profile.
    5 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 JPM_LABEL_TEXT Character(30) VARCHAR2(30) NOT NULL User defined text to be displayed as a label for a field or property within JPM User Interfaces.