CS_DOCSIGNER_VW(SQL View) |
Index Back |
|---|---|
Doc Collaboration StatusDoc Collaboration Status 12/2014 SCMT002 RMK Added emailid and url fields for EchoSign 05/13/2021 CD PSFTSCMT-782 Added field Recipient ID, which is key field to correct signer information in DocuSign |
| SELECT cs_doc_id , cs_sign_nbr , emailid , cs_collab_oprid , recipient_id , cs_signgroup_name , cs_signgroup_id , ' ' , cs_signer_flg , cs_sign_title , cs_alt_user , cs_alt_emailid , 'N' , cs_sign_Status , cs_username , cs_carbon_copy_flg 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 , oprid_Ext , recipient_id , cs_signgroup_name , cs_signgroup_id , contact_name , cs_signer_flg , ' ' , ' ' , cs_alt_emailid , 'Y' , cs_sign_Status , contact_name , cs_carbon_copy_flg 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_COLLAB_OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
User
Prompt Table: PSOPRDEFN_VW |
| 5 | RECIPIENT_ID |
Character(8) | VARCHAR2(8) NOT NULL | Fields used by Global Payroll |
| 6 | CS_SIGNGROUP_NAME | Character(100) | VARCHAR2(100) NOT NULL |
Image 48 PSFtSCMT-924 DocuSign Signing Groups
Prompt Table: CS_SIGNGROUP_VW |
| 7 | CS_SIGNGROUP_ID | Character(50) | VARCHAR2(50) NOT NULL | Image 48 PSFtSCMT-924 DocuSign Signing Groups |
| 8 | CONTACT_NAME | Character(50) | VARCHAR2(50) NOT NULL | The individual contact name associated with a given bank/counterparty. |
| 9 | CS_SIGNER_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Contract Signer
Y/N Table Edit Default Value: Y |
| 10 | CS_SIGN_TITLE | Character(35) | VARCHAR2(35) NOT NULL | Signing Title |
| 11 | CS_ALT_USER | Character(30) | VARCHAR2(30) NOT NULL | Signed/Marked as Signed By |
| 12 | CS_ALT_EMAILID | Character(70) | VARCHAR2(70) NOT NULL | SCMT002 2/9/2015 RMK |
| 13 | CS_EXT_SIGNER_FLG | Character(1) | VARCHAR2(1) NOT NULL |
SCMT002 2/3/2015
Y/N Table Edit |
| 14 | 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 |
| 15 | CS_USERNAME | Character(50) | VARCHAR2(50) NOT NULL |
SCMT010 11/9/2015
Prompt Table: CS_SIGNGROUP_VW |
| 16 | CS_CARBON_COPY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
SCMT010 11/9/2015
Y/N Table Edit Default Value: N |