CS_DOC_ATT_SES(SQL Table) |
Index Back |
---|---|
Contract Document Attachmentsrecord 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 |