CS_ESIGNUSER_VW

(SQL View)
 Index Back

Signers view

02/28/2023 PSFtSCMT-1173 New record view

SELECT u.cs_esign_name , u.oprid , u.cs_echosign_user , s.cs_email_address , s.cs_api_key , s.cs_emailbody , s.cs_password , u.cs_userid , ' ' , ' ' , s.cs_rest_baseurl , s.cs_expire_dttm , s.cs_client_id , s.cs_client_secret , s.cs_docusign_env , s.cs_private_key , s.cs_account_id FROM ps_cs_esign_setup s , PS_CS_ESIGN_USERS u WHERE s.cs_esign_name = u.cs_esign_name AND s.oprid = u.oprid

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CS_ESIGN_NAME Character(1) VARCHAR2(1) NOT NULL 12/2014 SCMT002 Electronic signature account
1=Adobe ESign
2=DocuSign

Default Value: 1

2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Prompt Table: PSOPRDEFN_VW

3 CS_ECHOSIGN_USER Character(30) VARCHAR2(30) NOT NULL EchoSign User
4 CS_EMAIL_ADDRESS Character(70) VARCHAR2(70) NOT NULL Account Email
5 CS_API_KEY Long Character(1000) VARCHAR2(1000) 12/2014 PUM#14 SCMT002 EchoSign electronic signature
6 CS_EMAILBODY Long Character CLOB 12/2014 New for PUM #14 EchoSign e-signature
7 CS_PASSWORD Character(100) VARCHAR2(100) NOT NULL Password
8 CS_USERID Character(50) VARCHAR2(50) NOT NULL User ID
9 CS_ACCESS_TOKEN Long Character CLOB Access Token
10 CS_REFRESH_TOKEN Long Character CLOB Image 34 Adobe Sign REST API
11 CS_REST_BASEURL Character(254) VARCHAR2(254) NOT NULL F-AHAYT-X0ES6 - new field for wizard enhancements
12 CS_EXPIRE_DTTM DateTime(26) TIMESTAMP Image 34 PSFTSCTM69 Adobe Sign REST API
13 CS_CLIENT_ID Character(254) VARCHAR2(254) NOT NULL Image 33 Adobe Sign REST API
14 CS_CLIENT_SECRET Character(254) VARCHAR2(254) NOT NULL Image 33 Adobe Sign REST API
15 CS_DOCUSIGN_ENV Character(1) VARCHAR2(1) NOT NULL DocuSign Environments
D=Demo
P=Production

Default Value: D

16 CS_PRIVATE_KEY Long Character CLOB 09/28/2022 RMK PSFTSCMT-1075 DocuSign OAuth 2.0
17 CS_ACCOUNT_ID Character(50) VARCHAR2(50) NOT NULL SCMT010 Account ID