FO_HISTORY (SQL Table)	Index Back
Front Office History All Front Office History Data

FO_HISTORY

(SQL Table)

Front Office History

All Front Office History Data

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HISTORY_ID Number(15,0) DECIMAL(15) NOT NULL History ID
Default Value: 999999999999999

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

3 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

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

5 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_CUST_ACT_VW

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

7 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
Prompt Table: %EDITTABLE

8 OWNERSHIP_ID Character(30) VARCHAR2(30) NOT NULL Owning Organization

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

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

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

12 ASSIGNMENT_ID Character(15) VARCHAR2(15) NOT NULL Work Assignment ID
Prompt Table: FO_ASGN_SR

13 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

14 EVENT_TYPE Character(10) VARCHAR2(10) NOT NULL Event Type
Prompt Table: FO_EVENT_DST_VW

15 FO_SUBEVENT Character(10) VARCHAR2(10) NOT NULL Staffing Front Office Recruiting Funnel SubEvent
Prompt Table: FO_SBEVT_VW

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

17 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID

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

19 START_TIME Time(15) TIMESTAMP Start of Shift

20 END_TIME Time(15) TIMESTAMP End of Shift

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

22 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

23 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

24 ORIGINAL_DATE DateTime(26) TIMESTAMP Original Date Time
Default Value: %datetime

25 ACTUAL_END_DATE DateTime(26) TIMESTAMP Actual End Date Time
Default Value: %datetime

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

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

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

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

30 COMMENTS_2000 Long Character CLOB Comment Text

31 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

32 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

33 START_DATE Date(10) DATE Start Date for Gen Standing PO
Default Value: %date

34 END_DATE Date(10) DATE End Date
Default Value: %date

35 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	HISTORY_ID	Number(15,0)	DECIMAL(15) NOT NULL	History ID Default Value: 999999999999999
2	CANDIDATE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Candidate Type A=Applicant E=Employee
3	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
4	CUSTOMER_SETID	Character(5)	VARCHAR2(5) NOT NULL	Customer SetID Prompt Table: SP_SETID_NONVW
5	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_CUST_ACT_VW
6	CONTACT_SETID	Character(5)	VARCHAR2(5) NOT NULL	Contact SetID Prompt Table: SP_SETID_NONVW
7	CONTACT_ID	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts Prompt Table: %EDITTABLE
8	OWNERSHIP_ID	Character(30)	VARCHAR2(30) NOT NULL	Owning Organization
9	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_PC_NONVW
10	SO_ID	Character(15)	VARCHAR2(15) NOT NULL	Service Order ID Prompt Table: FO_ORDR_SRCH_VW
11	SO_LINE	Number(3,0)	SMALLINT NOT NULL	Line Number Prompt Table: FO_ORDR_LIN_SRC
12	ASSIGNMENT_ID	Character(15)	VARCHAR2(15) NOT NULL	Work Assignment ID Prompt Table: FO_ASGN_SR
13	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
14	EVENT_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Event Type Prompt Table: FO_EVENT_DST_VW
15	FO_SUBEVENT	Character(10)	VARCHAR2(10) NOT NULL	Staffing Front Office Recruiting Funnel SubEvent Prompt Table: FO_SBEVT_VW
16	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Default Value: OPR_DEF_TBL_FS.OPRID Prompt Table: FO_SVC_GRP_VW
17	USERID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
18	FO_DATE	Date(10)	DATE NOT NULL	Date Default Value: %date
19	START_TIME	Time(15)	TIMESTAMP	Start of Shift
20	END_TIME	Time(15)	TIMESTAMP	End of Shift
21	OFFER_RESULT	Character(1)	VARCHAR2(1) NOT NULL	Confidential Order C=Considering D=Declined E=Accepted O=Other S=Assigned
22	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
23	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
24	ORIGINAL_DATE	DateTime(26)	TIMESTAMP	Original Date Time Default Value: %datetime
25	ACTUAL_END_DATE	DateTime(26)	TIMESTAMP	Actual End Date Time Default Value: %datetime
26	AGENDA_PRIORITY	Character(4)	VARCHAR2(4) NOT NULL	Agenda Priority 1=High 2=Medium 3=Low
27	RED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Red Flag Item Y/N Table Edit Default Value: N
28	DATETIME_ADDED	DateTime(26)	TIMESTAMP	DateTime Added Default Value: %datetime
29	EMAIL_ID	Number(12,0)	DECIMAL(12) NOT NULL	Email ID
30	COMMENTS_2000	Long Character	CLOB	Comment Text
31	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
32	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
33	START_DATE	Date(10)	DATE	Start Date for Gen Standing PO Default Value: %date
34	END_DATE	Date(10)	DATE	End Date Default Value: %date
35	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.