JPM_SRCH_PRP_V2 (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 both the Search and the Compare process to return property attributes. Use this view when then search use case has not been specified, so we don't have the search configuration property mapping.

JPM_SRCH_PRP_V2

(SQL View)

JPM Searchable Properties

selects all properties that are searchable for a content section of a profile type. This is used by both the Search and the Compare process to return property attributes. Use this view when then search use case has not been specified, so we don't have the search configuration property mapping.

SELECT A.JPM_JP_TYPE ,C.JPM_CAT_TYPE ,A.FIELDNAME ,A.JPM_LABEL_TEXT ,A.JPM_C_LIST_ID ,D.JPM_KEY_RECNAME ,A.JPM_PRP_DEFAULT ,C.JPM_JP_PSECTION_ID FROM PS_JPM_JP_TYPES T , PS_JPM_JP_PROPS A , PS_JPM_JP_SECTION C , PS_JPM_C_LIST_DEFN D WHERE %EffdtCheck(JPM_JP_TYPES T1, T, %CurrentDateIn) AND C.JPM_JP_TYPE = T.JPM_JP_TYPE AND C.EFFDT = T.EFFDT AND A.JPM_JP_TYPE = C.JPM_JP_TYPE AND A.EFFDT = C.EFFDT AND A.JPM_JP_SECTION_ID= C.JPM_JP_SECTION_ID AND D.JPM_C_LIST_ID = A.JPM_C_LIST_ID AND %EffdtCheck(JPM_C_LIST_DEFN D1, D, %CurrentDateIn) AND A.JPM_SRCH_FLG ='Y' UNION SELECT A.JPM_JP_TYPE ,C.JPM_CAT_TYPE ,A.FIELDNAME ,A.JPM_LABEL_TEXT ,' ' ,' ' ,A.JPM_PRP_DEFAULT ,C.JPM_JP_PSECTION_ID FROM PS_JPM_JP_TYPES T , PS_JPM_JP_PROPS A , PS_JPM_JP_SECTION C WHERE %EffdtCheck(JPM_JP_TYPES T1, T, %CurrentDateIn) AND C.JPM_JP_TYPE = T.JPM_JP_TYPE AND C.EFFDT = T.EFFDT AND A.JPM_JP_TYPE = C.JPM_JP_TYPE AND A.EFFDT = C.EFFDT AND A.JPM_JP_SECTION_ID= C.JPM_JP_SECTION_ID AND A.JPM_C_LIST_ID = ' ' AND A.JPM_SRCH_FLG ='Y'

Related Language Record: JPM_SRCH_PRPLV2

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 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.

3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

4 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.

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

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

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

8 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	JPM_TARGET_JP	Character(12)	VARCHAR2(12) NOT NULL	Target Profile
2	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.
3	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
4	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.
5	JPM_C_LIST_ID	Character(18)	VARCHAR2(18) NOT NULL	JPM Custom prompt list id
6	JPM_KEY_RECNAME	Character(15)	VARCHAR2(15) NOT NULL	JPM - Record Name
7	JPM_PRP_DEFAULT	Character(10)	VARCHAR2(10) NOT NULL	Property Default
8	JPM_JP_PSECTION_ID	Number(4,0)	SMALLINT NOT NULL	Parent Section Id on Profile Types