INSTALLATION_CS(SQL Table) |
Index Back |
|---|---|
Installation OptionsDate Initials Issue Description 01/09/2007 cel 1601618000 Added Server_id for the Attachment override. 2/19/2007 cel F-AHAYT-748L7 Added two new fields CS_PO_SOURCE, CS_CONTRACT_SOUCE. 1/31/2011 tbg SCMT-92-MDEM-04 Added field CS_AUC_SOURCE 4/9/2012 rmk 9.2 bug - added new field CS_PDF_PREP_CLIENT to potentially remove requirement of Adobe Acrobat installation on windows machine; 5/7/2012 Not needed field so can be removed 5/2014 TBG SCMT-003 Added field for CS_CWB_DISPROWS |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CS_VERITY_SRCH | Character(1) | VARCHAR2(1) NOT NULL |
2/8/2012 RMK Replaced word "" with PTSF
Y/N Table Edit |
| 2 | CS_CHUNK_SIZE | Number(4,0) | SMALLINT NOT NULL | Search Content Chunk Size |
| 3 | CS_LAST_DOC_ID | Number(25,0) | DECIMAL(25) NOT NULL | Last Working Document ID |
| 4 | CS_SYNDICATE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Allow Contract Syndication
Y/N Table Edit |
| 5 | SUBNODE | Character(30) | VARCHAR2(30) NOT NULL |
Subscribing Node
Prompt Table: CS_NODES_VW |
| 6 | CS_SNDCT_DEFAULTS | Character(1) | VARCHAR2(1) NOT NULL |
Flag to identifiy if the CNTRCT_DEFAULTS table will be syndicated.
Y/N Table Edit |
| 7 | CS_SNDCT_MISC_CHG | Character(1) | VARCHAR2(1) NOT NULL |
Flag to identifiy if the CNTRCT_HDR_MISC table will be syndicated.
Y/N Table Edit |
| 8 | CS_SNDCT_MILESTN | Character(1) | VARCHAR2(1) NOT NULL |
Flag to identifiy if the CNTRCT_MILESTN table will be syndicated.
Y/N Table Edit |
| 9 | CS_SNDCT_SHP_SCHED | Character(1) | VARCHAR2(1) NOT NULL |
Flag to identifiy if the CNTRCT_LN_SHIP table will be syndicated.
Y/N Table Edit |
| 10 | CS_SNDCT_DISTRIB | Character(1) | VARCHAR2(1) NOT NULL |
Flag to identifiy if the CNTRCT_BU_DSTRB and CNTRCT_DSTRB tables will be syndicated.
Y/N Table Edit |
| 11 | APPSERVER_PATH | Character(64) | VARCHAR2(64) NOT NULL | Application Server Path |
| 12 | CS_NTSERVER_PATH | Character(64) | VARCHAR2(64) NOT NULL | Compare/Render Server/Path |
| 13 | CS_NT_SERVER_URL | Character(254) | VARCHAR2(254) NOT NULL | Compare/Render Server URL |
| 14 | CS_LOG_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Log at Document Generation
A=Details E=Log Warnings and Wizard Default Value: E |
| 15 | CS_PROTECT_BINDS | Character(1) | VARCHAR2(1) NOT NULL |
Protect Binds
Y/N Table Edit Default Value: Y |
| 16 | CS_DOC_APPROVAL | Character(1) | VARCHAR2(1) NOT NULL |
Document Approval
Y/N Table Edit Default Value: N |
| 17 | CS_CLAUSE_APPROVAL | Character(1) | VARCHAR2(1) NOT NULL |
Require Clause Approval
Y/N Table Edit Default Value: N |
| 18 | CS_COL_TMPL_1 | Character(30) | VARCHAR2(30) NOT NULL |
Routing Template
Prompt Table: WL_TEMPL_GEN_VW |
| 19 | CS_COL_TMPL_2 | Character(30) | VARCHAR2(30) NOT NULL |
Done Template
Prompt Table: WL_TEMPL_GEN_VW |
| 20 | CS_COL_TMPL_3 | Character(30) | VARCHAR2(30) NOT NULL | Document Modified |
| 21 | CS_COLL_CANCL_TMPL | Character(30) | VARCHAR2(30) NOT NULL |
Cancel Template
Prompt Table: WL_TEMPL_GEN_VW |
| 22 | CS_WF_CHANNEL | Character(1) | VARCHAR2(1) NOT NULL |
Notifications
0=None 1=Email 2=Worklist 3=Email and Worklist 4=User Preference Default Value: 3 |
| 23 | CS_FORCE_APPROVAL | Character(1) | VARCHAR2(1) NOT NULL |
Document Reapproval After Edit
Y/N Table Edit Default Value: N |
| 24 | CS_TRACK_CHANGES | Character(1) | VARCHAR2(1) NOT NULL |
Track Changes
Y/N Table Edit Default Value: N |
| 25 | DOC_CONV_ENABLED | Character(1) | VARCHAR2(1) NOT NULL |
Enable Rendering .doc
Y/N Table Edit Default Value: N |
| 26 | COMPARE_ENABLED | Character(1) | VARCHAR2(1) NOT NULL |
Enable Compare Functionality
Y/N Table Edit Default Value: N |
| 27 | CS_USE_DOC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Use Document Type
Y/N Table Edit Default Value: N |
| 28 | CS_USE_PO_REQ | Character(1) | VARCHAR2(1) NOT NULL |
Use with PO Requisition
Y/N Table Edit Default Value: N |
| 29 | CS_NOCHECKIN_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Stop checking in document
Y/N Table Edit Default Value: Y |
| 30 | CS_FILTER_RESULTS | Character(1) | VARCHAR2(1) NOT NULL |
Filter Results Without Chunking For Documents
Y/N Table Edit Default Value: N |
| 31 | SERVER_ID | Number(4,0) | SMALLINT NOT NULL |
File Server ID
Default Value: 0 Prompt Table: CS_SERVERS_VW |
| 32 | CS_CONTRACT_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
cel 2/19/2007 F-AHAYT-748L7: New field for SCMT Installation page
Y/N Table Edit Default Value: Y |
| 33 | CS_PUR_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
cel 2/19/2007 F-AHAYT-748L7: New field for SCMT Installation page
Y/N Table Edit Default Value: N |
| 34 | PDF_CONV_ENABLED | Character(1) | VARCHAR2(1) NOT NULL |
Enable Rendering .pdf
Y/N Table Edit Default Value: N |
| 35 | CS_USE_EXT_COLL | Character(1) | VARCHAR2(1) NOT NULL |
Enable External Collaboration
Y/N Table Edit Default Value: N |
| 36 | CS_INTERNAL_SIGS | Character(1) | VARCHAR2(1) NOT NULL |
Enable Internal Signatures
Y/N Table Edit Default Value: N |
| 37 | CS_SIGN_TMPL | Character(30) | VARCHAR2(30) NOT NULL |
Sign Template
Prompt Table: WL_TEMPL_GEN_VW |
| 38 | CS_SIGN_CANCL_TMPL | Character(30) | VARCHAR2(30) NOT NULL |
Cancel Template
Prompt Table: WL_TEMPL_GEN_VW |
| 39 | CS_SIGN_COMPL_TMPL | Character(30) | VARCHAR2(30) NOT NULL |
Complete Template
Prompt Table: WL_TEMPL_GEN_VW |
| 40 | CS_EXTERNAL_SIGS | Character(1) | VARCHAR2(1) NOT NULL |
Enable External Signatures
Y/N Table Edit Default Value: N |
| 41 | CS_SIGN_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
5/16/2012 RMK Changed 'A' to deprecated, and added 'B' to use Office Word to convert xml document to PDF using "Save as PDF" feature
A=Adobe (Deprecated) B=Adobe (Word) D=DocuSign E=Adobe Document Cloud services W=Word Default Value: B |
| 42 | CS_INT_REJ_TMPL | Character(30) | VARCHAR2(30) NOT NULL |
Decline Signing Template
Prompt Table: WL_TEMPL_GEN_VW |
| 43 | CS_SUPP_VIEW_EXEC | Character(1) | VARCHAR2(1) NOT NULL |
External History Settings
A=View All Documents and Details D=Disable Viewing once Executed E=View Only Executed Documents Default Value: A |
| 44 | CS_COL_TMPL_4 | Character(30) | VARCHAR2(30) NOT NULL |
Routing Template
Prompt Table: WL_TEMPL_GEN_VW |
| 45 | CS_COL_TMPL_5 | Character(30) | VARCHAR2(30) NOT NULL |
Done Template
Prompt Table: WL_TEMPL_GEN_VW |
| 46 | CS_WF_CHANNEL_EXT | Character(1) | VARCHAR2(1) NOT NULL |
Notifications
0=None 1=Email 2=Worklist 3=Email and Worklist 4=User Preference Default Value: 3 |
| 47 | CS_SUPP_TMPL1 | Character(30) | VARCHAR2(30) NOT NULL |
Cancel Template
Prompt Table: WL_TEMPL_GEN_VW |
| 48 | CS_SUPP_TMPL2 | Character(30) | VARCHAR2(30) NOT NULL |
Cancel Template
Prompt Table: WL_TEMPL_GEN_VW |
| 49 | CS_SUPP_TMPL3 | Character(30) | VARCHAR2(30) NOT NULL |
Decline Signing Template
Prompt Table: WL_TEMPL_GEN_VW |
| 50 | CS_SUPP_TMPL4 | Character(30) | VARCHAR2(30) NOT NULL |
Signed Template
Prompt Table: WL_TEMPL_GEN_VW |
| 51 | CS_ENABLE_CYCLES | Character(1) | VARCHAR2(1) NOT NULL |
Enable Cyle Time
Y/N Table Edit Default Value: N |
| 52 | CS_CYCLE_DAY_AMEND | Number(4,0) | SMALLINT NOT NULL |
Cycle Time for Amendments
Default Value: 0 |
| 53 | CS_CYCLE_DAYS | Number(4,0) | SMALLINT NOT NULL |
Cycle Time per Document
Default Value: 0 |
| 54 | CS_BUS_CALENDAR | Character(20) | VARCHAR2(20) NOT NULL |
Business Calendar
Prompt Table: BUS_CAL_HOL_DFN |
| 55 | CS_DAYS_RED | Number(3,0) | SMALLINT NOT NULL |
Red
Default Value: 0 |
| 56 | CS_DAYS_YELLOW | Number(3,0) | SMALLINT NOT NULL |
Yellow
Default Value: 0 |
| 57 | CS_DAYS_RED_AMEND | Number(3,0) | SMALLINT NOT NULL |
Red
Default Value: 0 |
| 58 | CS_DAYS_YELL_AMEND | Number(3,0) | SMALLINT NOT NULL |
Yellow
Default Value: 0 |
| 59 | CS_CYCLE_COMPLETE | Character(2) | VARCHAR2(2) NOT NULL |
Complete When Status is
AA=Approved AP=Pending Approval DS=Dispatched EX=Executed/Complete Default Value: EX |
| 60 | CS_NOTIFYWHEN_TMPL | Character(30) | VARCHAR2(30) NOT NULL |
Notify When Available Template
Prompt Table: WL_TEMPL_GEN_VW |
| 61 | CS_REFRESH_VRSN | Character(1) | VARCHAR2(1) NOT NULL |
Update Version and Amendment
Y/N Table Edit Default Value: Y |
| 62 | CS_DOC_RETAIN | Character(1) | VARCHAR2(1) NOT NULL |
Document Retention Option
A=Keep All Versions P=Keep Only Executed Versions Default Value: A |
| 63 | CS_BROWSER_PREF | Character(2) | VARCHAR2(2) NOT NULL |
7/27/09 RMK Browser preference may use different tools attachment method - ViewAttachment vs DetachAttachment; flag is used in SCM_CS_ATTACHMENTS:DownloadTasks
1=Internet Explorer 99=Other Browser Default Value: 1 |
| 64 | CS_AUC_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
cel 2/19/2007 F-AHAYT-748L7: New field for SCMT Installation page
Y/N Table Edit Default Value: N |
| 65 | CS_PDF_PREP_CLIENT | Character(1) | VARCHAR2(1) NOT NULL |
Created for 9.2 - potentially to remove Adobe Acrobat requirement on windows server machine, and use Office Word to prep PDF instead. This will work well for word xml documents, except for Adobe digital signatures files - issue is eps signature field are not converted to signable field in PDF
Y/N Table Edit |
| 66 | CS_CWB_DISPROWS | Number(4,0) | SMALLINT NOT NULL |
SCMT003 TBG 5/15/2014 Contract Workbench --field used in the new workbench
Default Value: 20 |
| 67 | CS_CWB_SEARCHTYPE | Character(3) | VARCHAR2(3) NOT NULL |
03/11/2015 JOHAN SCMT009 Adding PTSF indexing to Supplier Contract Workbench
Q=Real Time Searching S=Search Engine Default Value: Q |