CS_CONTACT_VW

(SQL View)
 Index Back

External Contacts

Date Initials Issue Description ============================================ 07/2007 CEL F-AHAYT-25EQ8 modified view text to pull the email correctly based on if they are tied to an external user id or not.

SELECT A.CS_DOC_ID , A.CS_EXT_CNTCT_FLG , A.CNTCT_SEQ_NUM , A.CONTACT_NAME , A.CONTACT_TITLE , A.EXT_PRIMARY_OWNER , CASE WHEN A.EMAILID = ' ' THEN B.EMAILID ELSE A.EMAILID END FROM PS_CS_CONTACT A LEFT OUTER JOIN PSUSEREMAIL B ON A.OPRID_EXT = B.OPRID AND B.PRIMARY_EMAIL = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CS_DOC_ID Character(25) VARCHAR2(25) NOT NULL Document ID
2 CS_EXT_CNTCT_FLG Character(1) VARCHAR2(1) NOT NULL External Contact

Y/N Table Edit

3 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number
4 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL The individual contact name associated with a given bank/counterparty.
5 CONTACT_TITLE Character(35) VARCHAR2(35) NOT NULL The professional title for a given bank/counterparty contact person.
6 EXT_PRIMARY_OWNER Character(1) VARCHAR2(1) NOT NULL Primary owner for external collaboration
7 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address