CS_DOC_EXTUSRVW

(SQL View)
 Index Back

External User view

Date Initials Issue Description ============================================ 08/2007 CEL F-AHAYT-25EQ8 view for use on supply side doc mgmt to see who is listed as a valid online user for this doc.

SELECT A.CS_DOC_ID , A.CS_EXT_CNTCT_FLG , A.CNTCT_SEQ_NUM , A.CONTACT_NAME , A.CONTACT_TITLE , B.EMAILID ,A.OPRID_EXT ,A.EXT_VIEW_ACCESS FROM PS_CS_CONTACT A , PSUSEREMAIL B WHERE A.OPRID_EXT = B.OPRID AND A.OPRID_EXT <> ' ' AND A.EXT_VIEW_ACCESS = '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

Default Value: Y

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 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
7 OPRID_EXT Character(30) VARCHAR2(30) NOT NULL External user

Prompt Table: OPRID_VW

8 EXT_VIEW_ACCESS Character(1) VARCHAR2(1) NOT NULL Document access bu external users

Y/N Table Edit

Default Value: N