EMPLMT_SRCH_ALL (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.

EMPLMT_SRCH_ALL

(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 A.EMPLID ,A.EMPL_RCD FROM PS_PER_ORG_ASGN A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record