JPM_EPROFL_SRCH (SQL View)	Index Back
CI SRCH- NO ROWLVL SECURITY JPM_EPROFL_SRCH is an Person Profile Search record containing employee search keys This view does not use the Department Security Tree. It is only used by CI updates where the security was already handled by the process calling the CI. This view is used as the default search record for the Person profile component to allow CI's to access all profiles. The search view JPM_PPROFL_SRCH should be specified on the menu as a search record override where row level security is required.

JPM_EPROFL_SRCH

(SQL View)

CI SRCH- NO ROWLVL SECURITY

JPM_EPROFL_SRCH is an Person Profile Search record containing employee search keys This view does not use the Department Security Tree. It is only used by CI updates where the security was already handled by the process calling the CI. This view is used as the default search record for the Person profile component to allow CI's to access all profiles. The search view JPM_PPROFL_SRCH should be specified on the menu as a search record override where row level security is required.

SELECT P.JPM_PROFILE_ID , P.EMPLID , P.JPM_JP_TYPE , A.NAME , A.LAST_NAME_SRCH , A.NAME_AC FROM PS_PERS_SRCH_ALL A , PS_JPM_PROFILE P WHERE A.EMPLID = P.EMPLID

# 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_ALL

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

4 NAME Character(50) VARCHAR2(50) NOT NULL Name

5 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name

6 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name

#	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_ALL
3	JPM_JP_TYPE	Character(12)	VARCHAR2(12) NOT NULL	Profile Type name for a JPM Profile Type Prompt Table: JPM_JP_PTYPE_VW
4	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
5	LAST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Last Name
6	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Alternate Character Name