HRS_SRCH_PRP_V2 (SQL View)	Index Back
HRS Searchable Properties selects all properties that are searchable for the intersection of the primary Person profile type content sectiona and resume template section properties

HRS_SRCH_PRP_V2

(SQL View)

HRS Searchable Properties

selects all properties that are searchable for the intersection of the primary Person profile type content sectiona and resume template section properties

SELECT DISTINCT HRSCTCFG.JPM_JP_TYPE ,HRSCTCFG.JPM_CAT_TYPE ,JPMPRIPI.FIELDNAME ,JPMPRIPI.JPM_LABEL_TEXT FROM PS_HRS_SCT_CFG_VW HRSCTCFG , PS_JPM_PRI_P_PRP_I JPMPRIPI WHERE HRSCTCFG.JPM_JP_TYPE = JPMPRIPI.JPM_JP_TYPE AND HRSCTCFG.JPM_CAT_TYPE = JPMPRIPI.JPM_CAT_TYPE AND JPMPRIPI.JPM_JP_SRCH_FLG = 'Y'

Related Language Record: HRS_SRCH_PRPLV2

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 JPM_JP_TYPE Character(12) VARCHAR2(12) NOT NULL Profile Type name for a JPM Profile Type

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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	JPM_JP_TYPE	Character(12)	VARCHAR2(12) NOT NULL	Profile Type name for a JPM Profile Type
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.