CS_DOC_ATT_SES

(SQL Table)
Index Back

Contract Document Attachments

record used by AE routine in pre-processing the PTSF indexes --gathers all the attachment links

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CS_DOC_ID Character(25) VARCHAR2(25) NOT NULL Document ID
2 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
3 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
4 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.
5 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.
6 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
7 CS_CONTENT_ID Character(30) VARCHAR2(30) NOT NULL Content ID
8 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
9 VERSION_NBR Number(5,0) INTEGER NOT NULL Contract Version number

Default Value: 1

10 SETID Character(5) VARCHAR2(5) NOT NULL SetID
11 AUC_ROUND Number(5,0) INTEGER NOT NULL Event Round
12 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version
13 ATTACH_DESCR Character(100) VARCHAR2(100) NOT NULL A description of the file being attached. This field is provided as a convenience to app developers and customers. The attachment utility does not interpret its value in any way, simply storing it as set by the application.
14 COMMENTS_254 Character(254) VARCHAR2(254) NOT NULL EDI Comments
15 EXT_FLAG Character(1) VARCHAR2(1) NOT NULL External Resource

Y/N Table Edit

Default Value: N

16 FILENAME Character(80) VARCHAR2(80) NOT NULL File Name
17 FILE_EXTENSION Character(4) VARCHAR2(4) NOT NULL File Extension
18 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
19 DATETIME_STAMP DateTime(26) TIMESTAMP DateTime Stamp
20 CS_IMPORT_FLG Character(1) VARCHAR2(1) NOT NULL Imported Document

Y/N Table Edit

Default Value: N

21 PATHNAME Character(254) VARCHAR2(254) NOT NULL PATHNAME