CS_DOC_H_ADH_V1

(SQL View)
 Index Back

Contract Document Header

10/15/08 RMK Added cs_ex_summ_tmpl_id (executive summary template)

SELECT DISTINCT '0008' ,ADH.CS_DOC_ID ,ADH.SETID ,ADH.CS_ADHOC_ID ,T.CS_DOC_TYPE ,H.DESCR60 ,H.CS_DOC_STATUS ,H.CS_DOC_OWNER ,H.CS_SETID ,H.CS_TEMPLATE_ID ,H.CS_EX_SUMM_TMPL_ID ,H.CS_VERSION ,H.CS_AMENDMENT ,H.CS_TWOFILE_AMEND ,H.CS_SOURCE_TRANS ,H.CS_TRANKEY_REC ,H.CREATED_DTTM ,H.CREATED_BY_USER ,H.DATETIME_CHECKOUT ,H.CHECKED_OUT_BY ,H.COMMENT1 ,H.COLLABED_DTTM ,H.APPROVAL_DTTM ,H.DATETIME_DISPATCH ,H.EXECUTED_DTTM ,H.LAST_MODIFIED_DATE ,H.LASTUPDOPRID ,H.CS_DOCUMENT_TYPE FROM PS_CS_DOC_ADH_KEYS ADH ,PS_CS_DOC_HDR H ,PS_CS_DOC_PLAINTXT T WHERE ADH.CS_DOC_ID = H.CS_DOC_ID AND H.CS_DOC_ID = T.CS_DOC_ID AND T.CS_DOC_TYPE = '001'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 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
2 CS_DOC_ID Character(25) VARCHAR2(25) NOT NULL Document ID
3 SETID Character(5) VARCHAR2(5) NOT NULL SetID
4 CS_CONTENT_ID Character(30) VARCHAR2(30) NOT NULL Content ID
5 CS_DOC_TYPE Character(3) VARCHAR2(3) NOT NULL stores the file type -- main file, amendment, preview, throwaway Date Initials Issue Description ========================================== 06/2007 CEL F-AHAYT-25EQ8 added the external main and amendment types 7/2008 cel Added new executive summary file type. 9/30/2008 RMK Changed values 005 and 006 to 095 and 096, and added 010 for executive summary. This change is due to the search on file type using range (001-010 for non-attachment search, and 001-096 for attachment search)
001=Main Document
002=Amendment
003=Preview Document
004=Compare File
005=Document Attachment
006=Transaction Attachment
007=Config Selector
008=Main Signature Document
009=Amendment Signature File
010=Executive Summary
011=Exec-Sign
095=Document Attachment
096=Transaction Attachment
101=Main Document
102=Amendment Document
998=Main Document - ext collab
999=Amendment External Collab
6 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
7 CS_DOC_STATUS Character(2) VARCHAR2(2) NOT NULL Document Status
AA=Approved
AD=Denied
AP=Pending Approval
CC=Collaborated
CP=Pending Collaboration
CR=Collaborated, Pending Review
DC=Complete
DR=Draft
DS=Dispatched
EC=Pending External Collaboration
EX=Executed
PI=Pending Internal Review
8 CS_DOC_OWNER Character(30) VARCHAR2(30) NOT NULL Document Administrator
9 CS_SETID Character(5) VARCHAR2(5) NOT NULL setid for the document objects
10 CS_TEMPLATE_ID Character(20) VARCHAR2(20) NOT NULL SCC 09/01/04
11 CS_EX_SUMM_TMPL_ID Character(20) VARCHAR2(20) NOT NULL Executive Summary Configurator
12 CS_VERSION Number(6,2) DECIMAL(5,2) NOT NULL Version
13 CS_AMENDMENT Number(3,0) SMALLINT NOT NULL Amendment
14 CS_TWOFILE_AMEND Character(1) VARCHAR2(1) NOT NULL Amendment Option
1=Amend Contract Only
2=Amend Contract with Amendments
3=Amendment Files Only

Y/N Table Edit

Default Value: N

15 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
16 CS_TRANKEY_REC Character(15) VARCHAR2(15) NOT NULL Source Key Record
17 CREATED_DTTM DateTime(26) TIMESTAMP Created Date and time
18 CREATED_BY_USER Character(30) VARCHAR2(30) NOT NULL Created By
19 DATETIME_CHECKOUT DateTime(26) TIMESTAMP Checked Out On
20 CHECKED_OUT_BY Character(30) VARCHAR2(30) NOT NULL Checked Out By
21 COMMENT1 Character(254) VARCHAR2(254) NOT NULL Comments
22 COLLABED_DTTM DateTime(26) TIMESTAMP Collaborated On
23 APPROVAL_DTTM DateTime(26) TIMESTAMP A system generated value that reflects the date and time a given transaction is approved by an oper
24 DATETIME_DISPATCH DateTime(26) TIMESTAMP 02/2001 cel WV-802-1.0
25 EXECUTED_DTTM DateTime(26) TIMESTAMP Executed On
26 LAST_MODIFIED_DATE DateTime(26) TIMESTAMP Last modified date
27 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.
28 CS_DOCUMENT_TYPE Character(20) VARCHAR2(20) NOT NULL Document Type
001=Main Document
002=Amendment
003=Preview Document
004=Compare File