CUST_CNCT_BI_VW

(SQL View)
 Index Back

Current Effect Dated Contacts

Date Init Issue Description 111609 JJM 1905864000 Discontinued use of deprecated tables

SELECT CC.CUSTOMER_SETID , CC.CUST_ID , CC.CNTCT_SEQ_NUM , CT.NAME1 , CT.TITLE FROM PS_CONTACT CT , PS_CONTACT_CUST CC WHERE %Join(COMMON_KEYS, CONTACT CT, CONTACT_CUST CC) AND %EffdtCheck(CONTACT CT2, CT, %CurrentDateIn) AND CT.EFF_STATUS = 'A' AND CC.EFF_STATUS = 'A'

  • Related Language Record: CUST_CNCT_BI_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 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer

    Prompt Table: CUSTOMER

    3 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number

    Prompt Table: CUST_CONTACT

    4 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    5 TITLE Character(35) VARCHAR2(35) NOT NULL Title