CNTCT_CST_SR_VW

(SQL View)
 Index Back

Contact Update Search View

Contact Update Search View Date Init. Issue # Description 012304 JJM 685277000 Created Rel Lang Record 090707 JJM 1690670000 - Changed prompt table for CONTACT_ID

SELECT A.SETID , A.CONTACT_ID , A.NAME1 , B.CUSTOMER_SETID , B.CUST_ID , C.NAME1 FROM PS_CONTACT A , PS_CONTACT_CUST B , PS_CUSTOMER C WHERE A.SETID = B.SETID (+) AND A.CONTACT_ID = B.CONTACT_ID (+) AND A.EFFDT = B.EFFDT (+) AND A.EFFDT = ( SELECT MAX(CNT.EFFDT) FROM PS_CONTACT CNT WHERE CNT.SETID = A.SETID AND CNT.CONTACT_ID = A.CONTACT_ID) AND B.CUSTOMER_SETID = C.SETID (+) AND B.CUST_ID = C.CUST_ID (+)

  • Related Language Record: CNTCT_CST_SR_LN

    • # 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 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

    Prompt Table: CONTACT_ALL_VW2

    3 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    4 CUST_SETID Character(5) VARCHAR2(5) NOT NULL Customer SetID

    Prompt Table: SP_SETID_NONVW

    5 CUST_ID_CNTCT Character(15) VARCHAR2(15) NOT NULL Customer ID

    Prompt Table: CUST_CNTCT_VW

    6 CUST_NAME Character(40) VARCHAR2(40) NOT NULL Name