FO_ORD_HIST_VW (SQL View)	Index Back
Staffing FO Ord Hist VW Staffing Front Office Order History View. SELECT BUSINESS_UNIT , SO_ID , HISTORY_ID , OPRID , EVENT_TYPE , DATETIME_ADDED , CANDIDATE_TYPE , CANDIDATE_ID , CONTACT_SETID , CONTACT_ID , CUSTOMER_SETID , CUST_ID , FO_DATE FROM PS_FO_HISTORY WHERE SO_ID > ' '

FO_ORD_HIST_VW

(SQL View)

Staffing FO Ord Hist VW

Staffing Front Office Order History View. SELECT BUSINESS_UNIT , SO_ID , HISTORY_ID , OPRID , EVENT_TYPE , DATETIME_ADDED , CANDIDATE_TYPE , CANDIDATE_ID , CONTACT_SETID , CONTACT_ID , CUSTOMER_SETID , CUST_ID , FO_DATE FROM PS_FO_HISTORY WHERE SO_ID > ' '

SELECT BUSINESS_UNIT , SO_ID , HISTORY_ID , OPRID , EVENT_TYPE , DATETIME_ADDED , CANDIDATE_TYPE , CANDIDATE_ID , CONTACT_SETID , CONTACT_ID , CUSTOMER_SETID , CUST_ID , FO_DATE FROM PS_FO_HISTORY WHERE SO_ID > ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID

3 HISTORY_ID Number(15,0) DECIMAL(15) NOT NULL History ID

4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

5 EVENT_TYPE Character(10) VARCHAR2(10) NOT NULL Event Type

6 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added

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

8 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.

9 CONTACT_SETID Character(5) VARCHAR2(5) NOT NULL Contact SetID

10 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

11 CUSTOMER_SETID Character(5) VARCHAR2(5) NOT NULL Customer SetID

12 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.

13 FO_DATE Date(10) DATE Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	SO_ID	Character(15)	VARCHAR2(15) NOT NULL	Service Order ID
3	HISTORY_ID	Number(15,0)	DECIMAL(15) NOT NULL	History ID
4	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
5	EVENT_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Event Type
6	DATETIME_ADDED	DateTime(26)	TIMESTAMP	DateTime Added
7	CANDIDATE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Candidate Type A=Applicant E=Employee
8	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.
9	CONTACT_SETID	Character(5)	VARCHAR2(5) NOT NULL	Contact SetID
10	CONTACT_ID	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts
11	CUSTOMER_SETID	Character(5)	VARCHAR2(5) NOT NULL	Customer SetID
12	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.
13	FO_DATE	Date(10)	DATE	Date