FO_EMP_ASG_SRCH

(SQL View)
 Index Back

Employee Assignment Search


SELECT J.NAME ,A.EMPLID ,D.NAME1 ,B.CUST_ID ,A.BUSINESS_UNIT ,A.SO_ID ,H.FO_JOBTITLE ,A.ASSIGNMENT_ID FROM PS_RS_ASSIGNMENT A , PS_RS_SO_HDR B , PS_CUSTOMER D , PS_RS_SO_LINE H , PS_PERS_DATA_EFFDT J , PS_FO_ORDER_TYPE O WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.BUSINESS_UNIT = H.BUSINESS_UNIT AND A.SO_ID = B.SO_ID AND H.SO_ID = A.SO_ID AND O.USER_ORDER_TYPE = B.USER_ORDER_TYPE AND O.ORDER_TYPE = 'T' AND J.EMPLID = A.EMPLID AND %EffdtCheck(PERS_DATA_EFFDT, J, %CurrentDateIn) AND B.CUST_ID = D.CUST_ID AND D.SETID = ( SELECT G.SETID FROM PS_SET_CNTRL_REC G WHERE G.RECNAME = 'CUSTOMER' AND G.SETCNTRLVALUE = B.BUSINESS_UNIT )

  • Related Language Record: FO_EMPASG_SRLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 NAME Character(50) VARCHAR2(50) NOT NULL Name
    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSONAL_DATA

    3 CUST_NAME Character(40) VARCHAR2(40) NOT NULL Name
    4 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.
    5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    6 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID
    7 FO_JOBTITLE Character(9) VARCHAR2(9) NOT NULL Job Title Code
    8 ASSIGNMENT_ID Character(15) VARCHAR2(15) NOT NULL Work Assignment ID

    Prompt Table: FO_ASGN_SRCH_VW