FO_CANDIDATE_W

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CANDIDATE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Candidate Type A=Applicant E=Employee
2	CANDIDATE_ID	Character(11)	VARCHAR2(11) NOT NULL	Used as a general ID for anything from Employee id to other types of ID like asset and material. Prompt Table: FO_CANDIDATE_W
3	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
4	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
5	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
6	FIRST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	First Name
7	LAST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Last Name
8	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department SetID
9	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
10	PER_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Personnel Status E=Employee N=Non-Employee
11	EMPL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Employee Status A=Active D=Deceased I=Inactive 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
12	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
13	FO_BRANCH	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
14	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
15	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
16	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal Prompt Table: FO_GEOCODE_VW
17	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
18	DUE_DATE	Date(10)	DATE	Delivery Due Date from PO