CS_TMPL_TBL_VW

(SQL View)
 Index Back

Doc Config Header Definition

SCC 09/01/04 - Document Configurator Header Definition

SELECT A.SETID , '0007' , A.CS_TEMPLATE_ID , A.DESCR60 , A.CS_TMPL_TYPE , A.CS_TMPL_STATUS , A.CS_SOURCE_TRANS , A.CS_WIZARD_ID , A.CS_AMENDMENT_FLG , A.CS_EXEC_SUMM_FLG , A.CS_WORD_TMPL_NAME , A.CS_TOC_FLAG , A.LOCK_USER_ID , A.LOCKED_DTTM , A.OPRID_MODIFIED_BY , A.DATETIME_MODIFIED , A.ROW_CREATE_USER , A.CREATED_DTTM , A.APPROVAL_OPRID , A.APPROVED_DTTM , A.LAST_DTTM_STAMP , A.LASTUPDOPRID , A.NOTES 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_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
5 CS_TMPL_TYPE Character(4) VARCHAR2(4) NOT NULL SCC 09/01/04

Prompt Table: CS_TMPL_TYPE

6 CS_TMPL_STATUS Character(2) VARCHAR2(2) NOT NULL SCC 09/01/04
01=In Progress
02=Available
03=Obsolete

Default Value: 01

7 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
8 CS_WIZARD_ID Character(30) VARCHAR2(30) NOT NULL Wizard ID

Prompt Table: CS_WIZ_DOCCR_VW

9 CS_AMENDMENT_FLG Character(1) VARCHAR2(1) NOT NULL Use for Amendments

Y/N Table Edit

Default Value: N

10 CS_EXEC_SUMM_FLG Character(1) VARCHAR2(1) NOT NULL Use for Executive Summary

Y/N Table Edit

Default Value: N

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

Default Value: CS_CONFIG_TBL.CS_WORD_TMPL_NAME

Prompt Table: CS_WORD_TEMPL

12 CS_TOC_FLAG Character(1) VARCHAR2(1) NOT NULL Include Table of Contents

Y/N Table Edit

Default Value: N

13 LOCK_USER_ID Character(30) VARCHAR2(30) NOT NULL Last Locked By
14 LOCKED_DTTM DateTime(26) TIMESTAMP SCC 09/01/04 - Locked Date Time
15 OPRID_MODIFIED_BY Character(30) VARCHAR2(30) NOT NULL Last User to Modify Entered By 07/25/2011:Ensured that OPRID_MODIFIED_BY is set with format type of MixedCase.
16 DATETIME_MODIFIED DateTime(26) TIMESTAMP Last Modified On
17 ROW_CREATE_USER Character(30) VARCHAR2(30) NOT NULL Created By
18 CREATED_DTTM DateTime(26) TIMESTAMP Created Date and time
19 APPROVAL_OPRID Character(30) VARCHAR2(30) NOT NULL A system generated value that reflects the operator that approved a given transaction.
20 APPROVED_DTTM DateTime(26) TIMESTAMP SCC 09/16/04 - Approved Date and time
21 LAST_DTTM_STAMP DateTime(26) TIMESTAMP Data Time Stamp - Old
22 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.
23 NOTES Long Character CLOB Notes