| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 CS_DOC_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Document ID
|
| 2 |
DATETIME_STAMP |
DateTime(26) |
TIMESTAMP |
DateTime Stamp
|
| 3 |
CS_DOC_ACTION |
Character(2) |
VARCHAR2(2) NOT NULL |
4/22/08 RMK F-AHAYT-X0ES6 Added action "53" Amendment File Updated
7/08 cel Added 54 Created Executive Summary file
|
| 4 |
CS_DOCUMENT_TYPE |
Character(20) |
VARCHAR2(20) NOT NULL |
Document Type
001=Main Document
002=Amendment
003=Preview Document
004=Compare File
Prompt Table:
CS_DOCT_ALL_VW
|
| 5 |
OPRID_LAST_ACTION |
Character(30) |
VARCHAR2(30) NOT NULL |
Last User to Take Action
|
| 6 |
CS_DOC_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Document Status
AA=Approved
AD=Denied
AP=Pending Approval
CC=Collaborated
CP=Pending Collaboration
CR=Collaborated, Pending Review
DC=Complete
DR=Draft
DS=Dispatched
EC=Pending External Collaboration
EX=Executed
PI=Pending Internal Review
|
| 7 |
CS_DOC_OWNER |
Character(30) |
VARCHAR2(30) NOT NULL |
Document Administrator
|
| 8 |
CS_SPONSOR |
Character(30) |
VARCHAR2(30) NOT NULL |
Sponsor
|
| 9 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 10 |
CS_VERSION |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Version
|
| 11 |
CS_AMENDMENT |
Number(3,0) |
SMALLINT NOT NULL |
Amendment
|
| 12 |
CS_TWOFILE_AMEND |
Character(1) |
VARCHAR2(1) NOT NULL |
Amendment Option
1=Amend Contract Only
2=Amend Contract with Amendments
3=Amendment Files Only
|
| 13 |
CS_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
setid for the document objects
|
| 14 |
CS_TEMPLATE_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
SCC 09/01/04
|
| 15 |
CS_TEMPLATE_AMEND |
Character(20) |
VARCHAR2(20) NOT NULL |
SCC 09/01/04
|
| 16 |
CS_EX_SUMM_TMPL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Executive Summary Configurator
|
| 17 |
COMMENT1 |
Character(254) |
VARCHAR2(254) NOT NULL |
Comments
|
| 18 |
CNTRCT_BEGIN_DT |
Date(10) |
DATE |
Contract Begin Date
|
| 19 |
CNTRCT_EXPIRE_DT |
Date(10) |
DATE |
Expire Date
|
| 20 |
CS_DOC_ATT_VER |
Number(3,0) |
SMALLINT NOT NULL |
This is the cycle/seq nbr that indicates the change interation/version that the normal attachments are on.
Since we want to save them off in history
|
| 21 |
CS_DOC_EXT_ATT_VER |
Number(3,0) |
SMALLINT NOT NULL |
This is the cycle/seq nbr that indicates the change interation/version that the normal attachments are on.
Since we want to save them off in history
|
| 22 |
CS_DOC_DISP_VER |
Number(3,0) |
SMALLINT NOT NULL |
Dispatch version/cycle
|
| 23 |
CS_DOC_COLLAB_VER |
Number(3,0) |
SMALLINT NOT NULL |
Collaboration Version
|
| 24 |
CS_DOC_LOG_VER |
Number(3,0) |
SMALLINT NOT NULL |
Logging Version
|
| 25 |
CS_DOC_SIGN_VER |
Number(5,0) |
INTEGER NOT NULL |
Signing Version Number
|
| 26 |
CS_DOC_EXEC_VER |
Number(3,0) |
SMALLINT NOT NULL |
Executed Summary Version
|
| 27 |
INCLUDE_ATTACHMENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Attachments
|
| 28 |
SEND_TO_OWNER |
Character(1) |
VARCHAR2(1) NOT NULL |
Send Copy to Owner
|
| 29 |
DISBURSE_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Initials Issue Description
============================================
09/2007 CEL F-AHAYT-25EQ8 Added new translate for oline signatures
1=Email
2=Manual
3=Email and Online Signatures
|
| 30 |
AMNDMNT_DIS_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Amendment Disbursement Options
1=Most Recent Only
2=All
|
| 31 |
CS_ORIGINAL_DOC |
Character(1) |
VARCHAR2(1) NOT NULL |
Original Executed Document
|
| 32 |
CS_AMENDED_DOC |
Character(1) |
VARCHAR2(1) NOT NULL |
Amended Document
|
| 33 |
CS_AMENDMENTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Amendment Files
|
| 34 |
CS_IMPORT_CODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Import Type
1=Authored
2=Imported
3=Hybrid
4=Automatic Import
|
| 35 |
BUSINESS_UNIT_REQ |
Character(5) |
VARCHAR2(5) NOT NULL |
Requesting Business Unit
|
| 36 |
REQ_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Requisition ID
|
| 37 |
CS_DOC_ID_ORIG |
Character(25) |
VARCHAR2(25) NOT NULL |
Document ID
|
| 38 |
CS_INT_SIGN_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Internal Signature Status
NR=Not Required
PS=Pending Signatures
SS=Signed
Default Value: NR
|
| 39 |
CS_EXT_SIGN_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
External Signature Status
NR=Not Initiated
PS=Pending Signatures
RJ=Declined
SS=Signed
Default Value: NR
|
| 40 |
CS_SIGN_FILE |
Character(1) |
VARCHAR2(1) NOT NULL |
File Being Signed
0=No Files
1=Main
2=Amendment
Default Value: 0
|
| 41 |
CS_SIGN_PREP_DONE |
Character(1) |
VARCHAR2(1) NOT NULL |
Adobe Signature Prep
Y/N Table Edit
Default Value: N
|
| 42 |
CS_SOURCE_VER |
Number(3,0) |
SMALLINT NOT NULL |
cel 10/19/2007 - will store the associated source version number that this document is build upon. Both PO and Contracts in 9.1 will have a corresponding version.
Default Value: 0
|
| 43 |
CS_SOURCE_ROUND |
Number(5,0) |
INTEGER NOT NULL |
Event Round
|
| 44 |
CS_DOC_START_DATE |
Date(10) |
DATE |
Cycle Start Date
|
| 45 |
CS_DOC_DUE_DATE |
Date(10) |
DATE |
Cycle Due Date
|
| 46 |
CS_ACT_CYCLE_DAYS |
Number(4,0) |
SMALLINT NOT NULL |
Actual Cycle Time
|
| 47 |
CS_DOC_UFLD_VER |
Number(3,0) |
SMALLINT NOT NULL |
User Defined Field Version
|
| 48 |
CS_FILES_PURGED |
Character(1) |
VARCHAR2(1) NOT NULL |
Files Purged
Y/N Table Edit
Default Value: N
|
| 49 |
CS_COLLAB_COMMENTS |
Long Character |
CLOB |
Collaboration Comments
|
| 50 |
CS_DOCUMENTKEY |
Character(100) |
VARCHAR2(100) NOT NULL |
December 2014 PUM#14 SCMT002 EchoSign electronic signature
|
| 51 |
CS_ESEND_DTTM |
DateTime(26) |
TIMESTAMP |
SCMT002 2/11/2015 RMK Datetime stamp document is routed for electronic signature
|
| 52 |
CS_EMAIL_ADDRESS |
Character(70) |
VARCHAR2(70) NOT NULL |
Account Email
|