JPM_IDX_PROF_VW (SQL View)	Index Back
Searchable Profile Candidates Profile instances that may be searchable based on the profile type definition.

JPM_IDX_PROF_VW

(SQL View)

Searchable Profile Candidates

Profile instances that may be searchable based on the profile type definition.

SELECT A.JPM_PROFILE_ID , A.EMPLID , A.JPM_JP_TYPE FROM PS_JPM_PROFILE A WHERE A.JPM_PROFILE_USAGE IN ('J','P') AND A.JPM_JP_PRFL_STATUS = 'A' AND EXISTS ( SELECT 'X' FROM PS_JPM_JP_PROPS B WHERE B.JPM_JP_TYPE = A.JPM_JP_TYPE AND %EffdtCheck(JPM_JP_PROPS B1, B, %CurrentDateIn) AND B.JPM_SRCH_FLG = 'Y')

# 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERS_SRCH_GBL

3 JPM_JP_TYPE Character(12) VARCHAR2(12) NOT NULL Profile Type name for a JPM Profile Type
Prompt Table: %EDITTABLE

#	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	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERS_SRCH_GBL
3	JPM_JP_TYPE	Character(12)	VARCHAR2(12) NOT NULL	Profile Type name for a JPM Profile Type Prompt Table: %EDITTABLE