JPM_SRCH_PRP_V3 (SQL View)	Index Back
JPM Searchable Properties selects all properties that are searchable for a content section of a profile type. This is used by the JPM SES Search query a to return property attributes when then search use case has been specified. We will look at the search configuration property mapping to get the searchable fields and labels.

JPM_SRCH_PRP_V3

(SQL View)

JPM Searchable Properties

selects all properties that are searchable for a content section of a profile type. This is used by the JPM SES Search query a to return property attributes when then search use case has been specified. We will look at the search configuration property mapping to get the searchable fields and labels.

SELECT S1.OBJECTOWNERID ,S1.JPM_SRCH_SUB_ID ,S1.JPM_SRCH_ID ,S1.JPM_CAT_TYPE ,S1.JPM_TGT_FIELDNAME ,S1.JPM_SRC_FIELDNAME ,S1.JPM_LABEL_TEXT ,P.JPM_C_LIST_ID ,D.JPM_KEY_RECNAME ,P.JPM_PRP_DEFAULT ,C.JPM_JP_PSECTION_ID FROM PS_JPM_SRCH_PROPS S1 , PS_JPM_SRCH_CFG S2 , PS_JPM_JP_TYPES T , PS_JPM_JP_SECTION C ,PS_JPM_JP_PROPS P , PS_JPM_C_LIST_DEFN D WHERE S1.JPM_SRCH_FLG ='Y' AND S2.OBJECTOWNERID = S1.OBJECTOWNERID AND S2.JPM_SRCH_SUB_ID = S1.JPM_SRCH_SUB_ID AND S2.JPM_SRCH_ID = S1.JPM_SRCH_ID AND T.JPM_JP_TYPE = S2.JPM_TARGET_JP AND %EffdtCheck(JPM_JP_TYPES T1, T, %CurrentDateIn) AND C.JPM_JP_TYPE = T.JPM_JP_TYPE AND C.EFFDT = T.EFFDT AND C.JPM_CAT_TYPE = S1.JPM_CAT_TYPE AND P.JPM_JP_TYPE = C.JPM_JP_TYPE AND P.JPM_JP_SECTION_ID= C.JPM_JP_SECTION_ID AND P.EFFDT = C.EFFDT AND P.FIELDNAME = S1.JPM_TGT_FIELDNAME AND D.JPM_C_LIST_ID = P.JPM_C_LIST_ID AND %EffdtCheck(JPM_C_LIST_DEFN D1, D, %CurrentDateIn) UNION SELECT S1.OBJECTOWNERID ,S1.JPM_SRCH_SUB_ID ,S1.JPM_SRCH_ID ,S1.JPM_CAT_TYPE ,S1.JPM_TGT_FIELDNAME ,S1.JPM_SRC_FIELDNAME ,S1.JPM_LABEL_TEXT ,' ' ,' ' ,P.JPM_PRP_DEFAULT ,C.JPM_JP_PSECTION_ID FROM PS_JPM_SRCH_PROPS S1 , PS_JPM_SRCH_CFG S2 , PS_JPM_JP_TYPES T , PS_JPM_JP_SECTION C ,PS_JPM_JP_PROPS P WHERE S1.JPM_SRCH_FLG ='Y' AND S2.OBJECTOWNERID = S1.OBJECTOWNERID AND S2.JPM_SRCH_SUB_ID = S1.JPM_SRCH_SUB_ID AND S2.JPM_SRCH_ID = S1.JPM_SRCH_ID AND T.JPM_JP_TYPE = S2.JPM_TARGET_JP AND %EffdtCheck(JPM_JP_TYPES T1, T, %CurrentDateIn) AND C.JPM_JP_TYPE = T.JPM_JP_TYPE AND C.EFFDT = T.EFFDT AND C.JPM_CAT_TYPE = S1.JPM_CAT_TYPE AND P.JPM_JP_TYPE = C.JPM_JP_TYPE AND P.JPM_JP_SECTION_ID= C.JPM_JP_SECTION_ID AND P.EFFDT = C.EFFDT AND P.FIELDNAME = S1.JPM_TGT_FIELDNAME AND P.JPM_C_LIST_ID = ' '

Related Language Record: JPM_SRCH_PRPLV3

# 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 JPM_SRC_FIELDNAME Character(18) VARCHAR2(18) NOT NULL Source field for a search compare.

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.

8 JPM_C_LIST_ID Character(18) VARCHAR2(18) NOT NULL JPM Custom prompt list id

9 JPM_KEY_RECNAME Character(15) VARCHAR2(15) NOT NULL JPM - Record Name

10 JPM_PRP_DEFAULT Character(10) VARCHAR2(10) NOT NULL Property Default

11 JPM_JP_PSECTION_ID Number(4,0) SMALLINT NOT NULL Parent Section Id on Profile Types

#	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	JPM_SRC_FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Source field for a search compare.
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.
8	JPM_C_LIST_ID	Character(18)	VARCHAR2(18) NOT NULL	JPM Custom prompt list id
9	JPM_KEY_RECNAME	Character(15)	VARCHAR2(15) NOT NULL	JPM - Record Name
10	JPM_PRP_DEFAULT	Character(10)	VARCHAR2(10) NOT NULL	Property Default
11	JPM_JP_PSECTION_ID	Number(4,0)	SMALLINT NOT NULL	Parent Section Id on Profile Types