SPF_INTERVIEW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_SP_NONVW
2	SP_REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Service Request ID
3	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
4	BID_ID	Number(10,0)	DECIMAL(10) NOT NULL	Bid Id
5	WORK_ORDER_ID	Character(15)	VARCHAR2(15) NOT NULL	Work Order ID
6	SEQNBR	Number(5,0)	INTEGER NOT NULL	Sequence Number
7	LINKEDWORDER	Character(15)	VARCHAR2(15) NOT NULL	Linked Work Order
8	INTERVIEWER	Character(30)	VARCHAR2(30) NOT NULL	The sPro user that is scheduled to interview a submitted candidate Prompt Table: SP_INTRVW_NONVW
9	SPF_DATEFIELD	Date(10)	DATE NOT NULL	Date
10	SPF_TIME	Time(15)	TIMESTAMP NOT NULL	Time
11	INTERVIEWLOCATION	Character(50)	VARCHAR2(50) NOT NULL	The location where the interview is to take place.
12	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email Address
13	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
14	COMMENTS	Long Character	CLOB	Comment
15	INTERVW_COMPLETED	Character(1)	VARCHAR2(1) NOT NULL	Interview Completed N=No Y=Yes Y/N Table Edit Default Value: N
16	SPF_DATETIME	DateTime(26)	TIMESTAMP	Date and Time
17	SPF_RATING	Character(1)	VARCHAR2(1) NOT NULL	Candidate Rating E=Excellent F=Fair G=Good N=None P=Poor Default Value: N
18	SPF_BF_CNDT_RATING	Number(2,0)	SMALLINT NOT NULL	Candidate Bid Factor Rating