CS_DOC_ID001=Main Document
002=Amendment
003=Preview Document
004=Compare File
CS_DOC_TYPE_VW2(SQL View) |
Index Back |
|---|---|
Show signing fields by docUsed in AWE. Shows the signature fields for the documents document type. |
| SELECT A.CS_DOC_ID , B.CS_DOCUMENT_TYPE , B.CS_INTERNAL_SIGS , B.CS_SIGN_AFTER_APR , B.CS_SIGN_DURING_APR , B.CS_SIGN_PRIOR_APR , B.SETID FROM PS_CS_DOC_HDR A , PS_CS_DOC_TYPE_TBL B WHERE B.SETID = A.CS_SETID AND B.CS_DOCUMENT_TYPE = A.CS_DOCUMENT_TYPE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CS_DOC_ID |
Character(25) | VARCHAR2(25) NOT NULL | Document ID |
| 2 | CS_DOCUMENT_TYPE | Character(20) | VARCHAR2(20) NOT NULL |
Document Type
001=Main Document 002=Amendment 003=Preview Document 004=Compare File |
| 3 | CS_INTERNAL_SIGS | Character(1) | VARCHAR2(1) NOT NULL | Enable Internal Signatures |
| 4 | CS_SIGN_AFTER_APR | Character(1) | VARCHAR2(1) NOT NULL | After Approvals |
| 5 | CS_SIGN_DURING_APR | Character(1) | VARCHAR2(1) NOT NULL | During Approvals |
| 6 | CS_SIGN_PRIOR_APR | Character(1) | VARCHAR2(1) NOT NULL | Prior to Approvals |
| 7 | CS_SETID | Character(5) | VARCHAR2(5) NOT NULL | setid for the document objects |