CS_DOC_IDCS_COLLAB_OPRIDPrompt Table: PSOPRDEFN_VW
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
CS_DOC_SIGN5_VW(SQL View) |
Index Back |
|---|---|
View for AWE signer number 5This View can be used within an approval process step to identify if a signer is present for the document. |
| SELECT A.CS_DOC_ID , A.CS_COLLAB_OPRID , B.OPRDEFNDESC , A.CS_SIGNER_FLG , A.CS_SIGN_VISIBLE , A.CS_SIGN_NBR , A.CS_SIGN_TITLE FROM PS_CS_DOC_COL_USER A , PSOPRDEFN B WHERE A.CS_SIGNER_FLG = 'Y' AND A.cs_sign_nbr = 5 AND A.CS_COLLAB_OPRID = B.OPRID |
| # | 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 | OPRDEFNDESC | Character(30) | VARCHAR2(30) NOT NULL | Description field for a user |
| 4 | CS_SIGNER_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Contract Signer
Y/N Table Edit Default Value: N |
| 5 | CS_SIGN_VISIBLE | Character(1) | VARCHAR2(1) NOT NULL |
Visibile/invisible digital signatures
Y/N Table Edit Default Value: N |
| 6 | CS_SIGN_NBR | Number(3,0) | SMALLINT NOT NULL | Order of signatures |
| 7 | CS_SIGN_TITLE | Character(35) | VARCHAR2(35) NOT NULL | Signing Title |