CS_DOC_IDCS_COLLAB_OPRIDPrompt Table: PSOPRDEFN_VW
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
A=Signed by Proxy
D=Declined
I=Initial
M=Marked as Signed
P=Pending Signature
R=Replaced by Alternate
S=Signed
CS_DOC_ISIGN_VW(SQL View) |
Index Back |
|---|---|
List of Internal signersDate Initials Issue Description ============================================ 09/2007 CEL F-AHAYT-25EQ8 view to show the list of internal signers for a document |
| SELECT CS_DOC_ID , CS_COLLAB_OPRID , CS_SIGNER_FLG , CS_SIGN_VISIBLE , CS_SIGN_NBR , CS_SIGN_TITLE , cs_sign_status , cs_sign_dttm FROM PS_CS_DOC_COL_USER 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 | CS_COLLAB_OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
User
Prompt Table: PSOPRDEFN_VW |
| 3 | CS_SIGNER_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Contract Signer
Y/N Table Edit Default Value: N |
| 4 | CS_SIGN_VISIBLE | Character(1) | VARCHAR2(1) NOT NULL |
Visibile/invisible digital signatures
Y/N Table Edit Default Value: N |
| 5 | CS_SIGN_NBR | Number(3,0) | SMALLINT NOT NULL | Order of signatures |
| 6 | CS_SIGN_TITLE | Character(35) | VARCHAR2(35) NOT NULL | Signing Title |
| 7 | 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 |
| 8 | CS_SIGN_DTTM | DateTime(26) | TIMESTAMP | Signed DTTM |