CONVR_RECENT_VW

(SQL View)
 Index Back

Most Recent Conversation


SELECT SETID , CUST_ID , CONVER_DTTM_INIT , CONVER_DT , CONVER_SEQ_NUM , BUSINESS_UNIT FROM PS_CUST_CONVER C WHERE CONVER_DTTM_INIT = ( SELECT MAX(CONVER_DTTM_INIT) FROM PS_CUST_CONVER WHERE SETID= C.SETID AND BUSINESS_UNIT = C.BUSINESS_UNIT AND CUST_ID = C.CUST_ID) AND CONVER_DT = ( SELECT MAX(CONVER_DT) FROM PS_CUST_CONVER WHERE SETID = C.SETID AND BUSINESS_UNIT = C.BUSINESS_UNIT AND CUST_ID = C.CUST_ID) AND CONVER_SEQ_NUM = ( SELECT MAX(CONVER_SEQ_NUM) FROM PS_CUST_CONVER WHERE SETID = C.SETID AND BUSINESS_UNIT = C.BUSINESS_UNIT AND CUST_ID = C.CUST_ID AND CONVER_DTTM_INIT = C.CONVER_DTTM_INIT AND CONVER_DT = C.CONVER_DT)

  • Parent record: CUSTOMER

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

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

    Prompt Table: CUSTOMER

    3 CONVER_DTTM_INIT DateTime(26) TIMESTAMP Initial Conversation DateTime
    4 CONVER_DT Date(10) DATE NOT NULL Conversation Date

    Default Value: %date

    5 CONVER_SEQ_NUM Number(6,0) INTEGER NOT NULL Conversation Sequence Number
    6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit