HR_MSEL_RSLT_WK

#	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
3	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department Set ID
4	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
5	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location Set ID
6	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
7	SETID_JOBCODE	Character(5)	VARCHAR2(5) NOT NULL	Job Code Set ID
8	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
9	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number
10	SUPERVISOR_ID	Character(11)	VARCHAR2(11) NOT NULL	Supervisor ID
11	SUPERVISOR_ERN	Number(3,0)	SMALLINT NOT NULL	This is used to hold the Employment Record Number of a supervisor.
12	REPORTS_TO	Character(8)	VARCHAR2(8) NOT NULL	Reports To Position Number
13	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
14	NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Display Name - name formatted for Display based on the Country
15	LAST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Last Name
16	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Alternate Character Name
17	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
18	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
19	NAME_DISPLAY1	Character(50)	VARCHAR2(50) NOT NULL	Display Name - name formatted for Display based on the Country
20	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