FO_ORDR_MGR_SRC (SQL View)	Index Back
Staffing Order MGR Src Staffing Front Office Order MGR Src View SELECT A.BUSINESS_UNIT , A.SO_ID , A.SO_LINE ,A.MATCH_LINE_NBR ,A.CANDIDATE_TYPE ,A.CANDIDATE_ID ,B.CUST_ID ,B.MANAGER_CONTACT_ID , A.OFFER_RESULT FROM %Table(FO_SO_LINE_MTCH) A , %Table(RS_SO_LINE) B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.SO_ID = B.SO_ID

FO_ORDR_MGR_SRC

(SQL View)

Staffing Order MGR Src

Staffing Front Office Order MGR Src View SELECT A.BUSINESS_UNIT , A.SO_ID , A.SO_LINE ,A.MATCH_LINE_NBR ,A.CANDIDATE_TYPE ,A.CANDIDATE_ID ,B.CUST_ID ,B.MANAGER_CONTACT_ID , A.OFFER_RESULT FROM %Table(FO_SO_LINE_MTCH) A , %Table(RS_SO_LINE) B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.SO_ID = B.SO_ID

SELECT A.BUSINESS_UNIT , A.SO_ID , A.SO_LINE ,A.MATCH_LINE_NBR ,A.CANDIDATE_TYPE ,A.CANDIDATE_ID ,B.CUST_ID ,B.MANAGER_CONTACT_ID , A.OFFER_RESULT , C.OWNERSHIP_ID FROM %Table(FO_SO_LINE_MTCH) A , %Table(RS_SO_LINE) B ,%Table(RS_SO_HDR) C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.SO_ID = B.SO_ID AND B.BUSINESS_UNIT=C.BUSINESS_UNIT AND B.SO_ID=C.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 SO_LINE Number(3,0) SMALLINT NOT NULL Line Number

4 MATCH_LINE_NBR Number(4,0) SMALLINT NOT NULL Match Line Number

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

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

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

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

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

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

#	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	SO_LINE	Number(3,0)	SMALLINT NOT NULL	Line Number
4	MATCH_LINE_NBR	Number(4,0)	SMALLINT NOT NULL	Match Line Number
5	CANDIDATE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Candidate Type A=Applicant E=Employee
6	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.
7	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.
8	CONTACT_ID	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts
9	OFFER_RESULT	Character(1)	VARCHAR2(1) NOT NULL	Confidential Order C=Considering D=Declined E=Accepted O=Other S=Assigned
10	OWNERSHIP_ID	Character(30)	VARCHAR2(30) NOT NULL	Owning Organization