FO_CAND_OO_VW3

(SQL View)
 Index Back

View For Candidate Overview

Staffing Front Office Recruiting Funnel View For Candidate Overview

SELECT DISTINCT A.CANDIDATE_ID , A.BUSINESS_UNIT , A.SO_ID , A.SO_LINE , A.MATCH_LINE_NBR , A.CANDIDATE_TYPE , C.CUST_ID , B.ADDRESS1 , B.CITY , B.STATE , B.COUNTRY , %Substring(Z.DESCR, 1, 9) FROM PS_FO_SO_LINE_MTCH A , PS_RS_SO_HDR C , PS_CUST_ADDRESS B , PS_cust_addr_seq D , PS_JOBCODE_TBL Z , PS_RS_SO_LINE Y , PS_SET_CNTRL_TBL F WHERE A.FO_FUN_UCONS = 'Y' AND C.SO_ID = A.SO_ID AND C.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.CUST_ID = C.CUST_ID AND C.address_seq_num = b.address_seq_num AND d.bill_to_addr = 'Y' AND d.sold_to_addr = 'Y' AND d.setid = b.setid AND D.setid = b.setid AND b.eff_status='A' AND Y.JOBCODE = Z.JOBCODE AND Y.BUSINESS_UNIT = F.SETCNTRLVALUE AND Z.SETID = F.SETID AND Y.SO_ID = C.SO_ID AND A.SO_ID = Y.SO_ID AND A.SO_LINE = Y.SO_LINE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 APPLID Character(11) VARCHAR2(11) NOT NULL External Job Applicant ID
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID
4 SO_LINE Number(3,0) SMALLINT NOT NULL Line Number
5 MATCH_LINE_NBR Number(4,0) SMALLINT NOT NULL Match Line Number
6 CANDIDATE_TYPE Character(1) VARCHAR2(1) NOT NULL Candidate Type
A=Applicant
E=Employee
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 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
9 CITY Character(30) VARCHAR2(30) NOT NULL City
10 STATE Character(6) VARCHAR2(6) NOT NULL State
11 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
12 FO_JOBTITLE Character(9) VARCHAR2(9) NOT NULL Job Title Code