JPM_SRCH_SELECT (SQL View)	Index Back
Selected Profiles from search Selected profiles from Verity search results.

JPM_SRCH_SELECT

(SQL View)

Selected Profiles from search

Selected profiles from Verity search results.

SELECT ' ' , 0 , ' ' FROM PS_JPMINSTALLATION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 JPM_PROFILE_ID Character(12) VARCHAR2(12) NOT NULL The id, autoassigned or user assigned of the profile. This id is used to group items and other related material together into one coherent profile.

2 JPM_PCT_MATCH Number(3,0) SMALLINT NOT NULL Score

3 JPM_SRCH_MSG2 Character(100) VARCHAR2(100) NOT NULL Search Result Message

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	JPM_PROFILE_ID	Character(12)	VARCHAR2(12) NOT NULL	The id, autoassigned or user assigned of the profile. This id is used to group items and other related material together into one coherent profile.
2	JPM_PCT_MATCH	Number(3,0)	SMALLINT NOT NULL	Score
3	JPM_SRCH_MSG2	Character(100)	VARCHAR2(100) NOT NULL	Search Result Message