AUC_CUST_CNT_VW

(SQL View)
 Index Back

Current Effect Dated Contacts


SELECT a.setid , a.cust_id , a.cntct_seq_num , b.contact_id , a.name1 , a.title , A.ADDRESS_SEQ_NUM , A.EMAILID , A.LANGUAGE_CD FROM ps_cust_contact a , PS_CONTACT_CUST b WHERE %EffdtCheck(cust_contact,a,%currentdatein) AND a.eff_status='A' AND a.setid = b.customer_setid AND a.cust_id = b.cust_id AND a.cntct_seq_num = b.cntct_seq_num AND %EffdtCheck(contact_cust,b,%currentdatein) AND b.eff_status = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BIDDER_SETID Character(5) VARCHAR2(5) NOT NULL Bidder Setid
2 BIDDER_ID Character(15) VARCHAR2(15) NOT NULL Bidder ID
3 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number

Prompt Table: CUST_CONTACT

4 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

Prompt Table: CNTCT_CUST_VW2
Set Control Field: BIDDER_SETID

5 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
6 TITLE Character(35) VARCHAR2(35) NOT NULL Title
7 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
8 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
9 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code