FO_CAN4H_FUN_VW

(SQL View)
 Index Back

Order search view


SELECT C.SETID , C.CONTACT_ID , A.BUSINESS_UNIT , A.SO_ID , B.SO_STATUS , A.FO_EVENT_LST , A.OWNERSHIP_ID FROM PS_RS_SO_HDR A , PS_RS_SO_STATUS B , PS_CONTACT C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.SO_ID = B.SO_ID AND B.LASTUPDDTTM = ( SELECT MAX(LASTUPDDTTM) FROM PS_RS_SO_STATUS B1 WHERE B.BUSINESS_UNIT = B1.BUSINESS_UNIT AND B.SO_ID = B1.SO_ID) AND A.MANAGER_CONTACT_ID = C.CONTACT_ID AND A.SYSTEM_SOURCE = 'STF' AND EXISTS ( SELECT 'x' FROM PS_FO_EVENT_LS_HDR Z WHERE Z.FO_EVENT_LST = A.FO_EVENT_LST) AND B.SO_STATUS ='U' AND C.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_CONTACT D WHERE C.SETID = D.SETID AND C.CONTACT_ID = D.CONTACT_ID AND D.EFFDT <= %CurrentDateIn AND D.EFF_STATUS = 'A')

  • Parent Record Of FO_CAN4L_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

    Prompt Table: SP_BU_PC_NONVW

    4 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID
    5 FO_ORDER_STATUS Character(1) VARCHAR2(1) NOT NULL Order Status
    D=Draft
    E=Ended
    F=Filled
    U=Unfilled
    6 FO_EVENT_LST Character(30) VARCHAR2(30) NOT NULL Staffing Front Office Recruiting Funnel Event List
    7 OWNERSHIP_ID Character(30) VARCHAR2(30) NOT NULL Owning Organization