CS_WTMPL_FMT_VW (SQL View)	Index Back
Document Format and Options RMK 06/25/07: View used by Search Content (for where used); object has no description, therefore setid is used in both content id and description

CS_WTMPL_FMT_VW

(SQL View)

Document Format and Options

RMK 06/25/07: View used by Search Content (for where used); object has no description, therefore setid is used in both content id and description

SELECT a.cs_word_tmpl_name , '0016' , a.setid , a.setid FROM PS_CS_CONFIG_TBL a

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CS_WORD_TMPL_NAME Character(30) VARCHAR2(30) NOT NULL Word Template Name

2 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

3 CS_CONTENT_ID Character(30) VARCHAR2(30) NOT NULL Content ID

4 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CS_WORD_TMPL_NAME	Character(30)	VARCHAR2(30) NOT NULL	Word Template Name
2	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
3	CS_CONTENT_ID	Character(30)	VARCHAR2(30) NOT NULL	Content ID
4	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254