CS_WTMPL_CFG_VW(SQL View) |
Index Back |
---|---|
Document ConfiguratorRMK 06/25/07 9.1 View used by Search Content (for where used) to show document configurators and word template usage |
SELECT a.setid , a.cs_template_id , a.cs_word_tmpl_name , '0007' , a.cs_template_id , a.cs_source_trans , a.descr60 FROM PS_CS_TMPL_TBL a |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
2 | CS_TEMPLATE_ID | Character(20) | VARCHAR2(20) NOT NULL | SCC 09/01/04 |
3 | CS_WORD_TMPL_NAME | Character(30) | VARCHAR2(30) NOT NULL | Word Template Name |
4 | CS_CONTENT_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
06/08/09 F-AHAYT-XOES6 Add capability to use binds in headers and/or footers of contract document; new translate value added to support Where Used from Document Templates and Styles
06/25/07 F-AHAYT-XOES6 Added 0016 for Document Format and Options; this type is only used when displayed where a word template is used with doc options. We do not search doc format and options.
0001=Clause 0002=Section 0003=Ad Hoc Clause 0004=Rule 0005=Bind Variables 0006=Wizard Definition 0007=Document Configurator 0008=Document 0009=Contract Agreement 0010=Bid Factor 0011=Contract 0012=Sourcing Event 0013=Question Group 0014=Document Type 0015=Word Template 0016=Document Format and Options |
5 | CS_CONTENT_ID | Character(30) | VARCHAR2(30) NOT NULL | Content ID |
6 | 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 |
7 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |