FO_RF_ENTRY (SQL Table)	Index Back
Recruiting Funnel Data All Front Office History Data

FO_RF_ENTRY

(SQL Table)

Recruiting Funnel Data

All Front Office History Data

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_PC_NONVW

2 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID
Prompt Table: FO_ORDR_SRCH_VW

3 SO_LINE Number(3,0) SMALLINT NOT NULL Line Number
Prompt Table: FO_ORDR_LIN_SRC

4 CANDIDATE_TYPE Character(1) VARCHAR2(1) NOT NULL Candidate Type
A=Applicant
E=Employee

5 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

6 EVENT_TYPE Character(10) VARCHAR2(10) NOT NULL Event Type
Prompt Table: FO_EVT_LST_VW

7 FO_SUBEVENT Character(10) VARCHAR2(10) NOT NULL Staffing Front Office Recruiting Funnel SubEvent
Default Value: 'FOTMPFUN'
Prompt Table: FO_SBEVT_VW

8 CUSTOMER_SETID Character(5) VARCHAR2(5) NOT NULL Customer SetID
Prompt Table: SP_SETID_NONVW

9 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
Prompt Table: FO_CUSTOMER_SR

10 AGENDA_ID Number(15,0) DECIMAL(15) NOT NULL Agenda ID

11 HISTORY_ID Number(15,0) DECIMAL(15) NOT NULL History ID
Default Value: 999999999999999
Prompt Table: FO_HISTORY

12 CONTACT_SETID Character(5) VARCHAR2(5) NOT NULL Contact SetID
Prompt Table: SP_SETID_NONVW

13 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
Prompt Table: FO_CNTCT_SR

14 CONTACT_METHOD Character(1) VARCHAR2(1) NOT NULL Contact Method
A=Apply Online URL
C=Telephone Call
E=Email
P=In-Person
V=Verbal
W=In-Writing

15 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_FS.OPRID
Prompt Table: OPRIDDESC_VW

16 FO_DATE Date(10) DATE NOT NULL Date
Default Value: %date

17 START_TIME Time(15) TIMESTAMP Start of Shift

18 END_TIME Time(15) TIMESTAMP End of Shift

19 OFFER_RESULT Character(1) VARCHAR2(1) NOT NULL Confidential Order
C=Considering
D=Declined
E=Accepted
O=Other
S=Assigned

20 DECLINE_REASON Character(3) VARCHAR2(3) NOT NULL Decline Reason
D1=Undesirable Location
D10=No Longer Available for Work
D2=Undesirable Company
D3=Undesirable Pay
D4=Undesirable Benefits
D5=Undesirable Hours
D6=Undesirable Position
D7=Assignment too Long
D8=Assignment too Short
D9=Need More Notice
O=Other

21 OTHER_REASON Character(3) VARCHAR2(3) NOT NULL Other Reason
A1=Left Message with Person
A2=No Answer
A3=Phone Busy
A4=Phone Disconnected
A5=Left Message on Machine
A6=Incorrect Phone Number
A7=Backup
A8=Interview Tracking
O=Other

22 ORIGINAL_DATE DateTime(26) TIMESTAMP Original Date Time

23 ACTUAL_END_DATE DateTime(26) TIMESTAMP Actual End Date Time

24 AGENDA_PRIORITY Character(4) VARCHAR2(4) NOT NULL Agenda Priority
1=High
2=Medium
3=Low

25 RED_FLAG Character(1) VARCHAR2(1) NOT NULL Red Flag Item
Y/N Table Edit
Default Value: N

26 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added
Default Value: %datetime

27 EMAIL_ID Number(12,0) DECIMAL(12) NOT NULL Email ID

28 COMMENTS_2000 Long Character CLOB Comment Text

29 FO_EVENT_STAT Character(1) VARCHAR2(1) NOT NULL Staffing Front Office Recruiting Funnel Event Status
C=Completed
I=In Progress
O=Pending
P=Partially complete

30 FO_PROC_EVNT_ST Character(1) VARCHAR2(1) NOT NULL Staffing Front Office Recruiting Funnel Process Event Status
C=Completed
I=In Progress
O=Pending

31 FO_RF_DISQ Character(1) VARCHAR2(1) NOT NULL Disqualification
N=N
Y=Y
Default Value: N

32 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_PC_NONVW
2	SO_ID	Character(15)	VARCHAR2(15) NOT NULL	Service Order ID Prompt Table: FO_ORDR_SRCH_VW
3	SO_LINE	Number(3,0)	SMALLINT NOT NULL	Line Number Prompt Table: FO_ORDR_LIN_SRC
4	CANDIDATE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Candidate Type A=Applicant E=Employee
5	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
6	EVENT_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Event Type Prompt Table: FO_EVT_LST_VW
7	FO_SUBEVENT	Character(10)	VARCHAR2(10) NOT NULL	Staffing Front Office Recruiting Funnel SubEvent Default Value: 'FOTMPFUN' Prompt Table: FO_SBEVT_VW
8	CUSTOMER_SETID	Character(5)	VARCHAR2(5) NOT NULL	Customer SetID Prompt Table: SP_SETID_NONVW
9	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. Prompt Table: FO_CUSTOMER_SR
10	AGENDA_ID	Number(15,0)	DECIMAL(15) NOT NULL	Agenda ID
11	HISTORY_ID	Number(15,0)	DECIMAL(15) NOT NULL	History ID Default Value: 999999999999999 Prompt Table: FO_HISTORY
12	CONTACT_SETID	Character(5)	VARCHAR2(5) NOT NULL	Contact SetID Prompt Table: SP_SETID_NONVW
13	CONTACT_ID	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts Prompt Table: FO_CNTCT_SR
14	CONTACT_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Contact Method A=Apply Online URL C=Telephone Call E=Email P=In-Person V=Verbal W=In-Writing
15	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Default Value: OPR_DEF_TBL_FS.OPRID Prompt Table: OPRIDDESC_VW
16	FO_DATE	Date(10)	DATE NOT NULL	Date Default Value: %date
17	START_TIME	Time(15)	TIMESTAMP	Start of Shift
18	END_TIME	Time(15)	TIMESTAMP	End of Shift
19	OFFER_RESULT	Character(1)	VARCHAR2(1) NOT NULL	Confidential Order C=Considering D=Declined E=Accepted O=Other S=Assigned
20	DECLINE_REASON	Character(3)	VARCHAR2(3) NOT NULL	Decline Reason D1=Undesirable Location D10=No Longer Available for Work D2=Undesirable Company D3=Undesirable Pay D4=Undesirable Benefits D5=Undesirable Hours D6=Undesirable Position D7=Assignment too Long D8=Assignment too Short D9=Need More Notice O=Other
21	OTHER_REASON	Character(3)	VARCHAR2(3) NOT NULL	Other Reason A1=Left Message with Person A2=No Answer A3=Phone Busy A4=Phone Disconnected A5=Left Message on Machine A6=Incorrect Phone Number A7=Backup A8=Interview Tracking O=Other
22	ORIGINAL_DATE	DateTime(26)	TIMESTAMP	Original Date Time
23	ACTUAL_END_DATE	DateTime(26)	TIMESTAMP	Actual End Date Time
24	AGENDA_PRIORITY	Character(4)	VARCHAR2(4) NOT NULL	Agenda Priority 1=High 2=Medium 3=Low
25	RED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Red Flag Item Y/N Table Edit Default Value: N
26	DATETIME_ADDED	DateTime(26)	TIMESTAMP	DateTime Added Default Value: %datetime
27	EMAIL_ID	Number(12,0)	DECIMAL(12) NOT NULL	Email ID
28	COMMENTS_2000	Long Character	CLOB	Comment Text
29	FO_EVENT_STAT	Character(1)	VARCHAR2(1) NOT NULL	Staffing Front Office Recruiting Funnel Event Status C=Completed I=In Progress O=Pending P=Partially complete
30	FO_PROC_EVNT_ST	Character(1)	VARCHAR2(1) NOT NULL	Staffing Front Office Recruiting Funnel Process Event Status C=Completed I=In Progress O=Pending
31	FO_RF_DISQ	Character(1)	VARCHAR2(1) NOT NULL	Disqualification N=N Y=Y Default Value: N
32	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.