CS_DOC_HDR(SQL Table) |
Index Back |
|---|---|
Contract Document Header11/17/2015 TBG added CNTRCT_STYLE for PO0025 feature and also VENDOR_ID and VENDOR-SETID for adhoc enhancement to modify vendor for awarded Sources 11/10/2010 RMK Open XML integration - added cs_file_format to track document xml version versus contract library (cs_file_format in cs_config_tbl) 10/11/07 F-AHAYT-X0ES6 New field to track which file has been checked out; only used when contract goes into amendment cycle. This field is introduced due to managing check out/in of each file using the 2-file option 2008 cel Added the cycle time, user defined fields. etc. 5/3008 cel added the proxy user field. 11/17/2015 TBG Master Contracts changes |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(25) | VARCHAR2(25) NOT NULL | Document ID | |
| 2 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 3 | 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 |
| 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 | CS_DOC_OWNER | Character(30) | VARCHAR2(30) NOT NULL |
Document Administrator
Prompt Table: PSOPRDEFN_VW |
| 6 | CS_SPONSOR | Character(30) | VARCHAR2(30) NOT NULL |
Sponsor
Prompt Table: PSOPRDEFN_VW |
| 7 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: CS_DEPTID_VW |
| 8 | CS_SETID | Character(5) | VARCHAR2(5) NOT NULL |
setid for the document objects
Prompt Table: SP_SETID_NONVW |
| 9 | CS_TEMPLATE_ID | Character(20) | VARCHAR2(20) NOT NULL |
SCC 09/01/04
Prompt Table: CS_TEMPLATE_DVW |
| 10 | CS_TEMPLATE_AMEND | Character(20) | VARCHAR2(20) NOT NULL | SCC 09/01/04 |
| 11 | CS_EX_SUMM_TMPL_ID | Character(20) | VARCHAR2(20) NOT NULL |
Executive Summary Configurator
Prompt Table: CS_TEMPLATE_DVW |
| 12 | CS_VERSION | Number(6,2) | DECIMAL(5,2) NOT NULL | Version |
| 13 | CS_AMENDMENT | Number(3,0) | SMALLINT NOT NULL | Amendment |
| 14 | CS_TWOFILE_AMEND | Character(1) | VARCHAR2(1) NOT NULL |
Amendment Option
1=Amend Contract Only 2=Amend Contract with Amendments 3=Amendment Files Only Default Value: 1 |
| 15 | CS_SOURCE_TRANS | Character(2) | VARCHAR2(2) NOT NULL |
Source Transaction
03/22/07 cel F-AHAYT-748L7: Added Purchase Order (03) as a new source transaction
01/12/11 tbg SCMT-92-MDEM-04: Added RFx (04) as new source transaction for strat sourcing (doc authoring)
01=Ad Hoc 02=Purchasing Contracts 03=Purchase Orders 04=Sourcing Events 97=All Sources 98=Multiple Sources 99=Not Transactional |
| 16 | CS_TRANKEY_REC | Character(15) | VARCHAR2(15) NOT NULL | Source Key Record |
| 17 | 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 |
| 18 | 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 |
| 19 | CS_DOC_DISP_VER | Number(3,0) | SMALLINT NOT NULL | Dispatch version/cycle |
| 20 | CS_DOC_COLLAB_VER | Number(3,0) | SMALLINT NOT NULL | Collaboration Version |
| 21 | CS_DOC_LOG_VER | Number(3,0) | SMALLINT NOT NULL | Logging Version |
| 22 | CS_DOC_SIGN_VER | Number(5,0) | INTEGER NOT NULL | Signing Version Number |
| 23 | CS_DOC_EXEC_VER | Number(3,0) | SMALLINT NOT NULL | Executed Summary Version |
| 24 | CS_COLLAB_INSTR | Character(254) | VARCHAR2(254) NOT NULL | Collaboration Instructions |
| 25 | CLOSE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Close Contract Flag
Y/N Table Edit Default Value: N |
| 26 | EXT_LOCK_FLG | Character(1) | VARCHAR2(1) NOT NULL |
External Lock Flag
Y/N Table Edit Default Value: N |
| 27 | HOLD_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Hold
N=Hold Y=Hold Y/N Table Edit Default Value: N |
| 28 | CNTRCT_BEGIN_DT | Date(10) | DATE | Contract Begin Date |
| 29 | CNTRCT_EXPIRE_DT | Date(10) | DATE | Expire Date |
| 30 | CREATED_DTTM | DateTime(26) | TIMESTAMP | Created Date and time |
| 31 | CREATED_BY_USER | Character(30) | VARCHAR2(30) NOT NULL | Created By |
| 32 | AMENDED_DTTM | DateTime(26) | TIMESTAMP | Amendment Created On |
| 33 | DATETIME_CHECKOUT | DateTime(26) | TIMESTAMP | Checked Out On |
| 34 | CHECKED_OUT_BY | Character(30) | VARCHAR2(30) NOT NULL | Checked Out By |
| 35 | DATETIME_EX_CHKOUT | DateTime(26) | TIMESTAMP | Summary Checked Out On |
| 36 | CHECKED_OUT_EX_BY | Character(30) | VARCHAR2(30) NOT NULL | Checked Out By |
| 37 | COMMENT1 | Character(254) | VARCHAR2(254) NOT NULL | Comments |
| 38 | COLLABED_DTTM | DateTime(26) | TIMESTAMP | Collaborated On |
| 39 | COLLABED_EXT_DTTM | DateTime(26) | TIMESTAMP | Collaborated Externally On |
| 40 | CS_COLLAB_DUE_DT | Date(10) | DATE | Collaboration Due Date |
| 41 | CS_COLLAB_DUE_TM | Time(15) | TIMESTAMP | Collaboration Due Time |
| 42 | APPROVAL_DTTM | DateTime(26) | TIMESTAMP | A system generated value that reflects the date and time a given transaction is approved by an oper |
| 43 | DATETIME_DISPATCH | DateTime(26) | TIMESTAMP | 02/2001 cel WV-802-1.0 |
| 44 | EXECUTED_DTTM | DateTime(26) | TIMESTAMP | Executed On |
| 45 | CS_COMPLETED_DTTM | DateTime(26) | TIMESTAMP | Completed Datetime |
| 46 | LAST_MODIFIED_DATE | DateTime(26) | TIMESTAMP | Last modified date |
| 47 | LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 48 | CS_IMPORT_CODE | Character(1) | VARCHAR2(1) NOT NULL |
Import Type
1=Authored 2=Imported 3=Hybrid 4=Automatic Import Default Value: 1 |
| 49 | BUSINESS_UNIT_REQ | Character(5) | VARCHAR2(5) NOT NULL |
Requesting Business Unit
Prompt Table: SP_BU_PM_NONVW |
| 50 | REQ_ID | Character(10) | VARCHAR2(10) NOT NULL |
Requisition ID
Prompt Table: CS_REQ_ID_VW |
| 51 | CS_REQ_LOCATION | Character(1) | VARCHAR2(1) NOT NULL |
Requisition Transaction
C=Core E=ePro |
| 52 | CS_DOC_ID_ORIG | Character(25) | VARCHAR2(25) NOT NULL | Document ID |
| 53 | ATTACHED_TO_REQ | Character(1) | VARCHAR2(1) NOT NULL |
Attached to Requisition
Y/N Table Edit Default Value: N |
| 54 | CS_DOC_BLD_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Used by Copy Doc. All other document create processes automatically set to 1.
1=Complete 2=Refresh Binds 3=Original Copied 4=Exec Summary Copied 5=Wizard Invoked 9=Copy Initiated Default Value: 1 |
| 55 | CS_ROUTE_SIGN_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Document in Signature Loop
Y/N Table Edit Default Value: N |
| 56 | CS_SIGN_FILE | Character(1) | VARCHAR2(1) NOT NULL |
File Being Signed
0=No Files 1=Main 2=Amendment Default Value: 0 |
| 57 | CS_SIGN_PREP_DONE | Character(1) | VARCHAR2(1) NOT NULL |
Adobe Signature Prep
Y/N Table Edit Default Value: N |
| 58 | CS_INT_SIGN_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Internal Signature Status
NR=Not Required PS=Pending Signatures SS=Signed Default Value: NR |
| 59 | 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 |
| 60 | CS_CHECKOUT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
10/02/07 Field created for SCMT release 9.1 - flag to determine the checkout status
N - not checked out
M - main document is checked out (amendment option 1 or 2)
A - amendment file is checked out ((amendment option 2 or 3)
B - both files are checked out ((amendment option 2)
A=Checked out amendment file B=Checked out both files M=Checked out main document N=No checkout Default Value: N |
| 61 | 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. |
| 62 | CS_SOURCE_ROUND | Number(5,0) | INTEGER NOT NULL | Event Round |
| 63 | CS_DOC_DUE_DATE | Date(10) | DATE | Cycle Due Date |
| 64 | CS_DOC_START_DATE | Date(10) | DATE | Cycle Start Date |
| 65 | CS_DOC_STATUS_DATE | Date(10) | DATE | Last Status Change Date |
| 66 | CS_CHAR_USER1 | Character(10) | VARCHAR2(10) NOT NULL | Character 10 User Field 1 |
| 67 | CS_CHAR_USER2 | Character(10) | VARCHAR2(10) NOT NULL | Character 10 User Field 2 |
| 68 | CS_CHAR_USER3 | Character(10) | VARCHAR2(10) NOT NULL | Character 10 User Field 3 |
| 69 | CS_CHAR_USER4 | Character(10) | VARCHAR2(10) NOT NULL | Character 10 User Field 4 |
| 70 | CS_CHAR_USER5 | Character(30) | VARCHAR2(30) NOT NULL | Character 30 User Field 5 |
| 71 | CS_CHAR_USER6 | Character(30) | VARCHAR2(30) NOT NULL | Character 30 User Field 6 |
| 72 | CS_CHAR_USER7 | Character(30) | VARCHAR2(30) NOT NULL | Character 30 User Field 7 |
| 73 | CS_CHAR_USER8 | Character(30) | VARCHAR2(30) NOT NULL | Character 30 User Field 8 |
| 74 | CS_CHAR_USER9 | Character(60) | VARCHAR2(60) NOT NULL | Character 60 User Field 9 |
| 75 | CS_CHAR_USER10 | Character(60) | VARCHAR2(60) NOT NULL | Character 60 User Field 10 |
| 76 | CS_CHAR_USER11 | Character(10) | VARCHAR2(10) NOT NULL | Character 10 User Field 11 |
| 77 | CS_CHAR_USER12 | Character(10) | VARCHAR2(10) NOT NULL | Character 10 User Field 12 |
| 78 | CS_CHAR_USER13 | Character(10) | VARCHAR2(10) NOT NULL | Character 10 User Field 13 |
| 79 | CS_CHAR_USER14 | Character(10) | VARCHAR2(10) NOT NULL | Character 10 User Field 14 |
| 80 | CS_CHAR_USER15 | Character(10) | VARCHAR2(10) NOT NULL | Character 10 User Field 15 |
| 81 | CS_CHAR_USER16 | Character(10) | VARCHAR2(10) NOT NULL | Character 10 User Field 16 |
| 82 | CS_CHAR_USER17 | Character(10) | VARCHAR2(10) NOT NULL | Character 10 User Field 17 |
| 83 | CS_CHAR_USER18 | Character(10) | VARCHAR2(10) NOT NULL | Character 10 User Field 18 |
| 84 | CS_CHAR_USER19 | Character(30) | VARCHAR2(30) NOT NULL | Character 30 User Field 19 |
| 85 | CS_CHAR_USER20 | Character(30) | VARCHAR2(30) NOT NULL | Character 30 User Field 20 |
| 86 | CS_CHAR_USER21 | Character(30) | VARCHAR2(30) NOT NULL | Character 30 User Field 21 |
| 87 | CS_CHAR_USER22 | Character(30) | VARCHAR2(30) NOT NULL | Character 30 User Field 22 |
| 88 | CS_CHAR_USER23 | Character(30) | VARCHAR2(30) NOT NULL | Character 30 User Field 23 |
| 89 | CS_CHAR_USER24 | Character(30) | VARCHAR2(30) NOT NULL | Character 30 User Field 24 |
| 90 | CS_CHAR_USER25 | Character(30) | VARCHAR2(30) NOT NULL | Character 30 User Field 25 |
| 91 | CS_CHAR_USER26 | Character(30) | VARCHAR2(30) NOT NULL | Character 30 User Field 26 |
| 92 | CS_CHAR_USER27 | Character(60) | VARCHAR2(60) NOT NULL | Character 60 User Field 27 |
| 93 | CS_CHAR_USER28 | Character(60) | VARCHAR2(60) NOT NULL | Character 60 User Field 28 |
| 94 | CS_CHAR_USER29 | Character(60) | VARCHAR2(60) NOT NULL | Character 60 User Field 29 |
| 95 | CS_CHAR_USER30 | Character(60) | VARCHAR2(60) NOT NULL | Character 60 User Field 30 |
| 96 | CS_CHAR_USER31 | Character(60) | VARCHAR2(60) NOT NULL | Character 60 User Field 31 |
| 97 | CS_CHAR_USER32 | Character(60) | VARCHAR2(60) NOT NULL | Character 60 User Field 32 |
| 98 | CS_CHAR_USER33 | Character(120) | VARCHAR2(120) NOT NULL | Character 120 User Field 33 |
| 99 | CS_CHAR_USER34 | Character(120) | VARCHAR2(120) NOT NULL | Character 120 User Field 34 |
| 100 | CS_CHAR_USER35 | Character(120) | VARCHAR2(120) NOT NULL | Character 120 User Field 35 |
| 101 | CS_CHAR_USER36 | Character(120) | VARCHAR2(120) NOT NULL | Character 120 User Field 36 |
| 102 | CS_CHAR_USER37 | Character(120) | VARCHAR2(120) NOT NULL | Character 120 User Field 37 |
| 103 | CS_CHAR_USER38 | Character(120) | VARCHAR2(120) NOT NULL | Character 120 User Field 38 |
| 104 | CS_DATE_USER1 | Date(10) | DATE | Date User Field 1 |
| 105 | CS_DATE_USER2 | Date(10) | DATE | Date User Field 2 |
| 106 | CS_DATE_USER3 | Date(10) | DATE | Date User Field 3 |
| 107 | CS_DATE_USER4 | Date(10) | DATE | Date User Field 4 |
| 108 | CS_DATE_USER5 | Date(10) | DATE | Date User Field 5 |
| 109 | CS_DATE_USER6 | Date(10) | DATE | Date User Field 6 |
| 110 | CS_DATE_USER7 | Date(10) | DATE | Date User Field 7 |
| 111 | CS_DATE_USER8 | Date(10) | DATE | Date User Field 8 |
| 112 | CS_DATE_USER9 | Date(10) | DATE | Date User Field 9 |
| 113 | CS_DATE_USER10 | Date(10) | DATE | Date User Field 10 |
| 114 | CS_DATE_USER11 | Date(10) | DATE | Date User Field 11 |
| 115 | CS_DATE_USER12 | Date(10) | DATE | Date User Field 12 |
| 116 | CS_DATE_USER13 | Date(10) | DATE | Date User Field 13 |
| 117 | CS_DATE_USER14 | Date(10) | DATE | Date User Field 14 |
| 118 | CS_DATE_USER15 | Date(10) | DATE | Date User Field 15 |
| 119 | CS_DEC_USER1 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Decimal User Field 1 (23.3) |
| 120 | CS_DEC_USER2 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Decimal User Field 2 (23.3) |
| 121 | CS_DEC_USER3 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Decimal User Field 3 (23.3) |
| 122 | CS_DEC_USER4 | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Decimal User Field 4 (11.4) |
| 123 | CS_DEC_USER5 | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Decimal User Field5 (11.4) |
| 124 | CS_DEC_USER6 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Decimal User Field 6 (23.3) |
| 125 | CS_DEC_USER7 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Decimal User Field 7 (23.3) |
| 126 | CS_DEC_USER8 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Decimal User Field 8 (23.3) |
| 127 | CS_DEC_USER9 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Decimal User Field 9 (23.3) |
| 128 | CS_DEC_USER10 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Decimal User Field 10 (23.3) |
| 129 | CS_DEC_USER11 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Decimal User Field 11 (23.3) |
| 130 | CS_DEC_USER12 | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Decimal User Field 12 (11.4) |
| 131 | CS_DEC_USER13 | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Decimal User Field 13 (11.4) |
| 132 | CS_DEC_USER14 | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Decimal User Field 14 (11.4) |
| 133 | CS_DEC_USER15 | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Decimal User Field 15 (11.4) |
| 134 | CS_INT_USER1 | Number(8,0) | INTEGER NOT NULL | Integer User Field 1 |
| 135 | CS_INT_USER2 | Number(8,0) | INTEGER NOT NULL | Integer User Field 2 |
| 136 | CS_INT_USER3 | Number(8,0) | INTEGER NOT NULL | Integer User Field 3 |
| 137 | CS_INT_USER4 | Number(8,0) | INTEGER NOT NULL | Integer User Field 4 |
| 138 | CS_INT_USER5 | Number(8,0) | INTEGER NOT NULL | Integer User Field 5 |
| 139 | CS_INT_USER6 | Number(8,0) | INTEGER NOT NULL | Integer User Field 6 |
| 140 | CS_INT_USER7 | Number(8,0) | INTEGER NOT NULL | Integer User Field 7 |
| 141 | CS_INT_USER8 | Number(8,0) | INTEGER NOT NULL | Integer User Field 8 |
| 142 | CS_INT_USER9 | Number(8,0) | INTEGER NOT NULL | Integer User Field 9 |
| 143 | CS_INT_USER10 | Number(8,0) | INTEGER NOT NULL | Integer User Field 10 |
| 144 | CS_INT_USER11 | Number(8,0) | INTEGER NOT NULL | Integer User Field 11 |
| 145 | CS_INT_USER12 | Number(8,0) | INTEGER NOT NULL | Integer User Field 12 |
| 146 | CS_INT_USER13 | Number(8,0) | INTEGER NOT NULL | Integer User Field 13 |
| 147 | CS_INT_USER14 | Number(8,0) | INTEGER NOT NULL | Integer User Field 14 |
| 148 | CS_INT_USER15 | Number(8,0) | INTEGER NOT NULL | Integer User Field 15 |
| 149 | CS_INT_USER16 | Number(8,0) | INTEGER NOT NULL | Integer User Field 16 |
| 150 | CS_INT_USER17 | Number(8,0) | INTEGER NOT NULL | Integer User Field 17 |
| 151 | CS_INT_USER18 | Number(8,0) | INTEGER NOT NULL | Integer User Field 18 |
| 152 | CS_INT_USER19 | Number(8,0) | INTEGER NOT NULL | Integer User Field 19 |
| 153 | CS_INT_USER20 | Number(8,0) | INTEGER NOT NULL | Integer User Field 20 |
| 154 | CS_INT_USER21 | Number(8,0) | INTEGER NOT NULL | Integer User Field 21 |
| 155 | CS_INT_USER22 | Number(8,0) | INTEGER NOT NULL | Integer User Field 22 |
| 156 | CS_INT_USER23 | Number(8,0) | INTEGER NOT NULL | Integer User Field 23 |
| 157 | CS_INT_USER24 | Number(8,0) | INTEGER NOT NULL | Integer User Field 24 |
| 158 | CS_DOC_UFLD_VER | Number(3,0) | SMALLINT NOT NULL | User Defined Field Version |
| 159 | CS_PROXY_USER | Character(30) | VARCHAR2(30) NOT NULL | Proxy Administrator |
| 160 | SCM_ATTACH_ID | Character(64) | VARCHAR2(64) NOT NULL | The unique ID of each file whose attachment was handled by the attachment utility. Unique across all attachments, all applications. |
| 161 | ATT_VERSION | Number(3,0) | SMALLINT NOT NULL | The version of the attached file. Currently always 1, this field will find more use once the attachment utitlity starts supporting versioning of files. |
| 162 | CS_FILE_FORMAT | Character(1) | VARCHAR2(1) NOT NULL |
Created in 9.2 to indicate xml version - word xml vs. open
0=Imported or Signature Document 1=Word 2003 XML 2=Word Open XML Default Value: 0 |
| 163 | CS_RELXD_CHKIN | Character(1) | VARCHAR2(1) NOT NULL |
Relaxed CheckIn Used
Y/N Table Edit Default Value: N |
| 164 | CS_COLLAB_COMMENTS | Long Character | CLOB | Collaboration Comments |
| 165 | CNTRCT_STYLE | Character(10) | VARCHAR2(10) NOT NULL |
Contract Style
Prompt Table: CS_CNTSTYLE_VW |
| 166 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 167 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: CS_ADH_VENDR_VW |
| 168 | CS_DOCUMENTKEY | Character(100) | VARCHAR2(100) NOT NULL | December 2014 PUM#14 SCMT002 EchoSign electronic signature |
| 169 | CS_ESEND_DTTM | DateTime(26) | TIMESTAMP | SCMT002 2/11/2015 RMK Datetime stamp document is routed for electronic signature |
| 170 | CS_EMAIL_ADDRESS | Character(70) | VARCHAR2(70) NOT NULL | Account Email |