CS_DOC_ESIGN_VW (SQL View)	Index Back
External List of Signers Date Initials Issue Description ============================================ 09/2007 CEL F-AHAYT-25EQ8 view to show the list of external signers for a document

CS_DOC_ESIGN_VW

(SQL View)

External List of Signers

Date Initials Issue Description ============================================ 09/2007 CEL F-AHAYT-25EQ8 view to show the list of external signers for a document

SELECT CS_DOC_ID , CONTACT_NAME , CONTACT_TITLE , CS_SIGNER_FLG , CS_SIGN_NBR , CS_SIGN_VISIBLE FROM PS_CS_CONTACT WHERE CS_SIGNER_FLG = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CS_DOC_ID Character(25) VARCHAR2(25) NOT NULL Document ID

2 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL The individual contact name associated with a given bank/counterparty.

3 CONTACT_TITLE Character(35) VARCHAR2(35) NOT NULL The professional title for a given bank/counterparty contact person.

4 CS_SIGNER_FLG Character(1) VARCHAR2(1) NOT NULL Contract Signer
Y/N Table Edit
Default Value: N

5 CS_SIGN_NBR Number(3,0) SMALLINT NOT NULL Order of signatures

6 CS_SIGN_VISIBLE Character(1) VARCHAR2(1) NOT NULL Visibile/invisible digital signatures
Y/N Table Edit
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CS_DOC_ID	Character(25)	VARCHAR2(25) NOT NULL	Document ID
2	CONTACT_NAME	Character(50)	VARCHAR2(50) NOT NULL	The individual contact name associated with a given bank/counterparty.
3	CONTACT_TITLE	Character(35)	VARCHAR2(35) NOT NULL	The professional title for a given bank/counterparty contact person.
4	CS_SIGNER_FLG	Character(1)	VARCHAR2(1) NOT NULL	Contract Signer Y/N Table Edit Default Value: N
5	CS_SIGN_NBR	Number(3,0)	SMALLINT NOT NULL	Order of signatures
6	CS_SIGN_VISIBLE	Character(1)	VARCHAR2(1) NOT NULL	Visibile/invisible digital signatures Y/N Table Edit Default Value: N