PERS_S_E_VW_BRA

(SQL View)
 Index Back

Search Vw Brazil

PERSONAL_SRCH is used as a search view to select employee records for you to use when you access a panel. This view shows you records only for employees in departments that your operator class is allowed to access.

SELECT A.EMPLID %Sql(HRSECVIEWS_SELECT,SEC) ,JOB.EMPL_RCD ,B.NAME ,B.LAST_NAME_SRCH ,JOB.SETID_DEPT ,JOB.DEPTID , 'E' FROM PS_PERSON A ,PS_PERSON_NAME B %Sql(HRSECVIEWS_JOBFROM,JOB) %Sql(HRSECVIEWS_FROM,SEC) A.EMPLID=B.EMPLID AND B.EMPLID=JOB.EMPLID %Sql(HRSECVIEWS_JOB,JOB) %Sql(HRSECVIEWS_WHERE,SEC,JOB)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 ROWSECCLASS Character(30) VARCHAR2(30) NOT NULL The class used to determine row level security
3 ACCESS_CD Character(1) VARCHAR2(1) NOT NULL Access Code
N=No Access
Y=Read/Write Access
4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
5 NAME Character(50) VARCHAR2(50) NOT NULL Name
6 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
7 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID

Prompt Table: SETID_TBL

8 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: PERS_DEPT_VW

9 PER_STATUS Character(1) VARCHAR2(1) NOT NULL Personnel Status
E=Employee
N=Non-Employee