JPM_SUCC_SRCH (SQL View)	Index Back
CI SRCH- NO ROWLVL SECURITY EMPLMT_SRCH_ALL is an Employment Search record containing all of the localized alternate search keys This view does not use the Department Security Tree. It is only used by CI updates (CI_JOB_DATA) where the security was already handled by the process calling the CI. This allows processes that aren't using Dept Security (such as Self Service and Kenmu) to update the Job rows that they need to even if the user running the CI does not have dept security access. To reapply Dept Security to the CIs, open the EMPLMT_SRCH_SAV view and do a save as EMPLMT_SRCH_ALL and overwrite this view.

JPM_SUCC_SRCH

(SQL View)

CI SRCH- NO ROWLVL SECURITY

EMPLMT_SRCH_ALL is an Employment Search record containing all of the localized alternate search keys This view does not use the Department Security Tree. It is only used by CI updates (CI_JOB_DATA) where the security was already handled by the process calling the CI. This allows processes that aren't using Dept Security (such as Self Service and Kenmu) to update the Job rows that they need to even if the user running the CI does not have dept security access. To reapply Dept Security to the CIs, open the EMPLMT_SRCH_SAV view and do a save as EMPLMT_SRCH_ALL and overwrite this view.

SELECT %subrec(PER_KEY_SBR, A) , P.JPM_PROFILE_ID , P.JPM_JP_TYPE , A.NAME , A.NAME_DISPLAY_SRCH , A.LAST_NAME_SRCH , A.NAME_AC FROM PS_PERS_SRCH_GBL A , PS_SUCCESSION_PLAN B , PS_JPM_PROFILE P , PS_JPM_JP_SEC_VW S WHERE A.EMPLID = P.EMPLID AND A.EMPLID = B.EMPLID AND S.JPM_JP_TYPE = P.JPM_JP_TYPE AND S.JPM_ROLE = 'ADM'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 ROWSECCLASS Character(30) VARCHAR2(30) NOT NULL The class used to determine row level security

3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

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

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

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

8 NAME_DISPLAY_SRCH Character(50) VARCHAR2(50) NOT NULL Uppercase version of Name to improve performance on searches.

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	ROWSECCLASS	Character(30)	VARCHAR2(30) NOT NULL	The class used to determine row level security
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
5	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.
6	JPM_JP_TYPE	Character(12)	VARCHAR2(12) NOT NULL	Profile Type name for a JPM Profile Type Prompt Table: JPM_JP_TYP_P_VW
7	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
8	NAME_DISPLAY_SRCH	Character(50)	VARCHAR2(50) NOT NULL	Uppercase version of Name to improve performance on searches.
9	LAST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Last Name
10	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Alternate Character Name