FO_CN_CT_FUN_VW (SQL View)	Index Back
events = completed Staffing Front Office Recruiting Funnel View for Candidate Summary where events = completed

FO_CN_CT_FUN_VW

(SQL View)

events = completed

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

SELECT MAX(HISTORY_ID) , SO_ID , SO_LINE , CANDIDATE_ID FROM PS_FO_CAN_C_FUN_VW GROUP BY SO_ID , SO_LINE , CANDIDATE_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 SO_LINE Number(3,0) SMALLINT NOT NULL Line Number

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HISTORY_ID	Number(15,0)	DECIMAL(15) NOT NULL	History ID
2	SO_ID	Character(15)	VARCHAR2(15) NOT NULL	Service Order ID
3	SO_LINE	Number(3,0)	SMALLINT NOT NULL	Line Number
4	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.