CS_ESIGNERS_VW

(SQL View)
 Index Back

Doc Collaboration Status

Doc Collaboration Status 12/2014 SCMT002 RMK Added emailid and url fields for EchoSign

SELECT cs_doc_id , cs_sign_nbr , emailid , cs_signgroup_name , cs_collab_oprid , cs_username , cs_signer_flg , cs_sign_title , cs_alt_user , cs_alt_emailid , 'N' , cs_sign_Status , cs_sign_dttm FROM PS_CS_DOC_COL_USER WHERE (cs_signer_flg = 'Y' OR cs_carbon_copy_flg = 'Y') AND (Emailid <> ' ' OR cs_signgroup_name<>' ') UNION SELECT cs_doc_id , cs_sign_nbr , emailid , cs_signgroup_name , oprid_Ext , contact_name , cs_signer_flg , ' ' , ' ' , cs_alt_emailid , 'Y' , cs_sign_Status , cs_sign_dttm FROM ps_cs_contact WHERE (cs_signer_flg = 'Y' OR cs_carbon_copy_flg = 'Y') AND (Emailid <> ' ' OR cs_signgroup_name<>' ')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CS_DOC_ID Character(25) VARCHAR2(25) NOT NULL Document ID
2 CS_SIGN_NBR Number(3,0) SMALLINT NOT NULL Order of signatures
3 CS_EMAIL_ADDRESS Character(70) VARCHAR2(70) NOT NULL Account Email
4 CS_SIGNGROUP_NAME Character(100) VARCHAR2(100) NOT NULL Image 48 PSFtSCMT-924 DocuSign Signing Groups
5 CS_COLLAB_OPRID Character(30) VARCHAR2(30) NOT NULL User

Prompt Table: PSOPRDEFN_VW

6 CS_USERNAME Character(50) VARCHAR2(50) NOT NULL SCMT010 11/9/2015
7 CS_SIGNER_FLG Character(1) VARCHAR2(1) NOT NULL Contract Signer

Y/N Table Edit

Default Value: Y

8 CS_SIGN_TITLE Character(35) VARCHAR2(35) NOT NULL Signing Title
9 CS_ALT_USER Character(30) VARCHAR2(30) NOT NULL Signed/Marked as Signed By
10 CS_ALT_EMAILID Character(70) VARCHAR2(70) NOT NULL SCMT002 2/9/2015 RMK
11 CS_EXT_SIGNER_FLG Character(1) VARCHAR2(1) NOT NULL SCMT002 2/3/2015

Y/N Table Edit

12 CS_SIGN_STATUS Character(1) VARCHAR2(1) NOT NULL Sign Status
A=Signed by Proxy
D=Declined
I=Initial
M=Marked as Signed
P=Pending Signature
R=Replaced by Alternate
S=Signed
13 CS_SIGN_DTTM DateTime(26) TIMESTAMP Signed DTTM