FO_CAN_I_FUN_VW

(SQL View)
 Index Back

events = in progress

Staffing Front Office Recruiting Funnel View for Candidate Summary where events = in progress

SELECT A.SO_ID , A.SO_LINE , A.CANDIDATE_ID , A.FIRST_NAME , A.LAST_NAME , A.FO_CUR_EVENT , A.DESCR , A.FO_EVENT_STAT , A.FO_PROC_EVNT_ST , A.CONTACT_ID2 , A.FO_JOBTITLE , A.START_DATE , A.ADDRESS1 , A.CITY , A.STATE , A.COUNTRY , A.DATETIME_ADDED , A.START_TIME , A.HISTORY_ID FROM PS_FO_CAN_FUN_VW A WHERE FO_EVENT_STAT = 'I' AND EXISTS ( SELECT 'X' FROM PS_FO_SO_LINE_MTCH Q WHERE Q.FO_FUN_UCONS = 'Y' AND Q.SO_ID = A.SO_ID AND Q.SO_LINE = A.SO_LINE AND Q.CANDIDATE_ID = A.CANDIDATE_ID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID
2 SO_LINE Number(3,0) SMALLINT NOT NULL Line Number
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.
4 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
5 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
6 FO_CUR_EVENT Character(10) VARCHAR2(10) NOT NULL Staffing Front Office Recruiting Funnel Current Event
7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
8 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
9 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
10 CONTACT_ID2 Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
11 FO_JOBTITLE Character(9) VARCHAR2(9) NOT NULL Job Title Code
12 START_DATE Date(10) DATE Start Date for Gen Standing PO
13 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
14 CITY Character(30) VARCHAR2(30) NOT NULL City
15 STATE Character(6) VARCHAR2(6) NOT NULL State
16 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
17 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added
18 START_TIME Time(15) TIMESTAMP Start of Shift
19 HISTORY_ID Number(15,0) DECIMAL(15) NOT NULL History ID