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 |