FO_CAN4L_FUN_VW

(SQL View)
 Index Back

View for Candidate Summary

Staffing Front Office Recruiting Funnel View for Candidate Summary

SELECT DISTINCT CUA.SETID , CON.CONTACT_ID , HDR.BUSINESS_UNIT , RF.SO_ID , RF.SO_LINE , RF.CANDIDATE_ID , CAN.FIRST_NAME , CAN.LAST_NAME , RF.EVENT_TYPE , RF.FO_SUBEVENT , EVS.DESCR , RF.FO_EVENT_STAT , RF.FO_PROC_EVNT_ST , %Substring (JC.DESCR, 1 , 9) , JC.DESCR , LN.START_DT , CUA.ADDRESS1 , CUA.CITY , CUA.STATE , CUA.COUNTRY , RF.DATETIME_ADDED , RF.START_TIME , RF.HISTORY_ID , RF.FO_RF_DISQ FROM PS_FO_RF_ENTRY RF , PS_RS_SO_HDR HDR , PS_RS_SO_LINE LN , PS_FO_SO_LINE_MTCH MTCH , PS_FO_CANDIDATE_W CAN , PS_FO_EVENTS_SETUP EVS , PS_CUST_ADDRESS CUA , PS_CUST_ADDR_SEQ CUS , PS_FO_JOBCD_CUR_VW JC , PS_CONTACT CON , PS_RS_SO_STATUS STS , PS_SET_CNTRL_GROUP SCJC , PS_SET_CNTRL_GROUP SCCON , PS_SET_CNTRL_GROUP SCCUA WHERE RF.SO_LINE <> 0 AND RF.BUSINESS_UNIT = HDR.BUSINESS_UNIT AND RF.SO_ID = HDR.SO_ID AND HDR.BUSINESS_UNIT = LN.BUSINESS_UNIT AND HDR.SO_ID = LN.SO_ID AND RF.SO_LINE = LN.SO_LINE AND RF.BUSINESS_UNIT = MTCH.BUSINESS_UNIT AND RF.SO_ID = MTCH.SO_ID AND RF.SO_LINE = MTCH.SO_LINE AND RF.CANDIDATE_TYPE = MTCH.CANDIDATE_TYPE AND RF.CANDIDATE_ID = MTCH.CANDIDATE_ID AND RF.CANDIDATE_TYPE = CAN.CANDIDATE_TYPE AND RF.CANDIDATE_ID = CAN.CANDIDATE_ID AND RF.EVENT_TYPE = EVS.EVENT_TYPE AND HDR.SYSTEM_SOURCE = 'STF' AND RF.FO_EVENT_STAT = 'I' AND MTCH.FO_FUN_UCONS = 'Y' AND HDR.BUSINESS_UNIT = STS.BUSINESS_UNIT AND HDR.SO_ID = STS.SO_ID AND STS.LASTUPDDTTM = ( SELECT MAX(STSDTTM.LASTUPDDTTM) FROM PS_RS_SO_STATUS STSDTTM WHERE STSDTTM.BUSINESS_UNIT = STS.BUSINESS_UNIT AND STSDTTM.SO_ID = STS.SO_ID) AND STS.SO_STATUS = 'U' AND SCCUA.SETCNTRLVALUE = HDR.BUSINESS_UNIT AND SCCUA.REC_GROUP_ID = 'FS_23' AND CUA.SETID = SCCUA.SETID AND CUA.SETID = CUS.SETID AND CUA.CUST_ID= CUS.CUST_ID AND CUA.ADDRESS_SEQ_NUM = CUS.ADDRESS_SEQ_NUM AND CUS.BILL_TO_ADDR = 'Y' AND CUS.SOLD_TO_ADDR = 'Y' AND %EffdtCheck(CUST_ADDRESS, CUA, %CurrentDateIn) AND CUA.EFF_STATUS='A' AND CUS.CUST_ID = HDR.CUST_ID AND CUS.ADDRESS_SEQ_NUM = HDR.ADDRESS_SEQ_NUM AND SCJC.SETCNTRLVALUE = LN.BUSINESS_UNIT AND SCJC.REC_GROUP_ID='FS_27' AND JC.SETID = SCJC.SETID AND LN.JOBCODE = JC.JOBCODE AND SCCON.SETCNTRLVALUE = HDR.BUSINESS_UNIT AND SCCON.REC_GROUP_ID='FS_54' AND CON.SETID = SCCON.SETID AND CON.CONTACT_ID = HDR.MANAGER_CONTACT_ID AND %EffdtCheck(CONTACT, CON, %CurrentDateIn) AND RF.HISTORY_ID IN ( SELECT MAX(RFHIST.HISTORY_ID) FROM PS_FO_RF_ENTRY RFHIST WHERE RFHIST.BUSINESS_UNIT = RF.BUSINESS_UNIT AND RFHIST.SO_ID = RF.SO_ID AND RFHIST.SO_LINE = RF.SO_LINE AND RFHIST.CANDIDATE_TYPE = RF.CANDIDATE_TYPE AND RFHIST.CANDIDATE_ID = RF.CANDIDATE_ID AND RFHIST.FO_EVENT_STAT = RF.FO_EVENT_STAT GROUP BY RFHIST.BUSINESS_UNIT, RFHIST.SO_ID, RFHIST.SO_LINE , RFHIST.CANDIDATE_TYPE, RFHIST.CANDIDATE_ID) UNION SELECT DISTINCT CUA.SETID , CON.CONTACT_ID , HDR.BUSINESS_UNIT , RF.SO_ID , RF.SO_LINE , RF.CANDIDATE_ID , CAN.FIRST_NAME , CAN.LAST_NAME , RF.EVENT_TYPE , RF.FO_SUBEVENT , EVS.DESCR , RF.FO_EVENT_STAT , RF.FO_PROC_EVNT_ST , %Substring (JC.DESCR, 1 , 9) , JC.DESCR , LN.START_DT , CUA.ADDRESS1 , CUA.CITY , CUA.STATE , CUA.COUNTRY , RF.DATETIME_ADDED , RF.START_TIME , RF.HISTORY_ID , RF.FO_RF_DISQ FROM PS_FO_RF_ENTRY RF , PS_RS_SO_HDR HDR , PS_RS_SO_LINE LN , PS_FO_SO_LINE_MTCH MTCH , PS_FO_CANDIDATE_W CAN , PS_FO_EVENTS_SETUP EVS , PS_CUST_ADDRESS CUA , PS_CUST_ADDR_SEQ CUS , PS_FO_JOBCD_CUR_VW JC , PS_CONTACT CON , PS_RS_SO_STATUS STS , PS_SET_CNTRL_GROUP SCJC , PS_SET_CNTRL_GROUP SCCON , PS_SET_CNTRL_GROUP SCCUA WHERE RF.SO_LINE <> 0 AND RF.BUSINESS_UNIT = HDR.BUSINESS_UNIT AND RF.SO_ID = HDR.SO_ID AND HDR.BUSINESS_UNIT = LN.BUSINESS_UNIT AND HDR.SO_ID = LN.SO_ID AND RF.SO_LINE = LN.SO_LINE AND RF.BUSINESS_UNIT = MTCH.BUSINESS_UNIT AND RF.SO_ID = MTCH.SO_ID AND RF.SO_LINE = MTCH.SO_LINE AND RF.CANDIDATE_TYPE = MTCH.CANDIDATE_TYPE AND RF.CANDIDATE_ID = MTCH.CANDIDATE_ID AND RF.CANDIDATE_TYPE = CAN.CANDIDATE_TYPE AND RF.CANDIDATE_ID = CAN.CANDIDATE_ID AND RF.EVENT_TYPE = EVS.EVENT_TYPE AND HDR.SYSTEM_SOURCE = 'STF' AND RF.FO_EVENT_STAT = 'P' AND MTCH.FO_FUN_UCONS = 'Y' AND HDR.BUSINESS_UNIT = STS.BUSINESS_UNIT AND HDR.SO_ID = STS.SO_ID AND STS.LASTUPDDTTM = ( SELECT MAX(STSDTTM.LASTUPDDTTM) FROM PS_RS_SO_STATUS STSDTTM WHERE STSDTTM.BUSINESS_UNIT = STS.BUSINESS_UNIT AND STSDTTM.SO_ID = STS.SO_ID) AND STS.SO_STATUS = 'U' AND SCCUA.SETCNTRLVALUE = HDR.BUSINESS_UNIT AND SCCUA.REC_GROUP_ID = 'FS_23' AND CUA.SETID = SCCUA.SETID AND CUA.SETID = CUS.SETID AND CUA.CUST_ID= CUS.CUST_ID AND CUA.ADDRESS_SEQ_NUM = CUS.ADDRESS_SEQ_NUM AND CUS.BILL_TO_ADDR = 'Y' AND CUS.SOLD_TO_ADDR = 'Y' AND %EffdtCheck(CUST_ADDRESS, CUA, %CurrentDateIn) AND CUA.EFF_STATUS='A' AND CUS.CUST_ID = HDR.CUST_ID AND CUS.ADDRESS_SEQ_NUM = HDR.ADDRESS_SEQ_NUM AND SCJC.SETCNTRLVALUE = LN.BUSINESS_UNIT AND SCJC.REC_GROUP_ID='FS_27' AND JC.SETID = SCJC.SETID AND LN.JOBCODE = JC.JOBCODE AND SCCON.SETCNTRLVALUE = HDR.BUSINESS_UNIT AND SCCON.REC_GROUP_ID='FS_54' AND CON.SETID = SCCON.SETID AND CON.CONTACT_ID = HDR.MANAGER_CONTACT_ID AND %EffdtCheck(CONTACT, CON, %CurrentDateIn) AND RF.HISTORY_ID IN ( SELECT MAX(RFHIST.HISTORY_ID) FROM PS_FO_RF_ENTRY RFHIST WHERE RFHIST.BUSINESS_UNIT = RF.BUSINESS_UNIT AND RFHIST.SO_ID = RF.SO_ID AND RFHIST.SO_LINE = RF.SO_LINE AND RFHIST.CANDIDATE_TYPE = RF.CANDIDATE_TYPE AND RFHIST.CANDIDATE_ID = RF.CANDIDATE_ID AND RFHIST.FO_EVENT_STAT = RF.FO_EVENT_STAT GROUP BY RFHIST.BUSINESS_UNIT, RFHIST.SO_ID, RFHIST.SO_LINE , RFHIST.CANDIDATE_TYPE, RFHIST.CANDIDATE_ID) AND NOT EXISTS ( SELECT 'X' FROM PS_FO_RF_ENTRY RFPND WHERE RF.BUSINESS_UNIT=RFPND.BUSINESS_UNIT AND RF.SO_ID = RFPND.SO_ID AND RF.SO_LINE = RFPND.SO_LINE AND RF.CANDIDATE_TYPE = RFPND.CANDIDATE_TYPE AND RF.CANDIDATE_ID = RFPND.CANDIDATE_ID AND RFPND.FO_EVENT_STAT = 'I') UNION SELECT DISTINCT CUA.SETID , CON.CONTACT_ID , HDR.BUSINESS_UNIT , RF.SO_ID , RF.SO_LINE , RF.CANDIDATE_ID , CAN.FIRST_NAME , CAN.LAST_NAME , (CASE RF.LASTUPDOPRID WHEN 'SFOSYSTEMGENERATED' THEN ' ' ELSE RF.EVENT_TYPE END) , RF.FO_SUBEVENT , (CASE RF.LASTUPDOPRID WHEN 'SFOSYSTEMGENERATED' THEN ' ' ELSE EVS.DESCR END) , RF.FO_EVENT_STAT , RF.FO_PROC_EVNT_ST , %Substring (JC.DESCR, 1 , 9) , JC.DESCR , LN.START_DT , CUA.ADDRESS1 , CUA.CITY , CUA.STATE , CUA.COUNTRY , RF.DATETIME_ADDED , RF.START_TIME , RF.HISTORY_ID , RF.FO_RF_DISQ FROM PS_FO_RF_ENTRY RF , PS_RS_SO_HDR HDR , PS_RS_SO_LINE LN , PS_FO_SO_LINE_MTCH MTCH , PS_FO_CANDIDATE_W CAN , PS_FO_EVENTS_SETUP EVS , PS_CUST_ADDRESS CUA , PS_CUST_ADDR_SEQ CUS , PS_FO_JOBCD_CUR_VW JC , PS_CONTACT CON , PS_RS_SO_STATUS STS , PS_SET_CNTRL_GROUP SCJC , PS_SET_CNTRL_GROUP SCCON , PS_SET_CNTRL_GROUP SCCUA WHERE RF.SO_LINE <> 0 AND RF.BUSINESS_UNIT = HDR.BUSINESS_UNIT AND RF.SO_ID = HDR.SO_ID AND HDR.BUSINESS_UNIT = LN.BUSINESS_UNIT AND HDR.SO_ID = LN.SO_ID AND RF.SO_LINE = LN.SO_LINE AND RF.BUSINESS_UNIT = MTCH.BUSINESS_UNIT AND RF.SO_ID = MTCH.SO_ID AND RF.SO_LINE = MTCH.SO_LINE AND RF.CANDIDATE_TYPE = MTCH.CANDIDATE_TYPE AND RF.CANDIDATE_ID = MTCH.CANDIDATE_ID AND RF.CANDIDATE_TYPE = CAN.CANDIDATE_TYPE AND RF.CANDIDATE_ID = CAN.CANDIDATE_ID AND RF.EVENT_TYPE = EVS.EVENT_TYPE AND HDR.SYSTEM_SOURCE = 'STF' AND RF.FO_EVENT_STAT = 'O' AND MTCH.FO_FUN_UCONS = 'Y' AND HDR.BUSINESS_UNIT = STS.BUSINESS_UNIT AND HDR.SO_ID = STS.SO_ID AND STS.LASTUPDDTTM = ( SELECT MAX(STSDTTM.LASTUPDDTTM) FROM PS_RS_SO_STATUS STSDTTM WHERE STSDTTM.BUSINESS_UNIT = STS.BUSINESS_UNIT AND STSDTTM.SO_ID = STS.SO_ID) AND STS.SO_STATUS = 'U' AND SCCUA.SETCNTRLVALUE = HDR.BUSINESS_UNIT AND SCCUA.REC_GROUP_ID = 'FS_23' AND CUA.SETID = SCCUA.SETID AND CUA.SETID = CUS.SETID AND CUA.CUST_ID= CUS.CUST_ID AND CUA.ADDRESS_SEQ_NUM = CUS.ADDRESS_SEQ_NUM AND CUS.BILL_TO_ADDR = 'Y' AND CUS.SOLD_TO_ADDR = 'Y' AND %EffdtCheck(CUST_ADDRESS, CUA, %CurrentDateIn) AND CUA.EFF_STATUS='A' AND CUS.CUST_ID = HDR.CUST_ID AND CUS.ADDRESS_SEQ_NUM = HDR.ADDRESS_SEQ_NUM AND SCJC.SETCNTRLVALUE = LN.BUSINESS_UNIT AND SCJC.REC_GROUP_ID='FS_27' AND JC.SETID = SCJC.SETID AND LN.JOBCODE = JC.JOBCODE AND SCCON.SETCNTRLVALUE = HDR.BUSINESS_UNIT AND SCCON.REC_GROUP_ID='FS_54' AND CON.SETID = SCCON.SETID AND CON.CONTACT_ID = HDR.MANAGER_CONTACT_ID AND %EffdtCheck(CONTACT, CON, %CurrentDateIn) AND RF.HISTORY_ID IN ( ( SELECT MAX(RFHIST.HISTORY_ID) FROM PS_FO_RF_ENTRY RFHIST WHERE RFHIST.BUSINESS_UNIT = RF.BUSINESS_UNIT AND RFHIST.SO_ID = RF.SO_ID AND RFHIST.SO_LINE = RF.SO_LINE AND RFHIST.CANDIDATE_TYPE = RF.CANDIDATE_TYPE AND RFHIST.CANDIDATE_ID = RF.CANDIDATE_ID AND RFHIST.FO_EVENT_STAT = RF.FO_EVENT_STAT AND RFHIST.LASTUPDOPRID <> 'SFOSYSTEMGENERATED' GROUP BY RFHIST.BUSINESS_UNIT, RFHIST.SO_ID, RFHIST.SO_LINE , RFHIST.CANDIDATE_TYPE, RFHIST.CANDIDATE_ID) UNION ( SELECT MAX(RFSFO.HISTORY_ID) FROM PS_FO_RF_ENTRY RFSFO WHERE RFSFO.BUSINESS_UNIT = RF.BUSINESS_UNIT AND RFSFO.SO_ID = RF.SO_ID AND RFSFO.SO_LINE = RF.SO_LINE AND RFSFO.CANDIDATE_TYPE = RF.CANDIDATE_TYPE AND RFSFO.CANDIDATE_ID = RF.CANDIDATE_ID AND RFSFO.LASTUPDOPRID = 'SFOSYSTEMGENERATED' AND RFSFO.FO_EVENT_STAT = RF.FO_EVENT_STAT AND NOT EXISTS ( SELECT 'X' FROM PS_FO_RF_ENTRY RFSH WHERE RFSH.BUSINESS_UNIT = RFSFO.BUSINESS_UNIT AND RFSH.SO_ID = RFSFO.SO_ID AND RFSH.SO_LINE = RFSFO.SO_LINE AND RFSH.CANDIDATE_TYPE = RFSFO.CANDIDATE_TYPE AND RFSH.CANDIDATE_ID = RFSFO.CANDIDATE_ID AND RFSH.FO_EVENT_STAT IN ('C', 'O') AND RFSH.LASTUPDOPRID <> 'SFOSYSTEMGENERATED') GROUP BY RFSFO.BUSINESS_UNIT, RFSFO.SO_ID, RFSFO.SO_LINE , RFSFO.CANDIDATE_TYPE, RFSFO.CANDIDATE_ID)) AND NOT EXISTS ( SELECT 'X' FROM PS_FO_RF_ENTRY RFPND WHERE RF.BUSINESS_UNIT=RFPND.BUSINESS_UNIT AND RF.SO_ID = RFPND.SO_ID AND RF.SO_LINE = RFPND.SO_LINE AND RF.CANDIDATE_TYPE = RFPND.CANDIDATE_TYPE AND RF.CANDIDATE_ID = RFPND.CANDIDATE_ID AND RFPND.FO_EVENT_STAT IN ('I', 'P')) UNION SELECT DISTINCT CUA.SETID , CON.CONTACT_ID , HDR.BUSINESS_UNIT , RF.SO_ID , RF.SO_LINE , RF.CANDIDATE_ID , CAN.FIRST_NAME , CAN.LAST_NAME , RF.EVENT_TYPE , RF.FO_SUBEVENT , EVS.DESCR , RF.FO_EVENT_STAT , RF.FO_PROC_EVNT_ST , %Substring (JC.DESCR, 1 , 9) , JC.DESCR , LN.START_DT , CUA.ADDRESS1 , CUA.CITY , CUA.STATE , CUA.COUNTRY , RF.DATETIME_ADDED , RF.START_TIME , RF.HISTORY_ID , RF.FO_RF_DISQ FROM PS_FO_RF_ENTRY RF , PS_RS_SO_HDR HDR , PS_RS_SO_LINE LN , PS_FO_SO_LINE_MTCH MTCH , PS_FO_CANDIDATE_W CAN , PS_FO_EVENTS_SETUP EVS , PS_CUST_ADDRESS CUA , PS_CUST_ADDR_SEQ CUS , PS_FO_JOBCD_CUR_VW JC , PS_CONTACT CON , PS_RS_SO_STATUS STS , PS_SET_CNTRL_GROUP SCJC , PS_SET_CNTRL_GROUP SCCON , PS_SET_CNTRL_GROUP SCCUA WHERE RF.SO_LINE <> 0 AND RF.BUSINESS_UNIT = HDR.BUSINESS_UNIT AND RF.SO_ID = HDR.SO_ID AND HDR.BUSINESS_UNIT = LN.BUSINESS_UNIT AND HDR.SO_ID = LN.SO_ID AND RF.SO_LINE = LN.SO_LINE AND RF.BUSINESS_UNIT = MTCH.BUSINESS_UNIT AND RF.SO_ID = MTCH.SO_ID AND RF.SO_LINE = MTCH.SO_LINE AND RF.CANDIDATE_TYPE = MTCH.CANDIDATE_TYPE AND RF.CANDIDATE_ID = MTCH.CANDIDATE_ID AND RF.CANDIDATE_TYPE = CAN.CANDIDATE_TYPE AND RF.CANDIDATE_ID = CAN.CANDIDATE_ID AND RF.EVENT_TYPE = EVS.EVENT_TYPE AND HDR.SYSTEM_SOURCE = 'STF' AND RF.FO_EVENT_STAT = 'C' AND MTCH.FO_FUN_UCONS = 'Y' AND HDR.BUSINESS_UNIT = STS.BUSINESS_UNIT AND HDR.SO_ID = STS.SO_ID AND STS.LASTUPDDTTM = ( SELECT MAX(STSDTTM.LASTUPDDTTM) FROM PS_RS_SO_STATUS STSDTTM WHERE STSDTTM.BUSINESS_UNIT = STS.BUSINESS_UNIT AND STSDTTM.SO_ID = STS.SO_ID) AND STS.SO_STATUS = 'U' AND SCCUA.SETCNTRLVALUE = HDR.BUSINESS_UNIT AND SCCUA.REC_GROUP_ID = 'FS_23' AND CUA.SETID = SCCUA.SETID AND CUA.SETID = CUS.SETID AND CUA.CUST_ID= CUS.CUST_ID AND CUA.ADDRESS_SEQ_NUM = CUS.ADDRESS_SEQ_NUM AND CUS.BILL_TO_ADDR = 'Y' AND CUS.SOLD_TO_ADDR = 'Y' AND %EffdtCheck(CUST_ADDRESS, CUA, %CurrentDateIn) AND CUA.EFF_STATUS='A' AND CUS.CUST_ID = HDR.CUST_ID AND CUS.ADDRESS_SEQ_NUM = HDR.ADDRESS_SEQ_NUM AND SCJC.SETCNTRLVALUE = LN.BUSINESS_UNIT AND SCJC.REC_GROUP_ID='FS_27' AND JC.SETID = SCJC.SETID AND LN.JOBCODE = JC.JOBCODE AND SCCON.SETCNTRLVALUE = HDR.BUSINESS_UNIT AND SCCON.REC_GROUP_ID='FS_54' AND CON.SETID = SCCON.SETID AND CON.CONTACT_ID = HDR.MANAGER_CONTACT_ID AND %EffdtCheck(CONTACT, CON, %CurrentDateIn) AND RF.HISTORY_ID IN ( SELECT MAX(RFHIST.HISTORY_ID) FROM PS_FO_RF_ENTRY RFHIST WHERE RFHIST.BUSINESS_UNIT = RF.BUSINESS_UNIT AND RFHIST.SO_ID = RF.SO_ID AND RFHIST.SO_LINE = RF.SO_LINE AND RFHIST.CANDIDATE_TYPE = RF.CANDIDATE_TYPE AND RFHIST.CANDIDATE_ID = RF.CANDIDATE_ID AND RFHIST.FO_EVENT_STAT = RF.FO_EVENT_STAT GROUP BY RFHIST.BUSINESS_UNIT, RFHIST.SO_ID, RFHIST.SO_LINE , RFHIST.CANDIDATE_TYPE, RFHIST.CANDIDATE_ID) AND NOT EXISTS ( SELECT 'X' FROM PS_FO_RF_ENTRY RFPND WHERE RF.BUSINESS_UNIT = RFPND.BUSINESS_UNIT AND RF.SO_ID = RFPND.SO_ID AND RF.SO_LINE = RFPND.SO_LINE AND RF.CANDIDATE_TYPE = RFPND.CANDIDATE_TYPE AND RF.CANDIDATE_ID = RFPND.CANDIDATE_ID AND RFPND.FO_EVENT_STAT IN ('I','P')) AND NOT EXISTS ( SELECT 'X' FROM PS_FO_RF_ENTRY RFPN WHERE RF.BUSINESS_UNIT = RFPN.BUSINESS_UNIT AND RF.SO_ID = RFPN.SO_ID AND RF.SO_LINE = RFPN.SO_LINE AND RF.CANDIDATE_TYPE = RFPN.CANDIDATE_TYPE AND RF.CANDIDATE_ID = RFPN.CANDIDATE_ID AND RFPN.HISTORY_ID = ( SELECT MAX(RFH.HISTORY_ID) FROM PS_FO_RF_ENTRY RFH WHERE RFH.BUSINESS_UNIT = RFPN.BUSINESS_UNIT AND RFH.SO_ID = RFPN.SO_ID AND RFH.SO_LINE = RFPN.SO_LINE AND RFH.CANDIDATE_TYPE = RFPN.CANDIDATE_TYPE AND RFH.CANDIDATE_ID = RFPN.CANDIDATE_ID AND RFH.FO_EVENT_STAT = 'O' AND RFH.LASTUPDOPRID <> 'SFOSYSTEMGENERATED'))

  • Parent record: FO_CAN4H_FUN_VW

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

    Y/N Table Edit