CS_TMPLDET_SVW (SQL View)	Index Back
Template Detail View for PTSF PTSF template detail for SCMT

CS_TMPLDET_SVW

(SQL View)

Template Detail View for PTSF

PTSF template detail for SCMT

SELECT A.SETID , '0007' , A.CS_TEMPLATE_ID , B.DESCR60 , A.CS_KEYVALUE , A.CS_OBJECT_TYPE , A.CS_OBJECT_ID , A.SEQ_ID , A.SCM_ATTACH_ID , A.ATT_VERSION , A.CS_NUMBERING_FLG , A.CS_BODY_TYPE , A.DESCR60 , A.CS_TITLE , A.CS_APPROVAL_STATUS , A.CS_BODY FROM PS_CS_TMPL_DTL A ,PS_CS_TMPL_TBL B WHERE A.SETID = B.SETID AND A.CS_TEMPLATE_ID = B.CS_TEMPLATE_ID AND A.CS_OBJECT_TYPE = '0003'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

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_KEYVALUE Character(30) VARCHAR2(30) NOT NULL SCC 09/01/04

6 CS_OBJECT_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
0001=Clause
0002=Section
0003=Ad Hoc Clause
0004=Rule
0005=Bind Variables
0006=Wizard Definition
0007=Document Configurator
0008=Document
0015=Word Template
1000=All

7 CS_OBJECT_ID Character(20) VARCHAR2(20) NOT NULL Object id -- clause, section
Prompt Table: %EDITTABLE

8 SEQ_ID Number(4,0) SMALLINT NOT NULL Mapping Unique Sequence ID

9 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.

10 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.

11 CS_NUMBERING_FLG Character(1) VARCHAR2(1) NOT NULL Numbering
Y/N Table Edit
Default Value: Y

12 CS_BODY_TYPE Character(1) VARCHAR2(1) NOT NULL indicates body type -- full or by ref for clause/section
F=Full Text
R=By Reference Text

13 DESCR60_2 Character(60) VARCHAR2(60) NOT NULL Description

14 CS_TITLE Character(254) VARCHAR2(254) NOT NULL title

15 CS_APPROVAL_STATUS Character(1) VARCHAR2(1) NOT NULL Approval Status
A=Approved
I=Initial
P=Pending Approval

16 CS_BODY Long Character CLOB stores the body text for clause/section.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
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_KEYVALUE	Character(30)	VARCHAR2(30) NOT NULL	SCC 09/01/04
6	CS_OBJECT_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 0001=Clause 0002=Section 0003=Ad Hoc Clause 0004=Rule 0005=Bind Variables 0006=Wizard Definition 0007=Document Configurator 0008=Document 0015=Word Template 1000=All
7	CS_OBJECT_ID	Character(20)	VARCHAR2(20) NOT NULL	Object id -- clause, section Prompt Table: %EDITTABLE
8	SEQ_ID	Number(4,0)	SMALLINT NOT NULL	Mapping Unique Sequence ID
9	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.
10	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.
11	CS_NUMBERING_FLG	Character(1)	VARCHAR2(1) NOT NULL	Numbering Y/N Table Edit Default Value: Y
12	CS_BODY_TYPE	Character(1)	VARCHAR2(1) NOT NULL	indicates body type -- full or by ref for clause/section F=Full Text R=By Reference Text
13	DESCR60_2	Character(60)	VARCHAR2(60) NOT NULL	Description
14	CS_TITLE	Character(254)	VARCHAR2(254) NOT NULL	title
15	CS_APPROVAL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Approval Status A=Approved I=Initial P=Pending Approval
16	CS_BODY	Long Character	CLOB	stores the body text for clause/section.