OPR_ROWS_NOPRQ

#	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 Record
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 Set ID
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