HR_SRCH_EMPTY

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	REPORTS_TO	Character(8)	VARCHAR2(8) NOT NULL	Reports To Position Number
2	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number
3	HR_DR_LEVEL	Number(3,0)	SMALLINT NOT NULL	Number denoting how many levels down the organizational chart the employee is from the supervisor. Direct reports are always level 1.
4	SUPERVISOR_ID	Character(11)	VARCHAR2(11) NOT NULL	Supervisor ID
5	SUPERVIS_EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Supervisor employee record.
6	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
7	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
8	EMPL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payroll Status A=Active D=Deceased L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration
9	JOB_EFFDT	Date(10)	DATE	Job Effective Date
10	POSITION_OVERRIDE	Character(1)	VARCHAR2(1) NOT NULL	Override Position Data
11	SUPERVISOR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Y/N field to determine if a employee is a supervisor on the direct reports tables.