OPR_ROWS_EE (SQL Table)	Index Back
Employee Search - Global EMPLMT_SRCH_GBL is an Employment Search record containing all of the localized alternate search keys. None of the localized search keys are maked as alternate searches. However, it's easy for a customer to mark any/all of them as alternate search keys if they choose to. Use it 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. Use this view to access records with primary keys of EMPLID and EMPL_RCD#. To access records keyed by EMPLID without EMPL_RCD#, use one of ther Personal Searches.

OPR_ROWS_EE

(SQL Table)

Employee Search - Global

EMPLMT_SRCH_GBL is an Employment Search record containing all of the localized alternate search keys. None of the localized search keys are maked as alternate searches. However, it's easy for a customer to mark any/all of them as alternate search keys if they choose to. Use it 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. Use this view to access records with primary keys of EMPLID and EMPL_RCD#. To access records keyed by EMPLID without EMPL_RCD#, use one of ther Personal Searches.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON_NAME

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

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

4 ACCESS_CD Character(1) VARCHAR2(1) NOT NULL Access Code
N=No Access
Y=Read/Write Access

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

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

7 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

8 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department SetID

9 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
Prompt Table: DEPT_TBL

10 PER_ORG Character(3) VARCHAR2(3) NOT NULL Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest.
CWR=Contingent Worker
EMP=Employee
POI=Person of Interest

11 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name

12 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON_NAME
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
3	ROWSECCLASS	Character(30)	VARCHAR2(30) NOT NULL	The class used to determine row level security
4	ACCESS_CD	Character(1)	VARCHAR2(1) NOT NULL	Access Code N=No Access Y=Read/Write Access
5	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
6	LAST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Last Name
7	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
8	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department SetID
9	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPT_TBL
10	PER_ORG	Character(3)	VARCHAR2(3) NOT NULL	Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest. CWR=Contingent Worker EMP=Employee POI=Person of Interest
11	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
12	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
13	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Alternate Character Name
14	PER_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Personnel Status E=Employee N=Non-Employee